S_STU_X (ver 18.8.0)
This table is an extension of the [Students] table. This table is available for all states/provinces and may or may not be utilized for your state/province.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| StudentsDCID | 18.8.0 | Number(10,0) | Primary Key |
| ActiveDutyParent | 19.1.0 | Varchar2(1) | Indicates whether the student has a parent on active duty in the U.S. military (excluding the National Guard) in the past year. |
| BirthCity | 19.11.1.0 | Varchar2(30) | City or town where the student was born. |
| BirthCountry | 19.11.1.0 | Varchar2(30) | Code for the country in which the student was born. This is an Ed-Fi descriptor. |
| BirthCounty | 19.11.1.0 | Varchar2(50) | County where the student was born. |
| BirthState | 19.11.1.0 | Varchar2(50) | The abbreviation for the state/province where the student was born. This is an Ed-Fi descriptor. |
| EconomicDisadvantage | 20.7.2.0 | Varchar2(3) | Indicates if a student is Economically Disadvantaged. The values for the ReportedValue field are seeded for each state or province. |
| EntryDateIntoUSSchool | 19.3.0 | Date | The date the student first enrolled in a US school. |
| ExcludeFromEdFi | 19.11.1.0 | Number(1,0) | Indicates whether to exclude the student from Ed-Fi publishing. |
| ExitCode_Set_Date | 21.4.2.0 | Date | The field value is set with the snapshot date used when the Student Exit Code Mass Population report was run. |
| Home_Language | 20.4.4.0 | Number(11) | The code for the student's home language. |
| Immigrant | 19.1.0 | Varchar2(1) | Indicates whether the student is an immigrant. |
| JobCorps | 19.2.0 | Varchar2(1) | Indicates whether the student is participating in Job Corps. |
| LunchEligibility | 20.7.2.0 | Varchar2(2) | Indicates the criteria used for determining the student's lunch eligibility. The values for this field are seeded by the state/province. |
| MaritalStatus | 20.5.2 | Varchar2(2) | Indicates the student's Marital Status. |
| Native_Language | 20.4.1.0 | Number(11) | Indicates the student's native language. |
| PriorityForService | 18.8.0 | Varchar2(1) | Indicates whether the student meets Priority for Service criteria. |
| RepeatGradeIndicator | 19.11.1.0 | Number(1,0) | Indicates the student repeated the grade from the previous year. |
| ReportedValue | 20.7.2.0 | Varchar2(40) | The reported value. The values for this field are seeded by the state/province. |
| ResidencyStatus | 19.11.1.0 | Varchar2(50) | Indicates the location of legal residence relative to the school attended and its administrative unit. This is an Ed-Fi descriptor. |
| SchoolChoiceTransfer | 19.11.1.0 | Number(1,0) | Indicates the student was transferred to this school as allowed by a School Choice initiative. |
| SealOfBiliteracy | 18.8.3 | Varchar2(20) | Indicates whether the student has earned a Seal of Biliteracy. |
| SingleParent | 19.7.1.0 | Varchar2(1) | Indicates whether the student is a single parent. |
| SteamStemParticipant | 19.8.2.0 | Varchar2(1) | Indicates whether the student participates in a STEAM/STEM program. |
| Suffix | 20.2.2.0 | Varchar2(3) | The student's name suffix. |
| TwentyFirstCenturyServed | 18.8.0 | Varchar2(1) | Indicates whether the student is enrolled in the 21st Century after-school program. |
| VirtualStudent | 19.7.1.0 | Varchar2(1) | Indicates whether the student is a Virtual Student. |
| YouthChallenge | 19.2.0 | Varchar2(1) | Indicates whether the student is participating in Youth ChalleNGe. |
| DeviceType | 21.8.2.0 | Varchar2(10) | This is a part of Student Digital Resource data. The values can be seeded for each state/province. For example, Desktop Computer, Laptop Computer, etc. |
| DeviceAccess | 21.8.2.0 | Varchar2(5) | This is a part of Student Digital Resource data. The values can be seeded for each state/province. For example,
|
| InternetInResidence | 21.8.2.0 | Varchar2(5) | This is a part of Student Digital Resource data. The values can be seeded for each state/province. The valid values are Yes or No. |
| InternetAccess | 21.8.2.0 | Varchar2(5) | This is a part of Student Digital Resource data. The values can be seeded for each state/province. For example, Fiber, Cable DSL, etc. |
| InternetPerformance | 21.8.2.0 | Varchar2(5) | This is a part of Student Digital Resource data. The values can be seeded for each state/province. For example,
|
| Pref_First | 21.9.2.0 | Varchar2(150) | Preferred Student First Name |
| Pref_Middle | 21.9.2.0 | Varchar2(150) | Preferred Student MiddleName |
| Pref_Last | 21.9.2.0 | Varchar2(150) | Preferred Student Last Name |
| Tribal_Affiliation_1 | 21.9.2.0 | Varchar2(5) | Student Tribal Affiliation for CTE code 1 |
| Tribal_Affiliation_2 | 21.9.2.0 | Varchar2(5) | Student Tribal Affiliation for CTE code 2 |
| Tribal_Affiliation_3 | 21.9.2.0 | Varchar2(5) | Student Tribal Affiliation for CTE code 3 |
| Tribal_Affiliation_SIF_1 | 21.9.2.3 | Varchar2(5) | Student Tribal Affiliation for SIF code 1 |
| Tribal_Affiliation_SIF_1 | 21.9.2.3 | Varchar2(5) | Student Tribal Affiliation for SIF code 2 |
| Tribal_Affiliation_SIF_1 | 21.9.2.3 | Varchar2(5) | Student Tribal Affiliation for SIF code 3 |
| County | 22.2.2.0 | Varchar2(3) | Indicates the student's county. |
| Maiden_Name | 22.2.2.0 | Varchar2(30) | Indicates the student's maiden name. |
| Foster_Care | 22.5.3.0 | Boolean | Indicates if student belongs to Foster Care System |
| OnTrackToGraduate | 22.9.2.0 | Varchar2(1) | Indicates whether student is On Track to Graduate |