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
Aeries will extract the Mailing Address if it is the only one populated.
Residence Address will be extracted if it is populated. Changes to the addresses will also be extracted in the SINF file with start and end dates. To upload the Mailing Address, the SIAD file can be created on the Create CALPADS Extract form. SIAD Extract tab.
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.TD
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
Even though there are additional CALPADS fields for Guardian 1 & 2 Last & First Names, this is the only field in this optional group being extracted from Aeries.
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
Local codes should include "Secondary Enrollment" for students concurrently enrolled in a second school. A code for "5th Yr CAHSEE" should also be used for students who completed all other graduation requirements except the CAHSEE and who have returned to receive additional CAHSEE instruction. 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 Language This 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
01.27
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.26
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.29
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.27
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.29
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.28
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 valu