Documentation  >  Ticket / Locator Reports  > 

Audit Comparison

The Audit Comparison report is used to verify that all the tickets on the audits received from the one call center have been successfully received and processed within TicketRx.

It is important to run the Audit Comparison report on a daily basis. This will help prevent situations where a utility is not located because a ticket was sent by the call center, but not received by the TicketRx system.

The Audit Comparison report screen is shown below:

Process

Audit results are automatically calculated by the system. When a new transmission arrives it's marked as "NOT ON AUDIT", when a new audit is received its items are marked as "UNKNOWN". Every few minutes a process runs that tries to reconcile transmissions with audits. Typically audits are received overnight, so it usually will only make sense to run an Audit Comparison report for up to the previous day.

Parameters

• Audit Date - The date range of audits to check. This is an intensive report so short date ranges are preferred.
• Ticket Feed - The feeds to include in the report.
• List each ticket - If checked, the report will include information about each individual ticket. If it is not checked, the report will only have summary data for each feed. It is useful to run the report for several feeds at a time without the ticket-level detail. Then if there are any issues, run the report run again for a specific feed and with ticket-level detail turned on.
• Include raw audit text - If checked, a copy of the audit sent from the one call center will be included in the report.

Report Output

The Audit Comparison report contains the following fields:

• Ticket / Trans. Number - The ticket number as assigned by the one-call center.

• Sequence Number - The transmission sequence number as defined by the one-call center.

• Received? - Indicates the result of comparing the ticket numbers on the audits with the ticket numbers in TicketRx. The possible values are:

  • NOT ON AUDIT - ticket was received during audited period but is not included on the audit
  • EMPTY AUDIT - audit doesn't contain any ticket numbers
  • NOT RECEIVED - ticket number from audit was never received
  • NOT SAME DAY - ticket was not received within the audited period

The Tickets Received Detail report provides a way to identify missing tickets if the end-of-day audit transmissions have not been received.