The CCS Network -State-NPA table contains the:
- CCS Network -State-NPA mapping
- Status and Effective Date
Table 117 RHDB_NETWORKSTATENPA
|
RHDB_NETWORKSTATENPA |
||
|
Field |
Characters |
Description |
|
Network |
varchar2(2) |
The CCS Network codes. |
|
State |
varchar2(2) |
The State code. |
|
Npa |
varchar2(3) |
The NPA value. |
|
EffectiveDate |
Date |
The Effective Date for the Action (Pending Deletion or Pending Addition) of the listed CCS Network - LATA. |
|
StatusIndicator |
varchar2(1) |
Indicates the status of CCS Network. Possible values are:
|
|
ExtractDate |
Date |
The date when the record was sent to the RHDB database. |
|
Create_LoginID |
Varchar2 (8) |
The mandatory data field that identifies the Login ID of the SMS/800 TFN Registry user that created the record. |
|
Create_Time |
Timestamp (6) |
The date and time the record was last updated in the SMS/800 TFN Registry. |
|
Update_LoginID |
Varchar2 (8) |
The mandatory data field that identifies the Login ID of the SMS/800 TFN Registry user who last updated the record. |
|
Update_Time |
Timestamp (6) |
The date and time the record was last updated in the SMS/800 TFN Registry. |
Index for RHDB_NETWORKSTATENPA Table
The index and fields used for the RHDB_NETWORKSTATENPA table are:
|
RHDB_NETWORKSTATENPA |
|
|
Index Name |
Fields Used |
|
rhdb_ NetworkStateNPA _idx1 |
|
|
rhdb_ NetworkStateNPA _idx2 |
|
|
rhdb_ NetworkStateNPA _idx3 |
|
|
rhdb_ NetworkStateNPA _idx4 |
|