This chart lists each field from the CALPADS File Specifications documentation by each CALPADS extract.

For a full listing of Aeries fields by page see:  Aeries Cross Reference by Page 


SSID  Student Enrollment Identifier

SENR Student Enrollment Update

SINF Student Information

SELA Student English Language Acquisition

SPRG Student Program

SDEM Staff Demographics

SASS Staff Assignment

CRSE Course Section Enrollment

CRSC Course Section Completion

SCSE Student Course Section Enrollment

SCSC Student Course Section Completion

SCTE Student CTE

STAS Student Absence Summary

PSTS Postsecondary Status

SINC Student Incident

SIRS Student Incident Results

SOFF Student Offense

WBLR Work-Based Learning Records

 

CALPADS

Field #

CALPADS Field Name

Aeries

Table.Field

Comments/Notes

SSID  Student Enrollment Identifier

SENR Student Enrollment Update 

1.01Record Type Code
Must equal SENR.  
Automatically populated in SENR extract.
1.02Transaction Type Code
Must equal " ", A, D or R.  
Automatically populated in SENR extract.
1.03Local Record ID
Submission ID.  
Automatically populated in SENR extract.
1.04Reporting LEALOC.CC
+
LOC.DC

1.05School of AttendanceLOC.SC
  • 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.SCNPS schools should populate this field with six zeroes and a one: “0000001”.
1.07Academic Year ID
Determined by school calendar year.  
Automatically populated in SENR extract.
1.08State Student ID (SSID)STU.CIDUse the CALPADS Create SSID Extract to obtain and import SSIDS.
1.09Local Student IDSTU.IDUnique Aeries student identifier.
1.10Student Legal First NameSTU.FN
(LSI.LFN)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
1.11Student Legal Middle NameSTU.MN
(LSI.LMN)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
1.12Student Legal Last NameSTU.LN
(LSI.LLN)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
1.13Student Legal Name Suffix CodeSTU.SF
(LSI.LSF)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
1.14Student Alias First NameSTU.FNA
1.15Student Alias Middle NameSTU.MNA
1.16Student Alias Last NameSTU.FNA
1.17Student Birth DateSTU.BD
1.18Student Gender CodeSTU.GNWill extract from this field regardless if LSI is populated
1.19Student Birth CitySTU.BCY
1.20Student Birth State Provence CodeSTU.BSTThese code values will be translated when extracted from Aeries.
1.21Student Birth Country CodeSTU.BCUThese code values will be translated when extracted from Aeries.
1.22Enrollment Start DateSTU.EDThis 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.23Enrollment Status CodeSTU.SPSTU.SP values will be translated to these codes.  Optionally a User Code field could be used.
1.24Grade Level CodeSTU.GR
1.25Enrollment Exit DateSTU.LDThis 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. This information will also be populated with the last day of school if the EOY fields have been populated.
1.26Student Exit Reason CodeATT.RSMay also come from STU.SWR or STU.EOY.
1.27Student School Completion StatusSTU.HSGMap CALPADS Code Translations for Completer Status (STU.HSG).
1.28Expected Receiver School of AttendanceATT.NSOnly needed for Alternative schools or All records with an Exit Reason of "165" (Involuntary Transfer for Discipline).
1.29Student Met all UC CSU Requirements IndicatorSTU.CCS
&
STU.CUC
Run the Update College Entrance Requirements function to populate.
1.30Student School Transfer CodeATT.ITIf the Inter/Intra District field (STU.IT) on Student Demographics is populated, ATT.IT and ENR are also populated.
1.31District of Geographic Residence CodeATT.ITDIf the Inter/Intra District field (STU.ITD) on Student Demographics is populated, ATT.IT and ENR are also populated.
1.32Student Golden State Seal Merit Diploma IndicatorACT.CDMap CALPADS Other Options for ACT code.
1.33Student Seal of Biliteracy IndicatorACT.CDMap CALPADS Other Options for ACT code.
1.34
Adult Age Students with Disabilities in Transition Status
CSE.PSP
and/or
CSE.PSE
and/or
CSE.PSI
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.
1.35Graduation Exemption Indicator
STU.GEXStudent Data 2 tab.
This field is used with mapped CALPADS Code Translations for Completion Status (STU.HSG) CALPADS code 100 - Graduation HS Diploma. A value of Y or N is used.
Removed 9/15/2020
1.35
--Now extracted in PSTS file--
Workforce Readiness (Strategic Skills) Certificate Program Completion Indicator
ACT.CD--Data now stored in PSS table. This table can be accessed on Post-Secondary Survey tab located on Secondary Student Data page--
Removed 9/15/2020
1.36
--Now extracted in PSTS file--
Food Handler Certification Program Completion Indicator
ACT.CD--Data now stored in PSS table. This table can be accessed on Post-Secondary Survey tab located on Secondary Student Data page--
Removed 9/15/2020
1.37
--Now extracted in PSTS file--
Certified Pre-Apprenticeship Certification Program Completion Indicator
ACT.CD--Data now stored in PSS table. This table can be accessed on Post-Secondary Survey tab located on Secondary Student Data page--
Removed 9/15/2020
1.38
--Now extracted in PSTS file--
Non-Certified Pre-Apprenticeship Program Completion Indicator
ACT.CD--Data now stored in PSS table. This table can be accessed on Post-Secondary Survey tab located on Secondary Student Data page--
Removed 9/15/2020
-1.39
--Now extracted in PSTS file--
State or Federal Job Program Completion Indicator
ACT.CD--Data now stored in PSS table. This table can be accessed on Post-Secondary Survey tab located on Secondary Student Data page--

