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.
Code | Meaning |
---|---|
B | Balance adjustment |
BEE | Batch Element Entry |
C | Costing |
CP | Costing of Payment |
D | Void Payment |
E | Ext/Manual payment |
EC | Estimate Costing |
F | Advance Pay |
H | Cheque writer |
I | Balance Initialization |
L | Retropay by Element or Enhanced |
M | Magnetic transfer |
O | Retropay |
P | Pre-payments |
Q | QuickPay Run |
R | Payroll Run |
S | RetroCosting |
T | Transfer to Ledger |
U | QuickPay Pre-payments |
V | Reversal |
W | Advance Pay By Element |
X | Magnetic report |
Z | Purge |
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.