# 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, 2025, Oracle and/or its affiliates.