The Reserved Numbers table contains the data related to all Reserved numbers for the specified Resp Org.
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.
| 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 TFNRegistry. |
| Update_Time | Timestamp(6) | The date and time the record was last updated in the TFNRegistry. |
| Create_LoginID | varchar2(8) | The mandatory data field that identifies the Login ID of the TFNRegistry user that created the record. |
| Update_LoginID | varchar2(8) | The mandatory data field that identifies the Login ID of the TFNRegistry user who last updated the record. |
Index for RHDB_RESERVEDNUMBERS Table
| RHDB_RESERVEDNUMBERS | |
| Index Name | Fields Used |
| rhdb_ ReservedNumbers _idx1 |
|