The Records Scheduled by NPA Code Opening lists 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. This report will only show those records that were attempted to be converted automatically by the TFNRegistry™ (tfnregistry.somos.com).
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 Scheduled by NPA Code Opening Field Descriptions
The following table identifies Customer Records Scheduled by NPA Code Opening fields and their descriptions.
|
Records Scheduled 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:
|
|
CR Status |
Identifies the status of the affected record. Possible values:
|
|
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_SCHD” data source is used to create the Customer Records Scheduled by NPA Code Opening Report. The fields used from this table are:
- As Of
- CCS Network
- CR Status
- Effective Date/Time
- Entity
- New CCS Network
- Old CCS Network
- Reason Rejected
- Resp Org
- Rownum
- Schedule Date
- Scheduling End Date
- SCP AOS Expansion ID
- Toll-Free Number/Template
- Update Time
Please Note: For more information, please refer to the NPA Code Opening Scheduled Record Table (RHDB_NPAOPEN_SCHD).