The Unavailable Numbers table includes data related to all Unavailable numbers for the specified Resp Org (see Table 107 RHDB_UNAVAILABLENUMBERS).
Included in this table are the following fields:
- Control Resp Org that owns the Dial Number.
- Toll Free Service Dial Number.
- The current status of the Dial Number in Number Administration.
- The date the Dial Number was made Unavailable.
- Comments containing any notes related to the Number Administration Record.
- The date the record was last updated.
Table 107 RHDB_UNAVAILABLENUMBERS
RHDB_UNAVAILABLENUMBERS |
||
Field |
Characters |
Description |
DialNbr |
varchar2(12) |
A 10 digit Toll-Free Number (DIAL#). |
RespOrg |
varchar2(5) |
Control Resp Org that owns the Dial Number. |
NumberStatus |
varchar2(2) |
Status of Dial Number in Number Administration. |
StatusChangeDate |
Date |
Date the Dial Number went Transitional. |
Comments |
varchar2(72) |
Notes field in Number Administration Record. |
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_UNAVAILABLENUMBERS Table
The index and fields used for the RHDB_UNAVAILABLENUMBERS table are:
RHDB_UNAVAILABLENUMBERS |
|
Index Name |
Fields Used |
rhdb_ UnavailableNumbers _idx1 |
|