HP ALM Database Reference
td.AUDIT_PROPERTIES Table

Description

Details of the changes recorded in the AUDIT_LOG table.

Remarks

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.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key AP_PROPERTY_IDThe record ID.int4  
 AP_ACTION_IDThe audit log record: AUDIT_LOG.AU_ACTION_ID.int4  
 AP_TABLE_NAMEIf the property change was saved in the database, the name of the table in which the change occurred.varchar40 
 AP_FIELD_NAMEIf the property change was saved in the database, the field (column) that was changed.varchar40 
 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.

varchar50 
 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.

varchar2000 
 AP_NEW_VALUE

The value resulting from the change for types other than timestamp or large object fields.

NULL for timestamp and large object.

varchar2000 
 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.

varchar16 
 AP_NEW_LONG_VALUE

The value resulting from the change for large object fields, such as memo fields.

If not a large object, NULL.

varchar16 
 AP_OLD_DATE_VALUE

The value before the change for timestamp fields.

If there is no previous value or if not a timestamp , NULL.

datetime4 
 AP_NEW_DATE_VALUE

The value resulting from the change for  timestamp fields.

If not a timestamp , NULL.

datetime4 

See Also