DW_CMP_ZONE_TYPE_D (Preview)

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

Details

Module: Compensation

Key Columns

GEOGRAPHY_TYPE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
GEOGRAPHY_TYPE_ID NUMBER 38 0 True Primary Key sequence for Compensation Zone type 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
GEOGRAPHY_USE VARCHAR2 32 Use of Geogprahy - Compensation
ZONE_TYPE_NAME VARCHAR2 128 Compensation Zone Type Name