S_TN_STU_X (ver 15.4.0)
This table is an extension of the Students (1) table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 15.4.0 | Number(10,0) | Primary Key. |
| DateFirstEnrolledInESLProgram | 15.7.0 | Date | Date First Enrolled In ESL Program. |
| SESApplied_YN | 15.6.1 | Varchar2(1) | SES Applied Indicator. |
| SESReceiving_YN | 15.6.1 | Varchar2(1) | SES Receiving Indicator. |
| UngradedStudent_YN | 15.4.0 | Varchar2(1) | Ungraded Student Flag on ReEnrollments for use with CRDC. |
| UniqueEdFiPersonID | 16.11.0 | Varchar2(32) | Unique Ed-Fi Person ID - Not yet implemented for Ed-Fi use. |
| CityOfBirth | 16.8.0 | Varchar2(30) | City of Birth Migrated from Students. [TN_CityOfBirth]. |
| Completion | 16.8.0 | Varchar2(2) | Completion. Migrated from Students. [TN_Completion]. |
| CompletionDate | 16.8.0 | Date | Completion Date. Migrated from Students. [TN_CompletionDate]. |
| CountryBirthCode | 16.8.0 | Varchar2(2) | Country of Birth. Migrated from Students. [TN_CountryBirthCode]. |
| CountyBirthCode | 16.8.0 | Varchar2(3) | County of Birth. Migrated from Students. [TN_CountyBirthCode]. |
| CourseOfStudy | 16.8.0 | Varchar2(1) | Course of Study. Migrated from Students. [TN_CourseOfStudy]. |
| DateFirstEnrolledInUSSchool | 16.8.0 | Date | Date First Enrolled In US School. Migrated from Students. [TN_DateFirstEnrolledInUSSchool]. |
| ELB | 16.8.0 | Varchar2(1) | English Language Background. Migrated from Students.[ TN_ELB]. |
| EndOfServiceAction | 16.8.0 | Varchar2(1) | End Of Service Action. Migrated from Students.[TN_EndOfServiceAction]. |
| FRE | 16.8.0 | Varchar2(11) | Federal Race and Ethnicity. Migrated from [Students.TN_FRE]. |
| FundIneligBeginDate | 16.8.0 | Date | Funding Ineligibility Begin Date. Migrated from [Students.TN_FundIneligBeginDate]. |
| FundIneligEndDate | 16.8.0 | Date | Funding Ineligibility End Date. Migrated from [Students.TN_FundIneligEndDate]. |
| FundIneligStatus | 16.8.0 | Number(10,0) | Funding Ineligibility Status. Migrated from Students. [TN_FundIneligStatus]. |
| GraduationPeriod | 16.8.0 | Number(10,0) | Graduation Period. Migrated from Students. [TN_GraduationPeriod]. |
| HomelessPrimaryNightTimeRes | 16.8.0 | Varchar2(2) | Homeless Primary Night Time Res. Migrated from Students. [TN_HomelessPrimaryNightTimeRe]. |
| HomelessServedByMcKinney | 16.8.0 | Varchar2(1) | Homeless Served By McKinney. Migrated from Students. [TN_HomelessServedByMcKinney]. |
| HomelessUnaccompaniedYouth | 16.8.0 | Varchar2(1) | Homeless Unaccompanied Youth. Migrated from Students. [TN_HomelessUnaccompaniedYouth]. |
| ISPToS | 16.8.0 | Varchar2(1) | Instructional Service Primary Type of Service. Migrated from Students. [TN_ISPToS]. |
| ImmigrantStudent | 16.8.0 | Varchar2(1) | Immigrant Student. Migrated from Students. [TN_ImmigrantStudent]. |
| MothersMaidenName | 16.8.0 | Varchar2(25) | Mothers Maiden Name. Migrated from Students. [TN_MothersMaidenName]. |
| NativeLanguage | 16.8.0 | Varchar2(3) | Native Language. Migrated from Students.[TN_NativeLanguage]. |
| PrevFirstName | 16.8.0 | Varchar2(25) | Previous First Name. Migrated from Students. [TN_PrevFirstName]. |
| PrevLastName | 16.8.0 | Varchar2(35) | PrevLastName. Migrated from Students.[TN_PrevLastName]. |
| PrevMiddleName | 16.8.0 | Varchar2(25) | Previous Middle Name. Migrated from Students.[TN_PrevMiddleName]. |
| PrevSSN | 16.8.0 | Varchar2(11) | Previous SSN. Migrated from Students.[TN_PrevSSN]. |
| PrimarySchoolID | 16.8.0 | Number(10,0) | Primary School ID. Migrated from Students.[TN_PrimarySchoolID]. |
| SchoolChoiceApplied | 16.8.0 | Varchar2(1) | School Choice Applied. Migrated from Students.[TN_SchoolChoiceApplied]. |
| StateBirthCode | 16.8.0 | Varchar2(2) | State Birth Code. Migrated from Students.[TN_StateBirthCode]. |
| StudentPIN | 16.8.0 | Varchar2(9) | Student PIN Migrated from Students. [TN_StudentPIN]. |
| StudentStandardDay | 16.8.0 | Number(10,0) | Student Standard Day. Migrated from Students.[TN_StudentStandardDay]. |
| TransitionalGrade | 16.8.0 | Number(1,0) | Transitional Grade. Migrated from Students.[TN_TransitionalGrade]. |
| YearEnteredNinthGrade | 16.8.0 | Number(10,0) | Year Entered Ninth Grade. Migrated from Students. [TN_YearEnteredNinthGrade]. |
| PrevStudentID | 16.8.0 | Varchar2(9) | Previous Student ID. Migrated from Students. [TN_PrevStudentID]. |
| NameSuffix | 16.12.5 | Varchar2(10) | Student Suffix. |
| HomeLanguage | 16.12.6 | Varchar2(3) | Home Language. |