TFNRegistry Reporting: What is The NPA Code Opening Scheduled Record Table (RHDB_NPAOPEN_SCHD)? – Somos

The NPA Code Opening Scheduled Record table contains data related to those records that were attempted to be automatically converted by the NPA Code Opening ID/Conversion process and scheduled to be sent to the appropriate SCPs. The records that were either changed in the time frame of NOW or were given a future Effective Date/Time. The data will only show those records that were attempted to be converted automatically by the TFNRegistry.

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 Toll-Free Number (TFN) that was unable to be converted or scheduled.
The Effective Date for the record.
The current status of the record.
The Responsible Organization (Resp Org) for the TFN.
The reason the record was rejected.
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 & CPR State
- Label Definitions (LAD) NPA & LAD State Types

RHDB_NPAOPEN_SCHD
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 on this date.
OpenStartDate	Date	The date the new NPA is scheduled to open.
DialNbr	varchar2(15)	The 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.
CrStatus	char(1)	The status of the record. Status and definitions are: A - Active D - Disconnect with Referral F - Failed H - Hold I - Invalid M - Must Check P - Pending S - Sending U - Saved
CvStatus	char(4)	Identifies the conversion status. ILST - Illegal Status. RNFD - Record Not Found. MODI - Customer Record Modified. CR modified before conversion, manual updates may be needed. CVSC - Conversion Successful. CRPR - Customer Record Processed. BKTD - Backtracked to DWNTM. CPSD - Copied and Scheduled. FAVL - Failed Validation. CPFA - Copy Failed Validation. CNCP - Cannot Copy. CVER - Conversion Error (contact Help Desk). ERCP - Conversion Error After Copy. CLEX - CPR or LAD Exists.
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_SCHD Table

The index and fields used for the RHDB_NPAOPEN_SCHD table are:

RHDB_NPAOPEN_SCHD
Index Name	Fields Used
rhdb_ NPAOpen_Schd _idx1	NewNpa DialNbr EffectiveDate
rhdb_NPAOpen_Schd_idx2	RespOrg
rhdb_NPAOpen_Schd_idx3	RespOrg NewNpa