SINF Student Information  

SIAD Student Information Address (This extract was retired as of 7/1/2021)

2.01Record Type Code
Must equal SINF
Automatically populated in SINF extract.
2.02Transaction Type Code
Must equal " ", A or D.  
Automatically populated in SINF extract.
2.03Local Record ID
Submission ID.  
Automatically populated in SINF extract.
2.04Effective Start DateATT.CD = E
+
ATT.DT
Located on Attendance Enrollment page for the current year.
2.05Effective End Date
Effective End Date  
Automatically populated in CALPADS.
2.06Reporting LEALOC.CC
+
LOC.DC

2.07School of AttendanceLOC.SC
  • 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.
2.08Academic Year ID
Determined by school calendar year.  
Automatically populated in SINF extract.
2.09State Student ID (SSID)STU.CID
2.10Local Student IDSTU.IDUnique Aeries student identifier.
2.11Student Legal First NameSTU.FN
(LSI.LFN)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
2.12Student Legal Middle NameSTU.MN
(LSI.LMN)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
2.13Student Legal Last NameSTU.LN
(LSI.LLN)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
2.14Student Legal Name Suffix CodeSTU.SF
(LSI.LSF)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
2.15Student Alias First NameSTU.FNA
2.16Student Alias Middle NameSTU.MNA
2.17Student Alias Last NameSTU.LNA
2.18Student Birth DateSTU.BD
2.19Student Gender CodeSTU.GN
2.20Student Birth CitySTU.BCY
2.21Student Birth State Province CodeSTU.BSTThese code values will be translated when extracted from Aeries.
2.22Student Birth Country CodeSTU.BCUThese code values will be translated when extracted from Aeries.
2.23Student Hispanic Ethnicity IndicatorSTU.ETH
2.24Student Ethnicity Missing IndicatorSTU.ETHIf Ethnicity field is blank, this field will be flagged.
2.25Student Race 1 CodeSTU.RC1
2.26Student Race 2 CodeSTU.RC2
2.27Student Race 3 CodeSTU.RC3
2.28Student Race 4 CodeSTU.RC4
2.29Student Race 5 CodeSTU.RC5
2.30Student Race Missing IndicatorSTU.RC#If all Race fields are blank, this field will be flagged.
2.31Residential Address Line 1STU.ADMailing address fields from STU or ADH as appropriate
2.32Residential Address Line 2

2.33Residential Address City NameSTU.CYMailing address fields from STU or ADH as appropriate
2.34Residential Address State Province CodeSTU.STMailing address fields from STU or ADH as appropriate
2.35Residential Address Zip CodeSTU.ZCMailing address fields from STU or ADH as appropriate
2.36Student Initial US School Enrollment Date K-12LAC.USS
and/or
LAC.US3
This field is also displayed on the Demographics page.
LAC.US3 is required if the student entered US school prior to K/TK
2.37Enrolled in US School less than Three Cumulative Years IndicatorSSD.SUSThis field is also displayed on the Demographics page.
2.38Parent/Guardian1 Highest Education Level CodeCON.ELVParent/Guardian1 highest ed level will pull from Contacts based on District Settings. See Managing Contacts/Identifying Guardians for SINF Extract
2.39Guardian 1 First NameCON.FN(See Managing Contacts/Identifying Guardians for SINF Extract)
2.40Guardian 1 Last NameCON.LN(See Managing Contacts/Identifying Guardians for SINF Extract)
2.41Guardian 2 First NameCON.FN(See Managing Contacts/Identifying Guardians for SINF Extract)
2.42Guardian 2 Last NameCON.LN
(See Managing Contacts/Identifying Guardians for SINF Extract)
2.43Student Preferred First NameSTU.FNOnly extracted if Legal Student Info (LSI) table populated
2.44Student Preferred Last NameSTU.LNOnly extracted if Legal Student Info (LSI) table populated
2.45
Mailing Address Line 1

