S_NC_Lottery (ver 13.6.0)
This table is a stand alone table and stores ........
Column Name | Version | Data Type | Description |
|---|---|---|---|
| APPLICATION_DATE | 13.6.0 | DATE | The date the application was submitted. |
| ASSIGNED_SCHOOL | 13.6.0 | NUMBER(11,0) | The school the student was assigned. |
| CATCHMENT | 13.6.0 | VARCHAR2(16) | |
| CATCHMENT_CODE | 13.6.0 | VARCHAR2(16) | |
| CATCHMENT_SCHOOL | 13.6.0 | VARCHAR2(22) | |
| CHOICE_SCHOOL_1 | 13.6.0 | NUMBER(11,0) | The student's first school choice. |
| CHOICE_SCHOOL_2 | 13.6.0 | NUMBER(11,0) | The student's second school choice. |
| CHOICE_SCHOOL_3 | 13.6.0 | NUMBER(11,0) | The student's third school choice. |
| CURR_ASSIGNMENT_CODE_ID | 13.6.0 | NUMBER(11,0) | |
| CURR_EXCEPTION_CODE_ID | 13.6.0 | NUMBER(11,0) | |
| END_DATE | 13.6.0 | DATE | |
| FEDERAL_PROPERTY_ID | 13.6.0 | NUMBER(11,0) | |
| ID | 13.6.0 | NUMBER(19,0) | Primary key |
| INVALID_ADDRESS_REASON_CODE | 13.6.0 | VARCHAR2(6) | |
| MUNICIPALITY_CODE | 13.6.0 | NUMBER(11,0) | |
| NEXT_ASSIGNMENT_CODE_ID | 13.6.0 | NUMBER(11,0) | |
| NEXT_EXCEPTION_CODE_ID | 13.6.0 | NUMBER(11,0) | |
| NEXT_YEAR_CATCHMENT | 13.6.0 | VARCHAR2(16) | |
| OUT_OF_BOUNDARY_MUNICIPALITY | 13.6.0 | VARCHAR2(60) | |
| OUT_OF_CATCHMENT | 13.6.0 | VARCHAR2(1) | |
| POSTAL_CODE | 13.6.0 | VARCHAR2(10) | |
| PUPIL_NUMBER | 13.6.0 | NUMBER(11,0) | |
| SPECIAL_ADDRESS_CODE | 13.6.0 | VARCHAR2(3) | |
| START_DATE | 13.6.0 | DATE | |
| STREET_HIGH | 13.6.0 | NUMBER(11,0) | |
| STREET_LOW | 13.6.0 | NUMBER(11,0) | |
| STREET_NAME | 13.6.0 | VARCHAR2(30) | |
| STREET_SIDE | 13.6.0 | VARCHAR2(1) |