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 |
|