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. |
Index for RHDB_TEMPLATES_HISTORY Table
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 |
|