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:
|