The NPA-NXX Delete Schedule Customer Record table contains data related to those Customer Records that were attempted to be automatically converted by the NPA-NXX Deletion conversion programs and scheduled to be sent to the appropriate SCPs. The Customer Records were either changed in place or were given a future Effective Date and Time. This data only includes those records that were attempted to be converted automatically by the TFNRegistry.
Included in this table are the following fields:
- The NPA-NXX to be deleted from the TFNRegistry.
- The date and time the database is searched.
- The Dial#.
- The Effective Date for the Customer Record.
- Customer Record status.
- The reason the record failed the conversion.
- The Responsible Organization for the DIAL#.
- The Area of Service (AOS) fields that may be impacted by the NPA- NXX LATA Move.
- The CPR fields that may be impacted by the NPA-NXX Delete.
- The LAD fields that may be impacted by the NPA-NXX Delete.
Table 92 RHDB_NXXDELETE_SCHD
| RHDB_NXXDELETE_SCHD | ||
| Field | Characters | Description |
| NpaNxx | char(6) | The NPA-NXX to be deleted from TFNRegistry. |
| RunDateTime | Date | The date and time the database is searched. |
| DialNbr | varchar2(15) | A 10 digit Toll-Free Number (DIAL#) or Template Name. |
| EffectiveDate | Date | The Effective Date/Time of the listed Customer Record. |
| CrStatus | char(1) | The status of the Customer Record. Status and definitions are:
|
| CvStatus | char(4) | Identifies the conversion status.
|
| RespOrg | char(5) | The Responsible Organization for the DIAL#. |
| AosLabelAff | char(1) | Indicates if the Area of Service label field is affected by the NXX Delete. Values are:
|
| TerminatingNbrAff | char(1) | Indicates if the Terminating Nbr field is affected by the NXX Delete. Values are:
|
| LsoAff | char(1) | Indicates if the LSO field is affected by the NXX Delete. Values are:
|
| FsoAff | char(1) | Indicates if the FSO field is affected by the NXX Delete. Values are:
|
| NPhoneAff | char(1) | Indicates if the NPhone field is affected by NXX Delete. Values are:
|
| CprSixAff | char(1) | Indicates if the CPR six digit field is affected by NXX Delete. Values are:
|
| CprNxxAff | char(1) | Indicates if the CPR NXX field is affected by NXX Delete. Values are:
|
| CprTenAff | char(1) | Indicates if the CPR Ten Digit field is affected by NXX Delete. Values are:
|
| CprTelnoAff | char(1) | Indicates if the CPR Telephone Number (Tel#) Node is affected by the NXX Delete. Values are:
|
| LadSixAff | char(1) | Indicates if the LAD Six digit field is affected by NXX Delete. Values are:
|
| LadNxxAff | char(1) | Indicates if the LAD NXX field is affected by NXX Delete. Values are:
|
| LadTenAff | char(1) | Indicates if the LAD Ten Digit field is affected by NXX Delete. Values are:
|
| LadTelnoAff | char(1) | Indicates if the LAD Tel# field is affected by NXX Delete. Values are:
|
| BillTnAff | char(1) | Indicates if the BILLTN field is affected by NXX Delete. Values are:
|
Index for RHDB_NXXDELETE_SCHD Table
| RHDB_NXXDELETE_SCHD | |
| Index Name | Fields Used |
| rhdb_ NXXDelete_Schd _idx1 |
|
| rhdb_ NXXDelete_Schd _idx2 |
|
| rhdb_ NXXDelete_Schd _idx3 |
|