CST_PUBAUDITCHANGEDFIELD (ver 15.5.1)
This table is a standalone table and tracks fields that have changed during transactions, including the old and new value. 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_PUBAUDITCHANGEDFIELD record to which the record is associated. Required. (Default – Next value in CST_PUBAUDITCHANGEDFIELD_SQ sequence) |
CST_PUBAUDITID | 15.5.1 | NUMBER(19,0) | The internal ID for the CST_PUBAUDIT record to which the record is associated. Required. |
FIELDNAME | 15.5.1 | VARCHAR2(30) | The name of the field that changed. Required. |
OLDVALUE | 15.5.1 | VARCHAR2(4000) | The value of the field before it changed. |
| NEWVALUE | 15.5.1 | VARCHAR2(4000) | The value of the field after it changed. |