AB_PASISTATUS
This table stores Status Messages and Core Alerts data.
Column Name | Version | Data Type | Description |
|---|---|---|---|
AB_PASIStatusID | 13.0.0 | NUMBER(19,0) | Primary Key |
| PASICoreVersion | 13.0.0 | NUMBER(19,0) | Unique number allowing easy identification of when an entity has changed. |
| PASISystemID | 13.0.0 | Varchar2(50) | RefID of the entity associated with the status message. |
| StatusType | 13.0.0 | Varchar2(30) | Entity stype associated with the status message. |
| AcknowledgementStatus | 13.0.0 | Varchar2(25) | Indicated whether the record has been acknowledged. |
| AlertCode | 13.0.0 | NUMBER(10,0) | Code value for the core alert. |
| AlertType | 13.0.0 | Varchar2(30) | Indicates the type of core alert. |
| Description | 13.0.0 | Varchar2(2000) | Description of the core alert. |
| ProcessState | 13.0.0 | NUMBER(1,0) | System indicator if alert is being updated. |
| WhenProcessed | 13.0.0 | TIMESTAMP(6) | The date and time the record was processed. Defaults to system date. |
| 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. |
| WhoAcknowledged | 13.0.0 | Varchar2(100) | The name of the person who acknowledged the record. Defaults to user. |
| WhenAcknowledged | 13.0.0 | TIMESTAMP(6) | The date and time the record was acknowledged. 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 |
| PASIObject | 13.0.0 | Varchar2(30) | Component of the entity associated with the core alert message (usually only for students). |
| SchoolID | 13.0.0 | NUMBER(10,0) | The School Number in PowerSchool. |
| Acknowledged_ORG_Code | 13.0.0 | NUMBER(10,0) | Orginization code of who acknowledged the core alert. |
| Acknowledged_IP_Addr | 13.0.0 | Varchar2(45) | IP Address of who acknowledged the core alert. |
| Acknowledged_Local_ID | 13.0.0 | NUMBER(10,0) | User ID of who acknowledged the core alert. |
| PASISchoolYear | 13.0.0 | Varchar2(4) | A number representing which school year the record belongs to, such as 2017 for 2017-2018 school year. |
| Local_ID | 13.0.0 | Varchar2(255) | The DCID of the corresponding record in PowerSchool. This is the link between the PASI tables and the PowerSchool tables. |