The Active Employee Headcount by Location and Gender report uses the HR Profile - As of Date topic to show gender head counts of active employees grouped by job and then by location. The records are filtered to include only primary work assignments. You can use this template to report on the number of males and females in the jobs at each location of your organization.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Location | Yes | Ascending | |
| Job | Ascending | ||
| Gender | |||
| Headcount |
Custom Fields
Gender
The Gender custom field shows the gender of each employee. It uses the following expression:
CASE WHEN EmployeeGenderIdentity.ReferenceCode LIKE '%(___: __)%' THEN CASE WHEN EmployeeGenderIdentity.ReferenceCode IS NULL THEN 'Undefined' WHEN EmployeeGenderIdentity.ReferenceCode LIKE '%FEMALE (___: __)%' THEN 'Females' WHEN EmployeeGenderIdentity.ReferenceCode LIKE '%MALE (___: __)%' THEN 'Males' ELSE 'Non-Binary' END WHEN EmployeeAssignedSex.ReferenceCode LIKE '%(___: __)%' THEN CASE WHEN EmployeeAssignedSex.ReferenceCode IS NULL THEN 'Undefined' WHEN EmployeeAssignedSex.ReferenceCode LIKE '%F (___: __)%' THEN 'Females' WHEN EmployeeAssignedSex.ReferenceCode LIKE '%M (___: __)%' THEN 'Males' ELSE 'Non-Binary' END ELSE CASE WHEN EmployeeAssignedSex.ReferenceCode IS NULL THEN 'Undefined' WHEN EmployeeAssignedSex.ReferenceCode LIKE '%F (%' THEN 'Females' WHEN EmployeeAssignedSex.ReferenceCode LIKE '%M (%' THEN 'Males' ELSE 'Non-Binary' END END
Headcount
The Headcount custom field shows the active employee head count. It uses the following expression:
COUNT(DISTINCT EmployeeEmploymentStatus.EmployeeNumber)
Filters
This template includes the following filters: