AB_STU_RESPONSIBLE_SCHOOL
his table stores PASI Student Responsible School data
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 22.7.1 | NUMBER(19) | Primary Key |
| EFFECTIVEDATE | 22.7.1 | DATE | Identifies the date when the responsible school came into effect. |
| HASRESPONSIBLESCHOOL | 22.7.1 | VARCHAR2(100 CHAR) | The responsible school type for the responsible school. The code value of HasResponsibleSchool in PASI Code Values. |
| ISDELETED | 22.7.1 | NUMBER(1) | Indicates whether this record is deleted in PASI. |
| LASTUPDATEUTCTIME | 22.7.1 | TIMESTAMP(6) | The UTC time this Responsible School was last modified. |
| LOCALID | 22.7.1 | NUMBER(19) | The ID of the record in PowerSchool. This is the link between the PASI tables and the PowerSchool tables. |
| PASICOREVERSION | 22.7.1 | NUMBER(19) | The PASI version of this record. This is used for updating the record. |
| REFID | 22.7.1 | VARCHAR2(36 CHAR) | A Globally Unique Identifier (GUID) used to reference the Responsible School record |
| SCHOOLCITY | 22.7.1 | VARCHAR2(60 CHAR) | The City name of the school the student will be transitioning to. |
| SCHOOLCODE | 22.7.1 | VARCHAR2(4 CHAR) | Identifies the school associated with this record. |
| SCHOOLCOUNTRY | 22.7.1 | VARCHAR2(60 CHAR) | The Country associated with the School address that the student is transitioning to. |
| SCHOOLNAME | 22.7.1 | VARCHAR2(225 CHAR) | The name of the school the Student is transitioning to. |
| SCHOOLSTATEPROVINCE | 22.7.1 | VARCHAR2(20 CHAR) | The province or state associated with the School address that the student is transitioning to. For Canadian and US addresses, this should be the accepted 2 digit province or state code. |
| STATEPROVINCEID | 22.7.1 | VARCHAR2(20 CHAR), | The primary StateProvinceId for the student, otherwise known as the Alberta Student Number (ASN). |
| TRANSITIONREASON | 22.7.1 | VARCHAR2(100 CHAR) | Identifies the reason the student transitioned to this school or out of school. The code value of TransitionReason in PASI Code Values. |
| WhoCreated | 22.7.1 | Varchar2(100) | The name of the person who created the record. Defaults to the user. |
| WhenCreated | 22.7.1 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
| WhoModified | 22.7.1 | Varchar2(100) | The name of the person who modified the record. Defaults to the user. |
| WhenModified | 22.7.1 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |