This chart lists each field from the CALPADS File Specifications documentation by the page location in Aeries.

For a full listing of CALPADS fields by extract see:  Aeries Cross Reference by Extract


CALPADS 
Field #
Aeries Field Name
Aeries
Table.Field
Comments/Notes
504 Plans
3.15Effective DateFOF.SDSPRG
If not using FOF table, See Student Programs: PGM.ESD.
3.16Leave DateFOF.LDSPRG
If not using FOF table, See Student Programs: PGM.EED.
Activities and Awards
1.32Golden State Seal Merit Diploma RecordACT.CDSENR
Map CALPADS Other Options for ACT code.
1.33Seal of Biliteracy RecordACT.CDSENR
Map CALPADS Other Options for ACT code. 
1.35Workforce Readiness Certificate Program Completion IndicatorACT.CDSENR
Map CALPADS Other Options for ACT code.
1.36Food Handler Certification Program Completion IndicatorACT.CDSENR
Map CALPADS Other Options for ACT code.
1.37Pre-Apprenticeship Certification Program Completion IndicatorACT.CDSENR
Map CALPADS Other Options for ACT code.
1.38Pre-Apprenticeship Program (non-certified) Completion IndicatorACT.CDSENR
Map CALPADS Other Options for ACT code.
1.39State or Federal Job Program Completion IndicatorACT.CDSENR
Map CALPADS Other Options for ACT code.
Address History
2.31Address Line 1ADH.RADSINF or SIAD
Entered on Demographics page.
2.32Address Line 2
SINF or SIAD
2.33Address City NameADH.RCYSINF or SIAD
Entered on Demographics page.
2.34Address State Provence CodeADH.RSTSINF or SIAD
Entered on Demographics page.
These code values will be translated when extracted from Aeries.
2.35Address Zip CodeADH.RZCSINF or SIAD
Entered on Demographics page.
Assertive Discipline
4.13Incident IDADS.IIDSDIS
4.14Incident DateADS.DTSDIS
4.15ViolationsADS.CDSDIS
Place the most severe offense as the first code listed on this page. CALPADS codes may not compatible with codes that are being used in Aeries, verify your local codes account for all of the 48900 and 48915 Ed Codes. Your local codes will be translated to the CALPADS codes when they are extracted.
Map CALPADS Code Translations for Discipline Offense Code (ADS.CD). 
4.16Incident Most Severe Offense CodeADS.CDSDIS
This will be flagged when extracting the ADS.CD field. The Suspendable Offense Code Table must be populated for proper extraction.
4.17Weapon TypeADS.WTSDIS
Although you can use the CALPADS Code Values, we recommend creating your own codes that are more refined than the CALPADS codes. Your local codes can be translated to the CALPADS codes during extract.
Map CALPADS Code Translations for Discipline Weapon Type (ADS.WT). 
4.18Administrative ActionDSP.DSSDIS
Do not use the CALPADS Code Values. Use your own local codes. Multiple Dispositions can be entered. Aeries will extract the most severe. Suspension codes need to start with "SUS" for the Suspension letters to print the total # of days. There can be additional characters after "SUS", but they must start with those characters for the system to recognize what they represent.
Map CALPADS Code Translations for Discipline Action Taken (Disposition) (DSP.DS). 
4.19AuthorityDSP.AASDIS
All Suspension and Expulsion records must have this field populated.
Map CALPADS Code Translations for Disciplinary Action Authority (DSP.AA). 
4.20DaysDSP.DYSDIS
All Suspension and Expulsion records must have this field populated. Partial days should be entered with a decimal. DSP.HR Hours will not be extracted.
4.21Instructional SupportADS.ISISDIS
This field is required to be populated with a "Y" or "N" on all Suspension/Expulsion records for Special Ed students.
4.22Disciplinary Action ModificationEXP.EMCSDIS
Expulsion tab.
This field is required to be populated for all Expulsion records. The codes in Aeries match the CALPADS Codes.
Map CALPADS Code Translations for Disciplinary Action Modification (EXP.EMC). 
4.23Removal to Interim Alternative Setting ADS.RRSDIS
A coded value representing the reason a student was removed to an interim alternative setting for 45 days or less. This field is required on all discipline incidents for all Special Ed students.
Attendance
1.26Reason
Attendance Enrollment
ATT.RSSENR or SIAD
May also come from STU.SWR or STU.EOY.
1.28Next School (NextSchl)
Attendance Enrollment
ATT.NSSENR or SSID
Only needed for Alternative schools or All records with an Exit Reason of "165" (Involuntary Transfer for Discipline).
1.30InterDistrict
(IntDist)
ATT.ITSENR or SSID
If the Inter/Intra District field (STU.IT) on Student Demographics is populated, ATT.IT and ENR are also populated.
1.31Transfer District
(TransDist)
ATT.ITDSENR or SSID
If the Inter/Intra District field (STU.ITD) on Student Demographics is populated, ATT.IT and ENR are also populated.
2.04Start Date
Attendance Enrollment
ATT.CD = E
+
ATT.DT
SINF or SIAD
Located on Attendance Enrollment page for the current year.
2.05End Date
Attendance Enrollment
ATT.CD = L
+
ATT.DT
SINF or SIAD
Located on Attendance Enrollment page for the current year.
Attendance History
13.13Attendance Exemption

