AB_ENROLMENT
This table stores school enrolment information.
Column Name | Version | Data Type | Description |
---|---|---|---|
AB_EnrolmentID | 13.0.0 | NUMBER(19,0) | Primary Key |
Effective_RefID | 13.0.0 | TIMESTAMP(6) | Date this enrolment is valid. |
Grade | 13.0.0 | Varchar2(2) | Student's grade level |
PASI_CoreVersion | 13.0.0 | NUMBER(19,0) | Unique number allowing easy identification of when an entity has changed. |
RefID | 13.0.0 | Varchar2(36) | Unique system identifier |
Registration_Exit_Date | 13.0.0 | TIMESTAMP(6) | The date and time the enrolment ends. |
Registration_Start_Date | 13.0.0 | TIMESTAMP(6) | The date and time the enrolment begins. |
School_Code | 13.0.0 | Varchar2(4) | The Alberta school code |
School_Year | 13.0.0 | NUMBER(4,0) | A number representing which school year the record belongs to, such as 2017 for 2017-2018 school year. |
State_ProvinceID | 13.0.0 | Varchar2(255) | The provincial-assigned student number for the student - In most cases, this number should stay the same from school to school. |
PROGRAMMINGTYPE | 22.7.1 | VARCHAR2(100 CHAR) | The Programming Type of the registration. |
PROGRAMMINGTIMEFRAME | 22.7.1 | VARCHAR2(100 CHAR) | The Programming Timeframe of the registration. |
EXITDATETYPE | 22.7.1 | VARCHAR2(100 CHAR) | The exit date Type of the registration. |
WhoCreated | 13.0.0 | Varchar2(100) | The name of the person who created the record. Defaults to the user. |
WhenCreated | 13.0.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. |
WhoModified | 13.0.0 | Varchar2(100) | The name of the person who modified the record. Defaults to the user. |
WhenModified | 13.0.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date. |