AB_PASIENROLMENTIDVERSION
This table stores PASI Enrolment Identification Version Information – matches enrolments and their versions in PowerSchool to PASI.
Column Name | Version | Data Type | Description |
|---|---|---|---|
AB_PASIEnrolmentIDVersionID | 13.0.0 | NUMBER(19,0) | Primary Key |
| EnrolmentID | 13.0.0 | NUMBER(10,0) | A unique identifier for enrollments in PowerSchool
|
| PASISystemID | 13.0.0 | Varchar2(50) | The RefID on the AB_ENROLMENT table. |
| CoreVersion | 13.0.0 | NUMBER(19,0) | Unique number allowing easy identification of when an entity has changed. |
| TableName | 13.0.0 | Varchar2(25) | PowerSchool table that the enrolment is located. |
| WhoCreated | 13.0.0 | Varchar2(100) | The name of the person who created the record. Defaults to 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 person who modified the record. Defaults to user. |
| WhenModified | 13.0.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date |
| SchoolYear | 13.0.0 | Varchar2(4) | A number representing which school year the record belongs to, such as 2017 for 2017-2018 school year. |
| CreatedInError | 13.0.0 | NUMBER(1,0) | Indicates whether this enrolment is created erroneously. Valid values: 1=Yes, 0=No. Required. |
| State_StudentNumber | 13.0.0 | Varchar2(32) | The provincial-assigned student number for the student. In most cases, this number should stay the same from school to school. |