DW_PAY_BALANCE_CATEGORY_D

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

Details

Module: Global Payroll

Key Columns

EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, BALANCE_CATEGORY_ID

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     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    

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