S_STU_EDFI_X (ver 17.4.0)
This table is an extension of the Students table and used in conjunction with Ed-Fi related functionality. This table is available for all states and provinces and might or might not be utilized for your state or province.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 17.4.0 | Number(10,0) | Primary Key |
BirthCity | 17.4.0 | Varchar2(30) | City or town where student was born. |
BirthCountry | 17.4.0 | Varchar2(30) | Code for the country in which student was born. |
BirthState | 17.4.0 | Varchar2(2) | The 2-character abbreviation for the state/province where the student was born. |
| ExcludeFromEdFi | 18.12.0 | Boolean | Indicates whether to exclude students from Ed-Fi publishing. |
GenerationCodeSuffix | 17.4.0 | Varchar2(10) | Denotes an individual's generation in their family, e.g. Jr., Sr., III. |
PersonalTitlePrefix | 17.4.0 | Varchar2(30) | A prefix used to denote the title, degree, position, or seniority of the person. |
RepeatGradeIndicator | 17.4.0 | Number(1,0) | Indicates the student repeated the grade from the previous year. |
ResidencyStatus | 17.4.0 | Varchar2(30) | Indicates location of legal residence relative to school attended and its administrative unit. |
SchoolChoiceTransfer | 17.4.0 | Number(1,0) | Indicates the student was transferred to this school as allowed by a School Choice initiative. |