STAS
CALPADS Other Options tab.
If any codes have been selected in the STU.SP values STAS Exempt table, a "Y" will be reported. All virtual schools will be reported as exempt.
13.15EnrolledAHS.ENSTAS
13.16PresentAHS.PRSTAS
13.17Days of SuspensionAHS.SUSTAS
13.18Days In School SuspensionAHS.ISSSTAS
13.19ExcusedAHS.AESTAS
13.20UnexcusedAHS.AUSTAS
13.21Day Incomplete Independent StudyAHS.ISISTAS
Career Pathways
11.13CTE Pathway RecordCPW.CDSCTE
Reference CALPADS Valid Code Combinations
11.14Completed CheckboxCPH.AYSCTE
Only extracted on Career Pathway records identified as "Completed" for the current year.
Courses
9.07State Course CodeCRS.C3CRSE or CRSC
California Specifics Fields tab.
All courses must be populated with a value in this field. Use "6012" if you would like Aeries to skip this course.  For an Elementary school, TCH.CB is used.
9.08Course ID
(CrsID#)
CRS.CNCRSE or CRSC
General tab.

Aeries recommends a district-wide, unique Course ID for each course.  For an Elementary school, TCH.TN is used.
9.09Title/Long TitleCRS.COCRSE or CRSC
For an Elementary school, TCH.TE is used.
9.12TypeCRS.TYCRSE or CRSC
Other tab.

Values of 32 and 33 will be used for this field. Not needed for Elementary Schools.
9.13UC CSU Approved
(Subject Area, Elective?, Honors?, Validation)
CRS.E1
or
CRS.U1
or
CRS.U2
CRSE or CRSC
California Specific Fields tab.

All the UC/CSU Subjects Area fields, including the Validation Level field should be populated for accurate UC/CSU Course Completer Analysis at the student level.  Not needed for Elementary Schools, "N" will be extracted.
9.19Course Level
(Crs Lvl)
CRS.CLCRSE or CRSC
Other tab
.
Existing Code Values will be Translated to CALPADS Codes. Not reported for Elementary Schools.
Map CALPADS Code Translations for Course Instruction Level (CRS.CL). 
9.29Content SubcategoryCRS.CSCCRSE or CRSC
California Specific Fields tab.

Populate the range of grade level standards that are covered in the content of the course: Elementary K-4, Middle Grades 5-8, Secondary 9-12 or Not Applicable.
CRSE or CRSC
Other tab
.
9.30Content Standards AlignmentCRS.CSCCRSE or CRSC
California Specific Fields tab.

Populate the coded value representing the currency of the standards that were used to develop the content of the course:  Current Content Standards, Prior Content Standards or Not Content Standards - Aligned or Not Applicable.
9.31Charter IndicatorCRS.CNCCRSE or CRSC
California Specific Fields tab.

Populate a Y or N to indicate if the charter school has identified the course course as non-core, non-college preparatory. Typically, non-core, non-college prep courses are not required for graduation.  If the value on the section (MST.CNC) is different than the course (CRS.CNC) value, then MST.CNC will be extracted.
9.32AP/IB Cross Code ReferenceCRS.ACCCRSE or CRSC
California Specific Fields tab.

Identifies the four-digit cross reference to the actual AP or IB State Course Code for AP or IB courses that a local educational agency has mapped to a Career Technical Education (CTE) State Course Code (7000-8999) because that course is part of a CTE pathway. This allows districts to map to the CTE State Course Code in the State Course Code field, while providing the cross-reference to the actual AP or IB course code. If the value on the section (MST.ACC) is different than the course (CRS.ACC) value, then MST.ACC will be extracted.
9.34Middles School Core IndicatorCRC.MSCCRSE or CRSC
California Specific Fields tab.

Populate a Y or N to indicate if the course, in grades five through eight, is being taught as part of a middle school core setting.   If the value on the section (MST.MSC) is different than the course (CRS.MSC) value, then MST.MSC will be extracted.
10.13Course ID
(CrsID#)
CRS.CNSCSE or SCSC
General tab.

Aeries recommends a district-wide, unique Course ID for each course.
10.19UC CSU Approved
(Subject Area, Elective?, Honors?, Validation)
CRS.E1
or
CRS.U1
or
CRS.U2
SCSE or SCSC
California Specific Fields tab.
All the UC/CSU Subjects Area fields, including the Validation Level field should be populated for accurate UC/CSU Course Completer Analysis at the student level.  Not needed for Elementary Schools, "N" will be extracted. SE or SCSC
Demographics
1.08State Student ID
(State Stu ID)
STU.CIDSENR or SSID
Student Data 2 tab.

Always use the CALPADS Create SSID Extract to obtain and import SSIDs for new students.
1.09Perm ID#STU.IDSENR or SSID
Student Data 1 tab.

Unique Aeries student identifier.
1.10First NameSTU.FNSENR or SSID
Student Data 1 tab.
1.11Middle NameSTU.MNSENR or SSID
Student Data 1 tab.
1.12Last NameSTU.LNSENR or SSID
Student Data 1 tab.
1.13Suffix STU.SFSENR or SSID
Student Data 1 tab.
1.14First AliasSTU.FNASENR or SSID
Student Data 1 tab.
1.15Middle AliasSTU.MNASENR or SSID
Student Data 1 tab.
1.16Last AliasSTU.LNASENR or SSID
Student Data 1 tab.
1.17BirthdateSTU.BDSENR or SSID
Student Data 1 tab.
1.18GenderSTU.GNSENR or SSID
Student Data 1 tab.
1.19Birth CitySTU.BCYSENR or SSID
Student Data 1 tab.
1.20StateSTU.BSTSENR or SSID
Student Data 1 tab.

These code values will be translated when extracted from Aeries.
1.21CountrySTU.BCUSENR or SSID
Student Data 1 tab.

These code values will be translated when extracted from Aeries.
1.22School Enter Date
(Schl Enter Dt)
STU.EDSENR or SSID
Student Data 1 tab.

This information will also come from the ENR table if the district has good ENR data for multiple years. Local data management practices may need to be adjusted to treat contiguous School Enter Date. Attendance Enrollment may need to be used when students return to the current school after having left.
1.23Program
(Prog)
STU.SPSENR or SSID
Student Data 1 tab.

STU.SP values will be translated to these codes. Optionally a User Code field could be used.
1.24Grade
(Grd)
STU.GRSENR or SSID
Student Data 1 tab.
1.25School Leave Date
(Schl Leave Dt)
STU.LDSENR or SSID
Student Data 1 tab.

This information will also come from the ENR table if the district has good ENR data for multiple years. Local data management practices may need to be adjusted to treat the School Leave Date as the actual School Leave Date. Attendance Enrollment may need to be used when students return to the current school after leaving.
Student Data 2 tab.
This information will also be populated with the last day of school if the EOY fields have been populated.
1.27Completion Status
Code
STU.HSGSENR or SSID
Student Data 2 tab.

Map CALPADS Code Translations for Completer Status (STU.HSG).
2.09State Student ID
(State Stu ID)
STU.CIDSINF or SIAD
Student Data 2 tab.
2.10Perm ID#STU.IDSINF or SIAD
Student Data 1 tab.

Unique Aeries student identifier.
2.11First NameSTU.FNSINF or SIAD
Student Data 1 tab.
2.12Middle NameSTU.MNSINF or SIAD
Student Data 1 tab.
2.13Last NameSTU.LNSINF or SIAD
Student Data 1 tab.
2.14SuffixSTU.SFSINF or SIAD
Student Data 1 tab.
2.15First AliasSTU.FNASINF or SIAD
Student Data 1 tab.
2.16Middle AliasSTU.MNASINF or SIAD
Student Data 1 tab.
2.17Last AliasSTU.LNASINF or SIAD
Student Data 1 tab.
2.18BirthdateSTU.BDSINF or SIAD
Student Data 1 tab.
2.19GenderSTU.GNSINF or SIAD
Student Data 1 tab.
2.20Birth CitySTU.BCYSINF or SIAD
Student Data 1 tab.
2.21State STU.BSTSINF or SIAD
Student Data 1 tab.

These code values will be translated when extracted from Aeries.
2.22CountrySTU.BCUSINF or SIAD
Student Data 1 tab.

These code values will be translated when extracted from Aeries.
2.23EthnicitySTU.ETHSINF or SIAD
Student Data 1 tab.
2.24Ethnicity Missing STU.ETHSINF or SIAD
Student Data 1 tab.

If Ethnicity field is blank, this field will be flagged.
2.25Race 1STU.RC1SINF or SIAD
Student Data 1 tab.
2.26Race 2 STU.RC2SINF or SIAD
Student Data 1 tab.
2.27Race 3STU.RC3SINF or SIAD
Student Data 1 tab.
2.28Race 4 STU.RC4SINF or SIAD
Student Data 1 tab.
2.29Race 5 STU.RC5SINF or SIAD
Student Data 1 tab.
2.30Race Missing STU.RC#SINF or SIAD
Student Data 1 tab.

If all Race fields are blank, this field will be flagged.
2.38Parent/Guardian Education Level
(Ed Lvl)
STU.PEDSINF or SIAD
Student Data 1 tab.
2.39Parent/Guardian NameSTU.PGSINF or SIAD
Student Data 1 tab.
2.40Guardian 1 Last Name
SINF or SIAD
2.41Guardian 2 First Name
SINF or SIAD
2.42Guardian 2 Last Name
SINF or SIAD
3.07State Student ID
(State Stu ID)
STU.CIDSPRG
Student Data 2 tab.
3.08Perm ID#STU.IDSPRG
Student Data 1 tab.

Unique Aeries student identifier.
3.09First NameSTU.FNSPRG
Student Data 1 tab.
3.10Last NameSTU.LNSPRG
Student Data 1 tab.
3.11BirthdateSTU.BDSPRG
Student Data 1 tab.
3.12GenderSTU.GNSPRG
Student Data 1 tab.
4.07State Student ID
(State Stu ID)
STU.CIDSDIS
Student Data 2 tab.
4.08Perm ID#STU.IDSDIS
Student Data 1 tab.

Unique Aeries student identifier.
4.09First NameSTU.FNSDIS
Student Data 1 tab.
4.10Last NameSTU.LNSDIS
Student Data 1 tab.
4.11BirthdateSTU.BDSDIS
Student Data 1 tab.
4.12GenderSTU.GNSDIS
Student Data 1 tab.
10.07State Student ID
State Stu ID)
STU.CIDSCSE or SCSC
Student Data 2 tab.
10.08Perm ID#STU.IDSCSE or SCSC
Student Data 1 tab.

Unique Aeries student identifier
10.09First NameSTU.FNSCSE or SCSC
Student Data 1 tab.
10.10Last NameSTU.LNSCSE or SCSC
Student Data 1 tab.
10.11BirthdateSTU.BDSCSE or SCSC
Student Data 1 tab.
10.12Gender STU.GNSCSE or SCSC
Student Data 1 tab.
11.07State Student ID
(State Stu ID)
STU.CIDSCTE
Student Data 2 tab.
11.08Perm ID#STU.IDSCTE
Student Data 1 tab.

Unique Aeries student identifier
11.09First NameSTU.FNSCTE
Student Data 1 tab.
11.10Last NameSTU.LNSCTE
Student Data 1 tab.
11.11BirthdateSTU.BDSCTE
Student Data 1 tab.
11.12GenderSTU.GNSCTE
Student Data 1 tab.
12.07State Student ID
(State Stu ID)
STU.CIDSELA
Student Data 2 tab.
12.08First NameSTU.FNSELA
Student Data 1 tab.
12.09Last NameSTU.LNSELA
Student Data 1 tab.
12.10BirthdateSTU.BDSELA
Student Data 1 tab.
12.11GenderSTU.GNSELA
Student Data 1 tab.
12.12Perm ID#STU.IDSELA
Student Data 1 tab.
12.13Language Fluency
(LangFlu)
STU.LFSELA
Student Data 1 tab.
12.15Reporting Language
(RptgLng)
STU.HLSELA
Student Data 1 tab.
13.07State Student ID
(State Stu ID)
STU.CIDSTAS
Student Data 2 tab.
13.08Perm ID#STU.IDSTAS
Student Data 1 tab.

Unique Aeries student identifier
13.09First NameSTU.FNSTAS
Student Data 1 tab
.
13.10Last NameSTU.LNSTAS
Student Data 1 tab.
13.11BirthdateSTU.BDSTAS
Student Data 1 tab
.
13.12GenderSTU.GNSTAS
Student Data 1 tab.
Free and Reduced
3.15Start DateFRE.ESDSPRG
3.16End DateFRE.EEDSPRG
GATE
3.15Start DateGTE.ESDSPRG
If not using GATE table, See Student Programs:  PGM.ESD.
3.16End DateGTE.EEDSPRG
If not using GATE table, See Student Programs: PGM.EED.
Language Assessment
2.36US School K-12LAC.USSSINF or SIAD
This field is also located on the Demographics page.
12.14EL Start Date
Redesignation Date
IFEP Date
LAC.SD
LAC.RD1
LAC.IFD
SELA
  • EL Start Date (LAC.SD) will be used for EL students.
  • Redesignation Date (LAC.RD1) will be used for Redesignated students.
  • IFEP Date (LAC.IFD) will be used for IFEP students.
Master Schedule
9.10High Quality CTE CrsMST.HQCCRSE OR CRSC
MST.HQC values of Yes will be converted to a "154" value when extracted to CALPADS.
If teacher is not properly credentialed, populate the value with No. 
9.14SectionMST.SECRSE or CRSC
TCH.TN for Elementary Schools.
9.15Semester
(Sem)
MST.SMCRSE or CRSC
"FY" for Elementary Schools.
9.18Class IDMST.PD
MST.SM
MST.DY
CRSE or CRSC
This field is populated during the extract using information from many fields. This CALPADS field is used to associate multiple sections as being part of the same "Class" for purposes of determining Average Class Size. For Elementary Schools the definition level is SC+TN.
9.20Educational Service
(Ed Svc)
MST.ESRCRSE or CRSC
TCH.ESR for Elementary Schools.
9.21Language of Instruction
(Lang Instr)
MST.LICRSE or CRSC
TCH.LI for Elementary Schools. This field should only be populated if Education Service has a value of "1" or if Instructional Strategy has a value of "600". It should also never be populated with "English" or "Sign Language".
9.22Instructional Strategy
Instr Strategy)
MST.INS**As of the 2019/2020 school year, this field is not used.  English Learner Services will now be collected at the student level in the SPRG file as an Education Program code. 
9.23Independent Study
(Ind Study)
MST.ISICRSE or CRSC
TCH.ISI for Elementary Schools. A value of "Y" in this field will convert into the "Independent Study Indicator" CALPADS field when extracted.
9.24Distance Learning
(Dist Lrng)
MST.DLICRSE or CRSC
TCH.DLI for Elementary Schools. A value of "Y" in this field will convert into the "Distance Learning Indicator" CALPADS field when extracted.
9.25Multiple Teacher
(MultiTchr)
MST.MTSCRSE or CRSC
TCH.MTS for Elementary Schools.
9.26Educational Program Funding Source
(Fund Src)
MST.FSCRSE or CRSC
TCH.FS for Elementary Schools. This field should be populated as appropriate for codes:
113 – CA Partnership Academy 168 – Specialized Secondary Instruction.
9.27CTE Provider
(CTE Prvdr)
MST.TEPCRSE or CRSC
Populate this field if this section is a CTE course. Identify if this section is being administered by the "ROC/P" or "District". Not needed for Elementary Schools.
Map CALPADS Code Translations for CTE Provider (MST.TEP). 
9.31Charter IndicatorMST.CNCCRSE or CRSC
If the value on the section (MST.CNC) is different than the course (CRS.CNC) value, then MST.CNC will be extracted. Populate a Y or N to indicate if the charter school has identified the course course as non-core, non-college preparatory. Typically, non-core, non-college prep courses are not required for graduation.  
9.32AP/IB Course Code Cross ReferenceMST.ACCCRSE or CRSC
If the value on the section (MST.ACC) is different than the course (CRS.ACC) value, then MST.ACC will be extracted. Identifies the four-digit cross reference to the actual AP or IB State Course Code for AP or IB courses that a local educational agency has mapped to a Career Technical Education (CTE) State Course Code (7000-8999) because that course is part of a CTE pathway. This allows districts to map to the CTE State Course Code in the State Course Code field, while providing the cross-reference to the actual AP or IB course code.
9.33Online Course Instruction CodeMST. OITCRSE or CRSC
Populate the type of online instruction that is being delivered in a course section.
9.34Middle School Core IndicatorMST.MSCCRSE or CRSC
If the value on the section (MST.MSC) is different than the course (CRS.MSC) value, then MST.MSC will be extracted. Populate a Y or N to indicate if the course, in grades five through eight, is being taught as part of a middle school core setting.   
9.35Local Assignment OptionMST.NCACRSE or CRSC
Populate if the the local governing board authorized a teacher to teach a course without the appropriate credential or authorization.
9.36High Quality CTE CourseMST.HQC
Populate a Y or N if the course section and teacher meet the High Quality CTE Course qualifications.
School Options
1.04Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
SENR or SSID
1.05School CDS#LOC.SCSENR or SSID
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
1.06School of Attendance NPSLOC.SCSENR or SSID
  • District LOC records should populate this field with seven zeroes: "0000000".
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
2.06Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
SINF or SIAD
Located on Attendance Enrollment page for the current year.
2.07School of AttendanceLOC.SC
SINF or SIAD
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
3.04Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
SPRG
4.04Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
SDIS
4.05School CDS#LOC.SCSDIS
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
7.06Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
SDEM
8.04Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
SASS
9.04Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
CRSE or CRSC
9.05School CDS#LOC.SCCRSE or CRSC
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
10.04Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
SCSE or SCSC
10.05School CDS#LOC.SCSCSE or SCSC
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
11.04Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
SCTE
11.05School CDS#LOC.SCSCTE
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
12.04Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
SELA
12.05School CDS#LOC.SCSELA
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
13.04Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
STAS
13.05School CDS#LOC.SCSTAS
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
13.14Attendance Reporting
(Positive = Hourly)
LOC.BSTAS

