The POTS to Toll-Free Number Summary Report provides all Toll-Free Numbers that have a status of Working or Disconnected terminating to specified Plain Old Telephone Service (POTS) numbers.
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.
POTS to Toll-Free Number Summary Field Descriptions
| POTS to Toll-Free Number Summary Field Descriptions | |
| Field | Description |
| Entity | An identifier for the Entity. |
| Resp Org | An identifier for the Resp Org. |
| Destination-POTS# | Identifies the POTS number to which the call is routed. |
| Toll-Free Number | The Toll-Free Number that has been assigned for the Customer Record. |
| Number Status |
|
| Effective Date | The Effective Date of the listed Toll-Free Number. |
| Last Updated Date/Time | The date and time updated in the Transactional database (when activity occurred). |
| 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_DESTNPANXX” data source is used to create the POTS to Toll-Free Number Summary 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