Viewing the Purge Log Table

During execution, the Transaction Purge process writes to a log table called SCC_SL_PURG_LOG regardless of the value set for SCC_UPDATE_SW. The log table enables you to see the purge results based on the criteria you define before and after tables are updated. This record is added to the QUERY_TREE_CC access group of CTM PURGE.

SCC_SL_PURG_LOG has the following fields:

Field	Description
PROCESS_INSTANCE	Contains the system-generated process instance
OPRID	Operator who ran the purge process
RUN_CNTL_ID	Specifies the run control ID
SEQNBR	An incremental number to allow multiple transaction codes
SCC_TRANSAC_CD	Contains 1 to n transaction codes as defined within the run control ID When processing constituents either by a single temporary ID, or as a set as defined using Population Section, this field will contain the literal value [By Constituent]. Otherwise, it will contain the actual transaction code you specified.
SCC_TRANS_STS	Contains the related Transaction Status code you specified
SCC_STG_STATUS	Contains the related Staging Status code you specified When processing transactions that are defined as New User Registration, this field will contain the value '--'.
SCC_DATE_TIME	Date and time the Transaction Purge process was run.
SCC_UPDATE_SW	Specifies whether the data remained in the tables after execution of the Transaction Purge process. (Y)es = Yes, the data remained. No data was purged because the process ran in Test Mode. (N)o = No, the data was deleted. The tables were updated to purge the data based on the criteria you defined.
SCC_SL_REL_CONST	Specifies whether you requested that constituent data be deleted along with the transaction
SCC_TOT_ROW_COUNT	Specifies the total number of selected temporary IDs to be deleted. This number is generated whether or not the Transaction Purge process runs in Test Mode.
SCC_ELAPSED_TIME	Specifies the time it took to delete all the temporary IDs that comprise a specific transaction code. This number is generated whether or not the Transaction Purge process runs in Test Mode.
RECNAME	Specifies the record name that is related to the Transaction Code
SAD_WHERE_MSG254	Specifies the derived 'WHERE' clause for a specific Transaction Code as defined in the Transaction Purge criteria. When processing constituents, this field contains either a single temporary ID, the Population Selection query name, or file name.