S_NH_STU_CATE_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. |
| CATE_Include_Flag | 16.11.1 | Number (1,0) | Flag this student for inclusion in CATE Extracts |
| Concentrator | 16.11.1 | Number (1,0) | 1750 Concentrator |
| DisplacedHomemaker | 16.11.1 | Number (1,0) | 160 Displaced Homemaker |
| District_Number_Send | 21.9.2.0 | Varchar2(6) | Override field for [S_NH_STU_X]District_Responsible |
| Graduated_Flag | 16.11.1 | Number (1,0) | 680 GraduatedFlag |
| ProgramCompleter | 16.11.1 | Number (1,0) | 1720 ProgramCompleter |
| SingleParent | 16.11.1 | Number (1,0) | 161 Single Parent |
| Work_Ind | 16.11.1 | Number (1,0) | 141 Work |
| TotalCompetenciesCompleted | 16.11.1 | Number (11,0) | 1755 TotalCompetenciesCompleted |
| Address2 | 16.11.1 | Varchar2(100) | 134 Address2 |
| Enrollment_Status | 16.11.1 | Varchar2(5) | 1700 CATEEnrollmentStatus |
| EntryCode | 16.11.1 | Varchar2(5) | 240 EntryCode |
| ExitCode | 16.11.1 | Varchar2(5 ) | 260 ExitCode |
| Primary_ProgID | 16.11.1 | Varchar2(10) | 1710 PrimaryProgramID |
| Receiving_District_Number | 16.11.1 | Varchar2(6) | 1610 DistNbr Receive |
| Receiving_SAU_Number | 16.11.1 | Varchar2(6) | 1600 SauNbr Receive |
| Receiving_School_Number | 16.11.1 | Varchar2(10) | 1620 SchoolNbr Receive |
| SAU_Number_Send | 16.11.1 | Varchar2(6) | 1500 SauNbr Send |
| School_Number_Send | 16.11.1 | Varchar2(10) | 1520 SchoolNbr Send |
| Tech_Skill_Assessment_Flag | 16.11.1 | Varchar2(5) | 163 TSA FLAG |
| TranMode | 16.11.1 | Varchar2(5) | 1730 TranMode |
| EntryDate | 16.11.1 | Date | 230 EntryDate |
| ExitDate | 16.11.1 | Date | 250 ExitDate |