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

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