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


504 Plans

Activities and Awards  

Address History  

Assertive Discipline  

Attendance   

Attendance History   

Behavioral Emergency   

Career Pathways   

Courses  

Demographics  

Free and Reduced  

GATE  

Internships  

Language Assessment  

Master Schedule  

Post-Secondary Survey  

School Options  

Secondary Student Data  

Special Education  

Special Programs  

Staff  

Staff Job Assignments  

Teachers  

Transcript Definition  

Transcripts  


CALPADS 
Field #
Aeries Field Name
Aeries
Table.Field
Comments/Notes

504 Plans

3.15Effective DateFOF.SDSPRG
If not using FOF table, See Student Programs: PGM.ESD.
3.16Leave DateFOF.LDSPRG
If not using FOF table, See Student Programs: PGM.EED.

Activities and Awards  

1.32Golden State Seal Merit Diploma RecordACT.CDSENR
Map CALPADS Other Options for ACT code
1.33Seal of Biliteracy RecordACT.CDSENR
Map CALPADS Other Options for ACT code. 

Address History  

2.31Address Line 1ADH.ADSINF (if different than STU.AD for Info Day)
2.33Address City NameADH.CYSINF (if different than STU.AD for Info Day) 
2.34Address State Province CodeADH.STSINF (if different than STU.AD for Info Day) These code values will be translated when extracted from Aeries.
2.35Address Zip CodeADH.RZSINF (if different than STU.AD for Info Day) 

Assertive Discipline  

18.13
19.13
2013
Incident IDADS.IIDSINC
SIRS
SOFF
18.14Incident DateADS.DTSINC
18.15Statutory Offense Indicator 
SINC
Automatically populated with Y if Student Offense Code populated on the Suspendable Offense (SOC) Code table
20.14Student Offense CodeADS.CDSOFF
Place the most severe offense as the first code listed on this page. CALPADS codes may not compatible with codes that are being used in Aeries, verify your local codes account for all of the 48900 and 48915 Ed Codes. Your local codes will be translated to the CALPADS codes when they are extracted.
Map CALPADS Code Translations for Discipline Offense Code (ADS.CD). 
20.15Weapon Category codeADS.WTSOFF
Although you can use the CALPADS Code Values, we recommend creating your own codes that are more refined than the CALPADS codes. Your local codes can be translated to the CALPADS codes during extract.
Map CALPADS Code Translations for Discipline Weapon Type (ADS.WT). 
19.14Incident Result Code DSP.DS
(and BER.CD if linked to same ADS.IID)
SIRS
Do not use the CALPADS Code Values. Use your own local codes. Multiple Dispositions can be entered. Aeries will extract the most severe. Suspension codes need to start with "SUS" for the Suspension letters to print the total # of days. There can be additional characters after "SUS", but they must start with those characters for the system to recognize what they represent.
Map CALPADS Code Translations for Discipline Action Taken (Disposition) (DSP.DS). 
19.15Incident Result Authority Code DSP.AASIRS
All Suspension and Expulsion records must have this field populated.
Map CALPADS Code Translations for Disciplinary Action Authority (DSP.AA). 
19.16Incident Results Duration Days DSP.DYSIRS
All Suspension and Expulsion records must have this field populated. Partial days should be entered with a decimal. DSP.HR Hours will not be extracted.
18.16Student Instructional Support Indicator ADS.ISISINC
This field is required to be populated with a "Y" or "N" for ALL students. (Previously only required for Suspension/Expulsion records for Special Ed students.)
19.17Incident Result Modification Code EXP.EMCSIRS
Expulsion tab.
This field is required to be populated for all Expulsion records. The codes in Aeries match the CALPADS Codes.
Map CALPADS Code Translations for Disciplinary Action Modification (EXP.EMC). 
18.17Removal to Interim Alternative Setting ADS.RRSINC
A coded value representing the reason a student was removed to an interim alternative setting for 45 days or less. This field is required on all discipline incidents for all Special Ed students.

Attendance  

