DW_CMP_ZONE_D (Preview)
This table requires activation of Salary Basis functional area. Holds Compensation Zone data
Details
Module: Compensation
Key Columns
GEOGRAPHY_ID
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 | 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 |