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

LANGUAGE, PLAN_PERIOD_STATUS_CODE, 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     This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of code type and code.    
PLAN_PERIOD_STATUS_NAME VARCHAR2 128     Business name or value of the code.    
PLAN_PERIOD_STATUS_DESCRIPTION VARCHAR2 256     Code description.    

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