For any given record, only the fields relevant to the type of the changed data have values. Fields for other data types are NULL.
The AUDIT_LOG and AUDIT_PROPERTIES tables replace the HISTORY table, which no longer exists.
Column Name | Description | Datatype | Length | Allow Nulls | Default | |
---|---|---|---|---|---|---|
![]() | AP_PROPERTY_ID | The record ID. | int | 4 | ||
AP_ACTION_ID | The audit log record: AUDIT_LOG.AU_ACTION_ID. | int | 4 | |||
AP_TABLE_NAME | If the property change was saved in the database, the name of the table in which the change occurred. | varchar | 40 | ![]() | ||
AP_FIELD_NAME | If the property change was saved in the database, the field (column) that was changed. | varchar | 40 | ![]() | ||
AP_PROPERTY_NAME | If the property change was saved in the database, the user-defined label for the field that was changed (SYSTEM_FIELD.SF_USER_LABEL). If not a database field, the name of the property. | varchar | 50 | ![]() | ||
AP_OLD_VALUE | The value before the change for types other than timestamp or large object fields. If there is no previous value, or if timestamp or large object, NULL. | varchar | 2000 | ![]() | ||
AP_NEW_VALUE | The value resulting from the change for types other than timestamp or large object fields. NULL for timestamp and large object. | varchar | 2000 | ![]() | ||
AP_OLD_LONG_VALUE | The value before the change for large object fields. If there is no previous value or if not a large object, NULL. | varchar | 16 | ![]() | ||
AP_NEW_LONG_VALUE | The value resulting from the change for large object fields, such as memo fields. If not a large object, NULL. | varchar | 16 | ![]() | ||
AP_OLD_DATE_VALUE | The value before the change for timestamp fields. If there is no previous value or if not a timestamp , NULL. | datetime | 4 | ![]() | ||
AP_NEW_DATE_VALUE | The value resulting from the change for timestamp fields. If not a timestamp , NULL. | datetime | 4 | ![]() |