DW_PAY_BALANCE_DIMENSION_D (Preview)

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

Details

Module: Global Payroll

Key Columns

BALANCE_DIMENSION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
BALANCE_DIMENSION_ID NUMBER 38 0 True Balance Dimension Identifier
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. unique key
BASE_DIMENSION_NAME VARCHAR2 256 Base Dimension Name
DESCRIPTION VARCHAR2 256 Balance Dimension Description
DIMENSION_LEVEL VARCHAR2 32 Balance Dimension Level
DIMENSION_TYPE VARCHAR2 32 Balance Dimension Type
EXPIRY_CHECKING_LEVEL VARCHAR2 32 Expiry Checking Level
FEED_CHECKING_TYPE VARCHAR2 32 Feed Checking Type
INITIAL_DATE DATE Initial Date
PERIOD_TYPE VARCHAR2 32 Period Type