PSSR_DATA_EVENT_QUEUE
This table stores the event queue data.
Column Name | Version | Data Type | Description |
|---|---|---|---|
PSSR_Data_Event_QueueID | 13.0.0 | Number (19,0) | Primary Key |
| Event_Type | 13.0.0 | Number (6,0) | Indicates the type of event. |
| Event_Table | 13.0.0 | Varchar2 (30) | Indicates the table which the event originated. |
| Event_Table_DCID | 13.0.0 | Number (10,0) | The DCID of the table on which the event occurred. |
| Event_Category | 13.0.0 | Varchar2 (30) | Indicates the category of the event. |
| Process_State | 13.0.0 | Number (6,0) | Status of the event. |
| Processed_Date | 13.0.0 | Timestamp (6) | Date event was processed. |
| 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. |
| Event_Table_ID | 13.0.0 | Number (10,0) | The DCID of the parent object table table. |
| 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. |
| EnrollmentID | 13.0.0 | Number (10,0) | Unique ID assigned by PowerSchool to an enrollment. |
| Process_Attempts | 13.0.0 | Number (4,0) | Indicates the number of times an event has attempted to process. |
| Event_Fields | 13.0.0 | CLOB | JSON string of all fields on table. |
| Created_User_ID | 13.0.0 | Number (10,0) | The User ID of the person who created the event. (Submitted to Alberta) |
| Created_User_IP_Address | 13.0.0 | Varchar2 (45 BYTE) | The IP of the address that created the event. (Submitted to Alberta) |
| Created_User_Org_Code | 13.0.0 | Number (10,0) | The organization code of the person who created the event. (Submitted to Alberta) |