Payroll Actions and their usage in Fusion
Payroll Actions and their usage

 434 total views

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.

Join our fastest growing technology social groups to interact with experts in the Fusion space and get your queries resolved – Telegram group, Facebook Page and LinkedIn Group

The following two tabs change content below.
Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.

Leave a Reply