S_NH_STU_X (ver 16.11.1)
This table is an extension of the [Students] table
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 16.11.1 | Number (10,0) | Primary Key |
Accommodations | 24.4.2.0 | Number (1,0) | Accommodations for the student are needed (yes, no). |
AssessmentGrouping | 16.11.1 | Varchar2(30) | Assessment grouping |
Assessment_ID | 18.2.0 | Varchar2(20) | Identifies the State provided ID for the assessment record |
Country_Of_Birth | 18.1.0 | Varchar2(4) | A students country of birth |
DiplomaType | 16.11.1 | Varchar2(1) | Diploma type |
District_Responsible | 16.11.1 | Varchar2(1) | District responsible |
DLMEligible | 24.4.2.0 | Number (1,0) | Indicator that student will take DLM assessment. |
EnrollmentStatus | 16.11.1 | Varchar2(5) | Enrollment status |
FandRIndicator | 16.11.1 | Varchar2(1) | Free or reduced lunch indicator |
First_Entered_US_Schools | 18.1.0 | Date | The month, day, year the student entered a US school for the first time |
FullDayPct | 16.11.1 | Number (11,0) | Full day percent |
Home_Schooled | 16.8.1 | Varchar2(1) | Home Schooled |
Homeless_Code | 16.11.1 | Varchar2(1) | Homeless code |
i4SEE_Include_Flag | 16.11.1 | Number (1,0) | Indicates if the student should be included in the i.4.see Submissions |
i4See_Enrollment_Status | 24.12.2.0 | Varchar2(5) | Enrollment Status. |
i4See_Entry_Code | 24.12.2.0 | Varchar2(5) | Entry Code. |
i4See_Exit_Code | 24.12.2.0 | Varchar2(5) | Exit Code. |
LASID | 16.11.1 | Varchar2(1) | Local student ID |
Long_First_Name | 17.2.0 | Varchar2(200) | Student's long first name |
Long_Last_Name | 17.2.0 | Varchar2(200) | Student's long last name |
Long_Middle_Name | 17.2.0 | Varchar2(200) | Student's long middle name |
NotPromoted | 16.11.1 | Number (1,0) | A3 - Not Promoted |
NotPromotedTwice | 16.11.1 | Number (1,0) | A3 - Not Promoted 2nd Time |
OrigGradYear | 16.11.1 | Number (11,0) | Original graduation year |
Parent_Military_Status | 18.3.0 | Varchar2 (2) | This field indicates the student's parent or guardian military status. |
PostGradPlans | 16.11.1 | Varchar2(1) | Post graduation plans |
Promoted_Indicator | 16.11.1 | Varchar2(1) | Promoted Indicator |
ResidentialHome | 16.11.1 | Varchar2(1) | Residential Home |
School_Number_Override | 20.1.2.0 | Varchar2(5) | School Number override |
SPEDISId | 16.11.1 | Varchar2(1) | SPEDIS ID |
State_Scholars_Include_Flag | 16.11.1 | Number (1,0) | Flags the student for inclusion in State Scholars Program |
State_ExcludeEnrollment | 16.11.1 | Number (1,0) | Exclude the current enrollment from State Reporting |
State_GradeLevel | 17.2.0 | Varchar2(6) | Grade level |
Suffix | 16.11.1 | Varchar2(1) | Suffix |
Test_School_Override | 24.4.2.0 | Varchar2(5) | School number to override the test center. |
TownOfBirth | 16.11.1 | Varchar2(1) | Student's town of birth |
Town_Responsible | 16.11.1 | Varchar2(1) | Town responsible |
TuitionCharged | 17.2.0 | Varchar2(50) | Tuition Charged |
Virtual_Inst_Pct_Override | 21.5.3.0 | Number (11,0) | Virtual Instruction Percent Override |
Withdrawal_Type_Summer_Exit | 24.8.1.0 | Varchar2(1) | Withdrawal Type for Summer Exits. |