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    

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