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 

 

CALPADS

Field #

CALPADS Field Name

Aeries

Table.Field

Comments/Notes

SSID  Student Enrollment Identifier

SENR Student Enrollment Update

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

1.05School of AttendanceLOC.SC
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
1.06School of Attendance NPSLOC.SCNPS schools should populate this field with six zeroes and a one: “0000001”.
1.07Academic Year ID
Determined by school calendar year.  
Automatically populated in SENR extract.
1.08SSIDSTU.CIDUse the CALPADS Create SSID Extract to obtain and import SSIDS.
1.09Local Student IDSTU.IDUnique Aeries student identifier.
1.10Student Legal First NameSTU.FN
1.11Student Legal Middle NameSTU.MN
1.12Student Legal Last NameSTU.FL
1.13Student Legal Name Suffix CodeSTU.SF
1.14Student Alias First NameSTU.FNA
1.15Student Alias Middle NameSTU.MNA
1.16Student Alias Last NameSTU.FNA
1.17Student Birth DateSTU.BD
1.18Student Gender CodeSTU.GN
1.19Student Birth CitySTU.BCY
1.20Student Birth State Provence CodeSTU.BSTThese code values will be translated when extracted from Aeries.
1.21Student Birth Country CodeSTU.BCUThese code values will be translated when extracted from Aeries.
1.22Enrollment Start DateSTU.EDThis information will also come from the ENR table if the district has good ENR data for multiple years.  Local data management practices may need to be adjusted to treat contiguous School Enter Date.  Attendance Enrollment may need to be used when students return to the current school after having left.
1.23Enrollment Status CodeSTU.SPSTU.SP values will be translated to these codes.  Optionally a User Code field could be used.
1.24Grade Level CodeSTU.GR
1.25Enrollment Exit DateSTU.LDThis information will also come from the ENR table if the district has good ENR data for multiple years.  Local data management practices may need to be adjusted to treat the School Leave Date as the actual School Leave Date.  Attendance Enrollment may need to be used when students return to the current school after leaving.  This information will also be populated with the last day of school if the EOY fields have been populated.
1.26Student Exit Reason CodeATT.RSMay also come from STU.SWR or STU.EOY.
1.27Student School Completion StatusSTU.HSGMap CALPADS Code Translations for Completer Status (STU.HSG).
1.28Expected Receiver School of AttendanceATT.NSOnly needed for Alternative schools or All records with an Exit Reason of "165" (Involuntary Transfer for Discipline).
1.29Student Met all UC CSU Requirements IndicatorSTU.CCS
&
STU.CUC
Run the Update College Entrance Requirements function to populate.
1.30Student School Transfer CodeATT.ITIf the Inter/Intra District field (STU.IT) on Student Demographics is populated, ATT.IT and ENR are also populated.
1.31District of Geographic Residence CodeATT.ITDIf the Inter/Intra District field (STU.ITD) on Student Demographics is populated, ATT.IT and ENR are also populated.
1.32Student Golden State Seal Merit Diploma IndicatorACT.CDMap CALPADS Other Options for ACT code.
1.33Student Seal of Biliteracy IndicatorACT.CDMap CALPADS Other Options for ACT code.
1.34Post Secondary Transition IndicatorCSE.PSP
or
CSE.PSE
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.35Workforce Readiness (Strategic Skills) Certificate Program Completion IndicatorACT.CDMap CALPADS Other Options for ACT code.
1.36Food Handler Certification Program Completion IndicatorACT.CDMap CALPADS Other Options for ACT code.
1.37Certified Pre-Apprenticeship Certification Program Completion IndicatorACT.CDMap CALPADS Other Options for ACT code.
1.38Non-Certified Pre-Apprenticeship Program Completion IndicatorACT.CDMap CALPADS Other Options for ACT code.
1.39State or Federal Job Program Completion IndicatorACT.CDMap CALPADS Other Options for ACT code.
SINF Student Information
SIAD Student Information Address
2.01Record Type Code
Must equal SINF or SIAD.  
Automatically populated in SINF/SIAD extract.
2.02Transaction Type Code
Must equal " ", A or D.  
Automatically populated in SINF/SIAD extract.
2.03Local Record ID
Submission ID.  
Automatically populated in SINF/SIAD extract.
2.04Effective Start DateATT.CD = E
+
ATT.DT
Located on Attendance Enrollment page for the current year.
2.05Effective End DateATT.CD = L
+
ATT.DT
Located on Attendance Enrollment page for the current year.
2.06Reporting LEALOC.CC
+
LOC.DC