Will be added in the future to extract both addresses
2.46
Mailing Address Line2

Will be added in the future to extract both addresses
2.47
Mailing Address City Name

Will be added in the future to extract both addresses
2.48
Mailing Address State Province Code

Will be added in the future to extract both addresses
2.49
Mailing Address Zip Code

Will be added in the future to extract both addresses
2.50Parent Guardian2 Highest Education Level Code
CON.ELVParent/Guardian highest ed level will pull from Contacts based on District Settings. See Managing Contacts/Identifying Guardians for SINF Extract

SELA Student English Language Acquisition  

12.01Record Type Code
Must equal SELA.  
Automatically populated in SELA extract.
12.02Transaction Type Code
Must equal " ", A, D or R.  
Automatically populated in SELA extract.
12.03Local Record Id
Submission ID.  
Automatically populated in SELA extract.
12.04Reporting LEALOC.CC
+
LOC.DC

12.05School of AttendanceLOC.SC
  • 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.06Academic Year ID
Determined by school calendar year.  
Automatically populated in SELA extract.
12.07State Student ID (SSID)STU.CID
12.08Student Legal First NameSTU.FN
(LSI.LFN)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
12.09Student Legal Last NameSTU.LN
(LSI.LLN)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
12.10Student Birth DateSTU.BD
12.11Student Gender CodeSTU.GN
12.12Local Student IDSTU.ID
12.13English Language Acquisition Status CodeSTU.LFAs of 9/15/20 only codes EO, RFEP, or TBD will be extracted
12.14English Language Acquisition Status Start DateLAC.RD1
LAC.AES, LAC.STS, LAC.USS,
  STU.DD, or STU.ED
  • Redesignation Date (LAC.RD1) will be used for Redesignated students.
  • EO Start date will use LAC.STS, LAC.USS, STU.DD, STU.ED in this order
  • TBD Start date will use LAC.STS, LAC.USS, STU.DD, STU.ED in this order
  • ADEL Date (LAC.AES) will be used for Adult English Learner students (aged 22 or older) 
12.15Primary Language CodeSTU.HLAs of 2023-24 school year, the Primary Language codes reported to CALPADS will be extracted with the new 3 character codes. See New CALPADS Language Codes.

SPRG Student Program  

3.01Record Type Code
Must equal SPRG.  
Automatically populated in SPRG extract.
3.02Transaction Type Code
Must equal " ", A, D or R.  
Automatically populated in SPRG extract.
3.03Local Record ID
Submission ID.  
Automatically populated in SPRG extract.
3.04Reporting LEALOC.CC
+
LOC.DC

3.05School of AttendancePGM.SCLIf this field is populated with a zero (0), the School of Attendance will be reported from the Attendance Enrollment (ATT) table.
3.06Academic Year ID
Determined by school calendar year.
Automatically populated in SPRG extract.
3.07State Student ID (SSID)STU.CID
3.08Local Student IDSTU.IDUnique Aeries student identifier.
3.09Student Legal First NameSTU.FN
(LSI.LFN)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
3.10Student Legal Last NameSTU.LN
(LSI.LLN)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
3.11Student Birth DateSTU.BD
3.12Student Gender CodeSTU.GN
3.13Education Program CodePGM.CDSpecial 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.14Education Program Membership CodePGMFixed for Eligibility and Participation Categories.
3.15Education Program Membership Start DatePGM.PSD
&
PGM.ESD
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.16Education Program Membership End DatePGM.PED
&
PGM.EED
Date will be extracted as entered in Aeries unless the date extends beyond the last day of school. If the date entered is after the last day of school, the last day of school will be used for any programs requiring an annual end date in CALPADS. In certain programs the Eligibility End Date may also be extracted.

Special Education, NSLP, GATE, and 504 Programs will be extracted from their specific tables.
  • Special Education:  CSE.XD
  • NSLP:  FRE.EED
  • GATE: GTE.EED or PGM.EED
  • 504: FOF.ED or PGM.EED
