Student Data

 

Accessed from the navigation tree Student Data, Demographics.  The Demographics page has 2 tabs:

Student Data 1 and Student Data 2.


Student Data 1




Aeries Field Name
Aeries Table.Field

CALPADS

FldNum

CALPADS Name

Comment

Last Name
STU.LN
01.12
Student Last Name


First Name
STU.FN
01.10
Student First Name

Middle Name
STU.MN
01.11
Student Middle Name

Suffix
STU.SF
01.13
Student Legal Name Suffix Code
CALPADS Code Set: Name Suffix
Sex
STU.SX
01.18
Student Gender Code
CALPADS Code Set: Gender
Grade
STU.GR
01.25
Grade Level Code
CALPADS Code Set: Grade Level
Birthdate
STU.BD
01.17
Student Birth Date

Last Name Alias
STU.LNA
01.16
Student Alias Last Name

First Name Alias
STU.FNA
01.14
Student Alias First Name

Middle Name Alias
STU.MNA
01.15
Student Alias Middle Name



Legal Last Name
LSI.LLN
01.12
Student Legal Last Name
The Legal Student Information fields are available to populate. If populated the CALPADS extracts will pull from the Legal Student Information fields. Refer to the following link for more information:
 
Legal_Student_Information.pdf
Legal First Name
LSI.LFN
01.10
Student Legal First Name
Legal Middle Name
LSI.LMN
01.11
Student Legal Middle Name
Legal Gender
LSI.GN
01.18

Student Legal Gender

 


Aeries Field Name
Aeries Table.Field
CALPADS
FldNum
CALPADS Name
Comment
Mailing Address
STU.AD
02.36
Residential Address Line 1
Per direction from CALPADS and the CDE, Aeries will always extract the Mailing Address for students. Changes to the addresses will also be extracted in the SINF file with start and end dates.

Eventually the SINF file will be changed to allow extracting both the residential and mailing addresses. 
Mailing City
STU.CY
02.38
Residential Address City Name
Mailing State
STU.ST
02.39
Residential Address State Province Code
Mailing Zip Code
STU.ZC
02.40
Residential Address Zip Code




Aeries Field Name
Aeries Table.Field

CALPADS

FldNum

CALPADS Name

Comment

Inter/Intra District Transfer
STU.IT
01.31
Student School Transfer Code
Codes used locally may be different than the CALPADS codes. Make sure your Aeries codes do not conflict with the CALPADS Codes. Your local codes can match the CALPADS Codes, but you will probably have additional codes for "Intra-District Transfers" or you might break down Inter-District Transfers more than CALPADS. Local codes can be translated to a "Blank" during the CALPADS Extract process. CALPADS Code Set: Student School Transfer Code
District of Residence
STU.ITD
01.32
District of Geographic Residence
This should correspond to the district the student physically resides in. It will only be extracted if the STU.IT field is populated with (or translated to) a valid CALPADS Code.



Aeries Field Name
Aeries Table.Field

CALPADS

FldNum

CALPADS Name

Comment

Parent/Guardian
STU.PG
02.52
Guardian 1 Last Name
If the setting under CALPADS Extracts > Other Options is selected to take the Guardian Information from STU.PG, then the data here will be extracted to the Guardian1 Last Name field on the SINF extract.
(See Managing Contacts-Identify Guardians)
Parent Ed Level
STU.PED
02.50
Parent Guardian Highest Ed Level Code
This field was recently changed to be a 2- character field and so it can now accommodate the state-standard code values. Adjust the COD table if you would like to use the CALPADS Code values. If you keep the old code values, they can be translated to the CALPADS codes during the extract process. CALPADS Code Set: Highest Education Level
Attendance Program
STU.SP
01.24
Enrollment Status Code
Primary Enrollment Status, secondary enrollment, short term enrollment, Non ADA code. Local codes should include "Secondary Enrollment" for students concurrently enrolled in a second school. CALPADS Code Set: Enrollment Status
School Enter Date
STU.ED
01.23
Enrollment Start Date
The enrollment start date is pulled from the students ENR records. The STU.ED date should represent the date the student started in the current school. It should NOT be updated to the beginning of the current year. It should be changed any time a student moves to a new school or returns from a different school.
District Enter Date
STU.DD


The STU.DD date should represent the date the student started in the School District. Used to determine if a student is new to the district for the current year.




