TFNRegistry Reporting: NPA Code Opening Affected Records Table (RHDB_NPAOPEN_AFFECTED) – Somos

The NPA Code Opening Affected Records table contains data related to all records affected by an NPA Code Opening for the Controlling (current, old) Responsible Organization (Resp Org), which has update permission (see table below).

Included in this table are the following fields:

The new NPA being created.
The date for the report that the records were resident in the TFNRegistry.
The new NPA opening date.
The record Toll-Free Number (TFN) that was unable to be converted or scheduled.
The Effective Date for the record.
Indicator identifying if the record will be converted by the NPA Code Opening Process or if manual conversion is required.
The current status of the record.
The Resp Org for the TFN.
The Areas of Service (AOS) Region, AOS State, AOS NPA, and AOS Label affected by the NXX Move.
An indicator identifying if the following are affected by the NXX Move:
- Call Processing Record (CPR) NPA Node and CPR State
- Label Definitions (LAD) NPA and LAD State Types

RHDB_NPAOPEN_AFFECTED
Field	Characters	Description
NewNpa	char(3)	The new NPA that is being created.
RunDateTime	Date	This report data is based on the records resident in the TFNRegistry.
OpenStartDate	Date	The date the new NPA is scheduled to open.
DialNbr	varchar2(15)	The Toll-Free Number (TFN) or Template Name of the record that the conversion process was unable to convert or schedule.
EffectiveDate	Date	The Effective Date/Time of the listed Record.
AutoManualFlag	char(1)	Indicates if the record will be converted by the NPA Code Opening process or if manual conversion will be required.
CrStatus	char(1)	The status of the record. Status and definitions are: A - Active D - Disconnect with Referral Yes F - Failed H - Hold I - Invalid M - Must Check P - Pending S - Sending U - Saved
RespOrg	char(5)	The Resp Org for the TFN.
AosRegionAff	char(1)	Indicates if the AOS Region is affected by the NPA Code Opening. Values are: 0 = Not Affected 1 = Affected
AosStateAff	char(1)	Indicates if the AOS State is affected by the NPA Code Opening. Values are: 0 = Not Affected 1 = Affected
AosNpaAff	char(1)	Indicates if the AOS NPA is affected by the NPA Code Opening. Values are: 0 = Not Affected 1 = Affected
AosLabelAff	char(1)	Indicates if the AOS Label is affected by the NPA Code Opening. Values are: 0 = Not Affected 1 = Affected
CprNpaAff	char(1)	Indicates if the CPR NPA Node is affected by the NPA Code Opening. Values are: 0 = Not Affected 1 = Affected
CprStateAff	char(1)	Indicates if the CPR State is affected by the NPA Code Opening. Node Values are: 0 = Not Affected 1 = Affected
LadNpaAff	char(1)	Indicates if the LAD NPA Type is affected by the NPA Code Opening. Values are: 0 = Not Affected 1 = Affected
LadStateAff	char(1)	Indicates if the LAD State Type is affected by the NPA Code Opening. Values are: 0 = Not Affected 1 = Affected

Index for RHDB_NPAOPEN_AFFECTED Table

The index and fields used for the RHDB_NPAOPEN_AFFECTED table are:

RHDB_NPAOPEN_AFFECTED
Index Name	Fields Used
rhdb_NPAOpen_Affected _idx1	NewNpa DialNbr EffectiveDate
rhdb_NPAOpen_Affected_idx2	RespOrg
rhdb_NPAOpen_Affected_idx3	RespOrg NewNpa