The Number Administration Activity Log table contains information on changes made by online users to Number Administration records for each day, 7 days of data are kept.
| RHDB_NAACTLOG | ||
| Field | Characters | Description |
| RespOrg | char(5) | The Resp Org. |
| DialNbr | varchar2(15) | A 10 digit Toll-Free Number (DIAL#) in the format NPANXXLINE without any dashes or blank spaces. A DIAL# is comprised of a Number Plan Area (NPA) and a seven-digit NXX- LINE number. Example: 8770004444. |
| ActivityDate | Date | The date and time that the activity occurred. |
| MSecs | number(3) | Milliseconds of the ActivityDate. |
| LogonId | char(3) | The assigned Login ID. The last three characters of the full Login ID. |
| ResvUntilDate | Date | The reserved until date if the DIAL# is reserved. |
| ActivityStatus | char(2) | The status of the activity. Possible values and definitions 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. |
Index for RHDB_NAACTLOG Table
| RHDB_NAACTLOG | |
| Index Name | Fields Used |
| rhdb_ NAActLog _idx1 |
|
| rhdb_ NAActLog _idx2 |
|
| rhdb_ NAActLog _idx3 |
|