The Reserved Numbers table contains the data related to all Reserved numbers for the specified Resp Org (see Table 93 RHDB_RESERVEDNUMBERS).
Included in this table are the following fields:
- Toll Free Service Dial Number.
- Control Resp Org that owns the Dial Number.
- Current status of the Dial Number.
- Login ID that last updated the Dial Number.
- The date the Dial Number will be returned to Spare.
- The date the Dial Number was Reserved.
- The last update date for the record.
Table 93 RHDB_RESERVEDNUMBERS
|
RHDB_RESERVEDNUMBERS |
||
|
Field |
Characters |
Description |
|
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 seven-digit NXX-LINE number. |
|
RespOrg |
varchar2(5) |
Control Resp Org that owns the Dial Number. |
|
NumberStatus |
varchar2(1) |
Status of Dial Number in Number Administration. |
|
LogonId |
varchar2(8) |
Login ID that last updated the Dial Number. |
|
ReservedUntilDate |
Date |
Date the Dial Number will be returned to Spare. |
|
StatusChangeDate |
Date |
Date the Dial Number was Reserved. |
|
ExtractDate |
Date |
Date the record was last added/updated in Reporting. |
|
Create_Time |
Timestamp(6) |
The date and time the record was last updated in the SMS/800 TFN Registry. |
|
Update_Time |
Timestamp(6) |
The date and time the record was last updated in the SMS/800 TFN Registry. |
|
Create_LoginID |
varchar2(8) |
The mandatory data field that identifies the Login ID of the SMS/800 TFN Registry user that created the record. |
|
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. |
Index for RHDB_RESERVEDNUMBERS Table
The index and fields used for the RHDB_RESERVEDNUMBERS table are:
|
RHDB_RESERVEDNUMBERS |
|
|
Index Name |
Fields Used |
|
rhdb_ ReservedNumbers _idx1 |
|