2.07School of AttendanceLOC.SC
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
2.08Academic Year ID
Determined by school calendar year.  
Automatically populated in SINF/SIAD extract.
2.09SSIDSTU.CID
2.10Local Student IDSTU.IDUnique Aeries student identifier.
2.11Student Legal First NameSTU.FN
2.12Student Legal Middle NameSTU.MN
2.13Student Legal Last NameSTU.LN
2.14Student Legal Name Suffix CodeSTU.SF
2.15Student Alias First NameSTU.FNA
2.16Student Alias Middle NameSTU.MNA
2.17Student Alias Last NameSTU.LNA
2.18Student Birth DateSTU.BD
2.19Student Gender CodeSTU.GN
2.20Student Birth CitySTU.BCY
2.21Student Birth State Province CodeSTU.BSTThese code values will be translated when extracted from Aeries.
2.22Student Birth Country CodeSTU.BCUThese code values will be translated when extracted from Aeries.
2.23Student Hispanic Ethnicity IndicatorSTU.ETH
2.24Student Ethnicity Missing IndicatorSTU.ETHIf Ethnicity field is blank, this field will be flagged.
2.25Student Race 1 CodeSTU.RC1
2.26Student Race 2 CodeSTU.RC2
2.27Student Race 3 CodeSTU.RC3
2.28Student Race 4 CodeSTU.RC4
2.29Student Race 5 CodeSTU.RC5
2.30Student Race Missing IndicatorSTU.RC#If all Race fields are blank, this field will be flagged.
2.31Address Line 1ADH.RAD
2.32Address Line 2

2.33Address City NameADH.RCY
2.34Address State Provence CodeADH.RST
2.35Address Zip CodeADH.RZC
2.36Student Initial US School Enrollment Date K-12LAC.USSThis field is also displayed on the Demographics page.
2.37Enrolled in US School less than Three Cumulative Years IndicatorSSD.SUSThis field is also displayed on the Demographics page.
2.38Parent Guardian Highest Education Level CodeSTU.PED
2.39Guardian 1 First NameSTU.PG
2.40Guardian 1 Last Name

2.41Guardian 2 First Name

2.42Guardian 2 Last Name

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

12.05School of AttendanceLOC.SC
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
12.06Academic Year ID
Determined by school calendar year.  
Automatically populated in SELA extract.
12.07SSIDSTU.CID
12.08Student Legal First NameSTU.FN
12.09Student Legal Last NameSTU.LN
12.10Student Birth DateSTU.BD
12.11Student Gender CodeSTU.GN
12.12Local Student IDSTU.ID
12.13English Language Acquisition Status CodeSTU.LF
12.14English Language Acquisition Status Start DateLAC.SD
LAC.RD1
LAC.IFD
  • EL Start Date (LAC.SD) will be used for EL students.
  • Redesignation Date (LAC.RD1) will be used for Redesignated students.
  • IFEP Date (LAC.IFD) will be used for IFEP students.
12.15Primary Language CodeSTU.HL
SPRG Student Program
3.01Record Type Code
Must equal SPRG.  
Automatically populated in SPRG extract.
3.02Transaction Type Code
Must equal " ", A, D or R.  
Automatically populated in SPRG extract.
3.03Local Record ID
Submission ID.  
Automatically populated in SPRG extract.
3.04Reporting LEALOC.CC
+
LOC.DC

