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.CDMoving to PSTS
Map CALPADS Other Options for ACT code.
1.36Food Handler Certification Program Completion IndicatorACT.CDMoving to PSTS
Map CALPADS Other Options for ACT code.
1.37Pre-Apprenticeship Certification Program Completion IndicatorACT.CDMoving to PSTS
Map CALPADS Other Options for ACT code.
1.38Pre-Apprenticeship Program (non-certified) Completion IndicatorACT.CDMoving to PSTS
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
18.13
19.13
2013
Incident IDADS.IIDSINC
SIRS
SOFF
18.14Incident DateADS.DTSINC
18.15Statutory Offense Indicator 
SINC
Automatically populated with Y if Student Offense Code populated on the Suspendable Offense (SOC) Code table
20.14Student Offense Code
ADS.CDSOFF
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). 
20.15Weapon Category codeADS.WTSOFF
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). 
19.14Incident Result Code DSP.DS
(and BER.CD if linked to same ADS.IID)
SIRS
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). 
19.15Incident Result Authority Code DSP.AASIRS
All Suspension and Expulsion records must have this field populated.
Map CALPADS Code Translations for Disciplinary Action Authority (DSP.AA). 
19.16Incident Results Duration Days DSP.DYSIRS
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.
18.16Student Instructional Support Indicator ADS.ISISINC
This field is required to be populated with a "Y" or "N" for ALL students. (Previously only required for Suspension/Expulsion records for Special Ed students.)
19.17Incident Result Modification Code EXP.EMCSIRS
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). 
18.17Removal to Interim Alternative Setting ADS.RRSINC
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
Effective Start Date - Located on Attendance Enrollment page for the current year.
2.05End Date
Attendance Enrollment

SINF or SIAD
Effective End Date  
Automatically populated in Calpads.
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 and will extract with "Y".  All others will extract with "N".  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.28Content SubcategoryCRS.CSCCRSE or CRSC
California Specific Fields tab.

Populate if course contains a more detailed subject matter within an area of course content.  For example, "piano" is a subcategory of a "Music - Instrumental" course.  If the value on the section (MST.CSC) is different than the course (CRS.CSC) value, then MST.CSC will be extracted. 
9.29Course Content Area Subcategory Code
CRS.SGRCRSE 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.
When populating this field, the value should be based on the standards grade level of the course content and not the grade levels of the students enrolled in the course.

EX:  If a class of 4 and 5th graders is taught based on an Elementary curriculum, then the "ELM" code should be used.

9.30Content Standards AlignmentCRS.CSACRSE 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.) 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.34Middle School Core IndicatorCRS.MSC
CRSE 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 (SSID)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.FN
(LSI.LFN)
SENR or SSID
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
1.11Middle NameSTU.MN
(LSI.LMN)
SENR or SSID
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
1.12Last NameSTU.LN
(LSI.LLN)
SENR or SSID
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
1.13Suffix STU.SF
(LSI.LSF)
SENR or SSID
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
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 (SSID)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.FN
(LSI.LFN)
SINF or SIAD
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
2.12Middle NameSTU.MN
(LSI.LMN)
SINF or SIAD
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
2.13Last NameSTU.LN
(LSI.LLN)
SINF or SIAD
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
2.14SuffixSTU.SF
(LSI.LSF)
SINF or SIAD
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
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.39Guardian 1 Last Name
(Parent/Guardian Name)
STU.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
2.43Student Preferred First NameSTU.FNSINF or SIAD
Only if Legal Student Info (LSI) table populated
2.44Student Preferred Last Name
STU.LNSINF or SIAD
Only if Legal Student Info (LSI) table populated
^.07State Student ID (SSID)STU.CIDSPRG, SCSE, SCSC, SCTE, SELA, STAS, SINC, SIRS, SOFF, PSTS
Student Data 2 tab.
^.08Perm ID#STU.IDSPRG, SCSE, SCSC, SCTE, SELA, STAS, SINC, SIRS, SOFF
Student Data 1 tab.

