Touchstone Re 2022 Database Reference
tAuditHistory Table
AIRProject Database : tAuditHistory Table
Description

Stores audit records.

The application creates audit records for changes users make, such as:

  • Saving a change in the Administration Console
  • Running an analysis
  • Creating, updating, or deleting exposure data, and so on
Properties
Creation Date4/4/2022 3:02 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key Unique system-generated sequential identifier for the audit record.int4   
 

Code that represents the type of the audit record target.

The target is the object that the user created or modified.

For a complete list of codes, see tAuditTargetType Table.

varchar15   
 Unique system-generated sequential identifier for the audit record target.int4   
 

Code that represents what the user did to the audit record target.

For a complete list of codes, see tAuditActionType Table.

varchar15   
 User that made the change.varchar255   
 Date and time when the user made the change.datetime4   
 User-specified description of the change.varchar4000   
 Unique system-generated business unit sequential identifier for the audit record.int4  
Objects that depend on tAuditHistory
 Database ObjectObject TypeDescriptionDep Level
tAuditHistoryParentObjectXRef tabletAuditHistoryParentObjectXRefTable

System reference table used to identify the parent object associated with each audit record.

A parent object is a higher-level container for an object. For example, the parent object for an exposure set is a company.

1
See Also

Related Objects

AIRProject Database