The CCS Network - LATA Report contains the CCS Network - LATA Report is a pre-defined report available in the Reporting. The information for these reports derived from the respective RHDB tables.
This report is combining 4 other reports and they are:
- CCS Network-LATA By LATA Report-Active
- CCS Network-LATA By LATA Report-Pending
- CCS Network-LATA By Network Report-Active
- CCS Network-LATA By Network Report-Pending
The information for these reports are from the CCS Network-LATA table, which is maintained by Administrators (i.e. Somos and its Help Desk) of the SMS/800 TFN Registry. The following figure provides an example of the CCS Network - LATA Reports (see Figure 175 CCS Network LATA Report)
Figure 175 CCS Network LATA Report
CCS Network - LATA Report Field Descriptions
The following table identifies the CCS Network - LATA report fields and their descriptions (see Table 51 CCS Network LATA Report Field Descriptions).
Table 51 CCS Network LATA Report Field Descriptions
CCS Network LATA Report Field Descriptions |
|
Field |
Description |
Network |
Identifies the CCS Network codes. |
LATA |
Identifies the LATA numbers. |
Status Indicator |
Indicates the status of CCS Network - LATA. Possible values are:
|
Effective Date |
Identifies the Effective Date of the listed in CCS Network-LATA mapping. |
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_NETWORKLATA” data source is used to create the CCS Network - LATA Report. The fields used from this table are:
- Network
- Lata
- Effectivedate
- Statusindicator
- Extractdate
- Create_logonid
- Update_logonid
- Create_time
- Update_time
Please Note: Please refer to Chapter 15.59 CCS Network - LATA Table (RHDB_NETWORKLATA) for more information.