Table 109 RHDB_TEMPLATE_DIALNBR
|
RHDB_TEMPLATE_DIALNBR |
||
|
Field |
Characters |
Description |
|
TemplateID |
char (10) |
The Template ID of the Template Record. |
|
TemplateName |
char (15) |
The Template Name that is referenced on the Pointer CR. |
|
ControlRespOrg |
char (5) |
The Controlling Responsible Organization of the Pointer CR. |
|
CRDialNumber |
char (10) |
The dial number for the Pointer CR. |
|
CREffectiveDateTime |
char (3) |
The Effective Date and Time of the Pointer CR. |
|
ExtractDate |
Date |
The date the record was sent to RHDB. |
|
CrStatus |
char(1) |
The status of the Customer Record. Status and definitions are:
|
|
Create_LoginID |
Varchar2 (8) |
The mandatory data field that identifies the Login ID of the SMS/800 TFN Registry user that created the record. |
|
Create_Time |
Timestamp (6) |
The date and time the record was last updated in the SMS/800 TFN Registry. |
|
Update_LoginID |
Varchar2 (8) |
The mandatory data field that identifies the Login ID of the SMS/800 TFN Registry user who last updated the record. |
|
Update_Time |
Timestamp (6) |
The date and time the record was last updated in the SMS/800 TFN Registry. |
Index for RHDB_TEMPLATE_DIALNBR Table
The index and fields used for the RHDB_TEMPLATE_DIALNBR table are:
|
RHDB_TEMPLATE_DIALNBR |
|
|
Index Name |
Fields Used |
|
rhdb_Templates_DialNbr _idx1 |
|
|
rhdb_Templates_DialNbr _idx1 |
|