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     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    

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