• Post category:Others
  • Post comments:0 Comments
  • Post last modified:August 24, 2020
  • Reading time:3 mins read
You are currently viewing Payroll Actions and their usage in Fusion
Payroll Actions and their usage in Fusion

In this article we will look into the list of all payroll actions and their significance. We will also look into how to retrieve all of these payroll actions using a SQL Query at the end of the article.

ACTION_TYPE field on PAY_PAYROLL_ACTIONS table will store the payroll action information.

CodeMeaning
BBalance adjustment
BEEBatch Element Entry
CCosting
CPCosting of Payment
DVoid Payment
EExt/Manual payment
ECEstimate Costing
FAdvance Pay
HCheque writer
IBalance Initialization
LRetropay by Element or Enhanced
MMagnetic transfer
ORetropay
PPre-payments
QQuickPay Run
RPayroll Run
SRetroCosting
TTransfer to Ledger
UQuickPay Pre-payments
VReversal
WAdvance Pay By Element
XMagnetic report
ZPurge

The most common Action Types used are for Payroll Processing:
R – Payroll Run, Q – Quick Pay, V – Reversal, B – Balance Adjustment.

SQL Query to get this list of Payroll Actions:

select distinct ppa.action_type, hrl.meaning
from pay_payroll_Actions ppa, hr_lookups hrl
where ppa.action_type = hrl.lookup_code
and hrl.lookup_type='ACTION_TYPE'
order by ppa.action_type asc

For every payroll process or extract run, an entry will be added to this PAY_PAYROLL_ACTIONS table for the corresponding Action Type. PAYROLL_ACTION_ID is the unique key which when joined to other tables will provide more details on the process details.