AUDIT_PROPERTIES Table

Details of the changes recorded in the AUDIT_LOG table.

For any given record, only the fields relevant to the type of the changed data have values. Fields for other data types are NULL.

Column Name	Description	Datatype	Length
AP_PROPERTY_ID	The record ID.	Integer	4
AP_ACTION_ID	The audit log record: AUDIT_LOG.AU_ACTION_ID	Integer	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.	LongVarChar	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.	LongVarChar	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.	DBTimeStamp	4
AP_NEW_DATE_VALUE	The value resulting from the change for timestamp fields. If not a timestamp , NULL.	DBTimeStamp	4

	Copyright 2002-2007 Mercury Interactive Corporation.
	Documentation comments or suggestions? Please send feedback to SW-Doc@hp.com