This table stores student course enrolments.
|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.|
Indicates whether this course enrolment is deleted. Valid values: 1=Yes, 0=No. Required.
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|
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|
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.|
Indicates whether this course enrolment is a dual enrolment. Valid values: 1=Yes, 0=No.