Determined by school attendance setup.

Secondary Student Data
2.37SNOR - US Schl < 3 YrsSSD.SUSSINF or SIAD
This field is also located on the Demographics page.
3.20Migrant Ed - State Migrant IDSSD.MIDSPRG
This field is also located on the Program page.
Special Education
1.34Post-Secondary Program Status
and/or
Post-Secondary Employment
CSE.PSP
or
CSE.PSE
SENR
Select the CSE.PSP code to identify students in Special Education who are remaining in grade 12 till age 22. The CSE.PSE codes are also available, if applicable.
Map CALPADS Other Options for CSE.PSP and CSE.PSE codes.
3.15Entry DateCSE.EDSPRG
3.16Exit DateCSE.XDSPRG
3.21DisabilityCSE.DISPRG
Populate this field according the CASEMIS standards.
3.22District of ResidenceCSE.DRSPRG
Populate this field according the CASEMIS standards.
Special Programs
3.05School PGM.SCLSPRG
If this field is populated with a zero (0), the School of Attendance will be reported from the Attendance Enrollment (ATT) table.
3.13Program CodePGM.CDSPRG
Special Education, NSLP, GATE, and 504 Programs will be extracted from their specific tables.
  • Special Education is stored in CSE.
  • NSLP is stored in FRE.
  • GATE can be stored in PGM or GTE.
  • 504 can be stored in either PGM or FOF.
