DW_PAY_BALANCE_CATEGORY_D (Preview)

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

Details

Module: Global Payroll

Key Columns

BALANCE_CATEGORY_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
BALANCE_CATEGORY_ID NUMBER 38 0 True Balance Category Identifier
EFFECTIVE_START_DATE DATE True Effective Start Date
EFFECTIVE_END_DATE DATE True Effective End Date
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. unique key
BASE_CATEGORY_NAME VARCHAR2 32 Base Category Name
SAVE_RUN_BALANCE_ENABLED VARCHAR2 32 Run Balance Enabled Flag
LEGISLATION_CODE VARCHAR2 32 Legislation Code