AB_COURSE_ENROLL
This table stores student course enrolments.
Column Name | Version | Data Type | Description |
|---|---|---|---|
AB_Course_EnrollID | 16.5.0 | NUMBER(19,0) | Primary Key |
| Course_Code | 16.5.0 | Varchar2(10) | The Alberta course code |
| Course_Enrol_Status | 16.5.0 | Varchar2(15) | Indicates the course enrolment status. Valid values: Blank=Active, COM=Complete, INC=Incomplete, CTN=Continuing, WDR=Withdrawal. |
| Credits_Attempted | 16.5.0 | NUMBER(5,0) | The amount of credit awarded for completing a course. |
| Effective_UTC | 16.5.0 | DATE | The date the record is valid. Defaults to system date. |
| Entry_Date | 16.5.0 | DATE | Date student's course enrolment begins. |
| Exit_Date | 16.5.0 | DATE | Date student's course enrolment ends. |
| Instruct_Mins | 16.5.0 | NUMBER(10,0) | Indicates the instruction minutes the student received for this course enrolment. |
| Is_Deleted | 16.5.0 | NUMBER(1,0) | Indicates whether this course enrolment is deleted. Valid values: 1=Yes, 0=No. Required. |
| Is_Ext_Credit | 16.5.0 | NUMBER(1,0) | Indicates whether this course enrolment is eligible for external credential. Valid values: 1=Yes, 0=No. Required. |
| Is_Funding_Req | 16.5.0 | NUMBER(1,0) | Indicates whether funding has been requested for this course enrolment. Valid values: 1=Yes, 0=No. Required. |
| PASI_CoreVersion | 16.5.0 | NUMBER(19,0) | Unique number allowing for easy identification of when an entity has changed. |
| RefID | 16.5.0 | Varchar2(36) | Unique system identifier |
| Section_RefID | 16.5.0 | Varchar2(36) | The REFID from the AB_SECTION table |
| State_Province_ID | 16.5.0 | Varchar2(20) | The provincial-assigned student number for the student - In most cases, this number should stay the same from school to school. |
| Enrolment_RefID | 16.5.0 | Varchar2(36) | The REFID from the AB_ENROLMENT table |
| Local_ID | 16.5.0 | Varchar2(100) | The DCID of the CC record in PowerSchool - This is the link between the PASI tables and the PowerSchool tables. |
| WhoCreated | 16.5.0 | Varchar2(100) | The name of the person who created the record. Defaults to the user. |
| WhenCreated | 16.5.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. |
| WhoModified | 16.5.0 | Varchar2(100) | The name of the person who modified the record. Defaults to the user. |
| WhenModified | 16.5.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date. |
| Is_Dual_Enrolment | 16.5.0 | NUMBER(1,0) | Indicates whether this course enrolment is a dual enrolment. Valid values: 1=Yes, 0=No. |