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) (see Table 123 RHDB_RACHISTORY).
Table 123 RHDB_RACHISTORY
|
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 |
|