TFNRegistry Reporting: Records Affected by NPA Code Opening – Somos

The Records Affected by NPA Code Opening report contains all records affected by an NPA Code Opening for the Controlling (current, old) Resp Org who has update permission (see Figure 143 Records Affected by NPA Code Opening).

Figure 143 Records Affected by NPA Code Opening

Records Affected by NPA Code Opening Field Descriptions

The following table identifies the records affected by NPA Code Opening fields and their descriptions (see Table 33 Records Affected by NPA Code Opening Field Descriptions).

Table 33 Records Affected by NPA Code Opening Field Descriptions

Records Affected by NPA Code Opening Field Descriptions
Field	Description
Entity	An identifier for the Entity.
Resp Org	An identifier for the Responsible Organization (Resp Org).
Automatic and Manual Flag	Indicates if the record will be converted by the NPA Code Opening process or if manual conversion will be required.
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 CR database in order to generate the report.
CR Status	The status of the affected records. Possible statuses are: Pending Hold Invalid Saved Must Check Failed Active Sending Disconnect (with referral yes).
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
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_AFFECTED” data source is used to create the Customer Records Affected by NPA Code Opening report. The fields used from this table are:

Affected Area
As Of
Automatic Manual Flag
CR Status
Effective Date
Entity
New NPA
NPA Code Opening Date
Resp Org
Toll-Free Number/Template

Please Note: Please refer to Chapter 15.29 NPA Code Opening Affected Records Table (RHDB_NPAOPEN_AFFECTED) for more information.