This table requires activation of Salary Basis functional area. Holds Compensation Zone
Module: Compensation
GEOGRAPHY_ID
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.