Description: Find all usernames accessing KFS and KR tables with PII data that has an action other than select. Only six-months worth of data is kept in the audit table.
...
where ACTION_NAME <> 'SELECT';
Other Information -
ACH_UAT_USR_RO etlprod.its.uconn.edu is a production userid, used by the etl group. A The userid is used in a datastage process extracts CORE-CT ACH data and updates the PDP_PAYEE_ACH_ACCT_T with that data. Information about ACH can be found in ACH Table Load.
Results by year:
...