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     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 38 0   Cost Allocation Flex Number    

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