3.17Education Service Academic Year
Determined by school calendar year.  Automatically populated in SPRG extract.
3.18Education Service CodePGS.SRIf 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.19California Partnership Academy IDPGM.CPAFor 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.20Migrant Student IDSSD.MIDThis field is also located on the Program page.
3.21Primary Disability CodeCSE.DIPopulate this field according to CASEMIS standards.
3.22District of Special Education AccountabilityCSE.DRPopulate this field according to CASEMIS standards.
3.23Homeless Dwelling Type CodePGM.HDTFor Education Program Code = 191 – Homeless.
Populate Homeless Dwelling Type.
3.24Unaccompanied Youth IndicatorPGM.UYFor 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 Youth IndicatorPGM.RAFor 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.
3.26Filler
Field no longer used.  Filled with blank.

SDEM Staff Demographics  

7.01Record Type Code
Must equal SDEM.  
Automatically populated in SDEM extract.
7.02Transaction Type Code
Must equal " ", A, or  D.  
Automatically populated in SDEM extract.
7.03Local Record ID
Submission ID.  
Automatically populated in SDEM extract.
7.04Effective Start date
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.05Effective End DateSTF.LD
7.06Reporting LEALOC.CC
+
LOC.DC

7.07Academic Year ID
Determined by school calendar year.  
Automatically populated in SDEM extract.
7.08State Educator ID (SEID)STF.SID
7.09Local Staff IDSTF.IDUnique Aeries staff identifier.  
7.10Staff Legal First NameSTF.FN
7.11Staff Legal Middle NameSTF.MN
7.12Staff Legal Last NameSTF.LN
7.13Staff Alias First NameSTF.FNP
7.14Staff Alias Middle NameSTF.MNP
7.15Staff Alias Last NameSTF.LNP
7.16Staff Birth DateSTF.BD
7.17Staff Gender CodeSTF.GN
7.18Staff Hispanic Ethnicity IndicatorSTF.ETH
7.19Staff Ethnicity Missing IndicatorSTF.ETHIf Ethnicity field is blank, this field will be flagged.
7.20Staff Race 1 CodeSTF.RC1
7.21Staff Race 2 CodeSTF.RC2
7.22Staff Race 3 CodeSTF.RC3
7.23Staff Race 4 CodeSTF.RC4
7.24Staff Race 5 CodeSTF.RC5
7.25Staff Race Missing IndicatorSTF.RC#If all Race fields are blank, this field will be flagged.
7.26Staff Highest Degree CodeSTF.EL
7.27Staff Employment Status CodeSTF.PS
7.28Staff Employment Start DateSTF.HD
7.29Staff Employment End DateSTF.LD
7.30Staff Service Years LEASTF.TYD
7.31Staff Service Years TotalSTF.TYS

SASS Staff Assignment  

8.01Record Type Code
Must equal SASS.  
Automatically populated in SASS extract.
8.02Transaction Type Code
Must equal " ", D, or R.  
Automatically populated in SASS extract.
8.03Local Record ID
Submission ID.  
Automatically populated in SASS extract.
8.04Reporting LEALOC.CC
+
LOC.DC

8.05School of AssignmentSTF.PSCIf assigned to more than one school, pulls from STJ.SCL.
8.06Academic Year ID
Determined by school calendar year.  
Automatically populated in SASS extract.
8.07State Educator ID (SEID)STF.SID
8.08Local Staff IDSTF.IDUnique Aeries staff identifier.  
8.09Staff Legal First NameSTF.FN
8.10Staff Legal Last NameSTF.LN
8.11Staff Birth DateSTF.BD
8.12Staff Gender CodeSTF.GN
8.13Staff Job ClassificationSTJ.JCAny STF record without an STJ record will not be extracted for CALPADS.
8.14Staff Job Classification FTE PercentageSTJ.FTEThis percentage of time spent on each job classification in relation to a full-time position (100%).
8.15Non Classroom Based Job Assignment Code 1STJ.NC1Required for all non-teaching assignments.  If the Staff Job Classification Code = 10 (Teacher) or 11 (Pupil Services) or 25 (Non-Certificated Administrator), then one or more of the Non Classroom Based Job Assignment Codes may be populated.
8.16Non Classroom Based Job Assignment Code 2STJ.NC2
8.17Non Classroom Based Job Assignment Code 3STJ.NC3
8.18Non Classroom Based Job Assignment Code 4STJ.NC4
8.19Non Classroom Based Job Assignment Code 5STJ.NC5
8.20Non Classroom Based Job Assignment Code 6STJ.NC6
8.21Non Classroom Based Job Assignment Code 7STJ.NC7

