DW_CMP_ZONE_D_TL (Preview)

This table requires activation of Salary Basis functional area. Holds Compensation Zone

Details

Module: Compensation

Key Columns

GEOGRAPHY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
GEOGRAPHY_ID NUMBER 38 0 True Primary Key for Compensation Zone in Fusion Source.
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Unique Source Record Identifier
ZONE_TYPE_CODE VARCHAR2 32 Compensation Zone Type Code DW_CMP_ZONE_TYPE_D_TL ZONE_TYPE_CODE
GEOGRAPHY_USE VARCHAR2 32 Use of Geogprahy - Compensation
ZONE_CODE VARCHAR2 32 Compensation Zone code
ZONE_NAME VARCHAR2 512 Compensation Zone Name
START_DATE DATE Start date
END_DATE DATE End date