| RHDB_RESPORG_SPARENUM_HIST | ||
| Field | Characters | Description |
| Dialnbr | Varchar2(12) | A 10 digit Toll-Free Number (DIAL#). |
| Resporg | Char(5) | Control Resp Org that owns the Dial Number. |
| Start_Date_of_Control | Date | The start date of Spare number control. |
| End_Date_of_Control | Date | The end date of Spare number control. |
| Days_Spare_Before_Acquisition | Number | The number of days TFN was in SPARE status before acquisition by the Resp Org. |
| Mode_of_Acquisition | Varchar2(25) | The TFN was acquired by the Resp Org through Reservation or Control Resp Org change. Possible Values:
|
| Last_Spared_Date | Date | Date of the last TFN Spared. |
| Resporg_Seq_No | Number | Data value to maintain uniqueness of table data. |
| Extractdate | Date | The date when the record was sent to the RHDB database. |
| Include | String | Displays only the TFNs associated with the Resp Org(s), specified in the Resp Org field. |
| Exclude | String | Displays the TFNs that are not associated with the Resp Org(s), specified in the Resp Org field. |