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