Skip to main content
Skip table of contents


This table stores the event queue data.

Column Name


Data Type




Number (19,0)

Primary Key

Event_Type13.0.0Number (6,0)Indicates the type of event.
Event_Table13.0.0Varchar2 (30)Indicates the table which the event originated.
Event_Table_DCID13.0.0Number (10,0)The DCID of the table on which the event occurred.
Event_Category13.0.0Varchar2 (30)Indicates the category of the event.
Process_State13.0.0Number (6,0)Status of the event.
Processed_Date13.0.0Timestamp (6)Date event was processed.
WhoCreated13.0.0Varchar2(100)The name of the person who created the record. Defaults to user.
WhenCreated13.0.0Timestamp (6)The date and time the record was created. Defaults to system date.
WhoModified13.0.0Varchar2(100)The name of person who modified the record. Defaults to user.
WhenModified13.0.0Timestamp (6)The date and time the record was modified. Defaults to system date.
Event_Table_ID13.0.0Number (10,0)The DCID of the parent object table table.
State_StudentNumber13.0.0Varchar2 (32)The provincial-assigned student number for the student - In most cases, this number should stay the same from school to school.
EnrollmentID13.0.0Number (10,0)Unique ID assigned by PowerSchool to an enrollment.
Process_Attempts13.0.0Number (4,0)Indicates the number of times an event has attempted to process.
Event_Fields13.0.0CLOBJSON string of all fields on table.
Created_User_ID13.0.0Number (10,0)The User ID of the person who created the event. (Submitted to Alberta)
Created_User_IP_Address13.0.0Varchar2 (45 BYTE)The IP of the address that created the event. (Submitted to Alberta)
Created_User_Org_Code13.0.0Number (10,0)The organization code of the person who created the event. (Submitted to Alberta)
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.