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.15 | Effective Date | FOF.SD | SPRG If not using FOF table, See Student Programs: PGM.ESD. |
| 3.16 | Leave Date | FOF.LD | SPRG If not using FOF table, See Student Programs: PGM.EED. |
Activities and Awards ↑ | |||
| 1.32 | Golden State Seal Merit Diploma Record | ACT.CD | SENR Map CALPADS Other Options for ACT code |
| 1.33 | Seal of Biliteracy Record | ACT.CD | SENR Map CALPADS Other Options for ACT code. |
Address History ↑ | |||
| 2.31 | Address Line 1 | ADH.AD | SINF (if different than STU.AD for Info Day) |
| 2.33 | Address City Name | ADH.CY | SINF (if different than STU.AD for Info Day) |
| 2.34 | Address State Province Code | ADH.ST | SINF (if different than STU.AD for Info Day) These code values will be translated when extracted from Aeries. |
| 2.35 | Address Zip Code | ADH.RZ | SINF (if different than STU.AD for Info Day) |
Assertive Discipline ↑ | |||
| 18.13 19.13 2013 | Incident ID | ADS.IID | SINC SIRS SOFF |
| 18.14 | Incident Date | ADS.DT | SINC |
| 18.15 | Statutory Offense Indicator | SINC Automatically populated with Y if Student Offense Code populated on the Suspendable Offense (SOC) Code table | |
| 20.14 | Student Offense Code | ADS.CD | SOFF 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 | SOFF 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.14 | Incident 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.15 | Incident Result Authority Code | DSP.AA | SIRS 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 | SIRS 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.16 | Student Instructional Support Indicator | ADS.ISI | SINC 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.17 | Incident Result Modification Code | EXP.EMC | SIRS 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.17 | Removal to Interim Alternative Setting | ADS.RR | SINC 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.26 | Reason Attendance Enrollment | ATT.RS | SENR May also come from STU.SWR or STU.EOY. |
| 1.28 | Next School (NextSchl) Attendance Enrollment | ATT.NS | SENR or SSID Only needed for Alternative schools or All records with an Exit Reason of "165" (Involuntary Transfer for Discipline). |
| 1.30 | InterDistrict (IntDist) | ATT.IT | SENR or SSID If the Inter/Intra District field (STU.IT) on Student Demographics is populated, ATT.IT and ENR are also populated. |
| 1.31 | Transfer District (TransDist) | ATT.ITD | SENR or SSID If the Inter/Intra District field (STU.ITD) on Student Demographics is populated, ATT.IT and ENR are also populated. |
| 2.04 | Start Date Attendance Enrollment | ATT.CD = E + ATT.DT | SINF Effective Start Date - Located on Attendance Enrollment page for the current year. |
| 2.05 | End Date Attendance Enrollment | SINF Effective End Date Automatically populated in CALPADS. | |
Attendance History ↑ | |||
| 13.13 | Attendance 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.15 | Enrolled | AHS.EN | STAS |
| 13.16 | Present | AHS.PR | STAS |
| 13.17 | Days of Suspension | AHS.SU | STAS |
| 13.18 | Days In School Suspension | AHS.ISS | STAS |
| 13.19 | Excused | AHS.AE | STAS |
| 13.20 | Unexcused | AHS.AU | STAS |
| 13.21 | Non-ADA Generating Independent Study Days | AHS.ISI | STAS |
| 13.22 | ADA Generating Independent Study Days | AHS.ISC | STAS |
| 13.23 | Period-by-Period Attendance Method Indicator | LOC.A = 1 | STAS |
Behavioral Emergency ↑ | |||
| 19.14 | Behavioral Emergency Code | BER.CD | SIRS |
Career Pathways ↑ | |||
| 11.13 | CTE Pathway Record | CPW.CD | SCTE Reference CALPADS Valid Code Combinations |
| 11.14 | Completed Checkbox | CPH.AY | SCTE Only extracted on Career Pathway records identified as "Completed" for the current year. |
Courses ↑ | |||
| 9.07 | State Course Code College State Course Code | CRS.C3 CRS.CC3 | CRSE 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. See EOY 1 FAQ for reporting College Credit courses. |
| 9.08 | Course ID (CrsID#) | CRS.CN | CRSE or CRSC General tab. Aeries recommends a district-wide, unique Course ID for each course. For an Elementary school, TCH.TN is used. |
| 9.09 | Course Name | CRS.CO | CRSE or CRSC For an Elementary school, TCH.TE is used. |
| 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 | UC 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.19 | Course Level (Crs Lvl) | CRS.CL | CRSE 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.28 | Course Content Area Subcategory Code | CRS.CSC | CRSE 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.29 | Course Standards Grade Level Range Code | CRS.SGR | CRSE 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.30 | Content Standards Alignment | CRS.CSA | CRSE 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.31 | Charter Non-Core | CRS.CNC | CRSE or CRSC California Specific Fields tab. Data element retired 7/1/2021 |
| 9.32 | AP/IB Cross Code Reference | CRS.ACC | CRSE 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.34 | Middle School Core Setting Indicator | CRS.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.13 | Course ID (CrsID#) | CRS.CN | SCSE or SCSC General tab. Aeries recommends a district-wide, unique Course ID for each course. |
| 10.19 | UC 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.08 | State Student ID (SSID) | STU.CID | SENR or SSID Student Data 2 tab. Always use the CALPADS Create SSID Extract to obtain and import SSIDs for new students. |
| 1.09 | Perm ID# | STU.ID | SENR or SSID Student Data 1 tab. Unique Aeries student identifier. |
| 1.10 | First Name | STU.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.11 | Middle Name | STU.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.12 | Last Name | STU.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.13 | Suffix | 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.14 | First Alias | STU.FNA | SENR or SSID Student Data 1 tab. |
| 1.15 | Middle Alias | STU.MNA | SENR or SSID Student Data 1 tab. |
| 1.16 | Last Alias | STU.LNA | SENR or SSID Student Data 1 tab. |
| 1.17 | Birthdate | STU.BD | SENR or SSID Student Data 1 tab. |
| 1.18 | Gender | STU.GN | SENR or SSID Student Data 1 tab. |
| 1.19 | Birth City | STU.BCY | SENR or SSID Student Data 1 tab. |
| 1.20 | State | STU.BST | SENR or SSID Student Data 1 tab. These code values will be translated when extracted from Aeries. |
| 1.21 | Country | STU.BCU | SENR or SSID Student Data 1 tab. These code values will be translated when extracted from Aeries. |
| 1.22 | School Enter Date (Schl Enter Dt) | STU.ED | SENR 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.23 | Program (Prog) | STU.SP | SENR or SSID Student Data 1 tab. STU.SP values will be translated to these codes. Optionally a User Code field could be used. |
| 1.24 | Grade (Grd) | STU.GR | SENR or SSID Student Data 1 tab. |
| 1.25 | School Leave Date (Schl Leave Dt) | STU.LD | SENR 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.27 | Student School Completion Status | STU.HSG | SENR or SSID Student Data 2 tab. Map CALPADS Code Translations for Completion Status (STU.HSG). |
| 1.35 | Graduation Exemption Indicator | STU.GEX | SENR 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. |
| 2.09 | State Student ID (SSID) | STU.CID | SINF Student Data 2 tab. |
| 2.10 | Perm ID# | STU.ID | SINF Student Data 1 tab. Unique Aeries student identifier. |
| 2.11 | First Name | STU.FN (LSI.LFN) | SINF Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
| 2.12 | Middle Name | STU.MN (LSI.LMN) | SINF Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
| 2.13 | Last Name | STU.LN (LSI.LLN) | SINF Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
| 2.14 | Suffix | STU.SF (LSI.LSF) | SINF Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table. |
| 2.15 | First Alias | STU.FNA | SINF Student Data 1 tab. |
| 2.16 | Middle Alias | STU.MNA | SINF Student Data 1 tab. |
| 2.17 | Last Alias | STU.LNA | SINF Student Data 1 tab. |
| 2.18 | Birthdate | STU.BD | SINF Student Data 1 tab. |
| 2.19 | Gender | STU.GN | SINF Student Data 1 tab. |
| 2.20 | Birth City | STU.BCY | SINF Student Data 1 tab. |
| 2.21 | State | STU.BST | SINF Student Data 1 tab. These code values will be translated when extracted from Aeries. |
| 2.22 | Country | STU.BCU | SINF Student Data 1 tab. These code values will be translated when extracted from Aeries. |
| 2.23 | Ethnicity | STU.ETH | SINF Student Data 1 tab. |
| 2.24 | Ethnicity Missing | STU.ETH | SINF Student Data 1 tab. If Ethnicity field is blank, this field will be flagged. |
| 2.25 | Race 1 | STU.RC1 | SINF Student Data 1 tab. |
| 2.26 | Race 2 | STU.RC2 | SINF Student Data 1 tab. |
| 2.27 | Race 3 | STU.RC3 | SINF Student Data 1 tab. |
| 2.28 | Race 4 | STU.RC4 | SINF Student Data 1 tab. |
| 2.29 | Race 5 | STU.RC5 | SINF Student Data 1 tab. |
| 2.30 | Race Missing | STU.RC# | SINF Student Data 1 tab. If all Race fields are blank, this field will be flagged. |
| 2.31 | Address Line 1 | SINF | |
| 2.33 | Address City Name | SINF | |
| 2.34 | Address State Province Code | SINF (These code values will be translated when extracted from Aeries.) | |
| 2.35 | Address Zip Code | SINF | |
| 2.38 | Parent Guardian 1 Highest Education Level Code | CON.ELV | SINF |
| 2.39 | Guardian 1 First Name | CON.FN | SINF |
| 2.40 | Guardian 1 Last Name | CON.LN | SINF |
| 2.41 | Guardian 2 First Name | CON.FN | SINF |
| 2.42 | Guardian 2 Last Name | CON.LN | SINF |
| 2.43 | Student Preferred First Name | STU.FN | SINF Only if Legal Student Info (LSI) table populated |
| 2.44 | Student Preferred Last Name | STU.LN | SINF Only if Legal Student Info (LSI) table populated |
| 2.50 | Parent Guardian2 Highest Education Level Code | CON.ELV | SINF |
| ^.07 | State Student ID (SSID) | STU.CID | SPRG, SCSE, SCSC, SCTE, SELA, STAS, SINC, SIRS, SOFF, PSTS Student Data 2 tab. |
| ^.08 | Perm ID# | STU.ID | SPRG, SCSE, SCSC, SCTE, SELA, STAS, SINC, SIRS, SOFF Student Data 1 tab. Unique Aeries student identifier. |
| ^.09 | First Name | STU.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. |
| ^.10 | Last Name | STU.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. |
| ^.11 | Birthdate | STU.BD | SPRG, SCSE, SCSC, SCTE, SELA, STAS, SINC, SIRS, SOFF Student Data 1 tab. |
| ^.12 | Gender | STU.GN | SPRG, SCSE, SCSC, SCTE, SELA, STAS, SINC, SIRS, SOFF Student Data 1 tab. |
| 12.15 | Reporting Language | STU.HL | SELA The new CALPADS 3-character Language codes will be extracted as of 2023-24 schoolyear. |
Free and Reduced ↑ | |||
| 3.15 | Start Date | FRE.ESD | SPRG |
| 3.16 | End Date | FRE.EED | SPRG |
GATE ↑ | |||
| 3.15 | Start Date | GTE.ESD | SPRG If not using GATE table, See Special Programs: PGM.ESD. |
| 3.16 | End Date | GTE.EED | SPRG If not using GATE table, See Student Programs: PGM.EED. |
Internships ↑ | |||
| 21.09 | Work-Based Learning Type | ISP.WT | WBLR - Values are hard-coded |
| 21.13 | Employer Evaluation | ISP.EE | WBLR - Values are hard-coded |
| 21.11 | Total External Hours Completed | ISP.TXH | WBLR - Rounded to nearest whole number |
| 21.14 | School Sponsored | ISP.SCS | WBLR - Y/N |
| 21.15 | Certificated Supervisor | ISP.CS | WBLR - Y/N |
| 21.12 | Section | ISP.SE | WBLR - Translated to State Course Code (CRS.C3) for the extract. Only reported if WBL type is 10, 15 or 20. |
Language Assessment ↑ | |||
| 2.36 | US School K-12 | LAC.USS and/or LAC.US3 | SINF This field is also located on the Demographics page. LAC.US3 is required if the student entered US school prior to K/TK |
| 12.14 | ELAS Start Date: RFEP - (Redesignated EL's) EO - (English only) | LAC.RD1, LAC.AES (LAC.STS, LAC.USS, STU.DD, STU.ED) | SELA
|
Master Schedule ↑ | |||
| 9.10 | High Quality CTE Crs | MST.HQC | CRSE 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.14 | Section | MST.SE | CRSE or CRSC
|
| 9.15 | Semester (Sem) | MST.SM | CRSE or CRSC "FY" for Elementary Schools. |
| 9.18 | Class ID | MST.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.20 | Educational Service (Ed Svc) | MST.ESR | CRSE or CRSC TCH.ESR for Elementary Schools. |
| 9.21 | Language of Instruction (Lang Instr) | MST.LI | CRSE 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.22 | Instructional 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.23 | Independent Study (Ind Study) | MST.ISI | CRSE 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.24 | Distance Learning (Dist Lrng) | MST.DLI | CRSE 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.25 | Multiple Teacher (MultiTchr) | MST.MTS | CRSE or CRSC 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 | Educational Program Funding Source (Fund Src) | MST.FS | CRSE 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.27 | CTE Provider (CTE Prvdr) | MST.TEP | CRSE or CRSC This field is no longer used as of 2024/25 academic year and will extract with a 'blank'. |
| 9.31 | Charter Non-Core | MST.CNC | CRSE or CRSC Data element retired 7/1/2021 |
| 9.32 | AP/IB Course Code Cross Reference | MST.ACC | CRSE 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.33 | Online Course Instruction Code | MST. OIT | CRSE or CRSC Populate the type of online instruction that is being delivered in a course section. |
| 9.34 | Middle School Core Setting Indicator | MST.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.35 | Local Assignment Option | MST.NCA | CRSE or CRSC 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 | MST.HQC | CRSE or CRSC Populate a Y or N if the course section and teacher meet the High Quality CTE Course qualifications. |
Post-Secondary Survey ↑ | |||
| 17.12 | Postsecondary Status Code | PSS.CD | PSTS - Values are hard-coded |
| 17.13 | Educational Institution Type | PSS.EIT | PSTS - Values are hard-coded Only required for codes 200 through 350 (inclusive) |
| 17.14 | Industry Field | PSS.IFC | PSTS - Values are hard-coded Only required for codes 910, 920, or 930 |
| 17.15 | Post-High School Credential | PSS.PSC | PSTS - Values are hard-coded |
School Options ↑ | |||
| ^.04 | Reporting 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 Located on Attendance Enrollment page for the current year. |
| ^.05 | School CDS# | LOC.SC | SENR, SSID, SASS, CRSE, CRSC, SCSE, SCSC, SCTE, SELA, STAS, PSTS, SINC, SIRS, SOFF
|
| 1.06 | School of Attendance NPS | LOC.SC | SENR or SSID
|
| 2.07 | School of Attendance | LOC.SC | SINF
|
| 3.04 | Reporting LEA (County CDS# + District CDS#) | LOC.CC + LOC.DC | SPRG |
| 7.06 | Reporting LEA (County CDS# + District CDS#) | LOC.CC + LOC.DC | SDEM |
| 8.04 | Reporting LEA (County CDS# + District CDS#) | LOC.CC + LOC.DC | SASS |
| 9.04 | Reporting LEA (County CDS# + District CDS#) | LOC.CC + LOC.DC | CRSE or CRSC |
| 9.05 | School of Course Delivery | LOC.SC | CRSE, CRSC SCSE or SCSC
|
| 10.04 | Reporting LEA (County CDS# + District CDS#) | LOC.CC + LOC.DC | SCSE or SCSC |
| 10.05 | School CDS# | LOC.SC | SCSE or SCSC
|
| 11.04 | Reporting LEA (County CDS# + District CDS#) | LOC.CC + LOC.DC | SCTE |
| 11.05 | School CDS# | LOC.SC | SCTE
|
| 12.04 | Reporting LEA (County CDS# + District CDS#) | LOC.CC + LOC.DC | SELA |
| 12.05 | School CDS# | LOC.SC | SELA
|
| 13.04 | Reporting LEA (County CDS# + District CDS#) | LOC.CC + LOC.DC | STAS |
| 13.05 | School CDS# | LOC.SC | STAS
|
| 13.14 | Attendance Reporting (Positive = Hourly) | LOC.B | STAS Determined by school attendance setup. |
| 17.04 | Reporting LEA (County CDS# + District CDS#) | LOC.CC + LOC.DC | PSTS |
| 17.05 | School CDS# | LOC.SC | PSTS
|
| 18.04 19.04 20.04 | Reporting LEA (County CDS# + District CDS#) | ||
| 18.05 19.05 20.05 | School CDS# | ||
Secondary Student Data ↑ | |||
| 2.37 | SNOR - US Schl < 3 Yrs | SSD.SUS | SINF or SIAD This field is also located on the Demographics page. |
| 3.20 | Migrant Ed - State Migrant ID | SSD.MID | SPRG This field is also located on the Program page. |
| 17.12 | Postsecondary Status Code | SSD.PSS | PSTS This field is located on the Perkins tab |
Special Education ↑ | |||
| 1.34 | Adult 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.15 | Entry Date | CSE.ED | SPRG |
| 3.16 | Exit Date | CSE.XD | SPRG |
| 3.21 | Disability | CSE.DI | SPRG Populate this field according the CASEMIS standards. |
| 3.22 | District of Residence | CSE.DR | SPRG 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.05 | School | PGM.SCL | SPRG If this field is populated with a zero (0), the School of Attendance will be reported from the Attendance Enrollment (ATT) table. |
| 3.13 | Program Code | PGM.CD | SPRG Special Education, NSLP, GATE, and 504 Programs will be extracted from their specific tables.
|
| 3.14 | Program Code | PGM | Eligibility and Participation Categories are hard-coded based on Program Code. |
| 3.15 | Eligibility/Participation Start Date | PGM.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.
|
| 3.16 | Eligibility/Participation End Date | PGM.PED & PGM.EED | SPRG Special Education, NSLP, GATE, and 504 Programs will be extracted from their specific tables.
|
| 3.18 | Services Received | PGM.SR | SPRG 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 | CA PartnerShip Academy | PGM.CPA | SPRG 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.23 | Homeless Dwelling Type | PGM.HDT | SPRG For Education Program Code = 191 – Homeless. Populate Homeless Dwelling Type. |
| 3.24 | Unaccompanied Youth (Unaccomp Youth) | PGM.UY | SPRG 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 | PGM.RA | SPRG 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.04 | Effective Start Date | STF.HD | SDEM 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 | Leave Date | STF.LD | SDEM |
| 7.08 | State Educator ID (SEID) | STF.SID | SDEM |
| 7.09 | Staff ID | STF.ID | SDEM Unique Aeries staff identifier. |
| 7.10 | Legal First Name | STF.LFN or STF.FN | SDEM Legal First Name (LFN) will extract if populated, otherwise, First Name (FN) will extract. |
| 7.11 | Legal Middle Name | STF.LMN or STF.MN | SDEM Legal Middle Name (LMN) will extract if populated, otherwise, Middle Name (MN) will extract. |
| 7.12 | Legal Last Name | STF.LLN or STF.LN | SDEM Legal Last Name (LLN) will extract if populated, otherwise, Last Name (LN) will extract. |
| 7.13 | Previous First Name | STF.FN or FNP | SDEM If Legal First Name (LFN) is populated, then First Name (FN) will extract, otherwise Previous First Name (FNP) will extract. |
| 7.14 | Previous Middle Name | STF.MN or MNP | SDEM If Legal Middle Name (LMN) is populated, then Middle Name (MN) will extract, otherwise Previous Middle Name (MNP) will extract. |
| 7.15 | Previous Last Name | STF.LNP or STF.LN | SDEM If Legal Last Name (LLN) is populated, then Last Name (LN) will extract, otherwise Previous Last Name (LNP) will extract. |
| 7.16 | Birthdate | STF.BD | SDEM |
| 7.17 | Gender | STF.GN | SDEM Only STF.GN will extract, even if Legal Gender (LGN) is populated. |
| 7.18 | Ethnicity | STF.ETH | SDEM |
| 7.19 | Ethnicity Missing | STF.ETH | SDEM If Ethnicity field is blank, this field will be flagged. |
| 7.20 | Race | STF.RC1 | SDEM |
| 7.21 | Race 2 | STF.RC2 | SDEM |
| 7.22 | Race 3 | STF.RC3 | SDEM |
| 7.23 | Race 4 | STF.RC4 | SDEM |
| 7.24 | Race 5 | STF.RC5 | SDEM |
| 7.25 | Race Missing | STF.RC# | SDEM If all Race fields are blank, this field will be flagged. |
| 7.26 | Educational Level (Educational Lvl) | STF.EL | SDEM |
| 7.27 | Position Status | STF.PS | SDEM |
| 7.28 | Hire Date | STF.HD | SDEM |
| 7.29 | Leave Date | STF.LD | SDEM |
| 7.30 | Total Year in This District | STF.TYD | SDEM |
| 7.31 | Total Years of Educational Service (Total Years of Edu Service) | STF.TYS | SDEM |
Staff Job Assignments ↑ | |||
| 8.05 | Primary School | STF.PSC | SASS If assigned to more than one school, pulls from STJ.SCL |
| 8.07 | State Educator ID (SEID) | STF.SID | SASS |
| 8.08 | Staff ID | STF.ID | SASS Unique Aeries staff identifier. |
| 8.09 | Legal First Name | STF.LFN or FN | SASS Legal First Name (LFN) will extract if populated, otherwise, First Name (FN) will extract. |
| 8.10 | Legal Last Name | STF.LLN or LN | SASS Legal Last Name (LLN) will extract if populated, otherwise, Last Name (LN) will extract. |
| 8.11 | Birthdate | STU.BD | SASS |
| 8.12 | Gender | STF.GN | SASS Only STF.GN will extract, even if Legal Gender (LGN) is populated. |
| 8.13 | Staff/Job Assignments Job Classification | STJ.JC | SASS Job Assignments (STJ) window. |
| 8.14 | Staff/Job Assignments FTE | STJ.FTE | SASS Job Assignments (STJ) window. |
| 8.15 | Staff/Job Assignments Non Classroom Based Job Assignment Codes | STJ.NC1 | SASS Job Assignments (STJ) window. |
| 8.16 | Staff/Job Assignments Non Classroom Based Job Assignment Code 2 | STJ.NC2 | SASS Job Assignments (STJ) window. |
| 8.17 | Staff/Job Assignments Non Classroom Based Job Assignment Code 3 | STJ.NC3 | SASS Job Assignments (STJ) window. |
| 8.18 | Staff/Job Assignments Non Classroom Based Job Assignment Code 4 | STJ.NC4 | SASS Job Assignments (STJ) window. |
| 8.19 | Staff/Job Assignments Non Classroom Based Job Assignment Code 5 | STJ.NC5 | SASS Job Assignments (STJ) window. |
| 8.20 | Staff/Job Assignments Non Classroom Based Job Assignment Code 6 | STJ.NC6 | SASS Job Assignments (STJ) window. |
| 8.21 | Staff/Job Assignments Non Classroom Based Job Assignment Code 7 | STF.NC7 | SASS Job Assignments (STJ) window. |
Teachers ↑ | |||
| 9.16 | State Educator ID (SEID) | STF.SID | CRSE or CRSC |
| 9.17 | Teacher Number (Tch#) | TCH.ID | CRSE or CRSC TCH.ID2 and TCH.ID3 can also be used to express Team Teaching or Job Sharing for Elementary Schools. |
Transcript Definition ↑ | |||
| 10.20 | Terms | TDF.ST# | SCSE or SCSC Terms tab. State Term Codes. |
Transcripts ↑ | |||
| 1.29 | Met UC CSU Requirements | STU.CCS & STU.CUC | SENR or SSID Run the Update College Entrance Requirements function to populate. |
| 10.14 | Section ID | HIS.SE | SCSE or SCSC More button.
|
| 10.15 | Term (Tm) | HIS.TE | SCSE or SCSC
|
| 10.16 | Credits Attempted (Atmp) | HIS.CR | SCSE or SCSC
|
| 10.17 | Completed Credits (Comp) | HIS.CC | SCSE or SCSC
|
| 10.18 | Mark | HIS.MK | SCSE or SCSC
|
^ - 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.