Database View PAYREPAIR_AUDIT

When the Payment Repair database component is loaded in the FTM database, a view named PAYREPAIR_AUDIT is loaded. Querying the Payment Repair audit table provides records with the data shown in Table 1:
Table 1. PAYREPAIR_AUDIT
Column Name Description
CREATED The time the audit point was logged and shown as UTC
COMPONENT The Payment Repair component name. Component names for Payment Repair all begin with the string ‘PayRepair’. Component names include:
PayRepairUI
a web-based user interface component
SOURCE For actions initiated from the user interface, this is the logged in user ID responsible for initiating the action. For actions initiated by an application, this is an IP address.
ACTION Actions that apply to repair operator statistics are:
  • Holds FWD items
  • Holds RTN items
  • IZQRP110A: Worklist generated
  • IZQRP115A: Invalid repair
  • IZQRP120A: Valid repair
  • IZQRP125A: Rejected reject
  • IZQRP130A: Accepted reject
  • IZQRP135A: Rejected deferral
  • IZQRP140A: Accepted deferral
  • Recall pending item
  • Skip item
Actions that apply to repairable state changes are:
  • Declare an item as new
  • Declare an item as new for review
  • Declare an item unresolved
  • Defer an item
  • Finalize pending item
  • Recall pending item
  • Repair an item
  • Reset all locks
  • Skip item
  • Unsuccessful repair attempt
Actions that apply to Payment Repair configuration state changes are:
  • Add key mapping
  • Add priority control forward
  • Delete key mapping
  • Delete priority control forward
  • Screen options group assignment
  • Update key mapping
  • Update priority control forward
  • Update properties
MODULE This is the name of a sub-component that produces an action. Source values include:
  • OperatorRepairPage – The Operator Repair page was used to make a disposition.
  • DeferredItemRepairPage – The Deferred Item Repair page was used to make a disposition.
  • RepairServlet – A system component that performs internal actions while the user is logged on.
  • SessionListener – A system component that performs internal actions when the user session ends either because of logging out or timing out.
PAYMENTID This is the payment ID that was the target of an action.
UPDATES This is a list of updated field values for a payment ID when the action is repair an item or unsuccessful repair attempt.
ADVANCEMSEC Time interval, in milliseconds, between processing payments
REPAIRMSEC Time interval, in milliseconds to repair a payment before it is assigned a disposition
LOADMSEC Time interval, in milliseconds, from when a browser sends a list request until the first payment can be processed
LOADMAX The maximum number of payments for list load events