TFNRegistry Reporting: What is The Records Rejected by NPA Code Opening Report? – Somos

The Records Rejected by Conversion for NPA Code Opening Report lists those records rejected by the NPA Code Opening ID/Conversion process. It is possible that records on this report that have been converted automatically will not pass all validations. If after the conversion, the record is anything but Pending or Hold status, the Resp Org should check the report content to see if it needs manual conversion.

Therefore, this report may show invalid records that need to be acted upon manually by the Resp Org. This report contains records identified as having AOS changes that were rejected when the conversion was processed and need to have manual intervention. The Resp Org should look at the reason the record was rejected along with the explanation of the further action that should be taken. The changes required to these rejected records should be made as soon as possible after the report is received.

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.

Records Rejected by NPA Code Opening Field Descriptions
Field	Description
Entity	An identifier for the Entity.
Resp Org	An identifier for the Responsible Organization (Resp Org).
New NPA	The new NPA that is being created.
Toll-Free Number/Template	Identifies the Toll-Free Number (TFN) or Template Name for which the audit was performed.
NPA Code Opening Date	The date the new NPA is scheduled to open.
As Of	The date the NPA Code Opening ID/Conversion process searches the Customer Record database in order to generate the report.
Affected Area	An indication of the area of the record that is affected by the NPA Code Opening. Select a value from the list of affected areas: AOS REGION AOS STATE AOS NPA AOS LABEL CPR NPA CPR STATE NODE LAD NPA TYPE LAD STATE TYPE
CR Status	Identifies the status of the affected record. Possible values: A – Active D - Disconnect F - Failed H - Hold I - Invalid M - Must Check O - Old P - Pending S – Sending U - Saved
Reason Rejected	A brief statement of the reason that the record was rejected. See EXPLANATION and FURTHER ACTION for an explanation of the reason rejected. Some examples are: CANT COPY (CAN’T COPY CR): Record exists later manual updates may be needed. CONV. ERROR (CONVERSION ERROR): Check affected areas. CPY FAL VAL (COPY FAILED VALIDATION): Check record. DIDN’T GET CON.CR MODIFIED: Record modified before conversion manual updates may be needed. CR NOT FOUND (CR NOT FOUND): Possibly deleted ensure active record is okay. CR STATUS: Invalid CR status for conversion check Aff. areas & CR status. FAIL VALID. (CR FAILED VALIDATION): Check valid. results report.
Effective Date/Time	Identifies the Effective Date and Time for the 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_NPAOPEN_RJCT” data source is used to create the Customer Records Rejected by NPA Code Opening report. The fields used from this table are:

Affected Area
As Of
CR Status
Effective Date/Time
Entity
New NPA
NPA Code Opening Date
Reason Rejected
Resp Org
Toll-Free Number/Template

Please Note: For more information. NPA Code Opening Rejected Record Table (RHDB_NPAOPEN_RJCT)