Health labour market analysis support tool (‎beta version 3.0)‎ user manual 2024

Table of Contents

• Figure 1: Subteams of the multisectoral task teams (MTT) 16
• Figure 2: The home page (interface) of the HLMA support tool in Microsoft Excel 23
• Figure 3 : Interface of set-up model 25
• Figure 4: Interface of country information and objective of analysis 27
• Figure 5: Interface of prioritized health workforce for analysis 29
• Figure 6: Interface of national labour regulations 31
• Figure 7: Interface of population by subnational level 33
• Figure 8: Interface of population demographics 35
• Figure 9: Interface of health facility distribution 37
• Figure 10: Interface of descriptive health labour market models 39
• Figure 11: Interface of master list of accredited institutions 41
• Figure 12: Interface of health professions education pipeline 43
• Figure 13: Interface of current stock distribution by sector 45
• Figure 14: Interface of demographic distribution 47
• Figure 15: Interface of distribution by subnational level 49
• Figure 16: External income relativities 50
• Figure 17: Interface of income and income relativities 51
• Figure 18: Interface of attrition 53
• Figure 19: Expected wages and income (from a survey) 54
• Figure 20: Interface of vacancy analysis 56
• Figure 21: Interface of health workforce financing information 59
• Figure 22: Interface of predictor health labour models 61
• Figure 23: Supply forecasting (stock and flow method) 63
• Figure 24. Estimated cost of projected supply 65
• Figure 25: Interface of demand prediction of the health workforce 67
• Figure 26: Interface of nationally agreed staffing norms and standards 68
• Figure 27: Interface of projected requirements based on norms and standards 70
• Figure 28: Interface of estimated cost of staffing norms projection 72
• Figure 29: Interface of assumptions and projected requirements 74
• Figure 30: Interface of defining the level of health/disease burden 79
• Figure 31: Interface of defining professional standards for service delivery 82
• Figure 32: Interface of aligning with essential health package/planned services 85
• Figure 33: How do you access the quality review sheet? 86
• Figure 34: Validation of projected needs-based requirements 87
• Figure 35: Input validation sheet. 89
• Figure 36: Accessing the database of matched population health needs 91
• Figure 37: Interface of projected need for health workers (Headcount) 93
• Figure 38: Interface of selected summary results 95
• Figure 39: Results of descriptive analysis 96
• Figure 40: Summary of education indicators 97
• Figure 41: Quantifying the supply of health workers 99
• Figure 42: Geographical equity analysis (% share of HWF relative to a benchmark) 101
• Figure 43: Demographic distribution of health workforce 102
• Figure 44: Public sector demand and vacancy analysis 104
• Figure 45: Results of predictive analysis 105
• Figure 46: Estimated health workforce supply 106
• Figure 47: Estimated aggregate demand for health workers 107
• Figure 48: Estimate of population in need of health services 109
• Figure 49: Projected requirements (headcount and density) based on the population’s health needs 111
• Figure 50: Needs versus supply gap analysis: Absolute gaps and staff availability ratios 113
• Figure 51: Number of health professionals needed to train to fill needs-based workforce gaps 114
• Figure 52: Estimated wage bill of need versus supply 115
• Figure 53: Interface of employment cost of population health needs 116
• Figure 54: Kenyan example of interpreting economic feasibility analysis 119
• Figure 55: Correlation between health workforce density and health impact indicators 120
• Figure 56: Interface for training cost for the population’s health needs 121
• Figure 57: Need and supply comparative graphs 122
• Figure 58: Health workforce investment price tag 123
• Figure 59: Scenario analysis of the estimated need for health workers 124
• Figure 60: Graphical dashboard 126
• Acknowledgements 11
• Abbreviations 12
• Chapter 1: 13
• Introduction 13
• 1.1 What is a health labour market? 13
• 1.2 Practical consideration for undertaking health labour market analysis 15
• Chapter 2: 21
• HLMA support tool 21
• 2.1. Rationale for the HLMA support tool 21
• 2.2 Intended users of the HLMA support tool and user manual 21
• 2.3 How to use the manual 21
• 2.4 Need to know system requirements 21
• 2.5 HLMA support tool user interface 22
• Chapter 3: 24
• Setting up the HLMA support tool 24
• Model 1: country health system set-up 25
•  Sub-model 2: prioritized health workforce for analysis 27
•  Sub-model 3: national labour regulations 30
•  Sub-model 4: population by subnational level 32
•  Sub-model 5: population demographics 34
•  Sub-model 6: health facility distribution 36
• Chapter 4: 38
• Descriptive health labour market models 38
• Model 2: training and education 39
•  Sub-model 1: Master list of accredited training institutions 39
•  Sub-model 2: health professions education pipeline 42
• Model 3: supply, distribution and labour market flows 44
•  Sub-model 1: current stock and distribution by sector 44
•  Sub-model 2: demographic characteristics 46
•  Sub-model 3: distribution by sub-national level 48
•  Sub-model 4: income and income relativities 50
•  Sub-model 5: labour flows (attrition) 52
• Expected wages and income (only from a survey) 54
• Model 4: vacancies and demand analysis 55
•  Sub-model 1: vacancy analysis 55
• Model 5: health workforce financing 57
•  Sub-model 1: health workforce financing information 57
• Chapter 5: 60
• Predictive health labour market models 60
• Model 6: supply and demand forecasting 62
•  Sub-model 1: headcount of anticipated supply 62
•  Sub-model 2: estimated cost of supply 64
•  Sub-model 3: aggregate demand prediction of health workforce 66
• Model 7: health facilities and staffing norms method for estimating health workforce requirements 68
•  Sub-model 1: nationally agreed staffing norms and standards 68
•  Sub-model 2: projected requirements based on norms and standards 69
•  Sub-model 3: estimated cost of wages based on staffing norms projections 71
• Model 8: population ratios, thresholds and densities method 73
•  Sub-model 1: HWF requirements based on thresholds and densities 73
•  Sub-model 2: estimated cost of requirements 75
• Model 9: population health needs (epidemiological) method 77
•  Sub-model 1: defining the level of health/disease burden 77
•  Sub-model 2: defining professional standards for service delivery 80
•  Sub-model 3: aligning with essential health package/planned services 83
•  Sub-model 4: undertaking quality review for needs-based projections 86
•  Sub-model 5: projected needs for health workers (headcount) 92
• Chapter 6: 94
• Interpreting results 94
• Cluster 1: results of descriptive analysis 95
•  Results sheet 1: Summary of education indicators 96
•  Results sheet 2: current supply 98
•  Results sheet 3: health workforce distributional equity 100
•  Results sheet 4: summary of demographic distribution 102
•  Results sheet 5: demand and vacancy analysis 103
• Cluster 2: results of predictive analysis 105
•  Results sheet 1: Projected supply (stock and flow) 105
•  Results sheet 2: demand prediction of health workforce (aggregate) 106
•  Results sheet 3: estimated size of population in need of health services 108
•  Results sheet 4: projected need for health workers (headcount) 110
•  Results sheet 5: need versus supply gap results 112
•  Results sheet 6: number to train 114
• Cluster 3: financial implications 115
•  Results sheet 1: cost comparison by occupation: need versus supply 115
•  Results sheet 2: employment cost of needs-based health workforce requirements 116
•  Results sheet 3: economic feasibility analysis 117
•  Results sheet 4: return on investment analysis 119
•  Results sheet 5: Training cost of needs-based health workforce requirements 121
• Cluster 4: selected visualizations 122
•  Visualisation sheet 1: need and supply comparative graphs 122
•  Visualization sheet 2: health workforce investment price tag 123
•  Visualization sheet 3: Scenario analysis of the estimated need for health workers 123
•  Visualization sheet 4: graphical dashboard 125