3.05School of AttendancePGM.SCLIf this field is populated with a zero (0), the School of Attendance will be reported from the Attendance Enrollment (ATT) table.
3.06Academic Year ID
Determined by school calendar year.
Automatically populated in SPRG extract.
3.07SSIDSTU.CID
3.08Local Student IDSTU.IDUnique Aeries student identifier.
3.09Student Legal First NameSTU.FN
3.10Student Legal Last NameSTU.LN
3.11Student Birth DateSTU.BD
3.12Student Gender CodeSTU.GN
3.13Education Program CodePGM.CDSpecial Education, NSLP, GATE, and 504 Programs will be extracted from their specific tables.
  • Special Education is stored in CSE.
  • NSLP is stored in FRE.
  • GATE can be stored in PGM or GTE.
  • 504 can be stored in either PGM or FOF.
3.14Education Program Membership CodePGMFixed for Eligibility and Participation Categories.
3.15Education Program Membership Start DatePGM.PSD
&
PGM.ESD
Date will be extracted as entered in Aeries unless the date extends beyond the enrollment. If the date is before the Enrollment date, the Enrollment date will be used. In certain programs the Eligibility Start Date may also be extracted.

Special Education, NSLP, GATE, and 504 Programs will be extracted from their specific tables.
  • Special Education:  CSE.ED
  • NSLP:  FRE.ESD
  • GATE: GTE.ESD or PGM.ESD
  • 504: FOF.SD or PGM.ESD
3.16Education Program Membership End DatePGM.PED
&
PGM.EED
Date will be extracted as entered in Aeries unless the date extends beyond the last day of school. If the date entered is after the last day of school, the last day of school will be used for any programs requiring an annual end date in CALPADS. In certain programs the Eligibility End Date may also be extracted.

Special Education, NSLP, GATE, and 504 Programs will be extracted from their specific tables.
  • Special Education:  CSE.XD
  • NSLP:  FRE.EED
  • GATE: GTE.EED or PGM.EED
  • 504: FOF.ED or PGM.EED
3.17Education Service Academic Year
Determined by school calendar year.  Automatically populated in SPRG extract.
3.18Education Service CodePGM.SRIf School Wide Title 1 (Education Program code = 121) SPRG records do not need to be submitted per CALPADS.
Map CALPADS Code Translations for Program Code Education Service - Title I Part A Basic (Education Program code = 122).
3.19California Partnership Academy IDPGM.CPAFor Education Program Code = 113 this field was recently changed to be a 5 character field, enter the Academy ID in the COD table and select in this field.
3.20Migrant Student IDSSD.MIDThis field is also located on the Program page.
3.21Primary Disability CodeCSE.DIPopulate this field according to CASEMIS standards.
3.22District of Special Education AccountabilityCSE.DRPopulate this field according to CASEMIS standards.
3.23Homeless Dwelling Type CodePGM.HDTFor Education Program Code = 191 – Homeless.
Populate Homeless Dwelling Type.
3.24Unaccompanied Youth IndicatorPGM.UYFor Education Program Code = 191 – Homeless. An indication of whether or not a student who has been identified as homeless is not in the direct care of their parent or guardian.
3.25Runaway Youth IndicatorPGM.RAFor Education Program Code = 191 – Homeless. An indication of whether or not a student who has been identified as homeless who is less than 18 years of age who has left home without parental/caregiver permission and stay away for one or more nights.
Note: Once a student is reported as a runaway youth for a given school year, even if the student is no longer a runaway, the indicator (PGM.RA) should not be changed to N unless a correction is being made.
3.26Filler
Field no longer used.  Filled with blank.
SDEM Staff Demographics
7.01Record Type Code
Must equal SDEM.  
Automatically populated in SDEM extract.
7.02Transaction Type Code
Must equal " ", A, or  D.  
Automatically populated in SDEM extract.
7.03Local Record ID
Submission ID.  
Automatically populated in SDEM extract.
7.04Effective Start date
For Fall 1, July 1st of each academic year for returning staff or hire date for new staff. For EOY, May 1st of each academic year or hire date for staff hired after May 1st.  
Automatically populated in SDEM extract.
7.05Effective End DateSTF.LD
7.06Reporting LEALOC.CC
+
LOC.DC

