S_RI_STU_X (ver 14.8.0)
This table is an extension of the [Students] table:
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 14.8.0 | Number(10,0) | Primary Key. |
| ActiveDutyParent | 17.7.0 | VarChar2(1) | Indicates if the student has an active duty parent/guardian in the armed forces. |
| Alt_Assessment_Status | 18.9.0 | VarChar2(1) | Indicates if the student takes the alternate assessment as defined in the student’s IEP. |
| Cell_Phone | 17.1.0 | VarChar2(30) | Student Cell Phone. |
| CTE_Program_Participant | 17.12.0 | Number(1,0) | Indicates if the student is participating in a CTE program. |
| DispHomemaker | 14.9.3 | Number(1,0) | Indicates if the student is identified as a displaced homemaker. |
| 17.1.0 | VarChar2(100) | E-mail of the student. | |
| Enrollment_Type | 17.1.0 | VarChar2(5) | Indicates the student's enrollment type. |
| First_Year_Grade_9 | 17.1.0 | Number(10,0) | The year the student first enrolled in 9th grade. |
| Home_Language | 17.1.0 | VarChar2(8) | Student's language spoken at home. |
| Homeless | 17.1.0 | VarChar2(5) | Indicates the homeless status of the student. |
| Home_School | 20.8.2.0 | VarChar2(10) | Indicates student's home school, if Tuitioned Out is set to Y. |
| IEP_Date | 14.8.0 | Date | Student IEP Date. |
| IEP_Status | 17.1.0 | VarChar2(5) | IEP Status. |
| Immigrant | 17.1.0 | VarChar2(5) | Indicates if the student meets the immigrant criteria. |
| LEP_Monitoring | 17.1.0 | VarChar2(5) | LEP Monitoring Status. |
| LEP_Status | 17.1.0 | VarChar2(5) | Indicates the LEP status of the student. |
| Migrant | 17.1.0 | VarChar2(5) | Indicates the migrant status of the student. |
| Primary_Contact_Phone | 17.1.0 | VarChar2(30) | Phone number of the student's primary contact. |
| Secondary_Contact_Phone | 17.1.0 | VarChar2(30) | Phone number of the student's secondary contact. |
| Section_504 | 17.1.0 | VarChar2(5) | Section 504 Status. |
| SingleParent | 14.9.3 | Number(1,0) | Indicates if the student is a single parent. |
| State_Grade_KGPK | 17.1.0 | VarChar2(4) | Indicates the grade/setting for a preschool or kindergarten student. |
| State_Suffix_Name | 17.1.0 | VarChar2(6) | Student's name suffix. |
| Title_I | 17.1.0 | VarChar2(5) | Indicates a student's Title I status. |
| Tuition | 17.1.0 | VarChar2(5) | Indicates if the student is tuitioned out of district. |
| Tuition_School | 17.1.0 | VarChar2(10) | Identifies the school if the student is marked as Tuitioned Out. |
| Vocational_Ed_Status | 17.1.0 | VarChar2(5) | Indicates if the student is participating in a vocational education program. |
| Vocational_School | 17.1.0 | VarChar2(10) | Identifies the school if the student is marked as a vocational education participant. |