DW_PAY_PAYROLL_D (Preview)

This table requires activation of Payroll Balances functional area. This table stores the payroll information.

Details

Module: Global Payroll

Key Columns

EFFECTIVE_END_DATE, PAYROLL_ID, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PAYROLL_ID NUMBER 38 0 True Payroll 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 Source Record Identifier for Payroll Id, Effective Start Date and Effective End Date
PAYROLL_NAME VARCHAR2 128 Payroll Name
PERIOD_TYPE VARCHAR2 32 Payroll Frequency
FIRST_PERIOD_END_DATE DATE First Period End Date
FIXED_DATE_FLAG VARCHAR2 16 Fixed Date Indicator
CONSOLIDATION_SET_ID NUMBER 38 0 Consolidation Set Id DW_PAY_CONSOLIDATION_SETS_D CONSOLIDATION_SET_ID
NEGATIVE_PAY_ALLOWED_FLAG VARCHAR2 32 Negative Pay Allowed Flag