CRSE Course Section Enrollment  

CRSC Course Section Completion

9.01Record Type Code
Must equal CRSE or CRSC.  
Automatically populated in CRSE or CRSC  extract.
9.02Transaction Type Code
Must equal " ", D, or R.  
Automatically populated in CRSE or CRSC extract.
9.03Local Record ID
Submission ID.
Automatically populated in CRSE or CRSC extract.
9.04Reporting LEALOC.CC
+
LOC.DC

9.05School of Course DeliveryLOC.SC
  • 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.
9.06Academic Year ID
Determined by school calendar year.
Automatically populated in CRSE or CRSC extract.
9.07CRS-State Course CodeCRS.C3All 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.08CRS-Local Course IDCRS.CNAeries recommends a district-wide, unique Course ID for each course.  For an Elementary school, TCH.TN is used.
9.09CRS-Course NameCRS.COFor an Elementary school, TCH.TE is used.
9.10Filler
9.11Filler

9.12CRS-CTE Postsecondary Articulated Course IndicatorCRS.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.13CRS-UC CSU Approved IndicatorCRS.U1
etc.
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.14Course Section IDLOC.CD + MST.SE (CRSE)
HIS.SE (CRSC)
LOC.CD + TCH.TN for Elementary Schools.

Schools using schoolwide Alt Ed setting - courses are virtualized section numbers

Schools using Individual Alt Ed section setting - adds "V" before the virtual section number


9.15Academic Term CodeMST.SM
or CRS.TM
"FY" for Elementary Schools.
College courses use CRS
9.16State Educator ID (SEID)STF.SID
9.17Local Staff IDTCH.ID
SSE.ID
TCH.ID2 and TCH.ID3 can also be used to express Team Teaching or Job Sharing for Elementary Schools.
9.18Class IDLOC.CD + MST.TM +  STF.ID + MST.SE or TCH.TNThis 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.19Course Section Instructional Level CodeCRS.CLExisting Code Values will be Translated to CALPADS Codes. Not reported for Elementary Schools.
Map CALPADS Code Translations for Course Instruction Level (CRS.CL).

For code 24 – "Dual Credit" courses, the School of Dual Enrollment (HIS.SDE) and College Credit Hours (HIS.CH) fields must be populated.  A new course section and student course section will be virtualized and will include the code 24 value in the extract. 


For code 23 - "College Credit" only courses, the College Credit Hours (HIS.CH) field (greater than 0) and the School of Dual Enrollment (HIS.SDE) fields must both be populated in order for the record to be extracted as a college credit type course and be included in the CA Dashboard for College/Career Readiness.


See: How to enter a College Credit course on a student's transcript?


9.20Educational Service CodeMST.ESRTCH.ESR for Elementary Schools.
9.21Language of Instruction CodeMST.LITCH.LI for Elementary Schools.  This field should only be populated if Education Service has a value of "1". It should also never be populated with "English" or "Sign Language".
9.22Instructional Strategy CodeMST.INSTCH.INS for Elementary Schools.
9.23Independent Study IndicatorMST.ISITCH.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 IndicatorMST.DLITCH.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 CodeMST.MTSTCH.MTS for Elementary Schools
Populate MST.MTS when multi-teacher status is used for a single section. To flag all sections for a teacher, use TCH.MTS. The MST.MTS field is used in conjunction with MST.TN2 and TN3.
For Flex or section staff schools, see Flex Scheduling CRSE documentation.
9.26Education Program Funding Source CodeMST.FSTCH.FS for Elementary Schools.  This field should be populated as appropriate for codes:
113 – CA Partnership Academy 168 – Specialized Secondary Instruction.
9.27CTE Course Section Provider CodeMST.TEPPopulate 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.28Course Content Area Subcategory CodeCRS.CSC
or
MST.CSC
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 Standards Grade Level Range CodeCRS.SGRPopulate 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.CSAPopulate 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 Non-Core, Non-College Prep Course IndicatorCRS.CNC
or
MST.CNC
Data element retired 7/1/2021 
9.32AP/IB Course Code Cross ReferenceCRS.ACC
or
MST.ACC
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.33Online Course Instruction CodeMST.OIT

