DW_PERF_CHECKIN_TEMPLATE_D

This dimension captures the CheckIn Template Details

Details

Module: Performance Management

Key Columns

BUSINESS_GROUP_ID, CHECK_IN_TEMPLATE_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 This column is for Oracle Internal use only. 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