The Employee Listing by Gender and Location report uses the HR Profile - As of Date topic to show a list of active employees by gender, including their current employment and work details. You can use this template to report on the number of people of each gender in each location in your organization.
Note: Multiple rows might be shown for employees who are assigned more than one manager.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Gender | Yes | ||
| Location | Yes | Ascending | |
| Employee | A to Z | ||
| Hire Date | |||
| Rehire Date | |||
| First Day Worked | |||
| Seniority Date | |||
| Term. Date | |||
| Status | |||
| Department | |||
| Job Assignment | |||
| Manager | |||
| Pay Type | |||
| Pay Class |
Custom Fields
Gender
The Gender custom field shows the employee's gender. It uses the following expression:
CASE WHEN EmployeeGenderIdentity.ReferenceCode LIKE '%(___: __)%' THEN CASE WHEN EmployeeGenderIdentity.ReferenceCode IS NULL THEN 'Gender Undefined' WHEN EmployeeGenderIdentity.ReferenceCode LIKE '%FEMALE (___: __)%' THEN 'Female' WHEN EmployeeGenderIdentity.ReferenceCode LIKE '%MALE (___: __)%' THEN 'Male' ELSE 'Non-Binary' END WHEN EmployeeAssignedSex.ReferenceCode LIKE '%(___: __)%' THEN CASE WHEN EmployeeAssignedSex.ReferenceCode IS NULL THEN 'Gender Undefined' WHEN EmployeeAssignedSex.ReferenceCode LIKE '%F (___: __)%' THEN 'Female' WHEN EmployeeAssignedSex.ReferenceCode LIKE '%M (___: __)%' THEN 'Male' ELSE 'Non-Binary' END ELSE CASE WHEN EmployeeAssignedSex.ReferenceCode IS NULL THEN 'Gender Undefined' WHEN EmployeeAssignedSex.ReferenceCode LIKE '%F (%' THEN 'Female' WHEN EmployeeAssignedSex.ReferenceCode LIKE '%M (%' THEN 'Male' ELSE 'Non-Binary' END END
Filters
The template includes the following filters: