Table 133 RHDB_RESPORG_SPARENUM_HIST
|
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. |