DW_PERF_TEMPLATE_DEF_D

This table stores the structure and process for creating performance evaluations

Details

Module: Performance Management

Key Columns

BUSINESS_GROUP_ID, TEMPLATE_DEFINITION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
TEMPLATE_DEFINITION_ID NUMBER 38 0 True Business Key for Template Definition
BUSINESS_GROUP_ID NUMBER 38 0 True Business Group identifier
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Key consisting of TEMPLATE_DEFINITION_ID, BUSINESS_GROUP_ID
TEMPLATE_TYPE_CODE VARCHAR2 32 Identifies template type of the performance document.
VALID_FROM_DATE DATE This is the date when the performance template is valid from
VALID_TO_DATE DATE This is the last day that the performance template is valid
TEMPLATE_STATUS_CODE VARCHAR2 32 Status of the Performance Template(Active/Inactive)
DOC_TYPE_ID NUMBER 38 0 Document Type. DW_PERF_DOCUMENT_TYPE_D_TL DOC_TYPE_ID
PROCESS_FLOW_ID NUMBER 38 0 Indicates the Process Flow definiton that is used in template definiton for internal processing.