DW_CMP_PLAN_PERIOD_STATUS_D_TL

This table contains information about code, name, and description for the CMP_CYCLE_STATUS related codes

Details

Module: Compensation

Key Columns

PLAN_PERIOD_STATUS_CODE, LANGUAGE, PLAN_PERIOD_STATUS_CODE_TYPE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PLAN_PERIOD_STATUS_CODE_TYPE VARCHAR2 128   True Code type. It is specific to functionality.    
PLAN_PERIOD_STATUS_CODE VARCHAR2 128   True Code.    
LANGUAGE VARCHAR2 64   True Translation language.    
SOURCE_RECORD_ID VARCHAR2 512     Source record identifier. Value is derived from a combination of code type and code.    
PLAN_PERIOD_STATUS_NAME VARCHAR2 2048     Business name or value of the code.    
PLAN_PERIOD_STATUS_DESCRIPTION VARCHAR2 4000     Code description.