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 (see Table 83 RHDB_NAACTLOG).
Table 83 RHDB_NAACTLOG
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 SMS/800 TFN Registry user that created the record. |
Create_Time |
Timestamp (6) |
The date and time the record was last updated in the SMS/800 TFN Registry. |
Update_LoginID |
Varchar2 (8) |
The mandatory data field that identifies the Login ID of the SMS/800 TFN Registry user who last updated the record. |
Update_Time |
Timestamp (6) |
The date and time the record was last updated in the SMS/800 TFN Registry. |
Index for RHDB_NAACTLOG Table
The index and fields used for the RHDB_NAACTLOG table are:
RHDB_NAACTLOG |
|
Index Name |
Fields Used |
rhdb_ NAActLog _idx1 |
|
rhdb_ NAActLog _idx2 |
|
rhdb_ NAActLog _idx3 |
|