Audit Log Maintenance

Every time a Punch_dtl, Elapsed_dtl or Payroll_dtl record is created, edited, updated or deleted a record is created in a FTTT_Punch_dtl_History_mst, FTTT_Elapsed_dtl_History_MST or FTTT_Payroll_dtl_History_mst tables. A background task can be set up to regularly sweep records from the history tables to sub-tables. The background task, FTArchiveAuditDataSp, uses the Archive Every ## Days parameter to determine which records to move into the sub tables. The default value is 30 days so each time FTArchiveAuditDataSp is run the application validates in the history table for records older than 30 days. The findings are moved to the sub-table.

Adjacent to each transaction history’s archive information is a Clear Sub-table button. When this is invoked the transaction history’s sub-tables (FT_Punch_dtl_History_Archive_mst, FT_Elapsed_dtl_History_Archive_MST and FT_Payroll_dtl_History_Archive_mst is cleared).