Populate the type of online instruction that is being delivered in a course section.  
9.34Middle School Core Setting IndicatorCRS.MSC
or
MST.MSC
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 where one teacher is teaching two or more subject areas to the same students on the same day. If the value on the section (MST.MSC) is different than the course (CRS.MSC) value, then MST.MSC will be extracted. 
9.35Local Assignment Option CodeMST.NCAPopulate if the the local governing board authorized a teacher to teach a course without the appropriate credential or authorization.
9.36High Quality CTE Course IndicatorMST.HQCPopulate a Y or N if the course section and teacher meet the High Quality CTE Course qualifications.

SCSE Student Course Section Enrollment  

SCSC Student Course Section Completion

10.01Record Type Code
Must equal SCSE or SCSC.  
Automatically populated in SCSE or SCSC extract.
10.02Transaction Type Code
Must equal " ", D, or R.  
Automatically populated in SCSE or SCSC extract.
10.03Local Record Id
Submission ID.  
Automatically populated in SCSE or SCSC extract.
10.04Reporting LEALOC.CC
+
LOC.DC

10.05School of Course DeliveryLOC.SC
  • 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.06Academic Year ID
Determined by school calendar year.
Automatically populated in SCSE or SCSC extract.
10.07State Student ID (SSID)STU.CID
10.08Local Student IDSTU.ID
10.09Student Legal First NameSTU.FN
(LSI.LFN)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
10.10Student Legal Last NameSTU.LN
(LSI.LLN)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
10.11Student Birth DateSTU.BD
10.12Student Gender CodeSTU.GN
10.13Local Course IDCRS.CN
10.14Course Section IDLOC.CD + HIS.SE or CAR.SE
  • SCSE extracts from Crs Attendance (CAR.SE).
  • SCSC extracts from Transcripts (HIS.SE).
  • LOC.CD + TCH.TN for Elementary Schools.
10.15Academic Term CodeHIS.TE or MST.SM or CRS.TM
  • SCSE extracts from the Master Schedule (MST.SM).
  • SCSC extracts from Transcripts (HIS.TE).
  • "Y" for Elementary Schools.
  • SCSC extracts from CRS.TM for College Courses
10.16Student Credits AttemptedHIS.CR or
CRS.CR
  • SCSE extracts from Courses (CRS.CR).
  • SCSC extracts from Transcripts (HIS.CR).
10.17Student Credits EarnedHIS.CC or CRS.CR
  • SCSE extracts from Courses (CRS.CR).
  • SCSC extracts from Transcripts (HIS.CC).
10.18Student Course Final GradeHIS.MK or GRD.MK
  • SCSE extracts from Courses (GRD.MK).
  • SCSC extracts from Transcripts (HIS.MK).
10.19UC/CSU Admission Requirement CodeCRS.E1
or
CRS.U1
or
CRS.U2

10.20Marking Period CodeTDF.ST#State Term Codes on the Terms Tab.
10.21Carnegie Units Earned
Only populated for SCSC
Automatically calculated by taking Credits Completed (HIS.CC) and dividing by the 1 Yr Crs Units value from the School Information page (LOC.YCU)

SCTE Student CTE  

11.01Record Type Code
Must equal SCTE.  
Automatically populated in SCTE extract.
11.02Transaction Type Code
Must equal " ", D, or R.  
Automatically populated in SCTE extract.
11.03Local Record ID
Submission ID.  
Automatically populated in SCTE extract.
11.04Reporting LEALOC.CC
+
LOC.DC

11.05School of AttendanceLOC.SC
  • 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.06Academic Year ID
Determined by school calendar year.  
Automatically populated in SCTE extract.
11.07State Student ID (SSID)STU.CID
11.08Local Student IDSTU.IDUnique Aeries student identifier.
11.09Student Legal First NameSTU.FN
(LSI.LFN)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
11.10Student Legal Last NameSTU.LN
(LSI.LLN)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
11.11Student Birth DateSTU.BD
11.12Student Gender CodeSTU.GN
11.13CTE Pathway CodeCPW.CD
11.14CTE Pathway Complete Academic Year IDCPH.AYOnly extracted on Career Pathway records identified as "Completed" for the current year.

STAS Student Absence Summary  

13.01Record Type Code
Must equal STAS.  
Automatically populated in STAS extract.
13.02Transaction Type Code
Must equal " ", D, or R.  
Automatically populated in STAS extract.
13.03Local Record ID
Submission ID.  
Automatically populated in STAS extract.
13.04Reporting LEALOC.CC
+
LOC.DC

13.05School of AttendanceLOC.SC
  • 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.06Academic Year ID
Determined by school calendar year.  
Automatically populated in STAS extract.
13.07State Student ID (SSID)STU.CID
13.08Local Student IDSTU.ID
13.09Filler

13.10Filler