7.07Academic Year ID
Determined by school calendar year.  
Automatically populated in SDEM extract.
7.08SEIDSTF.SID
7.09Local Staff IDSTF.IDUnique Aeries staff identifier.  
7.10Staff Legal First NameSTF.FN
7.11Staff Legal Middle NameSTF.MN
7.12Staff Legal Last NameSTF.LN
7.13Staff Alias First NameSTF.FNP
7.14Staff Alias Middle NameSTF.MNP
7.15Staff Alias Last NameSTF.LNP
7.16Staff Birth DateSTF.BD
7.17Staff Gender CodeSTF.SX
7.18Staff Hispanic Ethnicity IndicatorSTF.ETH
7.19Staff Ethnicity Missing IndicatorSTF.ETHIf Ethnicity field is blank, this field will be flagged.
7.20Staff Race 1 CodeSTF.RC1
7.21Staff Race 2 CodeSTF.RC2
7.22Staff Race 3 CodeSTF.RC3
7.23Staff Race 4 CodeSTF.RC4
7.24Staff Race 5 CodeSTF.RC5
7.25Staff Race Missing IndicatorSTF.RC#If all Race fields are blank, this field will be flagged.
7.26Staff Highest Degree CodeSTF.EL
7.27Staff Employment Status CodeSTF.PS
7.28Staff Employment Start DateSTF.HD
7.29Staff Employment End DateSTF.LD
7.30Staff Service Years LEASTF.TYD
7.31Staff Service Years TotalSTF.TYS
SASS Staff Assignment
8.01Record Type Code
Must equal SASS.  
Automatically populated in SASS extract.
8.02Transaction Type Code
Must equal " ", D, or R.  
Automatically populated in SASS extract.
8.03Local Record ID
Submission ID.  
Automatically populated in SASS extract.
8.04Reporting LEALOC.CC
+
LOC.DC

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

9.05School of Course DeliveryLOC.SC
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
9.06Academic Year ID
Determined by school calendar year.
Automatically populated in CRSE or CRSC extract.
9.07CRS-State Course CodeCRS.C3All courses must be populated with a value in this field. Use "6012" if you would like Aeries to skip this course. For an Elementary school, TCH.CB is used.
9.08CRS-Local Course IDCRS.CNAeries recommends a district-wide, unique Course ID for each course.  For an Elementary school, TCH.TN is used.
9.09CRS-Course NameCRS.COFor an Elementary school, TCH.TE is used.
9.10CRS-Course Content CodeCRS.VCLCRS.VCL values of 01, 02, or 03 will be converted to a "154" when extracted to CALPADS. Not needed for Elementary Schools.
9.11Filler

9.12CRS-CTE Postsecondary Articulated Course IndicatorCRS.TYValues of 32 and 33 will be used for this field. Not needed for Elementary Schools.
9.13CRS-UC CSU Approved IndicatorCRS.U1
etc.
All the UC/CSU Subjects Area fields, including the Validation Level field should be populated for accurate UC/CSU Course Completer Analysis at the student level.  Not needed for Elementary Schools, "N" will be extracted.
9.14Course Section IDMST.SETCH.TN for Elementary Schools.
9.15Academic Term CodeMST.SM"FY" for Elementary Schools.
9.16SEIDSTF.SID
9.17Local Staff IDTCH.IDTCH.ID2 and TCH.ID3 call also be used to express Team Teaching or Job Sharing for Elementary Schools.
9.18Class IDMST.PD MST.SM MST.DYThis field is populated during the extract using information from many fields. This CALPADS field is used to associate multiple sections as being part of the same "Class" for purposes of determining Average Class Size.  For Elementary Schools the definition level is SC+TN.
9.19Course Section Instructional Level CodeCRS.CLExisting Code Values will be Translated to CALPADS Codes. Not reported for Elementary Schools.
Map CALPADS Code Translations for Course Instruction Level (CRS.CL).
9.20Educational Service CodeMST.ESRTCH.ESR for Elementary Schools.
9.21Language of Instruction CodeMST.LITCH.LI for Elementary Schools.  This field should only be populated if Education Service has a value of "1" or if Instructional Strategy has a value of "600". It should also never be populated with "English" or "Sign Language".
9.22Instructional Strategy CodeMST.INSTCH.INS for Elementary Schools.
9.23Independent Study IndicatorMST.ISITCH.ISI for Elementary Schools.  A value of "Y" in this field will convert into the "Independent Study Indicator" CALPADS field when extracted.
9.24Distance Learning IndicatorMST.DLITCH.DLI for Elementary Schools.  A value of "Y" in this field will convert into the "Distance Learning Indicator" CALPADS field when extracted.
9.25Multiple Teacher CodeMST.MTSTCH.MTS for Elementary Schools.
9.26Education Program Funding Source CodeMST.FSTCH.FS for Elementary Schools.  This field should be populated as appropriate for codes:
113 – CA Partnership Academy 168 – Specialized Secondary Instruction.
9.27CTE Course Section Provider CodeMST.TEPPopulate this field if this section is a CTE course. Identify if this section is being administered by the "ROC/P" or "District".  Not needed for Elementary Schools.
Map CALPADS Code Translations for CTE Provider (MST.TEP).
9.28Filler

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

