StateEventQueue, 102 (ver3.6.1)
Storage area for possible transactions used to send to other (right now state) systems. Used by both AZ and TN (these records are only processed for extracts ONLY IF your PowerSchool Nightly process is enabled and your TN_Extract_AttendanceMethod preference is NOT set to SNAPSHOT).
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Action | 3.6.1 | Varchar(20) | Action to be performed for this record. Ex; D=Delete. Indexed. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
ErrorText | 3.6.1 | CLOB | Error message(s) that are returned by the event processor but are not used by PowerSchool. |
EventData | 3.6.1 | CLOB | The extract fixed-length record that will be sent to the state. |
EventDate | 3.6.1 | Date | Date the extract record was posted. Indexed. |
EventTime | 3.6.1 | Time | Time the extract record was posted. |
EventType | 3.6.1 | Number(10,0) | Type of event. 1=attendance change, 2=new or reenrollment, 3=withdrawal, 4=student demog info, 5=promotion/retention, 6=fix state enrollment, 7=reset enrollment, 11=student needs, 12=student assessment, 13=lang prog participation, 14=SPED service part, 15=Support Program part, 19=SPED Service DOR Transfer. Indexed. |
Extract_LayoutRecordID | 3.6.1 | Varchar(79) | The state-assigned ID of the Extract. Identifies the type of this record: 030=Class Section, 031=Class Section Schedule, 045=Transportation, etc. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
OrigEventDate | 4.2.1 | Date | Original event date. Indexed. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
Status | 3.6.1 | Number(10,0) | Status returned by the event processor such as the error codes. 2=Unprocessed. Indexed. |
StudentID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Students record. |