Aeries Field Name
Aeries Table.Field
CALPADS
FldNum
CALPADS Name
Comment
Reporting Language
STU.HL
12.15
Reporting LanguageThis field should be a composite value from the Home Language Survey.
CALPADS Code Set: Language
Language Fluency
STU.LF
12.13
English Language Acquisition Status Code
Use whatever codes locally that you want. The CALPADS codes are too long to be used in Aeries. We recommend having codes for "To Be Determined" and "English-Only" so that this field can be set a Required field. You will need to configure the translations for this field on the Create CALPADS Extracts form.
CALPADS Code Set: English Language Acquisition Status State
Ethnicity
STU.ETH
02.24
Student Hispanic Ethnicity Indicator
We recommend creating an additional code for "Declined to State/Unknown". This code, along with blank values will be translated to a value in the "Missing Indicator" field when extracted to CALPADS.
Ethnicity
STU.ETH
02.25
Student Ethnicity Missing Indicator
Race 1
STU.RC1
02.26
Student Race 1 Code
We recommend creating an additional code for "Declined to State/Unknown". This code, along with blank values will be translated to a value in the "Missing Indicator" field when extracted to CALPADS.
Race 2
STU.RC2
02.27
Student Race 2 Code
Race 3
STU.RC3
02.28
Student Race 3 Code
Race 4
STU.RC4
02.29
Student Race 4 Code
Race 5
STU.RC5
02.30
Student Race 5 Code

STU.RC#
02.31
Student Race Missing Indicator



Aeries Field Name
Aeries Table.Field

CALPADS

FldNum

CALPADS Name

Comment

Birth City
STU.BCY
01.19
Student Birth City

Birth State
STU.BST
01.20
Student Birth State Province Code
CALPADS uses a different code set than CSIS previously used. Aeries still uses the old code values, but will automatically convert these values to the CALPADS code values when extracted.
CALPADS Code Set: State/Province
Birth Country
STU.BCU
01.21
Student Birth Country Code
CALPADS Code Set: Country International Standards Organization


Student Data 2




Aeries Field Name
Aeries Table.Field

CALPADS

FldNum

CALPADS Name

Comment

Reporting Home School
STU.HS


This field can be used in certain situations to have the CALPADS extract report the student as if they were enrolled in the school populated in this field. This should NOT be used on concurrently enrolled students. It should ONLY be used in a "virtual" school where the students need to be reported as if they were enrolled at their home school.
When populated, will be pulled into the ATT and ENR tables
State Student ID
STU.CID
01.08
SSID




 

Aeries Field Name
Aeries Table.Field

CALPADS

FldNum

CALPADS Name

Comment

Summer Withdrawal Reason
STU.SWR
1.26
Student Exit Reason Code
If the student left during the summer, before school started, you can populate this field to report that student as a Summer No Show with the appropriate Exit Reason.
Summer Withdrawal Leave Date
STU.SLD
1.25
Student School Exit Date
If the student left during the summer, before school started, you can populate this field to report that student as a Summer No Show with the appropriate Leave Date.
Summer Withdrawal Next School
STU.SNS
1.28
Expected Receiver School of Attendance
All records with an Exit Reason of "165" (Involuntary Transfer for Discipline) or an Exit Reason of "160" from an Alternative Ed School must have a SWR Next School
populated. This drop-down comes from the CHI (Course History institutions) Table where the full CDS code should be populated.
End of Year Status
STU.EOY
1.26
Student Exit Reason Code
Students who leave a school at the end of a school year should be populated with an EOY value of the correct Exit Reason.
End of Year Next School
STU.ENS
1.28
Expected Receiver School of Attendance
All records with an Exit Reason of "165" (Involuntary Transfer for Discipline) or an Exit Reason of "160" from an Alternative Ed School must have an EOY Next School
populated. This drop-down comes from the CHI Table where the full CDS code should be populated.
Graduation Status
STU.HSG
1.27
Student School Completion Status
All students completing the highest grade level of a school must have a value in this field. That includes elementary and middle school students who complete the school and matriculate to the next school. These students do not need an EOY value
Graduation ExemptionSTU.GEX1.35Graduation Exemption IndicatorAn indication of whether a graduating high school student was exempted from local graduation requirements but has completed all state graduation requirements for a standard high school diploma. A “Y” would indicate the student was exempted; an “N” would indicate the student was not exempted from local graduation requirements.