CST_PUBAUDITGRADEBOOK (ver 15.5.1)
This table is a standalone table and stores gradebook transaction information, including what table changed and the associated record. Note: Each entry must have a unique PSMTABLE, PSMID, and TRANSTYPE. This table is available for all states/provinces and may or may not be utilized for your state/province.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 15.5.1 | NUMBER(19,0) | The internal ID for the CST_PUBAUDITGRADEBOOK record to which the record is associated. Required. (Default – Next value in CST_PUBAUDITGRADEBOOK_SQ sequence) |
PSMTABLE | 15.5.1 | NUMBER(5,0) | The name of the PSM table. Required. |
PSMID | 15.5.1 | NUMBER(19,0) | The DCID of the PSM table. Required. |
TRANSTYPE | 15.5.1 | CHAR(1) | The transaction type of the table and row. Required. (i.e. ‘I’-Insert, ‘U’-Update, ‘D’-Delete) |