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:
|
| CvStatus | char(4) | Identifies the conversion status.
|
| 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:
|
| AosStateAff | char(1) | Indicates if the AOS State is affected by the NPA Code Opening. Values are:
|
| AosNpaAff | char(1) | Indicates if the AOS NPA is affected by the NPA Code Opening. Values are:
|
| AosLabelAff | char(1) | Indicates if the AOS Label is affected by the NPA Code Opening. Values are:
|
| CprNpaAff | char(1) | Indicates if the CPR NPA Node is affected by the NPA Code Opening. Values are:
|
| CprStateAff | char(1) | Indicates if the CPR State is affected by the NPA Code Opening. Node Values are:
|
| LadNpaAff | char(1) | Indicates if the LAD NPA Type is affected by the NPA Code Opening. Values are:
|
| LadStateAff | char(1) | Indicates if the LAD State Type is affected by the NPA Code Opening. Values are:
|
Index for RHDB_NPAOPEN_SCHD Table
| RHDB_NPAOPEN_SCHD | |
| Index Name | Fields Used |
| rhdb_ NPAOpen_Schd _idx1 |
|
| rhdb_NPAOpen_Schd_idx2 |
|
| rhdb_NPAOpen_Schd_idx3 |
|