The CCS Network -State-NPA table contains the:
- CCS Network -State-NPA mapping
- Status and Effective Date
| 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 TFNRegistry™ user that created the record. |
| Create_Time | Timestamp (6) | The date and time the record was last updated in the TFNRegistry. |
| Update_LoginID | Varchar2 (8) | The mandatory data field that identifies the Login ID of the TFNRegistry user who last updated the record. |
| Update_Time | Timestamp (6) | The date and time the record was last updated in the TFNRegistry. |
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 |
|