PGIncomingQueue, 40 (ver3.6.1)
This table serves as the temporary holding place for PowerGrade. This makes PowerGrade jobs Asynchronous so Teachers do not have to wait for completion before continuing to use PowerGrade.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
BLOBdata | 3.6.1 | BLOB | The actual data PowerGrade is sending in a compressed BLOB. |
Command | 3.6.1 | Varchar(80) | What PowerGrade wants done such as Update Attendance, Update Assignment, Log Entry, etc. |
CreateDT | 4.0.0 | Date | Date reported to admin of when this record was created. Indexed. |
CreateTM | 4.0.0 | Number(10,0) | Time reported to admin of when this record was created. Indexed. |
Data | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
PGVersion | 3.6.1 | Number(10,0) | Stores the PowerGrade version of incoming request for checking updates and BLOB handling. |
ProcessNum | 5.0.9 | Number(10,0) | Process Number (for Multi-Homing). |
SectionID | 5.0.9 | Number(10,0) | The internal number and ID of the associated Sections record. |
Server_InstanceID | 4.2.0 | Number(10,0) | Identifier for the PowerSchool Server Instance. Indexed. |
TeacherID | 3.6.1 | Number(10,0) | The internal identification number of the teacher in the associated SchoolStaff record. |
TimeReceived | 3.6.1 | Number(10,0) | When the request came in to PowerSchool from PowerGrade. |