PAY Employee Payroll History

Description

Categories
Enginatics
Repository
GitHub
Payroll results per employee and payroll run date: run result Pay Values summed by element classification.

Net Pay is Earnings plus Supplemental Earnings minus Pre-Tax, Tax, Voluntary and Involuntary Deductions, which equals the prepayment amount of the US payroll. Imputed Earnings and Information elements do not count towards it.

Previous Net Pay is the employee's net pay of the preceding payroll run date within the selected run date range, so the first run date of an employee has no variance. Use Variance % Over to list only changes above a percentage.

SQL 90 lines

Parameters 7

ParameterTypeList of values SQL
Last Name starts withLOV
upper(papf.last_name) like upper(:last_name)||'%'
Full nameLOV
papf.full_name=:full_name
Business GroupLOV
haouv.name=:business_group
Payroll Run Date FromDate
ppa.effective_date>=:date_from
Payroll Run Date ToDate
ppa.effective_date<:date_to+1
Effective DateDate
Variance % OverNumber
abs(y.net_pay-y.previous_net_pay)>abs(y.previous_net_pay)*:variance_percent_over/100