This table requires activation of Payroll Balances functional area. Payroll Balance Type Dimension
Module: Global Payroll
BALANCE_TYPE_ID
| 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.