10.05School of Course DeliveryLOC.SC
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
10.06Academic Year ID
Determined by school calendar year.
Automatically populated in SCSE or SCSC extract.
10.07SSIDSTU.CID
10.08Local Student IDSTU.ID
10.09Student Legal First NameSTU.FN
10.10Student Legal Last NameSTU.LN
10.11Student Birth DateSTU.BD
10.12Student Gender CodeSTU.GN
10.13Local Course IDCRS.CN
10.14Course Section IDHIS.SE
  • SCSE extracts from Crs Attendance (CAR.SE).
  • SCSC extracts from Transcripts (HIS.SE).
10.15Academic Term CodeHIS.TE
  • SCSE extracts from the Master Schedule (MST.SM).
  • SCSC extracts from Transcripts (HIS.TE).
10.16Student Credits AttemptedHIS.CR
  • SCSE extracts from Courses (CRS.CR).
  • SCSC extracts from Transcripts (HIS.CR).
10.17Student Credits EarnedHIS.CC
  • SCSE extracts from Courses (CRS.CR).
  • SCSC extracts from Transcripts (HIS.CC).
10.18Student Course Final GradeHIS.MK
  • SCSE extracts from Courses (GRD.MK).
  • SCSC extracts from Transcripts (HIS.MK).
10.19UC/CSU Admission Requirement CodeCRS.E1
or
CRS.U1
or
CRS.U2

10.20Marking Period CodeTDF.ST#State Term Codes on the Terms Tab.
SDIS Student Discipline
4.01Record Type Code
Must equal SDIS.  
Automatically populated in SDIS extract.
4.02Transaction Type Code
Must equal " " or D.  
Automatically populated in SDIS extract.
4.03Local Record ID
Submission ID.  
Automatically populated in SDIS extract.
4.04Reporting LEALOC.CC
+
LOC.DC

