ON_HIGH_CREDIT
This is a Standalone table
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 13.8 | Number(10,0) | Primary key - automatically generated |
Year_ID | 13.8 | Number(10,0) | [Terms] table yearID for the Year |
Run_Date | 13.8 | Date | System date from the day the report was run. |
Effective_Date | 13.8 | Date | The date to which the report is effective. |
StudentID | 13.8 | Number(10,0) | The internal number for the student with which this High Credit record is associated. |
Gr_Nine_Enroll_Date | 13.8 | Date | The date student entered 9th grade in an Ontario school if transferred in from another district |
Exemption_Code | 13.8 | Varchar2(2) | Exemption Code derived from Enrollment Fields.
|
Prior_Exempt_Cr | 13.8 | Number(3,1) | Prior Exempt credits – Total of prior credits earned that are exempt because they are ESL, ELD, ALF, or PANA derived from Enrollment Fields |
Current_Exempt_Cr | 13.8 | Number(3,1) | Current Exempt credits – Total of current credits enrolled that are exempt because they are ESL, ELD, ALF, or PANA derived from Enrollment Fields |
Prior_Non_Exempt_Cr | 13.8 | Number(3,1) | Prior Non-Exempt Credits – The total number of non-exempt credits student has earned in Secondary School prior to the count date derived from Enrollment Fields |
Curr_Non_Exempt_Cr | 13.8 | Number(3,1) | Current Non-Exempt Credits – Total number of non-exempt credits the student is currently enrolled for on the count date derived from Enrollment Fields |
Total_Non_Exempt_Cr | 13.8 | Number(3,1) | Total non-exempt credits – Total of prior and current credits that are not exempt. |
Current_Total_Cr | 13.8 | Number(3,1) | Total current credits (exempt and non-exempt). derived from Enrollment Fields |
High_Credits | 13.8 | Number(3,1) | derived from Enrollment Fields |
Regular_Credits | 13.8 | Number(3,1) | The number of regular credits (Total [exempt and non-exempt] credits minus high credits) derived from Enrollment Fields |
High_Credit_Factor | 13.8 | Number(4,3) | High credit factor (high credits divided by total [exempt and non-exempt] credits). |
Total_Enrolled_Minutes | 13.8 | Number(10,0) | Total enrolled minutes (minutes of instruction) as of the count date derived from Enrollment Fields |
High_Credit_Minutes | 13.8 | Number(10,0) | High credit minutes of instruction (total minutes times high credit proportion) derived from Enrollment Fields |
Regular_Minutes | 13.8 | Number(10,0) | Regular minutes of instruction (total minutes minus high credit minutes) derived from Enrollment Fields |
Regular_FTE | 13.8 | Number(3,2) | Regular Day School FTE derived from Enrollment Fields |
Regular_ADE | 16.11 | Number(5,4) | Regular ADE derived from Enrollment Fields |
High_Credit_FTE | 13.8 | Number(3,2) | High credit Day School FTE derived from Enrollment Fields |
High_Credit_ADE | 16.11 | Number(5,4) | High credit ADE derived from Enrollment Fields |
Attendance_Type | 22.8 | VARCHAR2(2) | Determines if a student is full- or part-time derived from Enrollment Fields |
Schoolid | 23.1 | Number(10,0) | Schoolid |