The Destination NPA-NXX Report lists the destination POTS# numbers and Toll-Free Numbers associated with the POTS# for the specified controlling Resp Org past.
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.
Destination NPA-NXX Field Descriptions
The following table identifies the Destination NPA-NXX fields and their descriptions.
| Destination NPA-NXX Field Descriptions | |
| Field | Description |
| Entity | An identifier for the Entity. |
| Resp Org | An identifier for the Resp Org. |
| Destination-POTS# | The destination number. |
| Toll-Free Number | Toll-Free Number associated with the POTS#. |
| Number Status |
The status of the Toll-Free Number. Possible values:
|
| LSO | The Local Serving Office (LSvcOff). |
| FSO | The Foreign Serving Office (FSvcOff). Used when the LSO cannot process the calls. |
| Effective Date | Identifies the Effective Date of the Customer Record. |
| Last Updated Date/Time | The date/time when the data updated in the Transactional database (when activity occurred). |
| Last Refresh Date/Time | Identifies the date and time when 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_DESTNPANXX” data source is used to create the Destination NPA-NXX report. The fields used from this table are:
- Controlresporg
- Dialnbr
- Effectivedate
- Crstatus
- Numberstatus
- Fsvcoff
- Lsvcoff
- Cprind
- Destnpanxx
- Desttelnumber
- Extractdate
- Create_Logonid
- Update_Logonid
- Create_Time
- Update_Time
Please Note: Please refer to the Destination NPA NXX Table (RHDB_DESTNPANXX) for more information.