Data Element: HEADCOUNT TURNOVER RATE (FTE IN REPORTING PERIOD)

HEADCOUNT TURNOVER RATE (FTE IN REPORTING PERIOD)

Format/length:	nnn.nn (including decimal point)
HES item:
National codes
Default codes

Notes:
The percentage of EMPLOYEES, based upon their ASSIGNMENT CONTRACTED FTE, leaving employment with the ORGANISATION within the REPORTING PERIOD, it is calculated as follows:

1.		Sum the ASSIGNMENT CONTRACTED FTE of each ASSIGNMENT in an ORGANISATION at the start of the REPORTING PERIOD where:
		a.	the ASSIGNMENT START DATE is before or on the REPORTING PERIOD START DATE
	and
		b.	the ASSIGNMENT END DATE is on or after the REPORTING PERIOD START DATE
			or
			no ASSIGNMENT END DATE has been recorded i.e. the employee is still employed
2.		Sum the ASSIGNMENT CONTRACTED FTE of each ASSIGNMENT in an ORGANISATION at the end of the REPORTING PERIOD where:
		c.	the ASSIGNMENT END DATE is on or after the REPORTING PERIOD END DATE
			or
			no ASSIGNMENT END DATE has been recorded i.e. the employee is still employed
	and
		d.	the EMPLOYMENT CONTRACT START DATE is on or before the REPORTING PERIOD END DATE
3.		Add the resulting sum of the FTEs at the start of the REPORTING PERIOD to the resulting sum of the FTEs at the end of the REPORTING PERIOD divided by 2.
		For example if the sum result at the start of the reporting period is 65.3 and the sum result at the end of the reporting period is 59.16 the average staff in assignments is:
			(65.3 +59.16) / 2 = 62.23
4.		Sum the ASSIGNMENT CONTRACTED FTE of each ASSIGNMENT for each EMPLOYEE leaving employment in an ORGANISATION with a recorded EMPLOYMENT HISTORY EMPLOYMENT LEAVING DATE where:
		e.	the EMPLOYMENT HISTORY EMPLOYMENT LEAVING DATE is on or after the REPORTING PERIOD START DATE
	and
		f.	the EMPLOYMENT HISTORY EMPLOYMENT LEAVING DATE is on or before the REPORTING PERIOD END DATE
5.		Divide the sum FTE of EMPLOYEES leaving employment by the average staff in assignments multiplied by 100
		For example if the number of FTEs leaving employment is 12.7 and the average FTEs in assignments is 62.23 the headcount turnover rate is:
			(12.7 / 62.23) * 100 = 20.40%

This data element is also known by these names:

Context Alias

plural HEADCOUNT TURNOVER RATES (FTE IN REPORTING PERIOD)