ON_ONSIS_SNAPSHOT
his is a Standalone table
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 12.10 | Number(38,0) | Primary key - automatically generated. |
Count_Date | 12.10 | Date | |
| StudentID | 12.10 | Number(38,0) | The internal number for the student with which this High Credit record is associated, indexed |
| Schoolid | Number(38,0) | From Students table, indexed | |
| Grade_Level | Number(38,0) | From Students table, -1, 0, 1 to 12 | |
| ON_Entry_Country | varchar2(500) | From Students table | |
| ON_Entry_Province | varchar2(500) | From Students table | |
| ON_Entry_Language | varchar2(500) | From Students table | |
| Zip | varchar2(10) | From Students table | |
| ON_Brd_Res_Status | varchar2(500) | From Students table | |
| ON_Residence_Status | varchar2(500) | From Students table | |
| CREATETMS | timestamp(6) | Default to 'sysdate' | |
| CREATEDBY | varchar2(500) | Default to 'system' | |
| ON_TimetableType | varchar2(500) | From Students table (note that starting in 2014-2015 this value will be null) | |
| OYAP | varchar2(1) | om S_ON_STU_FrX table | |
| Curr_Country | varchar2(3) | From S_ON_STU_X | |
| Curr_Province | varchar2(3) | From S_ON_STU_X | |
| Gender | varchar2(40) | From Students table | |
| Gender_Identity_Code | varchar2(40) | From S_ON_STU_X | |
| Gender_Identity_Desc | varchar2(500) | From S_ON_STU_X |