Example Query

Querying all of the columns from the PAYREPAIR_AUDIT view produces the example data shown in Figure 1.
Note: The created column data is truncated so the data fits better on the window.
Figure 1. Example Query
chq_izqc_exampleauditquery.jpg
These audit records show three payments were presented to operator izhadmin on March 27.
  • The operator viewed and repaired field 1 for PAYMENTID 216 and decided to repair the item again, so PAYMENTID 216 was recalled. After the item was recalled, the operator changed Field 1 to a different value.
    Note: In addition to the fields being changed, the VALIDATION_ERROR, USER_CODE, and additional fields were updated in the database for PAYMENTID 216.
  • Operator izhadmin viewed and deferred PAYMENTID 206.
  • Operator izhadmin viewed and repaired PAYMENTID 242. Field 5 was repaired.
  • Operator izqadmin viewed and repaired PAYMENTID 206 by updating Field 3 and changing Field 7 to blank.