As part of the CASEMIS to CALPADS (aka C2C) transition, the CDE has updated the CASEMIS Table A and Table B formats for the 2018-2019 school year. Below is a list of the fields in the Student SPED File and the Student Services File. As Aeries builds support for these files we will include the field mapping to the Aeries fields. 


Student SPED File:


Field #Column HeaderPublic NameAeries Table/FieldNotes
14.01RecTypeRecord Type CodeN/A
14.02TranTypeTransaction Type CodeN/A
14.03LocRecIDLocal Record IDN/A
14.04DIST_SERVReporting LEACSE.DS
14.05SCH_CODESchool of AttendanceCSE.SS
14.06SchNPSSchool of Attendance NPSCSE.SS
14.07AcadYearAcademic Year IDN/A
14.08SSIDSSIDSTU.CIDUsed for matching to STU record. Does not update STU
14.09LocStudIDLocal Student IDSTU.IDUsed for matching to STU record. Does not update STU
14.10STUDENT_IDLocal Special Education Student IDCSE.SEI
14.11FIRST_NAMEStudent Legal First NameSTU.FNNot used
14.12LAST_NAMEStudent Legal Last NameSTU.LNNot used
14.13BIRTHDATEStudent Birth DateSTU.BDUsed to determine age. Does not update STU
14.14GENDERStudent Gender CodeSTU.SXNot used
14.15SELPA_CODEReporting SELPACSE.SE
14.16DIST_RESIDistrict of Special Education AccountabilityCSE.DR
14.17REFR_DATESpecial Education Referral DateCSE.IRD or CSE.RDDepends on MeetType and PLAN_TYPE
14.18REFR_BYReferring Party CodeCSE.IRB or CSE.RBDepends on MeetType and PLAN_TYPE
14.19PRNT_CSNTInitial Evaluation Parental Consent DateCSE.IPC or CSE.PCDepends on MeetType and PLAN_TYPE
14.20MeetTypeSpecial Education Meeting Type CodeN/A
14.21MeetDateSpecial Education Meeting DateCSE.LI, CSE.LIF, CSE.IIE, CSE.IE, or CSE.LADepends on MeetType and PLAN_TYPE
14.22EIDtifierStudent Special Education Evaluation or Amendment IdentifierN/A
14.23EvaldlayEvaluation Delay CodeCSE.EDL, CSE.IDL, CSE.BDL, CSE.TDLDepends on MeetType and PLAN_TYPE
14.24PLAN_TYPEEducation Plan Type CodeCSE.PT
14.25AmendDateEducation Plan Amendment DateN/A
14.26RESID_STATPrimary Residence CodeCSE.RS
14.27ENTRY_DATESpecial Education Initial Service Start DateCSE.ED
14.28DISABILIT1Disability 1 CodeCSE.DI
14.29DISABILIT2Disability 2 CodeCSE.DI2
14.30SOLE_LOWInfant Regional Center Services Eligibility IndicatorCSE.SL
14.31PrgSettingSpecial Education Program Setting CodeCSE.FI, CSE.FP or CSE.FSDepends on student age
14.32ProglocPreschool Program Setting Service Location CodeN/A
14.33InsetindTen or More Weekly Hours in Setting IndicatorN/A
14.34GEPartiPctGeneral Education Participation Percentage Range CodeCSE.IRC
14.35Infant_setSpecial Education Infant Program Type CodeCSE.IS
14.36TRAN_REG1IEP Includes Postsecondary Goals IndicatorCSE.TR1
14.37TRAN_REG2Postsecondary Goals Updated Annually IndicatorCSE.TR2
14.38TRAN_REG3Postsecondary Goals Age Appropriate Transition Assessment IndicatorCSE.TR3
14.39TRAN_REG4Transition Services in IEP IndicatorCSE.TR4
14.40TRAN_REG5Supportive Services IndicatorCSE.TR5
14.41TRAN_REG6Transition Services Goals in IEP IndicatorCSE.TR6
14.42TRAN_REG7Student IEP Participation IndicatorCSE.TR7
14.43TRAN_REG8Agency Representative IEP Participation IndicatorCSE.TR8
14.44SPEC_TRANSSpecial Transportation IndicatorCSE.ST
14.45PARINPUTParental Involvement Facilitation CodeCSE.PI
14.46FILLERGraduation Plan CodeCSE.GP
14.47EXIT_DATESpecial Education Program Exit DateCSE.XD
14.48EXIT_RESONSpecial Education Program Exit Reason CodeCSE.XR
14.49SCH_TYPEType of School or programCSE.TY
14.50ETHNICITYEthnicity of the studentN/A
14.51RACE1Race Identification or background (first)N/A
14.52RACE2Race Identification or background (second)N/A
14.53RACE3Race Identification or background (third)N/A
14.54ELEnglish learnerN/A
14.55NATIV_LANGNative languageN/A
14.56MIGRANTMigrant Program participation eligibilityN/A
14.57GRADEGrade levelSTU.GRNot used



Student Services File:


Field #Column HeaderPublic NameAeries Table/FieldNotes
15.01RecTypeRecord Type CodeN/A
15.02TranTypeTransaction Type CodeN/A
15.03LocRecIDLocal Record IDN/A
15.04DIST_SERVReporting LEAN/A
15.05SCH_CODESchool of AttendanceN/A
15.06SchNPSSchool of Attendance NPSN/A
15.07NPAIDNonpublic Agency Identifier (NPA)N/A
15.08AcadYearAcademic Year IDN/A
15.09SSIDSSIDSTU.CIDUsed to link Services records to Student records. Does not update STU
15.1SELPA_CODEReporting SELPAN/A
15.11DIST_RESIDistrict of Special Education AccountabilityN/A
15.12EIDtifierStudent Special Education Evaluation or Amendment IdentifierN/AUsed to link Services records to Student records
15.13SERVICESpecial Education Service CodeCSV.CD
15.15PROVIDERSpecial Education Service Provider CodeCSV.PR
15.15LOCATIONSpecial Education Service Location CodeCSV.LO
15.16FREQUENCYService Frequency CodeCSV.FR
15.17DURATIONService DurationCSV.DU
15.18Student_IDLocal Special Education Student IDN/A