Skip to main content
Skip table of contents


This table stores an archive of data events.

Column Name


Data Type





Primary Key

Event_Type13.0.0NUMBER(6,0)Indicates the event type.
Event_Table13.0.0Varchar2(30)The PowerSchool table on which the event occurred.
Event_Table_DCID13.0.0NUMBER(10,0)The DCID of the PowerSchool record on which the event occurred.
Event_Category13.0.0Varchar2(30)Indicates the event category. Valid values: Student, Enrolment, Course, Section, Course Enrolment, Course Mark, Evaluated Mark, Course Mark Approval, Evaluated Mark Approval.
Process_State13.0.0NUMBER(6,0)Indicates whether the event is Processed, Unprocessed, In Progress, or Discarded.
Processed_Date13.0.0TIMESTAMP(6)The date and time the record was processed. Defaults to system date.
WhoCreated13.0.0Varchar2(100)The name of the person who created the record. Defaults to the user.
WhenCreated13.0.0TIMESTAMP(6)The date and time the record was created. Defaults to system date.
WhoModified13.0.0Varchar2(100)The name of the person who modified the record. Defaults to the user.
WhenModified13.0.0TIMESTAMP(6)The date and time the record was modified. Defaults to system date.
Event_Table_ID13.0.0NUMBER(10,0)Enrolment ID for enrolment events
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)The AB_ENROLLMENTID from the AB_ENROLLMENT table
Process_Attempts13.0.0NUMBER(4,0)Indicates the number of times the event has attempted to process.
Event_Fields13.0.0CLOBJSON string record of the data changes
Created_User_ID13.0.0NUMBER(10,0)User who executed the event.
Created_User_IP_Address13.0.0Varchar2(45)IP address from which the user executed the event.
Created_User_ORG_Code13.0.0NUMBER(10,0)Organization code of the user who executed the event.
WhenArchived13.0.0TIMESTAMP(6)The date and time the record was archived. Defaults to system date.
JavaScript errors detected

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

If this problem persists, please contact our support.