- HR business partner
- Junior
- 30 min
Active employees by department
Return department and headcount for employees active on June 30, 2026. An end date is the first day outside employment. Exclude contractors. Sort department.
Skills and rubricEmployee headcount
- I filter for employees who started by June 30 and whose end date is later or missing because the end date is the first day outside employment. I then count each department and check that contractors, July hires and June 30 departures are excluded.
- I reconcile the source identity, period and inclusion rule because a correct-looking total can include the wrong population. I test an excluded record and keep the stated jurisdiction and case assumptions visible.
- I retain source references, the saved work, unresolved exceptions and authorized approval because another reviewer must reproduce the decision. I restrict sensitive records and name the owner and review date.