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
SELA Student English Language Acquisition
CRSE Course Section Enrollment
CRSC Course Section Completion
SCSE Student Course Section Enrollment
SCSC Student Course Section Completion
WBLR Work-Based Learning Records
CALPADS Field # | CALPADS Field Name | Aeries Table.Field | Comments/Notes |
SSID Student Enrollment IdentifierSENR Student Enrollment Update | |||
1.01 | Record Type Code | Must equal SENR. Automatically populated in SENR extract. | |
1.02 | Transaction Type Code | Must equal " ", A, D or R. Automatically populated in SENR extract. | |
1.03 | Local Record ID | Submission ID. Automatically populated in SENR extract. | |
1.04 | Reporting LEA | LOC.CC + LOC.DC | |
1.05 | School of Attendance | LOC.SC |
|
1.06 | School of Attendance NPS | LOC.SC | NPS schools should populate this field with six zeroes and a one: “0000001”. |
1.07 | Academic Year ID | Determined by school calendar year. Automatically populated in SENR extract. | |
1.08 | State Student ID (SSID) | STU.CID | Use the CALPADS Create SSID Extract to obtain and import SSIDS. |
1.09 | Local Student ID | STU.ID | Unique Aeries student identifier. |
1.10 | Student Legal First Name | STU.FN (LSI.LFN) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
1.11 | Student Legal Middle Name | STU.MN (LSI.LMN) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
1.12 | Student Legal Last Name | STU.LN (LSI.LLN) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
1.13 | Student Legal Name Suffix Code | STU.SF (LSI.LSF) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
1.14 | Student Alias First Name | STU.FNA | |
1.15 | Student Alias Middle Name | STU.MNA | |
1.16 | Student Alias Last Name | STU.FNA | |
1.17 | Student Birth Date | STU.BD | |
1.18 | Student Gender Code | STU.GN | Will extract from this field regardless if LSI is populated |
1.19 | Student Birth City | STU.BCY | |
1.20 | Student Birth State Provence Code | STU.BST | These code values will be translated when extracted from Aeries. |
1.21 | Student Birth Country Code | STU.BCU | These code values will be translated when extracted from Aeries. |
1.22 | Enrollment Start Date | STU.ED | 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.23 | Enrollment Status Code | STU.SP | STU.SP values will be translated to these codes. Optionally a User Code field could be used. |
1.24 | Grade Level Code | STU.GR | |
1.25 | Enrollment Exit Date | STU.LD | 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. This information will also be populated with the last day of school if the EOY fields have been populated. |
1.26 | Student Exit Reason Code | ATT.RS | May also come from STU.SWR or STU.EOY. |
1.27 | Student School Completion Status | STU.HSG | Map CALPADS Code Translations for Completer Status (STU.HSG). |
1.28 | Expected Receiver School of Attendance | ATT.NS | Only needed for Alternative schools or All records with an Exit Reason of "165" (Involuntary Transfer for Discipline). |
1.29 | Student Met all UC CSU Requirements Indicator | STU.CCS & STU.CUC | Run the Update College Entrance Requirements function to populate. |
1.30 | Student School Transfer Code | ATT.IT | If the Inter/Intra District field (STU.IT) on Student Demographics is populated, ATT.IT and ENR are also populated. |
1.31 | District of Geographic Residence Code | ATT.ITD | If the Inter/Intra District field (STU.ITD) on Student Demographics is populated, ATT.IT and ENR are also populated. |
1.32 | Student Golden State Seal Merit Diploma Indicator | ACT.CD | Map CALPADS Other Options for ACT code. |
1.33 | Student Seal of Biliteracy Indicator | ACT.CD | Map 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.35 | Graduation Exemption Indicator | STU.GEX | Student 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.01 | Record Type Code | Must equal SINF Automatically populated in SINF extract. | |
2.02 | Transaction Type Code | Must equal " ", A or D. Automatically populated in SINF extract. | |
2.03 | Local Record ID | Submission ID. Automatically populated in SINF extract. | |
2.04 | Effective Start Date | ATT.CD = E + ATT.DT | Located on Attendance Enrollment page for the current year. |
2.05 | Effective End Date | Effective End Date Automatically populated in CALPADS. | |
2.06 | Reporting LEA | LOC.CC + LOC.DC | |
2.07 | School of Attendance | LOC.SC |
|
2.08 | Academic Year ID | Determined by school calendar year. Automatically populated in SINF extract. | |
2.09 | State Student ID (SSID) | STU.CID | |
2.10 | Local Student ID | STU.ID | Unique Aeries student identifier. |
2.11 | Student Legal First Name | STU.FN (LSI.LFN) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
2.12 | Student Legal Middle Name | STU.MN (LSI.LMN) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
2.13 | Student Legal Last Name | STU.LN (LSI.LLN) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
2.14 | Student Legal Name Suffix Code | STU.SF (LSI.LSF) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
2.15 | Student Alias First Name | STU.FNA | |
2.16 | Student Alias Middle Name | STU.MNA | |
2.17 | Student Alias Last Name | STU.LNA | |
2.18 | Student Birth Date | STU.BD | |
2.19 | Student Gender Code | STU.GN | |
2.20 | Student Birth City | STU.BCY | |
2.21 | Student Birth State Province Code | STU.BST | These code values will be translated when extracted from Aeries. |
2.22 | Student Birth Country Code | STU.BCU | These code values will be translated when extracted from Aeries. |
2.23 | Student Hispanic Ethnicity Indicator | STU.ETH | |
2.24 | Student Ethnicity Missing Indicator | STU.ETH | If Ethnicity field is blank, this field will be flagged. |
2.25 | Student Race 1 Code | STU.RC1 | |
2.26 | Student Race 2 Code | STU.RC2 | |
2.27 | Student Race 3 Code | STU.RC3 | |
2.28 | Student Race 4 Code | STU.RC4 | |
2.29 | Student Race 5 Code | STU.RC5 | |
2.30 | Student Race Missing Indicator | STU.RC# | If all Race fields are blank, this field will be flagged. |
2.31 | Residential Address Line 1 | STU.AD | Mailing address fields from STU or ADH as appropriate |
2.32 | Residential Address Line 2 | ||
2.33 | Residential Address City Name | STU.CY | Mailing address fields from STU or ADH as appropriate |
2.34 | Residential Address State Province Code | STU.ST | Mailing address fields from STU or ADH as appropriate |
2.35 | Residential Address Zip Code | STU.ZC | Mailing address fields from STU or ADH as appropriate |
2.36 | Student Initial US School Enrollment Date K-12 | LAC.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.37 | Enrolled in US School less than Three Cumulative Years Indicator | SSD.SUS | This field is also displayed on the Demographics page. |
2.38 | Parent/Guardian1 Highest Education Level Code | CON.ELV | Parent/Guardian1 highest ed level will pull from Contacts based on District Settings. See Managing Contacts/Identifying Guardians for SINF Extract |
2.39 | Guardian 1 First Name | CON.FN | (See Managing Contacts/Identifying Guardians for SINF Extract) |
2.40 | Guardian 1 Last Name | CON.LN | (See Managing Contacts/Identifying Guardians for SINF Extract) |
2.41 | Guardian 2 First Name | CON.FN | (See Managing Contacts/Identifying Guardians for SINF Extract) |
2.42 | Guardian 2 Last Name | CON.LN | (See Managing Contacts/Identifying Guardians for SINF Extract) |
2.43 | Student Preferred First Name | STU.FN | Only extracted if Legal Student Info (LSI) table populated |
2.44 | Student Preferred Last Name | STU.LN | Only 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.50 | Parent Guardian2 Highest Education Level Code | CON.ELV | Parent/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.01 | Record Type Code | Must equal SELA. Automatically populated in SELA extract. | |
12.02 | Transaction Type Code | Must equal " ", A, D or R. Automatically populated in SELA extract. | |
12.03 | Local Record Id | Submission ID. Automatically populated in SELA extract. | |
12.04 | Reporting LEA | LOC.CC + LOC.DC | |
12.05 | School of Attendance | LOC.SC |
|
12.06 | Academic Year ID | Determined by school calendar year. Automatically populated in SELA extract. | |
12.07 | State Student ID (SSID) | STU.CID | |
12.08 | Student Legal First Name | STU.FN (LSI.LFN) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
12.09 | Student Legal Last Name | STU.LN (LSI.LLN) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
12.10 | Student Birth Date | STU.BD | |
12.11 | Student Gender Code | STU.GN | |
12.12 | Local Student ID | STU.ID | |
12.13 | English Language Acquisition Status Code | STU.LF | As of 9/15/20 only codes EO, RFEP, or TBD will be extracted |
12.14 | English Language Acquisition Status Start Date | LAC.RD1 LAC.AES, LAC.STS, LAC.USS, STU.DD, or STU.ED |
|
12.15 | Primary Language Code | STU.HL | As 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.01 | Record Type Code | Must equal SPRG. Automatically populated in SPRG extract. | |
3.02 | Transaction Type Code | Must equal " ", A, D or R. Automatically populated in SPRG extract. | |
3.03 | Local Record ID | Submission ID. Automatically populated in SPRG extract. | |
3.04 | Reporting LEA | LOC.CC + LOC.DC | |
3.05 | School of Attendance | PGM.SCL | If this field is populated with a zero (0), the School of Attendance will be reported from the Attendance Enrollment (ATT) table. |
3.06 | Academic Year ID | Determined by school calendar year. Automatically populated in SPRG extract. | |
3.07 | State Student ID (SSID) | STU.CID | |
3.08 | Local Student ID | STU.ID | Unique Aeries student identifier. |
3.09 | Student Legal First Name | STU.FN (LSI.LFN) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
3.10 | Student Legal Last Name | STU.LN (LSI.LLN) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
3.11 | Student Birth Date | STU.BD | |
3.12 | Student Gender Code | STU.GN | |
3.13 | Education Program Code | PGM.CD | Special Education, NSLP, GATE, and 504 Programs will be extracted from their specific tables.
|
3.14 | Education Program Membership Code | PGM | Fixed for Eligibility and Participation Categories. |
3.15 | Education Program Membership Start Date | PGM.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.
|
3.16 | Education Program Membership End Date | PGM.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.
|
3.17 | Education Service Academic Year | Determined by school calendar year. Automatically populated in SPRG extract. | |
3.18 | Education Service Code | PGS.SR | 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.19 | California Partnership Academy ID | PGM.CPA | 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.20 | Migrant Student ID | SSD.MID | This field is also located on the Program page. |
3.21 | Primary Disability Code | CSE.DI | Populate this field according to CASEMIS standards. |
3.22 | District of Special Education Accountability | CSE.DR | Populate this field according to CASEMIS standards. |
3.23 | Homeless Dwelling Type Code | PGM.HDT | For Education Program Code = 191 – Homeless. Populate Homeless Dwelling Type. |
3.24 | Unaccompanied Youth Indicator | PGM.UY | 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.25 | Runaway Youth Indicator | PGM.RA | 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. |
3.26 | Filler | Field no longer used. Filled with blank. | |
SDEM Staff Demographics ↑ | |||
7.01 | Record Type Code | Must equal SDEM. Automatically populated in SDEM extract. | |
7.02 | Transaction Type Code | Must equal " ", A, or D. Automatically populated in SDEM extract. | |
7.03 | Local Record ID | Submission ID. Automatically populated in SDEM extract. | |
7.04 | Effective 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.05 | Effective End Date | STF.LD | |
7.06 | Reporting LEA | LOC.CC + LOC.DC | |
7.07 | Academic Year ID | Determined by school calendar year. Automatically populated in SDEM extract. | |
7.08 | State Educator ID (SEID) | STF.SID | |
7.09 | Local Staff ID | STF.ID | Unique Aeries staff identifier. |
7.10 | Staff Legal First Name | STF.LFN or STF.FN | Legal First Name (LFN) will extract if populated, otherwise, First Name (FN) will extract. |
7.11 | Staff Legal Middle Name | STF.LMN or STF.MN | Legal Middle Name (LMN) will extract if populated, otherwise, Middle Name (MN) will extract. |
7.12 | Staff Legal Last Name | STF.LLN or STF.LN | Legal Last Name (LLN) will extract if populated, otherwise, Last Name (LN) will extract. |
7.13 | Staff Alias First Name | STF.FN or STF.FNP | If Legal First Name (LFN) is populated, then First Name (FN) will extract. Otherwise Previous First Name (FNP) will extract. |
7.14 | Staff Alias Middle Name | STF.MN or STF.MNP | If Legal Middle Name (LMN) is populated, then Middle Name (MN) will extract. Otherwise Previous Middle Name (MNP) will extract. |
7.15 | Staff Alias Last Name | STF.LN or STF.LNP | If Legal Last Name (LLN) is populated, then Last Name (LN) will extract. Otherwise Previous Last Name (LNP) will extract. |
7.16 | Staff Birth Date | STF.BD | |
7.17 | Staff Gender Code | STF.GN | Only STF.GN will extract, even if Legal Gender (LGN) is populated. |
7.18 | Staff Hispanic Ethnicity Indicator | STF.ETH | |
7.19 | Staff Ethnicity Missing Indicator | STF.ETH | If Ethnicity field is blank, this field will be flagged. |
7.20 | Staff Race 1 Code | STF.RC1 | |
7.21 | Staff Race 2 Code | STF.RC2 | |
7.22 | Staff Race 3 Code | STF.RC3 | |
7.23 | Staff Race 4 Code | STF.RC4 | |
7.24 | Staff Race 5 Code | STF.RC5 | |
7.25 | Staff Race Missing Indicator | STF.RC# | If all Race fields are blank, this field will be flagged. |
7.26 | Staff Highest Degree Code | STF.EL | |
7.27 | Staff Employment Status Code | STF.PS | |
7.28 | Staff Employment Start Date | STF.HD | |
7.29 | Staff Employment End Date | STF.LD | |
7.30 | Staff Service Years LEA | STF.TYD | |
7.31 | Staff Service Years Total | STF.TYS | |
SASS Staff Assignment ↑ | |||
8.01 | Record Type Code | Must equal SASS. Automatically populated in SASS extract. | |
8.02 | Transaction Type Code | Must equal " ", D, or R. Automatically populated in SASS extract. | |
8.03 | Local Record ID | Submission ID. Automatically populated in SASS extract. | |
8.04 | Reporting LEA | LOC.CC + LOC.DC | |
8.05 | School of Assignment | STF.PSC | If assigned to more than one school, pulls from STJ.SCL. |
8.06 | Academic Year ID | Determined by school calendar year. Automatically populated in SASS extract. | |
8.07 | State Educator ID (SEID) | STF.SID | |
8.08 | Local Staff ID | STF.ID | Unique Aeries staff identifier. |
8.09 | Staff Legal First Name | STF.LFN or STF.FN | Legal First Name (LFN) will extract if populated, otherwise, First Name (FN) will extract. |
8.10 | Staff Legal Last Name | STF.LLN or STF.LN | Legal Last Name (LLN) will extract if populated, therwise, Last Name (LN) will extract. |
8.11 | Staff Birth Date | STF.BD | |
8.12 | Staff Gender Code | STF.GN | Only STF.GN will extract, even if Legal Gender (LGN) is populated. |
8.13 | Staff Job Classification | STJ.JC | Any STF record without an STJ record will not be extracted for CALPADS. |
8.14 | Staff Job Classification FTE Percentage | STJ.FTE | This percentage of time spent on each job classification in relation to a full-time position (100%). |
8.15 | Non Classroom Based Job Assignment Code 1 | STJ.NC1 | Required 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.16 | Non Classroom Based Job Assignment Code 2 | STJ.NC2 | |
8.17 | Non Classroom Based Job Assignment Code 3 | STJ.NC3 | |
8.18 | Non Classroom Based Job Assignment Code 4 | STJ.NC4 | |
8.19 | Non Classroom Based Job Assignment Code 5 | STJ.NC5 | |
8.20 | Non Classroom Based Job Assignment Code 6 | STJ.NC6 | |
8.21 | Non Classroom Based Job Assignment Code 7 | STJ.NC7 | |
CRSE Course Section Enrollment ↑CRSC Course Section Completion | |||
9.01 | Record Type Code | Must equal CRSE or CRSC. Automatically populated in CRSE or CRSC extract. | |
9.02 | Transaction Type Code | Must equal " ", D, or R. Automatically populated in CRSE or CRSC extract. | |
9.03 | Local Record ID | Submission ID. Automatically populated in CRSE or CRSC extract. | |
9.04 | Reporting LEA | LOC.CC + LOC.DC | |
9.05 | School of Course Delivery | LOC.SC |
|
9.06 | Academic Year ID | Determined by school calendar year. Automatically populated in CRSE or CRSC extract. | |
9.07 | CRS-State Course Code | CRS.C3 | 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.08 | CRS-Local Course ID | CRS.CN | Aeries recommends a district-wide, unique Course ID for each course. For an Elementary school, TCH.TN is used. |
9.09 | CRS-Course Name | CRS.CO | For an Elementary school, TCH.TE is used. |
9.10 | Filler | ||
9.11 | Filler | ||
9.12 | CRS-CTE Postsecondary Articulated Course Indicator | CRS.TY | CRSE 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.13 | CRS-UC CSU Approved Indicator | CRS.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.14 | Course Section ID | LOC.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.15 | Academic Term Code | MST.SM or CRS.TM | "FY" for Elementary Schools. College courses use CRS |
9.16 | State Educator ID (SEID) | STF.SID | |
9.17 | Local Staff ID | TCH.ID SSE.ID | TCH.ID2 and TCH.ID3 can also be used to express Team Teaching or Job Sharing for Elementary Schools. |
9.18 | Class ID | LOC.CD + MST.TM + STF.ID + MST.SE or TCH.TN | 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.19 | Course Section Instructional Level Code | CRS.CL | Existing 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.20 | Educational Service Code | MST.ESR | TCH.ESR for Elementary Schools. |
9.21 | Language of Instruction Code | MST.LI | TCH.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.22 | Instructional Strategy Code | MST.INS | TCH.INS for Elementary Schools. |
9.23 | Independent Study Indicator | MST.ISI | TCH.ISI for Elementary Schools. A value of "Y" in this field will convert into the "Independent Study Indicator" CALPADS field when extracted. |
9.24 | Distance Learning Indicator | MST.DLI | TCH.DLI for Elementary Schools. A value of "Y" in this field will convert into the "Distance Learning Indicator" CALPADS field when extracted. |
9.25 | Multiple Teacher Code | MST.MTS | TCH.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.26 | Education Program Funding Source Code | MST.FS | TCH.FS for Elementary Schools. This field should be populated as appropriate for codes: 113 – CA Partnership Academy 168 – Specialized Secondary Instruction. |
9.27 | CTE Course Section Provider Code | MST.TEP | 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.28 | Course Content Area Subcategory Code | CRS.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.29 | Course Standards Grade Level Range Code | CRS.SGR | 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.30 | Content Standards Alignment | CRS.CSA | 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.31 | Charter Non-Core, Non-College Prep Course Indicator | CRS.CNC or MST.CNC | Data element retired 7/1/2021 |
9.32 | AP/IB Course Code Cross Reference | CRS.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.33 | Online Course Instruction Code | MST.OIT | Populate the type of online instruction that is being delivered in a course section. |
9.34 | Middle School Core Setting Indicator | CRS.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.35 | Local Assignment Option Code | MST.NCA | Populate if the the local governing board authorized a teacher to teach a course without the appropriate credential or authorization. |
9.36 | High Quality CTE Course Indicator | MST.HQC | Populate 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.01 | Record Type Code | Must equal SCSE or SCSC. Automatically populated in SCSE or SCSC extract. | |
10.02 | Transaction Type Code | Must equal " ", D, or R. Automatically populated in SCSE or SCSC extract. | |
10.03 | Local Record Id | Submission ID. Automatically populated in SCSE or SCSC extract. | |
10.04 | Reporting LEA | LOC.CC + LOC.DC | |
10.05 | School of Course Delivery | LOC.SC |
|
10.06 | Academic Year ID | Determined by school calendar year. Automatically populated in SCSE or SCSC extract. | |
10.07 | State Student ID (SSID) | STU.CID | |
10.08 | Local Student ID | STU.ID | |
10.09 | Student Legal First Name | STU.FN (LSI.LFN) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
10.10 | Student Legal Last Name | STU.LN (LSI.LLN) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
10.11 | Student Birth Date | STU.BD | |
10.12 | Student Gender Code | STU.GN | |
10.13 | Local Course ID | CRS.CN | |
10.14 | Course Section ID | LOC.CD + HIS.SE or CAR.SE |
|
10.15 | Academic Term Code | HIS.TE or MST.SM or CRS.TM |
|
10.16 | Student Credits Attempted | HIS.CR or CRS.CR |
|
10.17 | Student Credits Earned | HIS.CC or CRS.CR |
|
10.18 | Student Course Final Grade | HIS.MK or GRD.MK |
|
10.19 | UC/CSU Admission Requirement Code | CRS.E1 or CRS.U1 or CRS.U2 | |
10.20 | Marking Period Code | TDF.ST# | State Term Codes on the Terms Tab. |
10.21 | Carnegie 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.01 | Record Type Code | Must equal SCTE. Automatically populated in SCTE extract. | |
11.02 | Transaction Type Code | Must equal " ", D, or R. Automatically populated in SCTE extract. | |
11.03 | Local Record ID | Submission ID. Automatically populated in SCTE extract. | |
11.04 | Reporting LEA | LOC.CC + LOC.DC | |
11.05 | School of Attendance | LOC.SC |
|
11.06 | Academic Year ID | Determined by school calendar year. Automatically populated in SCTE extract. | |
11.07 | State Student ID (SSID) | STU.CID | |
11.08 | Local Student ID | STU.ID | Unique Aeries student identifier. |
11.09 | Student Legal First Name | STU.FN (LSI.LFN) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
11.10 | Student Legal Last Name | STU.LN (LSI.LLN) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
11.11 | Student Birth Date | STU.BD | |
11.12 | Student Gender Code | STU.GN | |
11.13 | CTE Pathway Code | CPW.CD | |
11.14 | CTE Pathway Complete Academic Year ID | CPH.AY | Only extracted on Career Pathway records identified as "Completed" for the current year. |
STAS Student Absence Summary ↑ | |||
13.01 | Record Type Code | Must equal STAS. Automatically populated in STAS extract. | |
13.02 | Transaction Type Code | Must equal " ", D, or R. Automatically populated in STAS extract. | |
13.03 | Local Record ID | Submission ID. Automatically populated in STAS extract. | |
13.04 | Reporting LEA | LOC.CC + LOC.DC | |
13.05 | School of Attendance | LOC.SC |
|
13.06 | Academic Year ID | Determined by school calendar year. Automatically populated in STAS extract. | |
13.07 | State Student ID (SSID) | STU.CID | |
13.08 | Local Student ID | STU.ID | |
13.09 | Filler | ||
13.10 | Filler | ||
13.11 | Filler | ||
13.12 | Filler | ||
13.13 | Student 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.14 | Hourly Attendance School Type Indicator | LOC.B | Determined by school attendance setup. |
13.15 | Expected Attendance Days | AHS.EN | |
13.16 | Days Attended | AHS.PR | |
13.17 | Days Absent Out-of-School Suspension | AHS.SU | |
13.18 | Days in Attendance In-School Suspension | AHS.ISS | |
13.19 | Days Absent Excused Non-Suspension | AHS.AE | |
13.20 | Days Absent Unexcused Non-Suspension | AHS.AU | |
13.21 | Non-ADA Generating Independent Study Days | AHS.ISI | |
13.22 | ADA Generating Independent Study Days | AHS.ISC | |
13.23 | Period-by-Period Attendance Method Indicator | LOC.A = 1 | |
PSTS Postsecondary Status ↑ | |||
17.01 | Record Type Code | Must equal PSTS. Automatically populated in PSTS extract. | |
17.02 | Transaction Type Code | Must equal " ", D, or R. Automatically populated in PSTS extract. | |
17.03 | Local Record ID | Submission ID. Automatically populated in PSTSextract. | |
17.04 | Reporting LEA | LOC.CC + LOC.DC | |
17.05 | School of Attendance | LOC.SC |
|
17.06 | School of Attendance NPS | CSE.TY | |
17.07 | Academic Year ID | Determined by school calendar year. Automatically populated in PSTS extract. | |
17.08 | State Student ID (SSID) | STU.CID | |
17.09 | Local Special Education Student ID | CSE.SEI | Only populated for SWD students for EOY4 extract |
17.10 | Reporting SELPA | CSE.SE | Only populated for SWD students for EOY4 extract |
17.11 | Education Program Participation Type Code |
| |
17.12 | Postsecondary Status Code | PSS.CD | Only extracted if student meets one of the Program Participation Type Codes listed above |
17.13 | Educational Institution Type | PSS.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.01 | Record Type Code | Must equal SINC. Automatically populated in SINC extract. | |
18.02 | Transaction Type Code | Must equal " " or D. Automatically populated in SINC extract. | |
18.03 | Local Record ID | Submission ID. Automatically populated in SINC extract. | |
18.04 | Reporting LEA | LOC.CC + LOC.DC | |
18.05 | School of Attendance | LOC.SC |
|
18.06 | Academic Year ID | Determined by school calendar year. Automatically populated in SINC extract. | |
18.07 | State Student ID (SSID) | STU.CID | |
18.08 | Local Student ID | STU.ID | Unique Aeries student identifier. |
18.09 | Student Legal First Name | STU.FN (LSI.LFN) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
18.10 | Student Legal Last Name | STU.LN (LSI.LLN) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
18.11 | Student Birth Date | STU.BD | |
18.12 | Student Gender Code | STU.GN | |
18.13 | Disciplinary Incident ID Local | ADS.IID | |
18.14 | Incident Occurrence Date | ADS.DT | |
18.15 | Statutory 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.16 | Student Instructional Support Indicator | ADS.ISI | This field is required to be populated with a "Y" or "N" for all records with Statutory Offense Indicator |
18.17 | Removal to Interim Alternative Setting Reason Code | ADS.RR | 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. |
SIRS Student Incident Results ↑ | |||
19.01 | Record Type Code | Must equal SIRS. Automatically populated in SIRS extract. | |
19.02 | Transaction Type Code | Must equal " " or D. Automatically populated in SIRS extract. | |
19.03 | Local Record ID | Submission ID. Automatically populated in SIRS extract. | |
19.04 | Reporting LEA | LOC.CC + LOC.DC | |
19.05 | School of Attendance | LOC.SC |
|
19.06 | Academic Year ID | Determined by school calendar year. Automatically populated in SIRS extract. | |
19.07 | State Student ID (SSID) | STU.CID | |
19.08 | Local Student ID | STU.ID | Unique Aeries student identifier. |
19.09 | Student Legal First Name | STU.FN (LSI.LFN) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
19.10 | Student Legal Last Name | STU.LN (LSI.LLN) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
19.11 | Student Birth Date | STU.BD | |
19.12 | Student Gender Code | STU.GN | |
19.13 | Disciplinary Incident ID Local | ADS.IID | |
19.14 | Incident Result Code | DSP.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.15 | Incident Result Authority Code | DSP.AA | All Suspension and Expulsion records must have this field populated. Map CALPADS Code Translations for Disciplinary Action Authority (DSP.AA). |
19.16 | Incident Results Duration Days | DSP.DY | 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. |
19.17 | Incident Result Modification Code | EXP.EMC | This 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.01 | Record Type Code | Must equal SOFF. Automatically populated in SOFF extract. | |
20.02 | Transaction Type Code | Must equal " " or D. Automatically populated in SOFF extract. | |
20.03 | Local Record ID | Submission ID. Automatically populated in SOFF extract. | |
20.04 | Reporting LEA | LOC.CC + LOC.DC | |
20.05 | School of Attendance | LOC.SC |
|
20.06 | Academic Year ID | Determined by school calendar year. Automatically populated in SOFF extract. | |
20.07 | State Student ID (SSID) | STU.CID | |
20.08 | Local Student ID | STU.ID | Unique Aeries student identifier. |
20.09 | Student Legal First Name | STU.FN (LSI.LFN) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
20.10 | Student Legal Last Name | STU.LN (LSI.LLN) | Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
20.11 | Student Birth Date | STU.BD | |
20.12 | Student Gender Code | STU.GN | |
20.13 | Disciplinary Incident ID Local | ADS.IID | |
20.14 | Student Offense Code | ADS.CD | 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.15 | Weapon Category Code | ADS.WT | 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). |
WBLR Work-Based Learning Records ↑ | |||
21.01 | Record Type Code | Must equal WBLR. Automatically populated in WBLR extract. | |
21.02 | Transaction Type Code | Must equal " " or D. Automatically populated in WBLR extract. | |
21.03 | Local Record ID | Submission ID. Automatically populated in WBLR extract. | |
21.04 | Reporting LEA | LOC.CC + LOC.DC | If the entity is an independently reporting charter school, the School (S) code must be submitted for both the Reporting LEA and the School of Attendance. |
21.05 | School of Attendance | LOC.SC |
|
21.06 | School of Attendance NPS | CSE.TY | School of Attendance NPS must be a valid NPS code in CDS |
21.07 | Academic Year ID | STU.CID | Determined by school calendar year. Automatically populated in WBLR extract. |
21.08 | State Student ID (SSID) | STU.CID | |
21.09 | Work-Based Learning Type Code | ISP.WT | A coded value representing the work-based learning that the student completed during the academic year, in any grades 9-12. |
21.10 | Internship ID | ISP.ID + ISP.SQ | This field is populated during the extract using information from many fields. |
21.11 | Work-based Learning Hours - External | ISP.TXH | The 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 Simulated Work-Based Learning. Rounded to whole numbers. |
21.12 | State Course Code -Embedded Work-based Learning | ISP.SE translated into CRS.C3 | The State Course Code that the student completed in which the Internship, Student-Led Enterprise, or Simulated Work-Based Learning was embedded. May or may not be a CTE course for code 15 and 20. However, CTE state course code is required for 10-Internships as of 23/24 school year. |
21.13 | Internship -Employer Performance Evaluation Code | ISP.EE | A coded value representing the student’s performance in the internship as evaluated by their employment supervisor. Required for Internships. Values are hard-coded. |
21.14 | Internship -LEA Sponsored Indicator | ISP.SCS | An 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.15 | Internship –Certificated Supervisor Indicator | ISP.CS | An 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