| 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 TFNRegistry™ user that created the record. |
| Create_Time | Timestamp (6) | The date and time the record was last updated in the TFNRegistry. |
| Update_LoginID | Varchar2 (8) | The mandatory data field that identifies the Login ID of the TFNRegistry user who last updated the record. |
| Update_Time | Timestamp (6) | The date and time the record was last updated in the TFNRegistry. |
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 |
|