ON_ONSIS_SNAPSHOT

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

12.10

Number(38,0)

From Students table, indexed

Grade_Level

12.10

Number(38,0)

From Students table, -1, 0, 1 to 12

ON_Entry_Country

12.10

varchar2(500)

From Students table

ON_Entry_Province

12.10

varchar2(500)

From Students table

ON_Entry_Language

12.10

varchar2(500)

From Students table

Zip

12.10

varchar2(10)

From Students table

ON_Brd_Res_Status

12.10

varchar2(500)

From Students table

ON_Residence_Status

12.10

varchar2(500)

From Students table

CREATETMS

12.10

timestamp(6)

Default to 'sysdate'

CREATEDBY

12.10

varchar2(500)

Default to 'system'

ON_TimetableType

12.10

varchar2(500)

From Students table (note that starting in 2014-2015 this value will be null)

OYAP

12.10

varchar2(1)

om S_ON_STU_FrX table

Curr_Country

12.10

varchar2(3)

From S_ON_STU_X 

Curr_Province

12.10

varchar2(3)

From S_ON_STU_X 

Gender

20.3

varchar2(40)

From Students table

Gender_Identity_Code

20.3

varchar2(40)

From S_ON_STU_X 

Gender_Identity_Desc

20.3

varchar2(500)

From S_ON_STU_X

On_Online_Grad_Req

22.10

varchar2(3)

calculated as of the run date

STUMATURE

24.8.1

varchar2(1)

From S_ON_STU_X