PGNotification, 173 (ver4.0.0)
This transient table maintains the notification sent back to PowerGrade to confirm a record send by PowerGrade was committed to the database and/or any errors encountered.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Category | 4.0.0 | Varchar(30) | The type of the notification such as, Sequence number, attendance notification or etc. Optional. Indexed. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
ID | 4.0.0 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Identifier | 4.0.0 | Varchar(80) | Unique identifier for the notification. May be a database record ID, date, GUID, Student Number, etc. Specific value stored is dependent on the category. |
Ntf_Value | 4.0.0 | Varchar(50) | The text of the message being sent back to PowerGrade. Also dependent on the Category. |
SchoolID | 4.0.0 | Number(10,0) | The School_Number of the associated Schools record. |
SectionID | 4.0.0 | Number(10,0) | The internal number and ID of the associated Sections record. |
TeacherID | 4.0.0 | Number(10,0) | The internal identification number of the teacher in the associated SchoolStaff record. Indexed. |
YearID | 4.0.0 | Number(10,0) | A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. Maintained in the Terms table. |