The Number Administration Report table contains current number administration information for each Toll-Free Number, including Resp Org and current number status information (see Table 84 RHDB_NAREP).
Table 84 RHDB_NAREP
RHDB_NAREP |
||
Field |
Characters |
Description |
NPA |
varchar2(3) |
Number Plan Area. This field specifies the NPA of the DIAL# being requested. The first three digits of a DIAL#. Examples: 800, 888, 877, 866, 855, 844 and 833. |
TelNumber |
varchar2(7) |
The 7-digit NXX-LINE number. Example: In the Toll Free number 800-333-4444, the TelNumber is 3334444. |
TelNumberSt |
varchar2(2) |
Please Note: This field will always be empty. |
Entity |
varchar2(2) |
The first two characters in the Resp Org (Responsible Organization) field. Example: BR is the Entity in Resp Org BRNJ1. |
Org |
varchar2(3) |
The last three characters in the Resp Org field, representing the organization. Example: NJ1 is the organization in Resp Org BRNJ1. |
NumberStatus |
varchar2(1) |
The status of a DIAL#:
|
LogonId |
varchar2(8) |
The Login ID who last updated the number. |
ReservedUntilDate |
Date |
If the number status is Reserved (R), this field will be populated with the day the number will be changed to Spare. If the number status is Transitional (T), this field will be populated with the day the number will be changed to Spare. If the number status is Disconnect (D), this field will be populated with the day the number will be changed to Transitional. |
StatusChangeDate |
Date |
The date when the status was changed. |
DialNbr |
varchar2(12) |
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 7-digit NXX-LINE number. |
RespOrg |
varchar2(5) |
The Responsible Organization. |
Comments |
varchar2(72) |
Information the user wishes to enter in this field. |
Download_date |
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_NAREP Table
The index and fields used for the RHDB_NAREP table are:
RHDB_NAREP |
|
Index Name |
Fields Used |
rhdb_ NARep _idx1 |
|
rhdb_ NARep _idx2 |
|
rhdb_ NARep _idx3 |
|
rhdb_NARep_idx4 |
|
rhdb_NARep_idx5 |
|
rhdb_NARep_idx6 |
|