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 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 | 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 Exemption | STU.GEX | 1.35 | Graduation Exemption Indicator | An 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. |