S_ND_STU_X (ver 15.8.0)
This table is an extension of the [STUDENTS] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 15.8.0 | Number(10,0) | Foreign Key |
| Act_Opt_Out | 16.12.1 | Boolean | ACT Opt Out (test will be suppressed on the e-Transcript). |
| AltEd | 15.10.0 | Number(1,0) | Alt Ed. Migrated from [Students.ND_AltEd] |
| AsseDate | 15.10.0 | Date | No longer used by application. This field may still be referenced on reports and/or custom pages. Migrated from [Students.ND_AsseDate]. |
| BIA | 15.10.0 | Number(1,0) | BIE. Migrated from [Students.ND_BIA] |
| Bilingual | 15.10.0 | Varchar2(4) | Bilingual (including native language support). Migrated from [Students.ND_Bilingual] |
| CivicsTest | 15.8.0 | Date | Date Civics Test Passed |
| CohortGradYear | 15.10.0 | Number(11,0) | Four Year Cohort Graduation Class. Migrated from [Students.ND_CohortGradYear] |
| CTBLabelGroup | 15.10.0 | Varchar2(100) | CTB Label Group. Migrated from [Students.ND_CTBLabelGroup] |
| DateOptionalCurriculum | 15.10.0 | Date | Date Approved to Graduate with Optional Curriculum. Migrated from [Students.ND_DateOptionalCurriculum] |
| DeliContentBased | 15.10.0 | Number(1,0) | Delivered in English (SDAIE) Content-based ESL. Migrated from [Students.ND_DeliContentBased]. In version 19.6.2, this field was re-labeled in the UI from "Delivered in English (SDAIE) Content-based ESL" to "NSP – No Support". |
| DevelopBilingual | 15.10.0 | Varchar2(4) | Developmental Bilingual. Migrated from [Students.ND_DevelopBilingual] |
| DirectCert | 15.10.0 | Number(1,0) | Direct Cert. Migrated from [Students.ND_DirectCert] |
| DisplacedHomemaker | 15.10.0 | Number(1,0) | Displaced Homemaker. Migrated from [Students.ND_DisplacedHomemaker] |
| DualLang | 15.10.0 | Varchar2(4) | Dual Language. Migrated from [Students.ND_DualLang] |
| ELLEnrollmentDate | 15.10.0 | Date | ELL Enrollment Date. Migrated from [Students.ND_ELLEnrollmentDate] |
| ELLExitDate | 15.10.0 | Date | ELL Exit Date. Migrated from [Students.ND_ELLExitDate] |
| ELLOther | 15.10.0 | Varchar2(500) | Other - Describe. Migrated from [Students.ND_ELLOther] |
| EnrollELL | 15.10.0 | Number(1,0) | Ernolled in ELL. Migrated from [Students.ND_EnrollELL] |
| FatherActiveDuty | 15.10.0 | Number(1,0) | Father/Guardian 1 Active Duty Military? Migrated from [Students.ND_FatherActiveDuty] |
| FatherLivesOnBase | 15.10.0 | Varchar2(2) | Lives on Base. Migrated from [Students.ND_FatherLivesOnBase] |
| FatherMilitaryBranch | 15.10.0 | Varchar2(2) | Military Branch. Migrated from [Students.ND_FatherMilitaryBranch] |
| FatherPayGrade | 18.10.0 | Varchar2(3) | Military Pay Grade. Migrated from [Students.ND_FatherPayGrade]; Updated in October 2018 to increase length from 2 characters to 3 characters. |
| GraduationDate | 15.8.0 | Date | Graduation Date. |
| HeriLangCode | 15.10.0 | Varchar2(4) | Heritage Language Code. Migrated from [Students.ND_HeriLangCode] |
| HeritageLang | 15.10.0 | Varchar2(4) | Heritage Language Preservation. Migrated from [Students.ND_HeritageLang] |
| ILPDate | 15.10.0 | Date | ILP Date. Migrated from [Students.ND_ILPDate] |
| Immigrant | 15.10.0 | Number(1,0) | Immigrant. Migrated from [Students.ND_Immigrant] |
| LegalFirstName | 15.10.0 | Varchar2(50) | Legal First Name. Migrated from [Students.ND_LegalFirstName] |
| LegalGender | 17.8.0 | Varchar2(50) | Legal Gender |
| LegalLastName | 15.10.0 | Varchar2(50) | Legal Last Name. Migrated from [Students.ND_LegalLastName] |
| LegalMiddleName | 15.10.0 | Varchar2(50) | Legal Middle Name. Migrated from [Students.ND_LegalMiddleName] |
| MixedBilingual | 19.6.2 | Number(1,0) | MBL - Mixed Bilingual EL Program. |
| MotherActiveDuty | 15.10.0 | Number(1,0) | Mother/Guardian 2 Active Duty Military? Migrated from [Students.ND_MotherActiveDuty] |
| MotherLivesOnBase | 15.10.0 | Varchar2(2) | Lives on Base. Migrated from [Students.ND_MotherLivesOnBase] |
| MotherMilitaryBranch | 15.10.0 | Varchar2(2) | Military Branch. Migrated from [Students.ND_MotherMilitaryBranch] |
| MotherPayGrade | 18.10.0 | Varchar2(3) | Military Pay Grade. Migrated from [Students.ND_MotherPayGrade]; Updated in October 2018 to increase length from 2 characters to 3 characters. |
| NewcomerProgram | 19.2.0 | Number(1,0) | Indicator that the student is a participant in the EL Newcomer Program. Removed from the UI as obsolete in version 19.6.2. |
| NightTimeRes | 16.12.2 | Varchar2(2) | Primary Night Time Residence. Obsolete as of version 20.4.4; migrated to S_ND_STU_HomelessPrograms_C. |
| OriginCountryCode | 16.3.2 | Varchar2(4) | Origin Country Code. Migrated from [Students.ND_OriginCountryCode] Datatype changed from Number(11,0) to Varchar2(4) March 25, 2016 Release 16.3.2 |
| OtherBiligual | 15.10.0 | Varchar2(500) | Other Bilingual - Describe. Migrated from [Students.ND_OtherBiligual]. Removed from the UI as obsolete in version 19.6.2. |
| OtherESL | 15.10.0 | Varchar2(500) | Other ESL - Describe. Migrated from [Students.ND_OtherESL]. Removed from the UI as obsolete in version 19.6.2. |
| ParentRefused | 15.10.0 | Number(1,0) | Parent Refused ELL Services. Migrated from [Students.ND_ParentRefused] |
| ParentRefusedELATest | 17.9.0 | Boolean | Parent Refused EL Access Testing. |
| ProgramSectionCode | 15.10.0 | Varchar2(5) | Program Section Code. Migrated from [Students.ND_ProgramSectionCode] |
| Publications | 15.10.0 | Number(1,0) | School publications and Internet (info cannot be released). Migrated from [Students.ND_Publications] |
| PullOutESL | 15.10.0 | Number(1,0) | Pull-out ESL. Migrated from [Students.ND_PullOutESL]. In version 19.6.2, this field was re-labeled in the UI from "Pull-out ESL" to "ELO – EL Instruction in English". |
| ReceivedGED | 15.10.0 | Number(1,0) | Received GED. Migrated from [Students.ND_ReceivedGED] |
| Recruiters | 15.10.0 | Number(1,0) | Military Recruiters (info cannot be released). Migrated from [Students.ND_Recruiters] |
| Refugee | 15.10.0 | Number(1,0) | Refugee. Migrated from [Students.ND_Refugee] |
| RequestsNoservices | 16.12.2 | Boolean | Family Requests No Services. Obsolete as of version 20.4.4; migrated to S_ND_STU_HomelessPrograms_C. |
| Section504 | 15.10.0 | Number(1,0) | Section 504. Migrated from [Students.ND_Section504] |
| SendToTienet | 15.10.0 | Number(1,0) | Send to Tienet. Migrated from [Students.ND_SendToTienet] |
| ServingSpecialEdUnit | 15.10.0 | Varchar2(5) | Special Ed - Serving Spec Ed Unit. Migrated from [Students.ND_ServingSpecialEdUnit] |
| ShelteredEng | 15.10.0 | Number(1,0) | Sheltered English Instruction. Migrated from [Students.ND_ShelteredEng]. In version 19.6.2, this field was re-labeled in the UI from "Sheltered English Instruction" to "CBL – Content-Based EL". |
| Slife | 17.8.0 | Boolean | Students with Limited or Interrupted Formal Education |
| SpecDesignAcaIns | 15.10.0 | Number(1,0) | Specially Designed Academic Instruction. Migrated from [Students.ND_SpecDesignAcaIns]. In version 19.6.2, this field was re-labeled in the UI from "Specially Designed Academic Instruction" to "NEW – Newcomer". |
| StructEng | 15.10.0 | Number(1,0) | Structured English Immersion. Migrated from [Students.ND_StructEng]. In version 19.6.2, this field was re-labeled in the UI from "Structured English Immersion" to "EBL – EL Bilingual". |
| StudentWithChild | 15.10.0 | Number(1,0) | Student with Child. Migrated from [Students.ND_StudentWithChild] |
| Suffix | 15.10.0 | Varchar2(4) | Suffix. Migrated from [Students.ND_Suffix] |
| TeacLiceNum | 15.10.0 | Varchar2(9) | Teacher License Number. Migrated from [Students.ND_TeacLiceNum] |
| TotalHSUnits | 15.10.0 | Number(25,10) | HS Units. Migrated from [Students.ND_TotalHSUnits] |
| TransisBilingual | 15.10.0 | Varchar2(4) | Transitional Bilingual. Migrated from [Students.ND_TransisBilingual] |
| TwentyFirstCentury | 15.10.0 | Number(1,0) | 21st Century. Migrated from [Students.ND_21stcentury] |
| TwowayBilingual | 15.10.0 | Varchar2(4) | Two-Way Bilingual Immersion. Migrated from [Students.ND_TwowayBilingual] |
| Unaccompanied | 16.12.2 | Boolean | Unaccompanied Youth Indicator. Obsolete as of version 20.4.4; migrated to S_ND_STU_HomelessPrograms_C. |
| Universities | 15.10.0 | Number(1,0) | ND Universities (info cannot be released). Migrated from [Students.ND_Universities] |
| USEntryDate | 15.10.0 | Date | US Entry Date. Migrated from [Students.ND_USEntryDate] |
| XferFromCity | 15.10.0 | Varchar2(30) | Transfer from City. Migrated from [Students.ND_XferFromCity] |
| XferFromSchool | 19.2.0 | Varchar2(100) | Transfer from School. Migrated from [Students.ND_XferFromSchool]; Updated in February 2019 to increase length from 30 characters to 100 characters. |
| XferFromState | 15.10.0 | Varchar2(2) | Transfer from State. Migrated from [Students.ND_XferFromState] |
| XferToCity | 15.10.0 | Varchar2(30) | Transfer to City. Migrated from [Students.ND_XferToCity] |
| XferToSchool | 19.2.0 | Varchar2(100) | Transfer to School. Migrated from [Students.ND_XferToSchool]; Updated in February 2019 to increase length from 30 characters to 100 characters. |
| XferToState | 15.10.0 | Varchar2(2) | Transfer to City. Migrated from [Students.ND_XferToState] |
YouthRisk | 15.10.0 | Number(1,0) | Youth Risk Behavior Survey (info cannot be released). Migrated from [Students.ND_YouthRisk] |