S_ON_STU_XML_CLASS_ENROL_C
This table is a child table of Students and stores Student Special Education segment information.
Column Name | Version | Data Type | Description | |
|---|---|---|---|---|
ID | 20.11.2.0 | Number(19) | Primary key | |
StudentsDCID | 20.11.2.0 | Number(19) | Primary key that relates the extended table to the [Students] table | |
Academic_Year | 20.11.2.0 | Varchar2(9 char) | The academic year of the submission | |
| Submission_Period_Type | 20.11.2.0 | Varchar2(20 char) | Submission period type | |
| Action | 20.11.2.0 | Varchar2(6 char) | This is the action associated with this submission Valid values: ADD, UPDATE | |
| Class_Code | 20.11.2.0 | Varchar2(25 char) | Class Code | |
| Ministry_Dfnd_Crs | 20.11.2.0 | Varchar2(5 char) | Ministry Defined Course | |
| Institution_Type | 20.11.2.0 | Varchar2(6 char) | Institution (College or University) – used to identify the Dual Credit Course. | |
| Local_Dev_Crs | 20.11.2.0 | Varchar2(5 char) | Locally Developed Course | |
| Language_Type | 20.11.2.0 | Varchar2(3 char) | Segment language of instruction | |
| Credit_Value | 20.11.2.0 | Number(25,10) | Credit Value | |
| Course_Delivery_Type | 20.11.2.0 | Varchar2(3 char) | Course Delivery Type | |
| Course_Sem_Type | 20.11.2.0 | Varchar2(3 char) | Course Scheduling Indicator | |
| Withdrawal_Type | 20.11.2.0 | Varchar2(3 char) | Withdrawal Type | |
| Withdrawal_Date | 20.11.2.0 | Date | Withdrawal Date | |
| IEP_Flag | 20.11.2.0 | Varchar2(1 char) | IEP Flag | |
| Program | 20.11.2.0 | Varchar2(7 char) | Program | |
| Classes_Missed | 20.11.2.0 | Number(25,10) | Classes Missed | |
| Times_Late | 20.11.2.0 | Number(25,10) | Times Late | |
| Total_Classes | 20.11.2.0 | Number(25,10) | Total Classes | |
| Course_Start_Date | 20.11.2.0 | Date | Course Start Date | |
| Course_End_Date | 20.11.2.0 | Date | Course End Date | |
| Earned_Credit_Value | 20.11.2.0 | Number(25,10) | Earned Credit Value | |
| Final_Mark | 20.11.2.0 | Varchar2(3 char) | Final Mark | |
| Course_Sbst_Flag | 20.11.2.0 | Varchar2(1 char) | Indicates if this course is a substitution | |
| Course_Complete_Flag | 20.11.2.0 | Varchar2(1 char) | Flag indicating this course is complete | |
| Course_Repeat_Flag | 20.11.2.0 | Varchar2(1 char) | Flag indicating this course is a repeated course | |
| Compulsory_Course_Flag | 20.11.2.0 | Varchar2(1 char) | Flag indicating this course is compulsory | |
| Course_Incomplete_Flag | 20.11.2.0 | Varchar2(1 char) | Flag indicating this course is incomplete | |
| Course_Continued_Flag | 20.11.2.0 | Varchar2(1 char) | Flag indicating the course is continued from the previous year | |
| Campus_Number | 20.11.2.0 | Varchar2(20 char) | The number of the campus | |
| New_Course_Sem_Type | 20.11.2.0 | Varchar2(1 char) | New Course Scheduling Indicator | |
| Attempted_Credit_Value | 20.11.2.0 | Varchar2(5 char) | Credit Hours for the course | |
| Course_Complete_Date | 20.11.2.0 | Date | The date when the other credit course was completed | |
| Type | 20.11.2.0 | Varchar2(3 char) | Uniquely identify the Other Credit type | |
| Other_Credit_Flag | 20.11.2.0 | Varchar2(1 char) | Flag indicating this record is from OTHER_CREDIT segment | |
| Status_Type | 20.11.2.0 | Varchar2(2 char) | PLAR Information – PLAR Type | |
| Compulsory_Credit | 20.11.2.0 | Varchar2(5 char) | PLAR Information - The Prior Learning Assessment Recognition compulsory credit value. | |
| Date_Approved | 20.11.2.0 | Date | PLAR Information – Date completed | |
| PLAR_Flag | 20.11.2.0 | Varchar2(1 char) | Flag indicating this record is from PLAR segment | |
| OthCrsInfo_Cred_Recovery | 20.11.2.0 | Varchar2(10 char) | Credit Recovery Flag | |
| OthCrsInfo_Ministry_Content | 20.11.2.0 | Varchar2(10 char) | Ministry Developed Content Flag | |
| OthCrsInfo_UpgradCrdtCourse | 20.11.2.0 | Varchar2(10 char) | Upgrade Credit Course Flag | |
| WhoCreated | 20.11.2.0 | Varchar2(100 char) | Who created the record | |
| WhenCreated | 20.11.2.0 | Timestamp(6) | When record was created | |
| WhoModified | 20.11.2.0 | Varchar2(100 char) | Who modified the record | |
| WhenModified | 20.11.2.0 | Timestamp(6) | When was the record modified |