3.14 Program CodePGMEligibility and Participation Categories are hard-coded based on Program Code.
3.15Eligibility/Participation Start DatePGM.PSD
&
PGM.ESD
SPRG
Date will be extracted as entered in Aeries unless the date extends beyond the enrollment. If the date is before the Enrollment date, the Enrollment date will be used. In certain programs the Eligibility Start Date may also be extracted.

Special Education, NSLP, GATE, and 504 Programs will be extracted from their specific tables.
  • Special Education:  CSE.ED
  • NSLP:  FRE.ESD
  • GATE: GTE.ESD or PGM.ESD
  • 504: FOF.SD or PGM.ESD
3.16Eligibility/Participation End DatePGM.PED
&
PGM.EED
SPRG

Special Education, NSLP, GATE, and 504 Programs will be extracted from their specific tables.
  • Special Education:  CSE.ED
  • NSLP:  FRE.ESD
  • GATE: GTE.ESD or PGM.ESD
  • 504: FOF.SD or PGM.ESD
3.18Services ReceivedPGM.SRSPRG
If School Wide Title 1 (Education Program code = 121) SPRG records do not need to be submitted per CALPADS.
Map CALPADS Code Translations for Program Code Education Service - Title I Part A Basic (Education Program code = 122).
3.19CA PartnerShip AcademyPGM.CPASPRG
For Education Program Code = 113 this field was recently changed to be a 5 character field, enter the Academy ID in the COD table and select in this field.
3.23Homeless Dwelling Type PGM.HDTSPRG
For Education Program Code = 191 – Homeless.
Populate Homeless Dwelling Type.
3.24Unaccompanied Youth
(Unaccomp Youth)
PGM.UYSPRG
For Education Program Code = 191 – Homeless. An indication of whether or not a student who has been identified as homeless is not in the direct care of their parent or guardian.
3.25Runaway PGM.RASPRG
For Education Program Code = 191 – Homeless. An indication of whether or not a student who has been identified as homeless who is less than 18 years of age who has left home without parental/caregiver permission and stay away for one or more nights.
Note: Once a student is reported as a runaway youth for a given school year, even if the student is no longer a runaway, the indicator (PGM.RA) should not be changed to N unless a correction is being made.
Staff
7.04Hire DateSTF.HDSDEM
For Fall 1, July 1st of each academic year for returning staff or hire date for new staff. For EOY, May 1st of each academic year or hire date for staff hired after May 1st.  Automatically populated in SDEM extract.
7.05Leave DateSTF.LDSDEM

