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 |
FAFSA | 24.8.2.0 | Varchar2(50) | Free Application for Federal Student Aide |