AB_DATA_EVENT_QUEUE_ARC
This table stores an archive of data events.
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 event type. |
| Event_Table | 13.0.0 | Varchar2(30) | The PowerSchool table on which the event occurred. |
| Event_Table_DCID | 13.0.0 | NUMBER(10,0) | The DCID of the PowerSchool record on which the event occurred. |
| Event_Category | 13.0.0 | Varchar2(30) | Indicates the event category. Valid values: Student, Enrolment, Course, Section, Course Enrolment, Course Mark, Evaluated Mark, Course Mark Approval, Evaluated Mark Approval. |
| Process_State | 13.0.0 | NUMBER(6,0) | Indicates whether the event is Processed, Unprocessed, In Progress, or Discarded. |
| Processed_Date | 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 the 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 the person who modified the record. Defaults to the 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) | Enrolment ID for enrolment events |
| 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) | The AB_ENROLLMENTID from the AB_ENROLLMENT table |
| Process_Attempts | 13.0.0 | NUMBER(4,0) | Indicates the number of times the event has attempted to process. |
| Event_Fields | 13.0.0 | CLOB | JSON string record of the data changes |
| Created_User_ID | 13.0.0 | NUMBER(10,0) | User who executed the event. |
| Created_User_IP_Address | 13.0.0 | Varchar2(45) | IP address from which the user executed the event. |
| Created_User_ORG_Code | 13.0.0 | NUMBER(10,0) | Organization code of the user who executed the event. |
| WhenArchived | 13.0.0 | TIMESTAMP(6) | The date and time the record was archived. Defaults to system date. |