DW_PERF_TEMPLATE_DEF_D

This table stores the structure and process for creating performance evaluations

Details

Module: Performance Management

Key Columns

TEMPLATE_DEFINITION_ID, BUSINESS_GROUP_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     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.    

Copyright © 2019, 2022, Oracle and/or its affiliates.