sys_audit

The table below describes the sys_audit table.

This table contains the following foldable columns:

• sys_id_value
• documentkey_display_value
• documentkey_value
• fieldname_display_value
• fieldname_value
• internal_checkpoint_display_value
• internal_checkpoint_value
• newvalue_display_value
• newvalue_value
• oldvalue_display_value
• oldvalue_value
• reason_display_value
• reason_value
• record_checkpoint_display_value
• record_checkpoint_value
• sys_created_by_display_value
• sys_created_by_value
• sys_created_on_display_value
• sys_created_on_value
• sys_id_display_value
• tablename_display_value
• tablename_value
• user_display_value
• user_value

The primary key columns in this table are returnable.

Column Name	SQL Type	Updatable	Nullable
sys_id_value Primary Key	SQL_VARCHAR(64)	False	False
documentkey_display_value	SQL_VARCHAR(500)	True	True
documentkey_value	SQL_VARCHAR(256)	True	True
fieldname_display_value	SQL_VARCHAR(500)	True	True
fieldname_value	SQL_VARCHAR(256)	True	True
internal_checkpoint_display_value	SQL_VARCHAR(500)	True	True
internal_checkpoint_value	SQL_VARCHAR(80)	True	True
newvalue_display_value	SQL_VARCHAR(8000)	True	True
newvalue_value	SQL_VARCHAR(8000)	True	True
oldvalue_display_value	SQL_VARCHAR(8000)	True	True
oldvalue_value	SQL_VARCHAR(8000)	True	True
reason_display_value	SQL_VARCHAR(2000)	True	True
reason_value	SQL_VARCHAR(2000)	True	True
record_checkpoint_display_value	SQL_VARCHAR(500)	True	True
record_checkpoint_value	SQL_INTEGER(signed)	True	True
sys_created_by_display_value	SQL_VARCHAR(500)	False	True
sys_created_by_value	SQL_VARCHAR(80)	False	True
sys_created_on_display_value	SQL_VARCHAR(500)	False	True
sys_created_on_value	SQL_TIMESTAMP	False	True
sys_id_display_value	SQL_VARCHAR(500)	False	False
tablename_display_value	SQL_VARCHAR(500)	True	True
tablename_value	SQL_VARCHAR(256)	True	True
user_display_value	SQL_VARCHAR(500)	True	True
user_value	SQL_VARCHAR(80)	True	True