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.
