The Destination NPA-NXX table includes data related to the destination Plain Old Telephone Service (POTS) numbers and DIAL#s associated with the POTS# for the specified controlling Resp Org.
Included in this table are the following fields:
- Controlling Resp Org that owns the Dial Number.
- Toll-Free Number (also known as the Dial Number).
- The Effective Date of the Dial Number.
- The current status of the Customer Record.
- The current status of the Dial Number in Number Administration.
- The Local Serving Office (LSO, LsvcOff).
- The Foreign Serving Office (FSO, FsvcOff), which is used when the LSO cannot process the calls.
- An indicator denoting whether or not a CPR exists for the Dial Number.
- The NPA-NXX of the terminating number.
- The terminating number.
- The date the record was last updated.
| RHDB_DESTNPANXX | ||
| Field | Characters | Description |
| ControlRespOrg | char(5) | Control Resp Org that owns the Dial Number. |
| DialNbr | varchar2(12) | Toll-Free Number (also known as the Dial Number). |
| EffectiveDate | Date | Effective Date of the Dial Number. |
| CrStatus | char(1) | The status of the Customer Record. Status and definitions are:
|
| NumberStatus | char(1) | The status of a DIAL#:
|
| FsvcOff | char(6) | Foreign Service Office. |
| LsvcOff | char(6) | Local Service Office. |
| CprInd | char(1) | Indicator to denote whether or not a CPR exists for the Dial Number. |
| DestNpaNxx | char(6) | NPA-NXX of the terminating number. |
| DestTelNumber | char(10) | Terminating number. For example, 8003334444. |
| ExtractDate | Date | Date the record was last added/updated in Reporting. |
| Create_LoginID | Varchar2 (8) | The mandatory data field that identifies the Login ID of the TFNRegistry user that created the record. |
| Update_LoginID | Varchar2 (8) | The mandatory data field that identifies the Login ID of the TFNRegistry user who last updated the record. |
| Create_Time | Timestamp (6) | The date and time the record was last updated in the TFNRegistry. |
| Update_Time | Timestamp (6) | The date and time the record was last updated in the TFNRegistry. |
Index for RHDB_DESTNPANXX Table
The index and fields used for the RHDB_DESTNPANXX table are:
| RHDB_DESTNPANXX | |
| Index Name | Fields Used |
| rhdb_ DestNpaNxx _idx1 |
|