DW_PAY_ACTION_D (Preview)

This table requires activation of Payroll Balances functional area. This table containsinformation of the payroll actions.

Details

Module: Global Payroll

Key Columns

PAYROLL_ACTION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PAYROLL_ACTION_ID NUMBER 38 0 True Payroll Action Identifier    
SOURCE_RECORD_ID VARCHAR2 64     This column is for Oracle Internal use only. Unique Source Record Identifier with Payroll action id    
PAYROLL_ID NUMBER 38 0   Payroll Identifier DW_PAY_PAYROLL_D PAYROLL_ID
EFFECTIVE_DATE DATE       Effective Date    
ACTION_TYPE VARCHAR2 32     Action Type    
ACTION_STATUS VARCHAR2 16     Action Status    
START_DATE DATE       Start Date    
END_DATE DATE       End Date    
DATE_EARNED DATE       Date Earned    
DEDN_TIME_PERIOD_ID NUMBER 38 0   Deduction Time Period Id DW_PAY_PERIOD_D TIME_PERIOD_ID
EARN_TIME_PERIOD_ID NUMBER 38 0   Earn Time Period Id DW_PAY_PERIOD_D TIME_PERIOD_ID
CONSOLIDATION_SET_ID NUMBER 38 0   Consolidation Set Id DW_PAY_CONSOLIDATION_SETS_D CONSOLIDATION_SET_ID
PAY_REQUEST_ID NUMBER 38 0   Pay Request Id    
OVERRIDING_DD_DATE DATE       Overriding direct deposit date parameter for magnetic tape process.    
ACTION_SEQUENCE NUMBER 38 0   Action Sequence    
START_CHEQUE_NUMBER NUMBER 38 0   Start number for the cheque/check writer process.    
END_CHEQUE_NUMBER NUMBER 38 0   Optional end of cheque/check number range to be used by the cheque/check writer process.    
CHEQUE_PROCEDURE VARCHAR2 32     Lookup code for report run to print out cheques/checks.    
CURRENT_CHUNK_NUMBER NUMBER 38 0   Current chunk to process.    
CURRENT_TASK VARCHAR2 32     Indicates if payroll action is currently executing.    
LEGISLATIVE_DATA_GROUP_ID NUMBER 38 0   Legsilative Data Group Identifier DW_LEGISLATIVE_DATA_GROUP_D LEGISLATIVE_DATA_GROUP_ID
LEGISLATIVE_PARAMETERS VARCHAR2 999     process and legislation-dependent parameters are held    

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