DW_PAY_BALANCE_TYPE_D (Preview)

This table requires activation of Payroll Balances functional area. Payroll Balance Type Dimension

Details

Module: Global Payroll

Key Columns

BALANCE_TYPE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
BALANCE_TYPE_ID NUMBER 38 0 True Balance Type Identifier    
SOURCE_RECORD_ID NUMBER 38 0   This column is for Oracle Internal use only. unique key    
BASE_BALANCE_TYPE_ID NUMBER 38 0   Base Balance Type Identifier    
BALANCE_CATEGORY_ID NUMBER 38 0   Balance Category Identifier    
LEGISLATIVE_DATA_GROUP_ID NUMBER 38 0   Legislative Data Group Identifier    
BASE_BALANCE_NAME VARCHAR2 128     Base Balance Name    
BALANCE_UOM VARCHAR2 32     Balance Unit Of Measure    
CURRENCY_CODE VARCHAR2 16     Currency Code    
REMUNERATION_FLAG VARCHAR2 32     Remuneration Flag    
LEGISLATION_CODE VARCHAR2 32     Legislation Code    

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