7.08State IDSTF.SIDSDEM
7.09Staff IDSTF.IDSDEM
Unique Aeries staff identifier.
7.10First NameSTF.FNSDEM
7.11Middle NameSTF.MNSDEM
7.12Last NameSTF.LNSDEM
7.13Previous First NameSTF.FNPSDEM
7.14Previous Middle NameSTF.MNPSDEM
7.15Previous Last NameSTF.LNPSDEM
7.16BirthdateSTF.BDSDEM
7.17SexSTF.GNSDEM
7.18EthnicitySTF.ETHSDEM
7.19Ethnicity Missing STF.ETHSDEM
If Ethnicity field is blank, this field will be flagged.
7.20Race STF.RC1SDEM
7.21Race 2 STF.RC2SDEM
7.22Race 3 STF.RC3SDEM
7.23Race 4 STF.RC4SDEM
7.24Race 5 STF.RC5SDEM
7.25Race Missing STF.RC#SDEM
If all Race fields are blank, this field will be flagged.
7.26Educational Level
(Educational Lvl)
STF.ELSDEM
7.27Position StatusSTF.PSSDEM
7.28Hire DateSTF.HDSDEM
7.29Leave DateSTF.LDSDEM
7.30Total Year in This DistrictSTF.TYDSDEM
7.31Total Years of Educational Service
(Total Years of Edu Service)
STF.TYSSDEM
8.05Primary SchoolSTF.PSCSASS
If assigned to more than one school, pulls from STA.SCL.
8.07State IDSTF.SIDSASS
8.08Staff IDSTF.IDSASS
Unique Aeries staff identifier.
8.09First NameSTF.FNSASS
8.10Last NameSTF.LNSASS
8.11BirthdateSTU.BDSASS
8.12SexSTF.SXSASS
9.16State IDSTF.SIDCRSE or CRSC
Staff Job Assignments
8.13Staff/Job Assignments
Job Classification
STJ.JCSASS
Job Assignments (STJ) window.
8.14Staff/Job Assignments
FTE
STJ.FTESASS
Job Assignments (STJ) window.
8.15Staff/Job Assignments
Non Classroom Based Job Assignment Codes
STF.NC1SASS
Job Assignments (STJ) window.
8.16Staff/Job Assignments
Non Classroom Based Job Assignment Code 2
STF.NC2SASS
Job Assignments (STJ) window.
8.17Staff/Job Assignments
Non Classroom Based Job Assignment Code 3
STF.NC3SASS
Job Assignments (STJ) window.
8.18Staff/Job Assignments
Non Classroom Based Job Assignment Code 4
STF.NC4SASS
Job Assignments (STJ) window.
8.19Staff/Job Assignments
Non Classroom Based Job Assignment Code 5
STF.NC5SASS
Job Assignments (STJ) window.
8.20Staff/Job Assignments
Non Classroom Based Job Assignment Code 6
STF.NC6SASS
Job Assignments (STJ) window.
8.21Staff/Job Assignments
Non Classroom Based Job Assignment Code 7
STF.NC7SASS
Job Assignments (STJ) window.
Teachers
9.17Teacher Number
(Tch#)
TCH.IDCRSE or CRSC
TCH.ID2 and TCH.ID3 call also be used to express Team Teaching or Job Sharing for Elementary Schools.
Transcript Definition
10.20Terms TDF.ST#SCSE or SCSC
Terms tab.

State Term Codes.
Transcripts
1.29Met UC CSU Requirements
STU.CCS
&
STU.CUC
SENR or SSID
Run the Update College Entrance Requirements function to populate.
10.14SectionHIS.SESCSE or SCSC
More button.
  • SCSE extracts from Crs Attendance (CAR.SE).
  • SCSC extracts from Transcripts (HIS.SE).
10.15Term
(Tm)
HIS.TESCSE or SCSC
  • SCSE extracts from the Master Schedule (MST.SM).
  • SCSC extracts from Transcripts (HIS.TE).
10.16Credits Attempted
(Atmp)
HIS.CRSCSE or SCSC
  • SCSE extracts from Courses (CRS.CR).
  • SCSC extracts from Transcripts (HIS.CR).
10.17Completed Credits
(Comp)
HIS.CCSCSE or SCSC
  • SCSE extracts from Courses (CRS.CR).
  • SCSC extracts from Transcripts (HIS.CC).
10.18MarkHIS.MKSCSE or SCSC
  • SCSE extracts from Courses (GRD.MK).
  • SCSC extracts from Transcripts (HIS.MK).