1.26Reason
Attendance Enrollment
ATT.RSSENR
May also come from STU.SWR or STU.EOY.
1.28Next School (NextSchl)
Attendance Enrollment
ATT.NSSENR or SSID
Only needed for Alternative schools or All records with an Exit Reason of "165" (Involuntary Transfer for Discipline).
1.30InterDistrict
(IntDist)
ATT.ITSENR or SSID
If the Inter/Intra District field (STU.IT) on Student Demographics is populated, ATT.IT and ENR are also populated.
1.31Transfer District
(TransDist)
ATT.ITDSENR or SSID
If the Inter/Intra District field (STU.ITD) on Student Demographics is populated, ATT.IT and ENR are also populated.
2.04Start Date
Attendance Enrollment
ATT.CD = E
+
ATT.DT
SINF
Effective Start Date - Located on Attendance Enrollment page for the current year.
2.05End Date
Attendance Enrollment

SINF
Effective End Date  
Automatically populated in CALPADS.

Attendance History  

13.13Attendance Exemption
STAS
CALPADS Other Options tab.
If any codes have been selected in the STU.SP values STAS Exempt table, a "Y" will be reported. All virtual schools will be reported as exempt.
13.15EnrolledAHS.ENSTAS
13.16PresentAHS.PRSTAS
13.17Days of SuspensionAHS.SUSTAS
13.18Days In School SuspensionAHS.ISSSTAS
13.19ExcusedAHS.AESTAS
13.20UnexcusedAHS.AUSTAS
13.21Non-ADA Generating Independent Study Days AHS.ISISTAS
13.22ADA Generating Independent Study Days
AHS.ISCSTAS
13.23Period-by-Period Attendance Method Indicator
LOC.A = 1STAS

Behavioral Emergency  

19.14Behavioral Emergency CodeBER.CDSIRS

Career Pathways  

11.13CTE Pathway RecordCPW.CDSCTE
Reference CALPADS Valid Code Combinations
11.14Completed CheckboxCPH.AYSCTE
Only extracted on Career Pathway records identified as "Completed" for the current year.

Courses  