4.05School of AttendanceLOC.SC
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
4.06Academic Year ID
Determined by school calendar year.  
Automatically populated in SDIS extract.
4.07SSIDSTU.CID
4.08Local Student IDSTU.IDUnique Aeries student identifier.
4.09Student Legal First NameSTU.FN
4.10Student Legal Last NameSTU.LN
4.11Student Birth DateSTU.BD
4.12Student Gender CodeSTU.GN
4.13Disciplinary Incident ID LocalADS.IID
4.14Disciplinary Incident Occurrence DateADS.DT
4.15Student Offense CodeADS.CDPlace the most severe offense as the first code listed on this page. CALPADS codes may not compatible with codes that are being used in Aeries, verify your local codes account for all of the 48900 and 48915 Ed Codes.  Your local codes will be translated to the CALPADS codes when they are extracted.
Map CALPADS Code Translations for Discipline Offense Code (ADS.CD).
4.16Incident Most Severe Offense CodeADS.CDThis will be flagged when extracting the ADS.CD field.  The Suspendable Offense Code Table must be populated for proper extraction.
4.17Weapon Category CodeADS.WTAlthough you can use the CALPADS Code Values, we recommend creating your own codes that are more refined than the CALPADS codes. Your local codes can be translated to the CALPADS codes during extract.
Map CALPADS Code Translations for Discipline Weapon Type (ADS.WT).
4.18Incident Disciplinary Action Taken CodeDSP.DSDo 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).
4.19Disciplinary Action Authority CodeDSP.AAAll Suspension and Expulsion records must have this field populated.
Map CALPADS Code Translations for Disciplinary Action Authority (DSP.AA).
4.20Incident Disciplinary Action Duration DaysDSP.DYAll Suspension and Expulsion records must have this field populated.  Partial days should be entered with a decimal.  DSP.HR Hours will not be extracted.
4.21Student Instructional Support IndicatorADS.ISIThis field is required to be populated with a "Y" or "N" on all Suspension/Expulsion records for Special Ed students.
4.22Disciplinary Action Modification Category CodeEXP.EMCThis field is located on the Expulsion tab and is required to be populated for all Expulsion records. The codes in Aeries match the CALPADS Codes.
Map CALPADS Code Translations for Disciplinary Action Modification (EXP.EMC).
4.23Removal to Interim Alternative Setting Reason CodeADS.RRA coded value representing the reason a student was removed to an interim alternative setting for 45 days or less. This field is required on all discipline incidents for all Special Ed students.
SCTE Student CTE
11.01Record Type Code
Must equal SCTE.  
Automatically populated in SCTE extract.
11.02Transaction Type Code
Must equal " ", D, or R.  
Automatically populated in SCTE extract.
11.03Local Record ID
Submission ID.  
Automatically populated in SCTE extract.
11.04Reporting LEALOC.CC
+
LOC.DC

11.05School of AttendanceLOC.SC
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
11.06Academic Year ID
Determined by school calendar year.  
Automatically populated in SCTE extract.
11.07SSIDSTU.CID
11.08Local Student IDSTU.IDUnique Aeries student identifier.
11.09Student Legal First NameSTU.FN
11.10Student Legal Last NameSTU.LN
11.11Student Birth DateSTU.BD
11.12Student Gender CodeSTU.GN
11.13CTE Pathway CodeCPW.CD
11.14CTE Pathway Complete Academic Year IDCPH.AYOnly extracted on Career Pathway records identified as "Completed" for the current year.
STAS Student Absence Summary
13.01Record Type Code
Must equal STAS.  
Automatically populated in STAS extract.
13.02Transaction Type Code
Must equal " ", D, or R.  
Automatically populated in STAS extract.
13.03Local Record ID
Submission ID.  
Automatically populated in STAS extract.
13.04Reporting LEALOC.CC
+
LOC.DC

13.05School of AttendanceLOC.SC
  • District LOC records should populate this field with seven zeroes: "0000000".  
  • NPS schools should populate this field with six zeroes and a one: “0000001”.
  • Private Schools with six zeroes and a 2 "0000002".
  • Independent Charters should populate this field with the school part of their CDS number.
13.06Academic Year ID
Determined by school calendar year.  
Automatically populated in STAS extract.
13.07SSIDSTU.CID
13.08Local Student IDSTU.ID
13.09Student Legal First NameSTU.FN
13.10Student Legal Last NameSTU.LN
13.11Student Birth DateSTU.BD
13.12Student Gender CodeSTU.GN
13.13Student Absence Summary Data Collection Exemption Indicator
Determined by CALPADS Other Options tab.  If any codes have been selected in the STU.SP values STAS Exempt table, a "Y" will be reported.  All virtual schools will be reported as exempt.
13.14Hourly Attendance School Type IndicatorLOC.BDetermined by school attendance setup.
13.15Expected Attendance DaysAHS.EN
13.16Days AttendedAHS.PR
13.17Days Absent Out-of-School SuspensionAHS.SU
13.18Days in Attendance In-School SuspensionAHS.ISS
13.19Days Absent Excused Non-SuspensionAHS.AE
13.20Days Absent Unexcused Non-SuspensionAHS.AU
13.21Incomplete Independent Study DaysAHS.ISI