The Unavailable Numbers table includes data related to all Unavailable numbers for the specified Resp Org.
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.
| 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 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_UNAVAILABLENUMBERS Table
| RHDB_UNAVAILABLENUMBERS | |
| Index Name | Fields Used |
| rhdb_ UnavailableNumbers _idx1 |
|