Previous Topic: Attribute_Name Table

Next Topic: Behavior_Template Table

Audit_Log Table

Contains all audit log entries.

Field

Data Type

Reference

Remarks

analyst

Byte 16

ca_contact::uuid

Specifies the user whose update generated this audit record.
Note: This is a foreign key.

attr_after_val

nvarchar(160)

 

Specifies the new value of the object's attribute that has changed.

attr_before_val

nvarchar(160)

 

Indicates the previous value of the object's attribute that has changed.

attr_name

nvarchar(80)

 

This is the object's attribute that has changed.

aud_opr

INTEGER

 

Indicates the type of operation that generated this entry, such as, update, insert, and delete.

audobj_name

nvarchar(10)

 

Used for tracking the object that has changed.

audobj_persid

nvarchar(30)

 

Used for tracking the object that has changed.

audobj_trkid

nvarchar(40)

 

Used for tracking the object that has changed.

audobj_uniqueid

nvarchar(30)

 

Used for tracking the object that has changed.

change_date

INTEGER

 

The change date value for this Audit_Log.

id

INTEGER

 

Specifies the unique (to the table) numeric ID.
Note: This is a primary key.

int1_rsrved

INTEGER

 

Reserved

int2_rsrved

INTEGER

 

Reserved

persid

nvarchar(30)

 

This is the Persistent ID (SystemObjectName:id).

str1_rsrved

nvarchar(25)

 

Reserved for future use by CA.