Minimum Wage Rate AQ Report

The Minimum Wage Rate AQ report allows you to view and export all locality minimum wage rate records configured across your staffing suppliers. Use this report to audit wage rates by state, city, and date range — streamlining multi-state compliance management and reducing the time spent manually reviewing individual records.

Who should use this report: System administrators, compliance officers, payroll managers, and operations managers responsible for maintaining accurate minimum wage configurations across multiple states and suppliers.

---

Accessing the Report

1. Navigate to Back Office > Reports Section > All Categories.
2. Click the Minimum Wage Rate AQ report to open it in Report View.

The report loads with default filter values and displays all matching wage rate records in the data grid below the filter panel.

---

Report Filters

Filters appear at the top of the report. Adjust them and click Run Query to refresh results.

Filter	Default Value	Description
Supplier	All	Limits results to wage records associated with the selected staffing supplier(s).
State(s)	All	Returns only records matching the selected state(s).
City	% (all cities)	Filters by city name using wildcard matching. Enter a specific city name or leave as % to include all.
Active Records Only	Yes	'Yes' shows only current/active records. 'No' shows only past/expired records
Start Date		Filters records with a Start Date on or after the specified date.
End Date		Filters records with an End Date on or before the specified date.

---

Report Columns

Each row in the data grid represents a single locality minimum wage record. The report displays the following columns:

Column	Description
Staffing Supplier	The staffing supplier associated with the wage rate record.
State	The two-letter state abbreviation (e.g., CA, IL, MN) where the wage rate applies.
City	The city where the locality minimum wage rate is effective. May be blank if the rate applies statewide.
Minimum Wage	The minimum wage dollar amount for the locality.
Start Date	The date the minimum wage rate becomes effective.
End Date	The date the minimum wage rate expires or is superseded.
Locality Minimum Wage ID	The unique system identifier for each record. Useful for referencing specific records during updates or imports.
Select	Checkbox column for selecting individual records or using Select All for bulk selection.

---

How to Use This Report

Viewing All Wage Records

With no filters applied (default values), the report returns all minimum wage records across all suppliers, states, and cities. This gives you a complete picture of every configured wage rate in the system.

Filtering by State

Select one or more states in the State(s) filter and click Run Query to narrow results to specific states. This is useful when preparing for state-level wage changes or auditing a particular region.

Filtering by Supplier

Select a staffing supplier in the Supplier filter to view only wage records associated with that supplier. This helps when managing wage configurations for a specific supplier relationship.

Viewing Active Records Only

Set Active Records Only to Yes to display only currently effective wage rates (records where the End Date is null or on/after today's date). This filters out expired and historical records so you can focus on what is currently in effect.

Identifying Placeholder Records

Records with a MinimumWage value of $0.00 are intentionally included in report results. These often represent test or placeholder entries. Review and clean up these records to ensure accurate wage rate data across your system.

---

Exporting Data

You can export the report results to CSV or Excel for offline review, bulk update preparation, or sharing with compliance teams.

1. Apply your desired filters and click Run Query.
2. Use the Select checkboxes to choose specific records, or click Select All to include everything.
3. Click Export and choose your preferred format (CSV or Excel).

Note: The export includes only the data visible based on your current filter selections and selected rows. To export all records, ensure filters are set to their defaults and all rows are selected.