PS_WritebackAuditTrail (ver6.2.1.1)
This table implements the ability to write audit records for externally sourced transactions, which modify data in PowerSchool tables.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DMLActionType | 6.2.1.1 | Varchar2(30) | The type of data manipulation language action that was taken when the associated record was changed. Valid values; Update, Insert, Delete. Defaults to Update. Required. |
NewCharVal | 6.2.1.1 | Varchar2(4000) | When a character column is updated through an external source, the new value of the character column is stored. |
NewCLOBVal | 6.2.1.1 | CLOB | When a CLOB column is updated through an external source, the new value of the CLOB column is stored. |
NewNumberVal | 6.2.1.1 | Number(19) | When a numeric column is updated through an external source, the new value of the numeric column is stored. |
NewTimestampVal | 6.2.1.1 | Timestamp(6) | When a timestamp column is updated through an external source, the new value of the timestamp column is stored. |
PreviousCharVal | 6.2.1.1 | Varchar2(4000) | When a character column is updated through an external source, the previous value of the character column is stored. |
PreviousCLOBVal | 6.2.1.1 | CLOB | When a CLOB column is updated through an external source, the previous value of the CLOB column is stored. |
PreviousNumberVal | 6.2.1.1 | Number(19) | When a numeric column is updated through an external source, the previous value of the numeric column is stored. |
PreviousTimestampVal | 6.2.1.1 | Timestamp(6) | When a timestamp column is updated through an external source, the previous value of the timestamp column is stored. |
PS_WritebackAuditTrailID | 6.2.1.1 | Number(19) | Unique identifier for this table. Indexed. Required. |
School_Number | 6.2.1.1 | Number(10) | The school number of the record related to the school being updated. Required. |
SourceObjectID | 6.2.1.1 | Varchar2(32) | The object ID of the source application. Defaults to No Related External Object. Required. |
SourceTransactionID | 6.2.1.1 | Varchar2(32) | The transaction ID of the source application. Defaults to Invalid Transaction ID. Required. |
SourceTransactionType | 6.2.1.1 | Varchar2(30) | The name of the external application or type of transaction writing back to one of the PowerSchool tables, such as SIF. Defaults to Invalid Type. Required. |
TransactionSource | 6.2.1.1 | Varchar2(32) | The name of the business writing back to one of the PowerSchool tables, such as Edustructures. Defaults to Invalid Source. Required. |
UpdatedClobPairName | 6.2.1.1 | Varchar2(50) | The value of the Name field of a Name value pair record stored in a custom field CLOB record, which was parsed out of the CLOB record, and its related value updated. |
UpdatedColumnName | 6.2.1.1 | Varchar2(50) | The name of the physical column that was updated. Required. |
UpdatedRowPrimaryKey | 6.2.1.1 | Number(19) | The primary key value of the record that was updated. Required. |
UpdatedRowSecondaryKey | 6.2.1.1 | Number(19) | A secondary key, or related key value of the record that was updated. Defaults to 0. Required. |
UpdatedTableName | 6.2.1.1 | Varchar2(30) | The name of the physical table that was updated. Required. |
WhenCreated | 6.2.1.1 | Timestamp(6) | Date and time the record was created. Defaults to system date. |
WhenModified | 6.2.1.1 | Timestamp(6) | Date and time the record was modified. Defaults to system date. |
WhoCreated | 6.2.1.1 | Varchar2(100) | The user login that created the record. Defaults to database user. |
WhoModified | 6.2.1.1 | Varchar2(100) | The user login that modified the record. Defaults to database user. |