DW_LEGISLATIVE_DATA_GROUP_D

A means of partitioning payroll and related data, At least one legislative data group is required for each country where the enterprise operates

Details

Module: Global Human Resources

Key Columns

LEGISLATIVE_DATA_GROUP_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LEGISLATIVE_DATA_GROUP_ID NUMBER 38 0 True Primary Key sequence for Legislative Data group in Fusion Source.For translation refer table DW_LEGISLATIVE_DATA_GROUP_D_TL joining with this id. DW_LEGISLATIVE_DATA_GROUP_D_TL LEGISLATIVE_DATA_GROUP_ID
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Unique Source Record Identifier
BUSINESS_GROUP_ID NUMBER 38 0 Business Group id
LEGISLATION_CODE VARCHAR2 32 Legislation code (Country Code)
DEFAULT_CURRENCY_CODE VARCHAR2 32 Currency code for the Legislation
COST_ALLOCATION_ID_FLEX_NUM NUMBER Cost Allocation Flex Number