Zum Inhalt springen
Search the hub

← All suppliers

HCM

BambooHR

HRIS: employee/employment, time off, org — API load, strict workforce PII; never cleartext salary in marts.

Templates only — grain, filters, custom fields and ownership are firm-specific.

Copy formulas into the KPI Definition Card, then adapt grain and filters.

Example

Active headcount

How many active employees (snapshot)?

COUNT(*) FROM employee WHERE status = 'active'
Grain
Active employee
Fields
Employee.id, Employee.status, Department.id
Dimensions
department, employment_status, employment_type, location_country

status=active; lock contractor policy.

Adapt: FTE-weighted variant.

Example

Hires

How many hires in the period?

COUNT(*) FROM employee WHERE hire_date IN period
Grain
Hire event
Fields
Employee.id, Employee.hire_date
Dimensions
department, employment_type, location_country

hire_date required; treat rehires separately.

Adapt: Count primary employment only.

Terminations

How many terminations in the period?

COUNT(*) FROM employee WHERE termination_date IN period
Grain
Termination event
Fields
Employee.termination_date, Employee.id
Dimensions
department, employment_type, location_country

Clarify soft-deleted vs terminated.

Adapt: Voluntary vs involuntary if field exists.

Time-off days

How many approved absence days in the period?

SUM(days) FROM time_off WHERE status = 'approved' AND start_date IN period
Grain
Approved time-off day
Fields
TimeOff.days, TimeOff.status, TimeOff.type
Dimensions
department, time_off_type, location_country

Do not load medical notes.

Adapt: Vacation-only vs all types.

Avg span of control

What is the average span of control?

AVG(direct_reports) FROM manager_edge WHERE manager is active
Grain
Manager with direct reports
Fields
Manager.manager_id, Manager.employee_id
Dimensions
department, location_country

Active direct reports only.

Adapt: Max span as governance KPI.

Formula overview

Same formulas as a table — copy into KPI cards or SQL drafts.

Label Formula Grain Fields
Active headcount COUNT(*) FROM employee WHERE status = 'active' Active employee Employee.id, Employee.status, Department.id
Hires COUNT(*) FROM employee WHERE hire_date IN period Hire event Employee.id, Employee.hire_date
Terminations COUNT(*) FROM employee WHERE termination_date IN period Termination event Employee.termination_date, Employee.id
Time-off days SUM(days) FROM time_off WHERE status = 'approved' AND start_date IN period Approved time-off day TimeOff.days, TimeOff.status, TimeOff.type
Avg span of control AVG(direct_reports) FROM manager_edge WHERE manager is active Manager with direct reports Manager.manager_id, Manager.employee_id

Tour