Standard AQ - Bureau of Labor Current Employment Statistics

Overview

Updated 07/19/2021

Report Description

Pulls the information required for reporting Bureau of Labor Statistics Current Employment Statistics data.

Parameters

Parameter Name	Options	Description
Supplier	All available supplier.
Month Code		Filters data as per month code.
Year		Filters data as per year. The Year entry must be a four-digit value. e.g. "2019"
Pay Period	All Available pay period.
Show Missing Supervisor Mapping	Yes or No	If yes, then shows the job title which needs to be mapped in import export mapping group “Bureau of Labor Report” and mapping type name as “Job type Mapping”. If no, then show the data.

Report Fields

Field Name	Description
StaffingSupplierDesc	Paymentcheck’s supplier.
PayPeriod	Shows the pay period as pay period parameter.
Total EE Count	Counts employee who has worked during the max weekworked -7 and max weekworked.
Total Non Sup. EE Count	Counts the number of employees who have worked during the max weekworked -7 and max weekworked and who have job title supervisory had not been mapped to 'Supervisory'.
Total Female EE Count	Counts employees who have worked during the max weekworked -7 and max weekworked and gender is female.
Wages for All EE with out Comm.	Difference of totalwages – total commission. Totalwages is sum of grossamount from the paymentcheck. And total commission is the sum of itempay of transaction type “Commission” from transaction entry.
Wages for Non Sup. EE with out Comm.	Sum of grossamount from the paymentcheck  which are related to those employees who have worked during the max weekworked -7 and max weekworked and who have job title supervisory had not been mapped to 'Supervisory'.
Total Comm.	Sum of itempay of transaction type “Commission” from transaction entry.
Non Sup. EE Comm.	Sum of itempay of transaction type “Commission” from transaction entry and those transactions which are related to those employees who have worked during the max weekworked -7 and max weekworked and who have job title supervisory had not been mapped to 'Supervisory'.
Total Hours for All EE	Sum of the paytotalhours from transactiondetail.
Total Hours for Non Sup. EE	Sum of paytotalhours from transactiondetail which are related to those employees who has worked during the max weekworked -7 and max weekworked and who have job title supervisory had not been mapped to 'Supervisory'.

Back to Top