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. |