Table 135 RHDB_NEW_POINTER_RECORD_LIST_VIEW
|
RHDB_NEW_POINTER_RECORD_LIST_VIEW |
||
|
Field |
Characters |
Description |
|
Entity |
Varchar2(2) |
The first two characters in the Resp Org (Responsible Organization) field. |
|
TemplateID |
Varchar2(2) |
The Template ID of the Template Record. |
|
Template Name |
Varchar2(15) |
Name of the Template Record. |
|
Control Resp Org |
Varchar2(5) |
Control Resp Org that owns the Dial Number. |
|
CR Dial Number |
Varchar2(15) |
The Dial Number for the Pointer CR. |
|
CR Effective Date Time |
Date |
The Effective Date and Time of the record. |
|
CR Status |
Varchar2(10) |
The status of the Customer Record. Status definitions are:
|
|
ExtractDate |
Date |
Date when the record was sent to the RHDB database. |
|
Create LogonID |
Varchar2(8) |
The mandatory data field that identifies the Login ID of the SMS/800 TFN Registry user that created the record. |
|
Update LogonID |
Varchar2(8) |
The mandatory data field that identifies the Login ID of the SMS/800 TFN Registry user who last updated the record. |
|
Create Time |
Timestamp(6) |
The date and time of the record that was last updated in the SMS/800 TFN Registry. |
|
Update Time |
Timestamp(6) |
The date and time of the record that was last updated in the SMS/800 TFN Registry. |
|
Number Status |
Varchar2(12) |
Status of Dial Number in Number Administration:
|