The Deficient Customer Records Report contains a list of CRs queried by you, based on Customer Record status, that are incomplete (that is, deficient) and not ready to be sent to the SCP(s). The Deficient Customer Records Report supports both regular Customer Records, Pointer Records and Template Records whereby the user enters a Toll-Free Number or a Template Name to request a record.
Records that are considered ‘Deficient’ can have a CR Status of FAILED, INVALID, MUST CHECK, SAVED, HOLD or PENDING. In the case of HOLD and PENDING records, a ‘Deficient’ record means it has an Effective Date/Time that is in the past.
Disclaimer: Any images in this article are intended to be used as a guide for educational purposes only and they may differ slightly from the Production Environment.
Deficient Customer Records Field Descriptions
The following table identifies the Deficient Customer Records fields and their descriptions.
|
Deficient Customer Records 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. |
|
CR Status |
CR status for the Toll-Free Number/Template. Possible CR Status values:
|
|
Effective Date/Time |
Identifies the Effective Date and Time for the Customer Record. |
|
Last Updated Date/Time |
The date and time updated in the Transactional database (when activity occurred). |
|
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_CRREPHDR_DEFICIENT” data source is used to create the Deficient Customer Records report. The fields used from this table are:
- CR Status
- Create Login ID
- Create Time
- Effective Date
- Entity
- Last Updated Date/Time
- Resp Org
- Toll-Free Number/Template
- Update Login ID
Note: Click here for more information about Customer Record Reports Header Table.