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