Standard AQ - IL Equal Pay Act

Report Description

The IL Equal Pay Act report is used to upload employee data to the State of IL to comply with the Equal Pay Registration process.

Parameters

Parameter Name	Options	Description
Supplier Name	All available Suppliers
Start Date (Check Date)
End Date (Check Date)
Hours Worked Txn Type	Transactional Pay Codes

Report Fields

Field Name	Description
FirstName	Employee’s First Name
LastName	Employee’s Last Name
SSN	Employee’s SSN
Gender	Employee’s Gender
Race	Employee’s Race
Ethnicity	Employee’s Ethnicity
Wages	Employee’s Wages (Box 5 in W2) Rounded to nearest hundred dollars, per state requirements
HoursWorked	Employee's Hours Worked based on the selected Transaction Types calculated as: Payunit * UnitsToHoursMultiplier (Value of the property “UnitsToHoursMultiplier” of the transaction type). Rounded to nearest hour, per state requirements
HireDate	Employee’s first ever Hire Date
TerminationDate	Employee’s most recent Termination Date
JobClassification	Employee’s Job classification
JobTitle	Employee’s Job Title
County	Employee’s Job County
PaidHS	H if Hourly S if Salaried
BaseHourlyRate	Only add a value for hourly employees; for salaried, leave blank. If talent has different pay rates/ titles - do not show different rates but rather average the rate across the pay rates / titles the talent had.
CBAYN	Default the value to N