The CCS Network - State - NPA Reports contain the CCS Network - State - NPA Reports are pre-defined reports available in the Reporting application. The information for these reports derived from the respective RHDB tables.
This report is combining 3 other reports and they are:
- “CCS Network - State - NPA By Network Report”
- “CCS Network - State - NPA By NPA Report”
- “CCS Network - State - NPA By State Report”
The following figure provides an example of the Changed NPA-NXXs Report (see Figure 173 CCS Network-State-NPA Summary Report).
Figure 173 CCS Network-State-NPA Summary Report
CCS Network - State - NPA Report Field Descriptions
The following table identifies the CCS Network - State - NPA report fields and their descriptions (see Table 49 CCS Network-State-NPA Report Field Descriptions).
Table 49 CCS Network-State-NPA Report Field Descriptions
|
CCS Network-State-NPA Report Field Descriptions |
|
|
Field |
Description |
|
Network |
Identifies the CCS Network codes. |
|
NPA |
Identifies the NPAs (area codes). |
|
State |
Identifies the State/Province codes. |
|
Status Indicator |
Indicates the status of CCS Network. Possible values are:
|
|
Effective Date |
Identifies the Effective Date of the listed CCS Network-State-NPA. |
|
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 Reports
The “RHDB_NETWORKSTATENPA” data source is used to create the CCS Network - State - NPA Reports. The fields used from this table are:
- Network
- State
- Npa
- Effectivedate
- Statusindicator
- Extractdate
- Create_logonid
- Update_logonid
- Create_time
- Update_time
Please Note: Please refer to Chapter 15.60 CCS Network - State - NPA Table (RHDB_NETWORKSTATENPA) for more information.