Topics Map > Human Resource System (HRS) > HRS Human Resources Administration

Analyzing the FLSA Exempt Compliance Report in HRS


The FLSA Exemption Compliance Report identifies employees who potentially need a change in their FLSA Status from Exempt to Non-Exempt, accounting for exceptions due to job duties such as Doctor, Teacher, Lawyer, Camp Counselor or Academic Administrator that are legal exceptions to the rule. The report provides wages related to FLSA Jobs to assist with the analysis.

Process Considerations:

  • Report used to track employees who could potentially require a change to their FLSA Status from Exempt to Non-Exempt, accounting for exceptions due to job duties such as teaching are legal exceptions to the rule.  Campuses are to evaluate data provided and determine when changes are required.
  • Corrective actions for employees identified in the report may need to be completed after analysis.  Roughly 2% of the paid population could to be false positives on the report.  This report does not currently track on corrective action and presumes the institutional user is reviewing FLSA Status not only by reviewing the report, but also at every job and compensation change for their employees.
  • Query has been created for an intended audience of HR Admin's to evaluate the current FLSA Status of employees who are under the annual FLSA threshold of $35,568.  
  • This PS Query may take a while to run in the foreground and may time out.  Please consider scheduling the job as described below.
Warning  This job is running extremely long at this time or times out.  Please schedule the job by following these steps:
1.  Navigate to Reporting Tools > Query Viewer
query manager
2.  Search for the Query:
UW_HR_FLSA_EXEMPT_COMPLIANCE and choose "Schedule"
Reference the Related KB's to run and locate the output.
You may click on the links below to navigate directly to a section:

Instructions For Evaluation

The FLSA Compliance Query evaluates and lists employees in FLSA Jobs and provides the end user with wage information to determine if their FLSA Status should be changed.  An employee not meeting the annual threshold of $35,568 and not qualifying for an FMLA Exeption must be changed to Non-Exempt.

1.  Navigate to:  Workforce Administration > Job Information > UW FLSA WorkCenter

2. Choose the FLSA Compliance Report from the Queries panel:

report image

3.  Enter your search criteria

  • Business Unit (Optional):  the specific institution for evaluation; wildcard (%) use is acceptable
  • DeptID (Optional):  a specific Organizational Department; wildcard (%) use is acceptable

4.  Click View Results

  Note:  If specific search criteria are not used, there is a potential that the report will take an extended amount of time to run.  Scheduling the job may be a better option if timing out (instructions listed below).

5.  Evaluate to determine if employees listed need to have their FLSA Status changed from Exempt to Non-Exempt

  • Data for most recently completed Pay Run ID or pay period will populate; the report provides the Earns End and Period End Dates
  • Employees in Active (A) or Paid or intermittent LOA (P) Empl Status with a FLSA Status of E will populate if they are below the threshold. You will see data pertaining to Non FLSA Status employee data if the employee holds multiple jobs.
  • Employee job attributes are based on current Job Data
  • Threshold  Pay Period: is displayed based on the number of months paid to date
    • Monthly: 1/12th of $35,568 = $2,964 x month
    • Bi-Weekly: 1/26th of $35,568 = $1,368
  • FLSA Job Earnings: pulls earnings based on FLSA related job codes
  • FLSA Pers Earns: pulls earnings for ALL positions held for current month or Pay Period
  • FLSA YTD Earns: pulls FLSA job earnings paid YTD

report screenshot

6.  If analysis has determined that there needs to be modifications made to employee data, please reference Related KB's below.To the top

Additional Resources

Related KBs:

Keywords HR, Human Resources HR, Human Resources   Doc ID98371
OwnerJessica R.GroupUW–Shared Services
Created2020-03-02 13:09:42Updated2024-05-14 10:47:02
SitesUW–Shared Services
Feedback  0   0