| RHDB_TEMPLATES | ||
| Field | Characters | Description |
| TemplateID | char (10) | The Template ID that is stored at the SCPs. Each Template Record (also called a Routing Template) has a unique Template ID. A Template ID is a 10 digit identifier (numeric only). The value is assigned by the TFNRegistry™ when a Resp Org creates a Template Record. When a Template is sent to the SCPs, the TFNRegistry will send the Template ID, not the Template Name, to the SCPs. The Template ID is used by the SCPs and it is created by TFNRegistry upon creation (‘Update’) of a new Routing Template. The Template ID may only be useful when auditing Templates stored in TFNRegistry versus an SCP(s). |
| Template Name | char (15) | The Template Name:
|
| EffectiveDateTime | Date | The Effective Date and Time of the record. |
| ControlRespOrg | char (2) | Controlling Resp Org of the record. |
| ExtractDate | Date | Date when the record was sent to the RHDB database. |
| Description | char (40) | The Template Description. It is an optional field when creating a Template Name; therefore, this field may be empty. |
| Status | char(1) | The Status of the Template Record. Valid values for Template Records are:
Please Note: HOLD status is not valid for Template Records |
| 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 WBA TRL page or RHDB_TEMPLATES table are:
| RHDB_TEMPLATES | |
| Index Name | Fields Used |
| rhdb_ templates _idx1 |
|
| rhdb_ templates _idx1 |
|