Purge/Archive columns and orders for listed tables

Products

• CA Advanced Authentication

Issue/Introduction

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?

Environment

Release:
Component: RSKFRT

Resolution

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"}