The Active Employee Headcount by Location and Job Assignment report uses the HR Profile - As of Date topic to display head counts for employees with active status, grouped by assigned locations and job assignments. The records are filtered to include only primary work assignments. You can use this template to report on the number of active employees in each job assignment at each location in your organization.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Location | Yes | Ascending | |
| Job Assignment | |||
| Headcount |
Custom Fields
Headcount
The Headcount custom field displays the count of active employees. It uses the following expression:
COUNT(DISTINCT EmployeeEmploymentStatus.EmployeeNumber)
Filters
The template includes the following filters: