The Customer Record Audit Results Report is a pre-defined on-demand report that is initiated from an output to the Reporting, which shows the results of a comparison between the following 2 versions of the Customer Record:
4. The translated TFNRegistry version
5. The SCP version
The Customer Record Audit Results Report supports Customer Records, Pointer Records and Template Records. This report presents all the results from every audited SCP for a specific Toll-Free Number or Template Name (see Figure 124 Customer Record Audit Results Report).
Figure 124 Customer Record Audit Results Report
Customer Record Audit Results Field Descriptions
The following table identifies the Customer Record Audit Results fields and their descriptions (see Table 19 Customer Record Audit Results Field Descriptions).
Table 19 Customer Record Audit Results Field Descriptions
Customer Record Audit Results Field Descriptions |
|
Field |
Description |
Entity |
An identifier for the Entity. |
Resp Org |
An identifier for the Resp Org. |
Toll-Free Number/Template |
Identifies the Toll-Free Number or Template Name for which the audit was performed. |
Requested At |
Identifies the date and time the audit request was requested. |
Login By |
Identifies the Login ID of the person who issued the audit request. |
SCP ID |
Identifies the SCPs audited. |
Audit Results |
Identifies the results from each of the audited SCPs. Possible value:
|
Arrived At |
Identifies the date and time when SCP response was received by the TFNRegistry. |
Effective Date/Time |
Identifies the Effective Date and Time for the Customer Record. |
Last Refresh Date/Time |
Identifies the date and time the report was last refreshed. |
Record Count |
Display the count of records associated with the filtered data set (xxxxxxx) and the grand total of records (yyyyyyy) formatted as xxxxxxx/yyyyyyy. |
Data Source Used to Create the Report
The “RHDB_CRAUDITRESULTS” data source is used to create the Customer Record Audit Results report. The fields used from this table are:
- Arrived At
- Audit Results
- By
- Effective Date/Time
- Entity
- Last Updated Date/Time
- Requested At
- Resp Org
- SCP ID
- Toll-Free Number/Template
Please Note: Please refer to Chapter 15.7 Customer Record Audit Results Table (RHDB_CRAUDITRESULTS) for more information.