DW_PERF_CHECKIN_TEMPLATE_D

This dimension captures the CheckIn Template Details

Details

Module: Performance Management

Key Columns

CHECK_IN_TEMPLATE_ID, BUSINESS_GROUP_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CHECK_IN_TEMPLATE_ID NUMBER 38 0 True Primary Key for Check in Template    
BUSINESS_GROUP_ID NUMBER 38 0 True Reference to Business Group    
SOURCE_RECORD_ID VARCHAR2 256     unique key    
STATUS_CODE VARCHAR2 32     Status of the Check-in Template DW_ACTIVE_INACTIVE_D_TL STATUS_CODE
PERFORMANCE_GOALS_FLAG VARCHAR2 32     Indicator if the template is of type Performance Goals    
DEVELOPMENT_GOALS_FLAG VARCHAR2 32     Indicator if the template is of type Development Goals    
GENERAL_DISCUSSION_TOPIC_FLAG VARCHAR2 32     Indicator if the template is of type General Discussion Topic    
VALID_FROM_DATE DATE       Valid from Date    
VALID_TO_DATE DATE       Valid to Date    

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