13.11Filler

13.12Filler

13.13Student Absence Summary Data Collection Exemption Indicator
Determined by 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.14Hourly Attendance School Type IndicatorLOC.BDetermined by school attendance setup.
13.15Expected Attendance DaysAHS.EN
13.16Days AttendedAHS.PR
13.17Days Absent Out-of-School SuspensionAHS.SU
13.18Days in Attendance In-School SuspensionAHS.ISS
13.19Days Absent Excused Non-SuspensionAHS.AE
13.20Days Absent Unexcused Non-SuspensionAHS.AU
13.21Non-ADA Generating Independent Study Days AHS.ISI
13.22ADA Generating Independent Study Days
AHS.ISC
13.23Period-by-Period Attendance Method Indicator
LOC.A = 1

PSTS Postsecondary Status  

17.01Record Type Code
Must equal PSTS.  
Automatically populated in PSTS extract.
17.02Transaction Type Code
Must equal " ", D, or R.  
Automatically populated in PSTS extract.
17.03Local Record ID
Submission ID.  
Automatically populated in PSTSextract.
17.04Reporting LEALOC.CC
+
LOC.DC

17.05School of AttendanceLOC.SC
  • 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.
17.06School of Attendance NPSCSE.TY
17.07Academic Year ID
Determined by school calendar year.  
Automatically populated in PSTS extract.
17.08State Student ID (SSID)STU.CID
17.09Local Special Education Student IDCSE.SEIOnly populated for SWD students for EOY4 extract
17.10Reporting SELPACSE.SEOnly populated for SWD students for EOY4 extract
17.11Education Program Participation Type Code
  • 10 - populated if PGM.CD=113-CA Partnership Academy and PGM.PED is null or in the future
  • 20 - populated if CPW.CM = True (CTE Completer)
  • 30 - Populated if CSE.XD is null and CSE.DI does not equal 200 **See Note Below
17.12Postsecondary Status CodePSS.CDOnly extracted if student meets one of the Program Participation Type Codes listed above
17.13Educational Institution TypePSS.EIT

The type of educational or training institution based on the institution’s tax status: Public, Private Nonprofit, For Profit.

Only required for codes 200 through 350 (inclusive)
17.14

Industry Field

PSS.IFC

The industry sector that best represents the field in which the respondent is employed, or the field in which the respondent will potentially be employed upon completion of the educational or training program where they are currently enrolled.

Only required for codes 910, 920, or 930
17.15

Post-High School Credential

PSS.PSC

A post-high school credential includes, an industry-recognized certification provided by a third-party entity, a degree or certificate issued by a postsecondary institution, a license issued by the State of California, or other measure of technical skill attainment that the respondent has received. 

SINC Student Incident  

18.01Record Type Code
Must equal SINC.  
Automatically populated in SINC extract.
18.02Transaction Type Code
Must equal " " or D.  
Automatically populated in SINC extract.
18.03Local Record ID
Submission ID.  
Automatically populated in SINC extract.
18.04Reporting LEALOC.CC
+
LOC.DC

18.05School of AttendanceLOC.SC
  • 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.06Academic Year ID
Determined by school calendar year.  
Automatically populated in SINC extract.
18.07State Student ID (SSID)STU.CID
18.08Local Student IDSTU.IDUnique Aeries student identifier.
18.09Student Legal First NameSTU.FN
(LSI.LFN)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
18.10Student Legal Last NameSTU.LN
(LSI.LLN)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
18.11Student Birth DateSTU.BD
18.12Student Gender CodeSTU.GN
18.13Disciplinary Incident ID LocalADS.IID
18.14Incident Occurrence DateADS.DT
18.15Statutory  Offense Indicator  
If ADS.CD is a suspendable offense, then "Y", else "N" 
Suspendable Offense Code Table must be populated for proper extraction. 
Automatically populated in SINC extract.
18.16Student Instructional Support IndicatorADS.ISIThis field is required to be populated with a "Y" or "N" for all records with Statutory Offense Indicator
18.17Removal to Interim Alternative Setting Reason CodeADS.RRA 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.

SIRS Student Incident Results  

19.01Record Type Code
Must equal SIRS.  
Automatically populated in SIRS extract.
19.02Transaction Type Code
Must equal " " or D.  
Automatically populated in SIRS extract.
19.03Local Record ID
Submission ID.  
Automatically populated in SIRS extract.
19.04Reporting LEALOC.CC
+
LOC.DC

19.05School of AttendanceLOC.SC
  • 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.
