US Payroll - Query

Overview

The US Payroll module contains several query functions enabling users to view current and past data. The queries also include security settings that modify what is viewable, depending on the user logged into the system.

Transaction Types

There are several queries and reports that may include a transaction type. The standard Transaction Types used throughout the CMiC Enterprise system include:

  • BN – Benefit

  • BW – Basic Wage

  • DE – Deduction

  • EX – Expense

  • LE – Leave

  • LI – Loan Interest

  • LP – Loan Principle

  • PL – Public Liability

  • TX – Tax

  • WC – Workers’ Compensation

Payroll Job Allocation

Pgm: PYPAJOBQ – Payroll Job Allocation; standard Treeview path: US Payroll > Query > Payroll Job Applications

The Payroll Job Allocations query displays the details of all job allocations made through the US Payroll module for the selected date range. Check the ‘Charge/Pay Amount Diff’ box to only view records where the charge amount differs from the pay amount.

Employee Multiple Company Pay History

Pgm: PYMCOMPPAHISQ – Empl Multiple Comp Pay History; standard Treeview path: US Payroll > Query > Employee Multiple Company Pay History

The Employee Multiple Company Pay History query gives the same information as the Employee Pay History query but allows for the query of employees who have been copied to multiple companies.

Employee Earnings

Pgm: PYEPERSQ – Employee Earnings; standard Treeview path: US Payroll > Query > Employee Earning

The Employee Earnings query displays the details of all employee earnings on the selected pay group/pay run for the period specified. This is much like the Payroll Journal in that it only prints those items that affect net pay. For this reason, items such as non-cash benefits are not displayed here.

After entering the desired employee, the History Detail section displays each pay period in which a check or direct deposit has been issued. Each line displays the starting and ending pay period as well as the pay amount for that period.

WRL Code

This is the work location code which identifies the relevant working location (which is important in regards to taxation). Enter “*ALL” for all work locations.

Employee Pay History

Pgm: PYPAHISQ – Employee Pay History; standard Treeview path: US Payroll > Query > Employee Pay History

The Employee Pay History query displays the details of everything calculated for an employee on a selected pay group/pay run for the period specified.

This query is used to verify employee calculated amounts including basic wage, benefits, deductions, taxes, leaves, expenses, loan principal, loan interest, public liability, and workers’ compensation prior to posting.

This screen requires the entry of the desired pay run, period range and employee. The Detail section then displays all entries, ordered by transaction type and transaction code.