AB_PASISTUDENTSIDVERSION
This table stores PASI Student Identification Version Information – matches students and their versions in PowerSchool to PASI.
Column Name | Version | Data Type | Description |
|---|---|---|---|
AB_PASIStudentsIDVersionID | 13.0.0 | NUMBER(19,0) | Primary Key |
| StudentsID | 13.0.0 | NUMBER(10,0) | Student ID on the Students table in PowerSchool. |
| PASISystemID | 13.0.0 | Varchar2(50) | Alberta Student Number (ASN) of student. |
| StudentRefID | 13.0.0 | Varchar2(50) | DCID of the student on the Students table in PowerSchool. |
| CoreVersion | 13.0.0 | NUMBER(19,0) | Unique number allowing easy identification of when an entity has changed. |
| 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 |
| StudentSynchRefIDs | 13.0.0 | CLOB | RefID of entity being synchronized. |