RDC data is viewable only by the Help Desk and Administrators. This table is only available via SQL*Net and SFTP (see Table 124 RHDB_RDCHISTORY).
Table 124 RHDB_RDCHISTORY
| RHDB_RDCHISTORY | ||
| Field | Characters | Description |
| activityDate | Date | Date/time of the RAC record activity. |
| potsNumber | char (10) | The 10-digit POTS # of the RAC record. |
| modifiedBy | char (8) | Login ID of the person that did the RAC update or delete. The value will be set to "**LOAD**" if the RAC data record was populated in the RHDB during the initial load process on general availability (GA) date of this feature. The value will be set to "**AUDIT**" if the RAC data record was updated via an audit process. |
| Activitycode | char (1) | Indicates the type of activity of the data record. Valid values are:
(Meaning, the data was populated in RHDB on the general availability (GA) date of this new table). |
| extractDate | Date | The date when the record was sent to the RHDB database. |
| Ocn | char (4) | Operating Company Number (OCN) listed on the RAC record. |
| lecName | char (25) | Local Exchange Company (LEC) listed on the RAC record. |
| contactPhone | char (10) | Contact phone number of the LEC listed on the RAC record. |
| contactName | char (25) | Contact name of the LEC listed on the RAC record. |
| contactEmail | char (50) | Email address of the LEC contact on the RDC record. |
Index for RHDB_RDCHISTORY Table
The index and fields used for the RHDB_RDCHISTORY table are:
| RHDB_RDCHISTORY | |
| Index Name | Fields Used |
| rhdb_RDCHistory_idx1 |
|
| rhdb_RDCHistory_idx2 |
|
| rhdb_RDCHistory_idx3 |
|