Skip to main content
Skip table of contents


This table stores school enrolment information.

Column Name


Data Type





Primary Key

Effective_RefID13.0.0TIMESTAMP(6)Date this enrolment is valid.
Grade13.0.0Varchar2(2)Student's grade level
PASI_CoreVersion13.0.0NUMBER(19,0)Unique number allowing easy identification of when an entity has changed.
RefID13.0.0Varchar2(36)Unique system identifier
Registration_Exit_Date13.0.0TIMESTAMP(6)The date and time the enrolment ends.
Registration_Start_Date13.0.0TIMESTAMP(6)The date and time the enrolment begins.
School_Code13.0.0Varchar2(4)The Alberta school code
School_Year13.0.0NUMBER(4,0)A number representing which school year the record belongs to, such as 2017 for 2017-2018 school year.
State_ProvinceID13.0.0Varchar2(255)The provincial-assigned student number for the student - In most cases, this number should stay the same from school to school.
PROGRAMMINGTYPE22.7.1VARCHAR2(100 CHAR)The Programming Type of the registration.
PROGRAMMINGTIMEFRAME22.7.1VARCHAR2(100 CHAR)The Programming Timeframe of the registration.
EXITDATETYPE22.7.1VARCHAR2(100 CHAR)The exit date Type of the registration.
WhoCreated13.0.0Varchar2(100)The name of the person who created the record. Defaults to the user.
WhenCreated13.0.0TIMESTAMP(6)The date and time the record was created. Defaults to system date.
WhoModified13.0.0Varchar2(100)The name of the person who modified the record. Defaults to the user.
WhenModified13.0.0TIMESTAMP(6)The date and time the record was modified. Defaults to system date.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.