9.07State Course 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.08Course ID
(CrsID#)
CRS.CNCRSE or CRSC
General tab.

Aeries recommends a district-wide, unique Course ID for each course.  For an Elementary school, TCH.TN is used.
9.09Course NameCRS.COCRSE or CRSC
For an Elementary school, TCH.TE is used.
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.13UC CSU Approved
(Subject Area, Elective?, Honors?, Validation)
CRS.E1
or
CRS.U1
or
CRS.U2
CRSE or CRSC
California Specific Fields tab.

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

Populate if course contains a more detailed subject matter within an area of course content.  For example, "piano" is a subcategory of a "Music - Instrumental" course.  If the value on the section (MST.CSC) is different than the course (CRS.CSC) value, then MST.CSC will be extracted. 
9.29Course Standards Grade Level Range CodeCRS.SGRCRSE or CRSC
California Specific Fields tab.

Populate the range of grade level standards that are covered in the content of the course: Elementary K-4, Middle Grades 5-8, Secondary 9-12 or Not Applicable.
When populating this field, the value should be based on the standards grade level of the course content and not the grade levels of the students enrolled in the course.

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

9.30Content Standards AlignmentCRS.CSACRSE or CRSC
California Specific Fields tab.

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

Data element retired 7/1/2021
9.32AP/IB Cross Code ReferenceCRS.ACCCRSE or CRSC
California Specific Fields tab.

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

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

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

Demographics  

1.08State Student ID (SSID)STU.CIDSENR or SSID
Student Data 2 tab.

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

Unique Aeries student identifier.
1.10First NameSTU.FN
(LSI.LFN)
SENR or SSID
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
1.11Middle NameSTU.MN
(LSI.LMN)
SENR or SSID
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
1.12Last NameSTU.LN
(LSI.LLN)
SENR or SSID
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
1.13Suffix STU.SF
(LSI.LSF)
SENR or SSID
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
1.14First AliasSTU.FNASENR or SSID
Student Data 1 tab.
1.15Middle AliasSTU.MNASENR or SSID
Student Data 1 tab.
1.16Last AliasSTU.LNASENR or SSID
Student Data 1 tab.
1.17BirthdateSTU.BDSENR or SSID
Student Data 1 tab.
1.18GenderSTU.GNSENR or SSID
Student Data 1 tab.
1.19Birth CitySTU.BCYSENR or SSID
Student Data 1 tab.
1.20StateSTU.BSTSENR or SSID
Student Data 1 tab.

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

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

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

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

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

Map CALPADS Code Translations for Completion Status (STU.HSG).
1.35Graduation Exemption IndicatorSTU.GEXSENR
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.09State Student ID (SSID)STU.CIDSINF
Student Data 2 tab.
2.10Perm ID#STU.IDSINF
Student Data 1 tab.

Unique Aeries student identifier.
2.11First NameSTU.FN
(LSI.LFN)
SINF
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
2.12Middle NameSTU.MN
(LSI.LMN)
SINF
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
2.13Last NameSTU.LN
(LSI.LLN)
SINF
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
2.14SuffixSTU.SF
(LSI.LSF)
SINF
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
2.15First AliasSTU.FNASINF
Student Data 1 tab.
2.16Middle AliasSTU.MNASINF
Student Data 1 tab.
2.17Last AliasSTU.LNASINF
Student Data 1 tab.
2.18BirthdateSTU.BDSINF
Student Data 1 tab.
2.19GenderSTU.GNSINF
Student Data 1 tab.
2.20Birth CitySTU.BCYSINF
Student Data 1 tab.
2.21State STU.BSTSINF
Student Data 1 tab.

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

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

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

If all Race fields are blank, this field will be flagged.
2.31Address Line 1
SINF
2.33Address City Name
SINF
2.34Address State Province Code
SINF (These code values will be translated when extracted from Aeries.)
2.35Address Zip Code
SINF
2.38Parent Guardian 1 Highest Education Level CodeCON.ELVSINF
2.39Guardian 1 First Name

CON.FNSINF
2.40Guardian 1 Last Name

CON.LNSINF
2.41Guardian 2 First NameCON.FNSINF
2.42Guardian 2 Last NameCON.LNSINF
2.43Student Preferred First NameSTU.FNSINF
Only if Legal Student Info (LSI) table populated
2.44Student Preferred Last NameSTU.LNSINF
Only if Legal Student Info (LSI) table populated
2.50
Parent Guardian2 Highest Education Level Code
CON.ELV
SINF
^.07State Student ID (SSID)STU.CIDSPRG, SCSE, SCSC, SCTE, SELA, STAS, SINC, SIRS, SOFF, PSTS
Student Data 2 tab.
^.08Perm ID#STU.IDSPRG, SCSE, SCSC, SCTE, SELA, STAS, SINC, SIRS, SOFF
Student Data 1 tab.

Unique Aeries student identifier.
^.09First NameSTU.FN
(LSI.LFN)
SPRG, SCSE, SCSC, SCTE, SELA, STAS, SINC, SIRS, SOFF
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
^.10Last NameSTU.LN
(LSI.LLN)
SPRG, SCSE, SCSC, SCTE, SELA, STAS, SINC, SIRS, SOFF
Data will come from Legal Student Info (LSI) table if populated, otherwise it will come from Student (STU) table.
^.11BirthdateSTU.BDSPRG, SCSE, SCSC, SCTE, SELA, STAS, SINC, SIRS, SOFF
Student Data 1 tab.
^.12GenderSTU.GNSPRG, SCSE, SCSC, SCTE, SELA, STAS, SINC, SIRS, SOFF
Student Data 1 tab.
12.15Reporting LanguageSTU.HLSELA
The new CALPADS 3-character Language codes will be extracted as of 2023-24 schoolyear.

Free and Reduced  

3.15Start DateFRE.ESDSPRG
3.16End DateFRE.EEDSPRG

GATE  

3.15Start DateGTE.ESDSPRG
If not using GATE table, See Special Programs:  PGM.ESD.
3.16End DateGTE.EEDSPRG
If not using GATE table, See Student Programs: PGM.EED.

Internships  

21.09Work-Based Learning TypeISP.WTWBLR - Values are hard-coded
21.13Employer EvaluationISP.EEWBLR - Values are hard-coded
21.11Total External Hours Completed

ISP.TXH

WBLR - Rounded to nearest whole number
21.14School SponsoredISP.SCSWBLR - Y/N
21.15Certificated SupervisorISP.CSWBLR - Y/N
21.12SectionISP.SEWBLR - Translated to State Course Code (CRS.C3) for the extract. Only reported if WBL type is 15 or 20.

Language Assessment  

2.36US School K-12LAC.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.14ELAS Start Date:
RFEP - (Redesignated EL's)
EO - (English only)

LAC.RD1,
LAC.AES
(LAC.STS, LAC.USS, STU.DD, STU.ED)
SELA
  • Redesignation Date (LAC.RD1) will be used for RFEP students.
  • EO Start date will use either LAC.STS, LAC.USS, STU.DD, or STU.ED in this order
  • ADEL Date (LAC.AES) will be used for Adult English Learner students (aged 22 or older) 

Master Schedule  

9.10High Quality CTE CrsMST.HQCCRSE OR CRSC
MST.HQC values of Yes will be converted to a "154" value when extracted to CALPADS.
If teacher is not properly credentialed, populate the value with No. 
9.14SectionMST.SECRSE or CRSC
  • TCH.TN for Elementary Schools
  • Alt Ed courses are virtualized section numbers
  • Individual Alt Ed course sections use "V" before the virtual section number

9.15Semester
(Sem)
MST.SMCRSE or CRSC
"FY" for Elementary Schools.
9.18Class IDMST.PD
MST.SM
MST.DY
CRSE or CRSC
This field is populated during the extract using information from many fields. This CALPADS field is used to associate multiple sections as being part of the same "Class" for purposes of determining Average Class Size. For Elementary Schools the definition level is SC+TN.
9.20Educational Service
(Ed Svc)
MST.ESRCRSE or CRSC
TCH.ESR for Elementary Schools.
9.21Language of Instruction
(Lang Instr)
MST.LICRSE or CRSC
TCH.LI for Elementary Schools. This field should only be populated if Education Service has a value of "1" or if Instructional Strategy has a value of "600". It should also never be populated with "English" or "Sign Language".
9.22Instructional Strategy
Instr Strategy)
MST.INS**As of the 2019/2020 school year, this field is not used.  English Learner Services will now be collected at the student level in the SPRG file as an Education Program code. 
9.23Independent Study
(Ind Study)
MST.ISICRSE or CRSC
TCH.ISI for Elementary Schools. A value of "Y" in this field will convert into the "Independent Study Indicator" CALPADS field when extracted.
9.24Distance Learning
(Dist Lrng)
MST.DLICRSE or CRSC
TCH.DLI for Elementary Schools. A value of "Y" in this field will convert into the "Distance Learning Indicator" CALPADS field when extracted.
9.25Multiple Teacher
(MultiTchr)
MST.MTSCRSE or CRSC
TCH.MTS for Elementary Schools
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.26Educational Program Funding Source
(Fund Src)
MST.FSCRSE or CRSC
TCH.FS for Elementary Schools. This field should be populated as appropriate for codes:
113 – CA Partnership Academy 168 – Specialized Secondary Instruction.
9.27CTE Provider
(CTE Prvdr)
MST.TEPCRSE or CRSC
Populate this field if this section is a CTE course. Identify if this section is being administered by the "ROC/P" or "District". Not needed for Elementary Schools.
Map CALPADS Code Translations for CTE Provider (MST.TEP). 
9.31Charter Non-CoreMST.CNCCRSE or CRSC
Data element retired 7/1/2021
9.32AP/IB Course Code Cross ReferenceMST.ACCCRSE or CRSC
If the value on the section (MST.ACC) is different than the course (CRS.ACC) value, then MST.ACC will be extracted. Identifies the four-digit cross reference to the actual AP or IB State Course Code for AP or IB courses that a local educational agency has mapped to a Career Technical Education (CTE) State Course Code (7000-8999) because that course is part of a CTE pathway. This allows districts to map to the CTE State Course Code in the State Course Code field, while providing the cross-reference to the actual AP or IB course code.
9.33Online Course Instruction CodeMST. OITCRSE or CRSC
Populate the type of online instruction that is being delivered in a course section. 
9.34Middle School Core Setting IndicatorMST.MSCCRSE or CRSC
If the value on the section (MST.MSC) is different than the course (CRS.MSC) value, then MST.MSC will be extracted. Populate a Y or N to indicate if the course, in grades five through eight, is being taught as part of a middle school core setting.   
9.35Local Assignment OptionMST.NCACRSE or CRSC
Populate if the the local governing board authorized a teacher to teach a course without the appropriate credential or authorization.
9.36High Quality CTE CourseMST.HQCCRSE or CRSC
Populate a Y or N if the course section and teacher meet the High Quality CTE Course qualifications.

Post-Secondary Survey  

17.12Postsecondary Status CodePSS.CDPSTS - Values are hard-coded  
17.13Educational Institution TypePSS.EITPSTS - Values are hard-coded
Only required for codes 200 through 350 (inclusive)
17.14Industry FieldPSS.IFCPSTS - Values are hard-coded 
Only required for codes 910, 920, or 930
17.15Post-High School CredentialPSS.PSCPSTS - Values are hard-coded 

School Options  

^.04Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
SENR, SSID, SASS, CRSE, CRSC, SCSE, SCSC, SCTE, SELA, STAS, PSTS, SINC, SIRS, SOFF, SPRG
2.06Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
SINF
Located on Attendance Enrollment page for the current year.
^.05School CDS#LOC.SCSENR, SSID, SASS, CRSE, CRSC, SCSE, SCSC, SCTE, SELA, STAS, PSTS, SINC, SIRS, SOFF
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
1.06School of Attendance NPSLOC.SCSENR or SSID
  • District LOC records should populate this field with seven zeroes: "0000000".
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
2.07School of AttendanceLOC.SCSINF
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
3.04Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
SPRG
7.06Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
SDEM
8.04Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
SASS
9.04Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
CRSE or CRSC
9.05

School of Course DeliveryLOC.SCCRSE, CRSC
SCSE or SCSC
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
10.04Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
SCSE or SCSC
10.05School CDS#LOC.SCSCSE or SCSC
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
11.04Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
SCTE
11.05School CDS#LOC.SCSCTE
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
12.04Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
SELA
12.05School CDS#LOC.SCSELA
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
13.04Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
STAS
13.05School CDS#LOC.SCSTAS
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
13.14Attendance Reporting
(Positive = Hourly)
LOC.BSTAS

Determined by school attendance setup.

17.04Reporting LEA
(County CDS# + District CDS#)
LOC.CC
+
LOC.DC
PSTS
17.05School CDS#LOC.SCPSTS
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number

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


18.05
19.05
20.05
School CDS#

Secondary Student Data  

2.37SNOR - US Schl < 3 YrsSSD.SUSSINF or SIAD
This field is also located on the Demographics page.
3.20Migrant Ed - State Migrant IDSSD.MIDSPRG
This field is also located on the Program page.
17.12Postsecondary Status CodeSSD.PSSPSTS
This field is located on the Perkins tab

Special Education  

1.34Adult Age with Students with Disabilities Transition
(Renamed from Post-Secondary Program Status and/or Post-Secondary Employment)
CSE.PSP
and/or
CSE.PSE
and/or
CSE.PSI
SENR
Select the CSE.PSP code to identify students in Special Education who are remaining in grade 12 till age 22. The CSE.PSE codes are also available, if applicable.
Map CALPADS Other Options for CSE.PSP and CSE.PSE codes.
3.15Entry DateCSE.EDSPRG
3.16Exit DateCSE.XDSPRG
3.21DisabilityCSE.DISPRG
Populate this field according the CASEMIS standards.
3.22District of ResidenceCSE.DRSPRG
Populate this field according the CASEMIS standards.
17.06

School of Attendance NPS

CSE.TYPSTS
17.09Local Special Education Student IDCSE.SEIPSTS
Reporting to be done via Special Ed Database, not Aeries
17.10Reporting SELPACSE.SEPSTS
Reporting to be done via Special Ed Database, not Aeries

Special Programs  

3.05School PGM.SCLSPRG
If this field is populated with a zero (0), the School of Attendance will be reported from the Attendance Enrollment (ATT) table.
3.13Program CodePGM.CDSPRG
Special Education, NSLP, GATE, and 504 Programs will be extracted from their specific tables.
  • Special Education is stored in CSE.
  • NSLP is stored in FRE.
  • GATE can be stored in PGM or GTE.
  • 504 can be stored in either PGM or FOF.
3.14 Program CodePGMEligibility and Participation Categories are hard-coded based on Program Code.
3.15Eligibility/Participation Start DatePGM.PSD
&
PGM.ESD
SPRG
Date will be extracted as entered in Aeries unless the date extends beyond the enrollment. If the date is before the Enrollment date, the Enrollment date will be used. In certain programs the Eligibility Start Date may also be extracted.

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

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

Staff  

7.04Effective Start DateSTF.HDSDEM
For Fall 1, July 1st of each academic year for returning staff or hire date for new staff. For EOY, May 1st of each academic year or hire date for staff hired after May 1st.  Automatically populated in SDEM extract.
7.05Leave DateSTF.LDSDEM

7.08State Educator ID (SEID)STF.SIDSDEM
7.09Staff IDSTF.IDSDEM
Unique Aeries staff identifier.
7.10First NameSTF.FNSDEM
7.11Middle NameSTF.MNSDEM
7.12Last NameSTF.LNSDEM
7.13Previous First NameSTF.FNPSDEM
7.14Previous Middle NameSTF.MNPSDEM
7.15Previous Last NameSTF.LNPSDEM
7.16BirthdateSTF.BDSDEM
7.17GenderSTF.GNSDEM
7.18EthnicitySTF.ETHSDEM
7.19Ethnicity Missing STF.ETHSDEM
If Ethnicity field is blank, this field will be flagged.
7.20Race STF.RC1SDEM
7.21Race 2 STF.RC2SDEM
7.22Race 3 STF.RC3SDEM
7.23Race 4 STF.RC4SDEM
7.24Race 5 STF.RC5SDEM
7.25Race Missing STF.RC#SDEM
If all Race fields are blank, this field will be flagged.
7.26Educational Level
(Educational Lvl)
STF.ELSDEM
7.27Position StatusSTF.PSSDEM
7.28Hire DateSTF.HDSDEM
7.29Leave DateSTF.LDSDEM
7.30Total Year in This DistrictSTF.TYDSDEM
7.31Total Years of Educational Service
(Total Years of Edu Service)
STF.TYSSDEM

Staff Job Assignments  

8.05Primary SchoolSTF.PSCSASS
If assigned to more than one school, pulls from STJ.SCL
8.07State Educator ID (SEID)STF.SIDSASS
8.08Staff IDSTF.IDSASS
Unique Aeries staff identifier.
8.09First NameSTF.FNSASS
8.10Last NameSTF.LNSASS
8.11BirthdateSTU.BDSASS
8.12GenderSTF.GNSASS
8.13Staff/Job Assignments
Job Classification
STJ.JCSASS
Job Assignments (STJ) window.
8.14Staff/Job Assignments
FTE
STJ.FTESASS
Job Assignments (STJ) window.
8.15Staff/Job Assignments
Non Classroom Based Job Assignment Codes
STJ.NC1SASS
Job Assignments (STJ) window.
8.16Staff/Job Assignments
Non Classroom Based Job Assignment Code 2
STJ.NC2SASS
Job Assignments (STJ) window.
8.17Staff/Job Assignments
Non Classroom Based Job Assignment Code 3
STJ.NC3SASS
Job Assignments (STJ) window.
8.18Staff/Job Assignments
Non Classroom Based Job Assignment Code 4
STJ.NC4SASS
Job Assignments (STJ) window.
8.19Staff/Job Assignments
Non Classroom Based Job Assignment Code 5
STJ.NC5SASS
Job Assignments (STJ) window.
8.20Staff/Job Assignments
Non Classroom Based Job Assignment Code 6
STJ.NC6SASS
Job Assignments (STJ) window.
8.21Staff/Job Assignments
Non Classroom Based Job Assignment Code 7
STF.NC7SASS
Job Assignments (STJ) window.

Teachers  

9.16State Educator ID (SEID)STF.SIDCRSE or CRSC
9.17Teacher Number
(Tch#)
TCH.IDCRSE or CRSC
TCH.ID2 and TCH.ID3 can also be used to express Team Teaching or Job Sharing for Elementary Schools.

Transcript Definition  

10.20Terms TDF.ST#SCSE or SCSC
Terms tab.

State Term Codes.

Transcripts  

1.29Met UC CSU RequirementsSTU.CCS
&
STU.CUC
SENR or SSID
Run the Update College Entrance Requirements function to populate.
10.14Section IDHIS.SESCSE or SCSC
More button.
  • SCSE extracts from Crs Attendance (CAR.SE).
  • SCSC extracts from Transcripts (HIS.SE).
  • Alt Ed courses are virtualized section numbers
  • Individual Alt Ed course sections use "V" before the virtual section number
10.15Term
(Tm)
HIS.TESCSE or SCSC
  • SCSE extracts from the Master Schedule (MST.SM).
  • SCSC extracts from Transcripts (HIS.TE).
10.16Credits Attempted
(Atmp)
HIS.CRSCSE or SCSC
  • SCSE extracts from Courses (CRS.CR).
  • SCSC extracts from Transcripts (HIS.CR).
10.17Completed Credits
(Comp)
HIS.CCSCSE or SCSC
  • SCSE extracts from Courses (CRS.CR).
  • SCSC extracts from Transcripts (HIS.CC).
10.18MarkHIS.MKSCSE or SCSC
  • SCSE extracts from Courses (GRD.MK).
  • SCSC extracts from Transcripts (HIS.MK).


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