The Resp Org List report is a monthly list of information on all the Resp Orgs known to the SMS/800 TFN Registry. The following figure provides an example of the Resp Org List report (see Figure 176 Resp Org List Report).
Figure 176 Resp Org List Report
Resp Org List Report Field Descriptions
The following table identifies the Changed NPA-NXXs report fields and their descriptions (see Table 52 Resp Org List Report Field Descriptions).
Table 52 Resp Org List Report Field Descriptions
|
Resp Org List Report Field Descriptions |
|
|
Field |
Description |
|
Entity |
An identifier for the Entity. |
|
Resp Org |
An identifier for the Resp Org. |
|
Trouble Referral Number |
The contact number to help resolve issues with a specific Toll-Free Number. |
|
Status |
Possible status values are:
|
|
Company Name |
The date and time the report was created. |
|
Last Updated Date/Time |
The date of the data updated in the Transactional database. |
|
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_RESPORG” data source is used to create the Resp Org List Report. The fields used from this table are:
- Resporg
- Daorg
- Dabill
- Troublereferralnbr
- Resporgname
- Effectivedate
- Statusindicator
- Extractdate
- Create_logonid
- Update_logonid
- Create_time
- Update_time
Please Note: Please refer to Chapter 15.61 Resp Org List Table (RHDB_RESPORG) for more information.