HP ALM Database Reference
td.AUDIT_LOG Table

Description

Events on which history is recorded.

Remarks

Details of the changes caused by the audited events are in the AUDIT_PROPERTIES Table.

The AUDIT_LOG and AUDIT_PROPERTIES tables replace the HISTORY table, which no longer exists.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key AU_ACTION_IDThe record ID.int4  
 AU_FATHER_IDFor backward compatibility. Field may be removed in future version.int4  
 AU_USERThe user name of the user who performed the action.varchar2000  
 AU_SESSION_IDThe ALM session ID of the session in which the action was performed.int4  
 AU_TIMEThe timestamp of the audit record according to the database server clock.datetime4  
 AU_ACTIONThe type of event. For example: INSERT, UPDATE, DELETE, and so on.varchar200  
 AU_ENTITY_TYPEThe name of the table in which the change occurred.varchar200  
 AU_ENTITY_IDThe record ID of the changed record in the table specified by AU_ENTITY_TYPE.varchar200 
 AU_DESCRIPTIONThe audit record description.varchar16 

See Also