RAC data is viewable only by the Help Desk and Administrators. This table is only available via SQL*Net and Secure File Transfer Protocol (SFTP).
| RHDB_RACHISTORY | ||
| 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. |
Index for RHDB_RACHISTORY Table
The index and fields used for the RHDB_RACHISTORY table are:
| RHDB_RACHISTORY | |
| Index Name | Fields Used |
| rhdb_RACHistory_idx1 |
|
| rhdb_RACHistory_idx2 |
|
| rhdb_RACHistory_idx3 |
|