Miscellaneous Student Data - Authorizations, Prohibitions, and Waivers
Field#
Name
06.13
Education Regulatory
Exemption Code
In Aeries? Tbl.Fld
AUT.TY
Aeries Comment
CALPADS Code Set
See Code Set Education Regulatory Exemption
06.14
Education Regulatory
Exemption Outcome Code
AUT.ST
See Code Set Education Regulatory Exemption
Outcome
06.15
Education Regulatory
Exemption Outcome Start Date
AUT.SDT
Student Secondary Data
Field#
Name
03.26
Student Foster Identifier
In Aeries? Tbl.Fld
SSD.FID
Aeries Comment
CALPADS Code Set
A filler until October 2014
Transcript Definition
Field#
Name
10.20
Marking Period Code
In Aeries? Tbl.Fld
TDF.ST#
Aeries Comment
CALPADS Code Set
"State Term Codes" on the "Terms" tab
See Code Set Academic Term
Aeries Comment
CALPADS Code Set
School Options
Field#
Name
In Aeries? Tbl.Fld
01.04
Reporting LEA
LOC.CC &
DC
01.05
School of Attendance
LOC.SC
12.04
Reporting LEA
LOC.CC &
DC
12.05
School of Attendance
LOC.SC
Aeries CALPADS Cross Reference by Form
7/29/2014
Page 1
Master Schedule
Field#
Name
09.14
Course Section ID
In Aeries? Tbl.Fld
MST.SE
Aeries Comment
TCH.TN for Elementary Schools
CALPADS Code Set
09.15
Academic Term Code
MST.SM
"FY" for Elementary Schools
09.18
Class ID
SC,
MST.SM,
TN, PD, BL,
DY
Various fields will be concatenated to create this ID.
Elementary Level definition is SC + TN.
09.20
Education Service Code
MST.ESR
TCH.ESR for Elementary Schools
See Code Set Education Service English Learners
09.21
Language of Instruction Code
MST.LI
TCH.LI for Elementary Schools
See Code Set Language
09.22
Instructional Strategy Code
MST.INS
TCH.INS for Elementary Schools
See Code Set Instructional Strategy
09.23
Independent Study Indicator
MST.ISI
TCH.ISI for Elementary Teachers and MST.ISI for
Secondary Sections
09.24
Distance Learning Indicator
MST.DLI
TCH.DLI for Elementary Teachers and MST.DLI for
Secondary Sections
09.25
Multiple Teacher Code
MST.MTS
TCH.MTS for Elementary Schools or Secondary
Teacher records assigned to multiple Staff IDs.
See Code Set Multiple Teacher Instruction Strategy
Category
09.26
Education Program Funding
Source Code
MST.FS
TCH.FS for Elementary Schools
See Code Set Education Program Funding Source
09.27
CTE Course Section Provider
Code
MST.TEP
Not needed for Elementary Schools.
See Code Set Career Technical Education Funding
Provider Category
09.28
HQT Competency Code
MST.HQT
This may also come from TCH.HQT for elementary
teachers. This info can be setup in the STH table and
cross-referenced with NCLB Core Area.
See Code Set Content Area Competency Category
Aeries CALPADS Cross Reference by Form
See Code Set Academic Term
7/29/2014
Page 2
Courses
Field#
Name
Aeries Comment
CALPADS Code Set
09.07
CRS-State Course Code
In Aeries? Tbl.Fld
CRS.C3
TCH.CB for Elementary Schools
See Code Set Course Group State
09.08
CRS-Local Course ID
CRS.CN
TCH.TN for Elementary Schools
09.09
CRS-Course Name
CRS.CO
TCH.TE for Elementary Schools
09.10
CRS-Course Content Code
CRS.VCL
CRS.VCL values of 01, 02, or 03 will be converted to a
"154" when extracted to CALPADS. Not needed for
Elementary Schools.
See Code Set Education Program Course Content
09.11
CRS-NCLB Core Course
Instructional Level Code
CRS.NCC
TCH.NCC for Elementary Schools
See Code Set NCLB Core Course Indicator and
Instructional Level
09.12
CRS-CTE Technical
Preparation Course Indicator
CRS.TY
Values of 32 &33 will be used for this field. Not needed
for Elementary Schools
09.13
CRS-UC CSU Approved
Indicator
CRS.U1
CSU and UC data will be converted to "Y" or "N" for this
field. Not needed for Elementary Schools, "N" will be
extracted.
09.19
Course Section Instructional
Level Code
CRS.CL
Existing Code Values will be Translated to CALPADS
Codes. Not reported for Elementary Schools.
See Code Set Course Non Standard Instructional Level
Aeries Comment
CALPADS Code Set
Teacher Data
Field#
Name
09.17
Local Staff ID
In Aeries? Tbl.Fld
TCH.ID
Aeries CALPADS Cross Reference by Form
TCH.ID2 and TCH.ID3 can also be used to express
Team teaching or Job Sharing.
7/29/2014
Page 3
Staff
Field#
Name
07.08
SEID
In Aeries? Tbl.Fld
STF.SID
Aeries Comment
CALPADS Code Set
07.09
Local Staff ID
STF.ID
07.10
Staff Legal First Name
STF.FN
07.11
Staff Legal Middle Name
STF.MN
07.12
Staff Legal Last Name
STF.LN
07.13
Staff Alias First Name
STF.FNP
07.14
Staff Alias Middle Name
STF.MNP
07.15
Staff Alias Last Name
STF.LNP
07.16
Staff Birth Date
STF.BD
07.17
Staff Gender Code
STF.SX
07.18
Staff Hispanic Ethnicity
Indicator
STF.ETH
07.19
Staff Ethnicity Missing Indicator
STF.ETH
07.20
Staff Race 1 Code
STF.RC1
See Code Set Race Category
07.21
Staff Race 2 Code
STF.RC2
See Code Set Race Category
07.22
Staff Race 3 Code
STF.RC3
See Code Set Race Category
07.23
Staff Race 4 Code
STF.RC4
See Code Set Race Category
07.24
Staff Race 5 Code
STF.RC5
07.25
Staff Race Missing Indicator
STF.RC#
See Code Set Gender
If Ethnicity field is blank, this field will be flagged
See Code Set Race Category
If all Race fields are blank, this field will be flagged
07.26
Staff Highest Degree Code
STF.EL
See Code Set Degree
07.27
Staff Employment Status Code
STF.PS
See Code Set Employment Status Category
07.28
Staff Employment Start Date
STF.HD
07.29
Staff Employment End Date
STF.LD
07.30
Staff Service Years LEA
STF.TYD
07.31
Staff Service Years Total
STF.TYS
Aeries CALPADS Cross Reference by Form
7/29/2014
Page 4
Staff - Job Assignments
Field#
Name
Aeries Comment
CALPADS Code Set
08.13
Staff Job Classification Code
In Aeries? Tbl.Fld
STJ.JC
Any STF record without a STJ record will not be
extracted for CALPADS.
See Code Set Educational Service Job Classification
08.14
Staff Job Classification FTE
Percentage
STJ.FTE
The percentage of time spent on each job classification
in relation to a full-time position (100%).
08.15
Non Classroom Based Job
Assignment Code 1
STJ.NC1
If Staff Job Classification Code = 10 – Teachor or 11 –
Pupil Services,
Then one or more of the Non Classroom Based Job
Assignment Codes must be populated.
08.16
Non Classroom Based Job
Assignment Code 2
STJ.NC2
See Code Set Non Classroom Based or Support
Assignment
08.17
Non Classroom Based Job
Assignment Code 3
STJ.NC3
See Code Set Non Classroom Based or Support
Assignment
08.18
Non Classroom Based Job
Assignment Code 4
STJ.NC4
See Code Set Non Classroom Based or Support
Assignment
08.19
Non Classroom Based Job
Assignment Code 5
STJ.NC5
See Code Set Non Classroom Based or Support
Assignment
08.20
Non Classroom Based Job
Assignment Code 6
STJ.NC6
See Code Set Non Classroom Based or Support
Assignment
08.21
Non Classroom Based Job
Assignment Code 7
STJ.NC7
See Code Set Non Classroom Based or Support
Assignment
Aeries CALPADS Cross Reference by Form
7/29/2014
See Code Set Non Classroom Based or Support
Assignment
Page 5
Student Data
Field#
Name
01.08
SSID
In Aeries? Tbl.Fld
STU.CID
01.10
Student Legal First Name
STU.FN
01.11
Student Legal Middle Name
STU.MN
01.12
Student Legal Last Name
STU.LN
01.13
Student Legal Name Suffix
Code
STU.SF
01.14
Student Alias First Name
STU.FNA
01.15
Student Alias Middle Name
STU.MNA
01.16
Student Alias Last Name
STU.LNA
01.17
Student Birth Date
STU.BD
Aeries Comment
CALPADS Code Set
See Code Set Name Suffix
01.18
Student Gender Code
STU.SX
01.19
Student Birth City
STU.BCY
01.20
Student Birth State Province
Code
STU.BST
These code values will be translated when extracted
from Aeries.
See Code Set State/Province
01.21
Student Birth Country Code
STU.BCU
These code values will be translated when extracted
from Aeries.
See Code Set Country International Standards
Organization
01.23
Enrollment Start Date
STU.ED
This information will also come from the ENR table if the
district has good ENR data for multiple years. Local
data management practices may need to be adjusted to
treat the School Enter Date as the actual, contiguous
School Enter Date. Attendance Enrollment may need to
be used because of students who return to the current
school after having left.
01.24
Enrollment Status Code
STU.SP
STU.SP values will be translated to these codes.
Optionally a User Code field could be used.
01.25
Grade Level Code
STU.GR
01.26
Enrollment Exit Date
STU.LD
This information will also come from the ENR table is
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
because of students who return to the current school
after having left.
01.28
Student School Completion
Status
STU.HSG
CALPADS Code values for this field differ from how this
field was previously populated for CSIS.
01.31
Student School Transfer Code
STU.IT
01.32
District of Geographic
Residence Code
STU.ITD
02.24
Student Hispanic Ethnicity
Indicator
STU.ETH
Aeries CALPADS Cross Reference by Form
See Code Set Gender
See Code Set Enrollment Status
See Code Set Grade Level
See Code Set School Completion Status
See Code Set Interdistrict Transfer Category
7/29/2014
Page 6
Student Data
Field#
Name
02.25
Student Ethnicity Missing
Indicator
In Aeries? Tbl.Fld
STU.ETH
Aeries Comment
CALPADS Code Set
02.26
Student Race 1 Code
STU.RC1
See Code Set Race Category
02.27
Student Race 2 Code
STU.RC2
See Code Set Race Category
02.28
Student Race 3 Code
STU.RC3
See Code Set Race Category
02.29
Student Race 4 Code
STU.RC4
See Code Set Race Category
02.30
Student Race 5 Code
STU.RC5
See Code Set Race Category
02.31
Student Race Missing Indicator
STU.RC#
If all Race fields are blank, this field will be flagged
02.36
Residential Address Line 1
STU.RAD
STU.AD will be used if STU.RAD is blank.
02.38
Residential Address City Name
STU.RCY
STU.CY will be used if STU.RAD is blank.
02.39
Residential Address State
Province Code
STU.RST
STU.ST will be used if STU.RAD is blank.
02.40
Residential Address Zip Code
STU.RZC
STU.ZC will be used if STU.RAD is blank.
02.50
Parent Guardian Highest
Education Level Code
STU.PED
02.52
Guardian 1 Last Name
STU.PG
12.07
SSID
STU.CID
12.08
Student Legal First Name
STU.FN
12.09
Student Legal Last Name
STU.LN
12.10
Student Birth Date
STU.MN
12.11
Student Gender Code
STU.SX
12.12
Local Student ID
STU.ID
12.13
English Language Acquisition
Status Code
STU.LF
See Code Set English Language Acquisition Status
State
12.15
Primary Language Code
STU.HL
See Code Set Language
If Ethnicity field is blank, this field will be flagged
See Code Set State/Province
See Code Set Highest Education Level
Information Only - Not Required
See Code Set Gender
Student Data - Secondary Student Data - STU4
Field#
Name
02.46
Enrolled in US School less
than Three Cumulative Years
Indicator
In Aeries? Tbl.Fld
SSD.SUS
03.20
Migrant Student ID
SSD.MID
11.13
CTE Pathway Code
CTE.CD
11.14
CTE Pathway Completion
Academic Year ID
CTE.AY
Aeries CALPADS Cross Reference by Form
Aeries Comment
CALPADS Code Set
See Code Set Career Technical Education Pathway
Only extracted on records with the Completed indicator
checked.
7/29/2014
Page 7
Attendance
Field#
Name
01.27
Student Exit Reason Code
In Aeries? Tbl.Fld
ATT.RS
01.29
Expected Receiver School of
Attendance
ATT.NS
Aeries Comment
CALPADS Code Set
May also come from STU.SWR or STU.EOY
See Code Set Student Exit Category
Aeries Comment
CALPADS Code Set
Discipline
Field#
Name
04.13
Disciplinary Incident ID Local
In Aeries? Tbl.Fld
ADS.IID
04.14
Disciplinary Incident
Occurrence Date
ADS.DT
04.15
Student Offense Code
ADS.CD#
Multiple records will be extracted for each Discipline
Code populated in ADS.
See Code Set Student Offense
04.16
Incident Most Severe Offense
Code
ADS
This will be flagged when extracting the ADS.CD field
See Code Set Student Offense
04.17
Weapon Category Code
ADS.WT
See Code Set Weapon Category
04.18
Incident Disciplinary Action
Taken Code
ADS.DS
See Code Set Disciplinary Action Category
04.19
Disciplinary Action Authority
Code
ADS.AA
04.20
Incident Disciplinary Action
Duration Days
ADS.DY
04.21
Student Instructional Support
Indicator
ADS.ISI
New field in ADS
04.22
Expulsion Modification
Category Code
EXP.EMC
New field in EXP
Aeries CALPADS Cross Reference by Form
New field in ADS.
New field in ADS
See Code Set Disciplinary Action Authority
See Code Set Expulsion Modification Category
7/29/2014
Page 8
Special Programs
Field#
Name
03.05
School of Attendance
In Aeries? Tbl.Fld
PGM.SCL
Aeries Comment
CALPADS Code Set
03.13
Education Program Code
PGM.CD
SpEd, NSLP, GATE will be extracted from their specific
tables. GATE can be stored in either PGM or GTE.
See Code Set Education Program
03.14
Education Program
Membership Code
PGM
Fixed for Eligibility and Participation Dates
See Code Set Membership Category
03.15
Education Program
Membership Start Date
PGM.PSD & Eligibility Start Date can also be extracted for certain
ESD
programs
03.16
Education Program
Membership End Date
PGM.PED & Eligibility End Date can also be extracted for certain
EED
programs
03.18
Education Service Code
PGM.SR
03.19
California Partnership
Academy ID
PGM.CPA
03.23
Homeless Dwelling Type Code
PGM.HDT
03.24
Unaccompanied Youth
Indicator
PGM.UY
03.25
Runaway Youth Indicator
PGM.RA
See Code Set Education Service Title I Part A Basic
Language Assessment
Field#
Name
02.45
Student Initial US School
Enrollment Date
LAC.USS
12.14
English Language Acquisition
Status Start Date
LAC.RD1 &
SD & IFD
In Aeries? Tbl.Fld
Aeries Comment
CALPADS Code Set
The Redesignation Date will be used for Redesignated
students, LAC Start Date will be used for EL students
and a new IFEP Date field in LAC will be used for IFEP
students.
Special Education
Field#
Name
01.06
School of Attendance NPS
In Aeries? Tbl.Fld
CSE.SS
03.15.
Education Program
Membership Start Date
CSE.ED
03.21
Primary Disability Code
CSE.DI
03.22
District of Special Education
Accountability
CSE.DR
Aeries CALPADS Cross Reference by Form
Aeries Comment
CALPADS Code Set
Special Education Start Date
See Code Set Disability Category
7/29/2014
Page 9
College Entrance Tests
Field#
Name
01.30
Student Met all UC CSU
Requirements Indicator
In Aeries? Tbl.Fld
Aeries Comment
CALPADS Code Set
Aeries Comment
CALPADS Code Set
STU.CCS &
CUC
Transcripts
Field#
Name
10.16
Student Credits Attempted
HIS.CR
Might also come from GRD or CRS depending on what
data is being extracted
10.17
Student Credits Earned
HIS.CC
Might also come from GRD or CRS depending on what
data is being extracted
10.18
Student Course Final Grade
HIS.MK
Might also come from GRD depending on what data is
being extracted
In Aeries? Tbl.Fld
Course History Institutions
Field#
Name
10.05
School of Course Delivery
In Aeries? Tbl.Fld
CHI.ID
Aeries CALPADS Cross Reference by Form
Aeries Comment
CALPADS Code Set
This information might also come from CHI for HIS
records.
7/29/2014
Page 10

23.10.2014 Ausschuss für Arbeit und Sozialordnung, Familie