S_OR_STU_X (ver 14.4.0)
This table is an extension of the [Students] table. These fields are for general use.
Column Name | Version | Data Type | Description |
---|---|---|---|
StudentsDCID | 14.4.0 | Number(10,0) | Primary key that relates the extended table back to the Students table. |
AltEdProgFg | 15.10.3 | Number(1,0) | Indicates that the student has been placed by the district in an Alternative Education Program(s). Migrated from [Students.OR_AltEdProgFg]. |
AmerIndianTrbEnrlmntNbr | 15.10.3 | Varchar2(11) | Identifier indicating the student's Native American tribal membership. Migrated from [Students.OR_AmerIndianTrbEnrlmntNbr]. |
AmerIndianTrbMbrshpCd | 15.10.3 | Varchar2(3) | Indicates a student having membership in any Federally recognized tribe. Migrated from [Students.OR_AmerIndianTrbMbrshpCd]. |
AttndDistInstID | 15.10.3 | Number(11,0) | ODE assigned Institution Identifier for the Attending District. The District where the student is receiving instruction and where state assessments are administered. Migrated from [Students.OR_AttndDistInstID]. |
AttndSchlInstID | 15.10.3 | Number(11,0) | ODE assigned Institution Identifier for the Attending School. The School where the student is receiving instruction and where state assessments are administered. Migrated from [Students.OR_AttndSchlInstID]. |
BornOutsideUS | 14.4.0 | Number(1,0) | Indicates that student was NOT born in any state (or Puerto Rico). |
DemogFill | 15.10.3 | Varchar2(100) | Demographic Filler. Migrated from [Students.OR_DemogFill]. |
DstncLrnFg | 15.10.3 | Number(1,0) | Indicates student participation in a distance learning program or a program that includes online coursework. Migrated from [Students.OR_DstncLrnFg]. |
EconDsvntg | 15.10.3 | Number(1,0) | Indicates student eligibility for a Free or Reduced Lunch program. Migrated from [Students.OR_EconDsvntg]. |
EnrlGrdCd | 15.10.3 | Varchar2(2) | Code indicating the enrolled grade level of the student; or a grade level assigned to an ungraded student based on student age. Migrated from [Students.OR_EnrlGrdCd]. |
Fill | 15.10.3 | Varchar2(100) | Student Filler. Migrated from [Students.OR_Fill]. |
GenerationCd | 15.10.3 | Varchar2(4) | Name suffix of the student (i.e. Jr., II, III). Migrated from [Students.OR_GnrtnCd]. |
HomeSchlFg | 15.10.3 | Number(1,0) | Indicates that the student is registered to receive homeschool instruction. Migrated from [Students.OR_HomeSchlFg]. |
HSEntrySchlYr | 15.10.3 | Varchar2(4) | School year the student entered high school in the format XXYY. (i.e. 0809 for the 2008-2009 school year). Migrated from [Students.OR_HSEntrySchlYr]. |
IndianEdFg | 15.10.3 | Number(1,0) | Indicates student participation in a program designed to meet the unique educational and culturally related academic needs of American Indians. Migrated from [Students.OR_IndEdFg]. |
InstFill | 15.10.3 | Varchar2(100) | Institution Filler. Migrated from [Students.OR_InstFill]. |
LEPFg | 15.10.3 | Number(1,0) | Indicates a child who is Limited English Proficient. Migrated from [Students.OR_LEPFg]. Note: Renamed to ELFg as of 19.7.1.0 |
LT_3_YearsUSSch | 14.4.0 | Number(1,0) | Indicates that student has NOT been attending one or more schools in any one or more state for more than three full academic years. |
MigrntEdFg | 15.10.3 | Number(1,0) | Indicates student participation in a program designed to assure that migratory children receive full and appropriate opportunity to meet the state academic content and student academic achievement standards. Migrated from [Students.OR_MigrntEdFg]. |
Preferred_FNm | 15.10.3 | Varchar2(40) | Preferred first name of the student. Migrated from [Students.OR_PrfrdFNm]. |
Preferred_LNm | 15.10.3 | Varchar2(50) | Preferred last name of the student. Migrated from [Students.OR_PrfrdLNm]. |
Preferred_MNm | 15.10.3 | Varchar2(40) | Preferred middle name of the student. Migrated from [Students.OR_PrfrdMNm]. |
ResdCnty | 15.10.3 | Varchar2(2) | Code indicating the county of legal residence of the student's parent or legal guardian or the county of residence of an emancipated minor student. Migrated from [Students.OR_ADMResdCnty]. |
ResdDistInstID | 15.10.3 | Number(11,0) | ODE assigned Institution Identifier for the Resident District. The District responsible for the education of the student and also is the basis on which the State School Fund, the Common School Fund, and the County School Fund are distributed to local districts. Migrated from [Students.OR_ResdDistInstID]. |
ResdSchlInstID | 15.10.3 | Number(11,0) | ODE assigned Institution Identifier for the Resident School. The School responsible for the education of the student and also is the basis on which the State School Fund, the Common School Fund, and the County School Fund are distributed to local districts. Migrated from [Students.OR_ResdSchlInstID]. |
Sect504Fg | 15.10.3 | Number(1,0) | Indicates student eligibility for Section 504 services. Migrated from [Students.OR_Sect504Fg]. |
SpEdFg | 15.10.3 | Number(1,0) | Indicates student participation in an Individualized Education Plan (IEP/IFSP). Migrated from [Students.OR_SpEdFg]. |
state_excludeenrollment | 15.10.3 | Number(1,0) | Indicates exclusion of enrollment from specific reporting. Migrated from [Students.state_excludeenrollment]. |
StuDeclDirServ | 15.10.3 | Number(1,0) | Indicates if student declined directory services. Migrated from [Students.OR_StuDeclDirServ]. |
TAGAcdmTlnt_MathFg | 15.10.3 | Number(1,0) | Indicates that the student scored at or above the 97th percentile on a standardized test of total mathematics. Migrated from [Students.OR_TAGAcdmTlntMaFg]. |
TAGAcdmTlnt_ReadFg | 15.10.3 | Number(1,0) | Indicates that the student scored at or above the 97th percentile on a standardized test of total reading. Migrated from [Students.OR_TAGAcdmTlntRdFg]. |
TAGCrtvAbltyFg | 15.10.3 | Number(1,0) | Indicates that the student demonstrated original or nontraditional methods in thinking and producing. Migrated from [Students.OR_TAGCrtvAbltyFg]. |
TAGIntlctGiftFg | 15.10.3 | Number(1,0) | Indicates that the student scored at or above the 97th percentile on a nationally standardized test of mental ability. Migrated from [Students.OR_TAGIntlctGiftFg]. |
TAGLdrshpAbltyFg | 15.10.3 | Number(1,0) | Indicates that the student demonstrated ability in motivating the performance of others either in educational or non-educational settings. Migrated from [Students.OR_TAGLdrshpAbltyFg]. |
TAGPotentialFg | 15.10.3 | Number(1,0) | Indicates that the student demonstrated the potential to perform at the 97th percentile. Migrated from [Students.OR_TAGPtntTAGFg]. |
TAGPrfmArtsAbltyFg | 15.10.3 | Number(1,0) | Indicates that the student demonstrated ability in dance, music or art. Migrated from [Students.OR_TAGPrfmArtsAbltyFg]. |
TchrFill | 15.10.3 | Varchar2(100) | Teacher Filler. Migrated from [Students.OR_TchrFill]. |
Title1Fg | 15.10.3 | Number(1,0) | Indicates the student is being served in a Title I Targeted Assisted School (TAS). Does NOT include students served in a Title I School Wide Program (SWP). Migrated from [Students.OR_TAGTitle1Fg]. |
TrnstnProgFg | 15.10.3 | Number(1,0) | Indicates a Special Education student of high school or post high school age (up through the age of 21) who has not graduated with a regular diploma and are not working towards a regular or modified diploma. Migrated from [Students.OR_TrnstnProgFg]. |