Purge/Archive columns and orders for listed tables

Document ID : KB000095736
Last Modified Date : 14/05/2018
Show Technical Document Details
Question:
This is the doc for purge data -- https://docops.ca.com/ca-advanced-authentication/9-0/en/building/master-master-replication-support/master-master-support-for-ca-risk-authentication/database-tables-replication-advice/ca-risk-authentication-database-tables/database-tables-archival-recommendations But there is no column listed for each table, some of which has more than one date column listed. Can you please provide that. Also, is there any order has to follow during purge/archive process?
Answer:
Here is the Column Name used for Purge process in Audit Tables.

{"ARADMINAUDITTRAIL", "TIMESTAMP"}, 
 {"ARUDSCONFIGAUDITLOG", "TXTIMESTAMP"}, 
 {"ARUDSORGANIZATIONAUDITLOG", "TXTIMESTAMP"}, 
 {"ARUDSUSERAUDITLOG", "TXTIMESTAMP"}, 
 {"ARWFADMINAUDITLOG", "DATECREATED"}, 
 {"ARWFAUTHAUDITLOG", "DATECREATED"}, 
 {"ARWFISSUANCEAUDITLOG", "DATECREATED"}, 
 {"ARWFSVRMGMTAUDITLOG", "DATECREATED"}, 
 {"ARDBAUDITLOG", "LogTimestamp"}, 
 {"ARAUTHAUDITLOG", "DATELOGGED"}, 
 {"ARUDSAUDITLOG", "TXTIMESTAMP"}, 
 {"ARADMINAUDITLOG", "CREATETIME"}, 
 {"ARRFCASEAUDITLOG", "DTCREATED"}, 
 {"ARRFINSTANCEAUDITLOG", "OPERATIONTIME"}, 
 {"ARRFSYSAUDITLOG", "DATELOGGED"}, 
 {"ARRFUPLOADAUDITLOG", "UPLOADDATETIME"}, 
 {"ARRFSYSAUDITLOG_3DSECURE", "DATELOGGED"}