Table 110 RHDB_TEMPLATES_HISTORY
| RHDB_TEMPLATES_HISTORY | ||
| Field | Characters | Description |
| ActivityDateTime | timestamp (6) | Date and time the record was last updated. |
| TemplateID | char (10) | The Template ID of the Template Record. |
| TemplateName | char (15) | Name of the Template Record. |
| EffectiveDateTime | char (3) | The Effective Date and Time of the Template Record. |
| 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. |
| ControlRespOrg | char (5) | The Controlling Resp Org Entity ID. |
| ExtractDate | Date | Date when the Record was sent to RHDB database. |
The index and fields used for the RHDB_TEMPLATES_HISTORY table are:
| RHDB_TEMPLATES_HISTORY | |
| Index Name | Fields Used |
| rhdb_ Templates_History _idx1 |
|
| rhdb_ Templates_History _idx1 |
|