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] |