19.06Academic Year ID
Determined by school calendar year.  
Automatically populated in SIRS extract.
19.07State Student ID (SSID)STU.CID
19.08Local Student IDSTU.IDUnique Aeries student identifier.
19.09Student Legal First NameSTU.FN
(LSI.LFN)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
19.10Student Legal Last NameSTU.LN
(LSI.LLN)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
19.11Student Birth DateSTU.BD
19.12Student Gender CodeSTU.GN
19.13Disciplinary Incident ID LocalADS.IID
19.14Incident Result CodeDSP.DS
BER.CD
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 CodeDSP.AAAll Suspension and Expulsion records must have this field populated.
Map CALPADS Code Translations for Disciplinary Action Authority (DSP.AA).
19.16Incident Results Duration DaysDSP.DYAll Suspension and Expulsion records must have this field populated.  Partial days should be entered with a decimal.  DSP.HR Hours will not be extracted.
19.17Incident Result Modification  CodeEXP.EMCThis field is located on the Expulsion tab and 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).

SOFF Student Offense  

20.01Record Type Code
Must equal SOFF.  
Automatically populated in SOFF extract.
20.02Transaction Type Code
Must equal " " or D.  
Automatically populated in SOFF extract.
20.03Local Record ID
Submission ID.  
Automatically populated in SOFF extract.
20.04Reporting LEALOC.CC
+
LOC.DC

20.05School of AttendanceLOC.SC
  • 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.
20.06Academic Year ID
Determined by school calendar year.  
Automatically populated in SOFF extract.
20.07State Student ID (SSID)STU.CID
20.08Local Student IDSTU.IDUnique Aeries student identifier.
20.09Student Legal First NameSTU.FN
(LSI.LFN)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
20.10Student Legal Last NameSTU.LN
(LSI.LLN)
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
20.11Student Birth DateSTU.BD
20.12Student Gender CodeSTU.GN
20.13Disciplinary Incident ID LocalADS.IID
20.14Student Offense CodeADS.CDPlace 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.WTAlthough 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).

WBLR Work-Based Learning Records  

21.01Record Type Code
Must equal WBLR.  
Automatically populated in WBLR extract.
21.02Transaction Type Code
Must equal " " or D.  
Automatically populated in WBLR extract.
21.03Local Record ID
Submission ID.  
Automatically populated in WBLR extract.
21.04Reporting LEALOC.CC
+
LOC.DC

21.05School of AttendanceLOC.SC
  • 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.

21.06School of Attendance NPSCSE.TY
21.07Academic Year IDSTU.CIDDetermined by school calendar year.  
Automatically populated in WBLR extract.
21.08State Student ID (SSID)STU.CID
21.09

Work-Based Learning Type Code

ISP.WTA coded value representing the work-based learning that the student completed during the academic year, in any grades 9-12.
21.10Internship IDISP.ID + ISP.SQThis field is populated during the extract using information from many fields.
21.11Work-based Learning Hours - ExternalISP.TXHThe count of hours that the student spent outside of school in a work-based learning activity for types 10, 15, and 20 in the academic year being reported.  While the hours are outside of classroom, the work-based learning activity is tied to the Internship, Student-Led Enterprise, or Virtual/Simulated Work-Based Learning. Rounded to whole numbers.
21.12State Course Code -Embedded Work-based LearningISP.SE translated into CRS.C3The State Course Code that the student completed in which the Internship, Student-Led Enterprise, or Virtual/Simulated Work-Based Learning was embedded. May or may not be CTE course. Not required for Internships.
21.13Internship -Employer Performance Evaluation CodeISP.EEA coded value representing the student’s performance in the internship as evaluated by their employment supervisor. Required for Internships. Values are hard-coded.
21.14Internship -LEA Sponsored IndicatorISP.SCSAn indication of whether the school, district, or county played a direct role in securing the internship for the student. A “Y” would indicate that the school, district, or county played a direct role in securing the internship. An “N” would indicate it did not.
21.15Internship –Certificated Supervisor IndicatorISP.CSAn indication of whether the internship was part of a program supervised by a certificated staff member of the school, district, or county. A “Y” would indicate that the internship was part of a program supervised by a certificated staff member of the school, district, or county. An “N” would indicate that it was not.


The following extracts are NOT available in Aeries, they go to CALPADS directly from the Special Education Data Systems:

  • SPED - Special Education Program
  • SSRV - Student Services
  • PSTS - Post-Secondary Transistion Status **For Special Education Students only, data comes from Special Education Data Ssystem only for EOY