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