Unique Aeries student identifier.
^.09First NameSTU.FN
(LSI.LFN)
SPRG, SCSE, SCSC, SCTE, SELA, STAS, SINC, SIRS, SOFF
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
^.10Last NameSTU.LN
(LSI.LLN)
SPRG, SCSE, SCSC, SCTE, SELA, STAS, SINC, SIRS, SOFF
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
^.11BirthdateSTU.BDSPRG, SCSE, SCSC, SCTE, SELA, STAS, SINC, SIRS, SOFF
Student Data 1 tab.
^.12GenderSTU.GNSPRG, SCSE, SCSC, SCTE, SELA, STAS, SINC, SIRS, SOFF
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.14ELAS Start Date:
RFEP - (Redesignated EL's)
EO - (English only)

LAC.RD1
(LAC.STS, LAC.USS, STU.DD, STU.ED)
SELA
  • Redesignation Date (LAC.RD1) will be used for RFEP students.
  • EO Start date will use either LAC.STS, LAC.USS, STU.DD, or STU.ED in this order
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. OIT
CRSE or CRSC
Populate the type of online instruction that is being delivered in a course section. 
9.34Middle School Core IndicatorMST.MSC
CRSE 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.HQCCRSE or CRSC
Populate a Y or N if the course section and teacher meet the High Quality CTE Course qualifications.
School Options
^.04Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
SENR, SSID, SASS, CRSE, CRSC, SCSE, SCSC, SCTE, SELA, STAS, PSTS, SINC, SIRS, SOFF, SPRG
2.06
Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
SINF or SIAD
Located on Attendance Enrollment page for the current year.
^.05School CDS#LOC.SCSENR, SSID, SASS, CRSE, CRSC, SCSE, SCSC, SCTE, SELA, STAS, PSTS, SINC, SIRS, SOFF
  • 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.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
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.05

School of Course DeliveryLOC.SCCRSE, CRSC
SCSE 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.
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.

17.04Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
PSTS
17.05School CDS#
LOC.SC
PSTS
  • 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

18.04
19.04
20.04
Reporting LEA
(County CDS# + District CDS#)


18.05
19.05
20.05
School CDS#


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.
17.12Postsecondary Status Code
SSD.PSS
PSTS
This field is located on the Perkins tab
Special Education
1.34Adult Age with Students with Disabilities Transition
(Renamed from Post-Secondary Program Status and/or Post-Secondary Employment)
CSE.PSP
and/or
CSE.PSE
and/or
CSE.PSI
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.
17.06

School of Attendance NPS

CSE.TY
PSTS
17.09
Local Special Education Student ID
CSE.SEI
PSTS
Reporting to be done via Special Ed Database, not Aeries
17.10
Reporting SELPA
CSE.SE
PSTS
Reporting to be done via Special Ed Database, not Aeries
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 Educator ID (SEID)STF.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.17GenderSTF.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 Educator ID (SEID)STF.SIDSASS
8.08Staff IDSTF.IDSASS
Unique Aeries staff identifier.
8.09First NameSTF.FNSASS
8.10Last NameSTF.LNSASS
8.11BirthdateSTU.BDSASS
8.12GenderSTF.GNSASS
9.16State Educator ID (SEID)STF.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
STJ.NC1SASS
Job Assignments (STJ) window.
8.16Staff/Job Assignments
Non Classroom Based Job Assignment Code 2
STJ.NC2SASS
Job Assignments (STJ) window.
8.17Staff/Job Assignments
Non Classroom Based Job Assignment Code 3
STJ.NC3SASS
Job Assignments (STJ) window.
8.18Staff/Job Assignments
Non Classroom Based Job Assignment Code 4
STJ.NC4SASS
Job Assignments (STJ) window.
8.19Staff/Job Assignments
Non Classroom Based Job Assignment Code 5
STJ.NC5SASS
Job Assignments (STJ) window.
8.20Staff/Job Assignments
Non Classroom Based Job Assignment Code 6
STJ.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 can 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).


^ - all the listed extracts use the same Aeries field in the same location; only the number of the extract itself changes; i.e. SPRG is extract 3, SINF=18, SIRS = 19, SOFF = 20, etc.