{"display_field_name":"ohrm_job_activity.name","report_name":"Project Report"}
{"display_field_name":"ohrm_job_activity.name","report_name":"Employee Report"}
{"display_field_name":"r.vacancy_added_date","report_name":"Vacancy Succession Report"}
{"display_field_name":"r.job_title","report_name":"Vacancy Succession Report"}
{"display_field_name":"r.no_of_positions","report_name":"Vacancy Succession Report"}
{"display_field_name":"r.no_of_applicants","report_name":"Vacancy Succession Report"}
{"display_field_name":"SUM(IF(r.no_of_shortlisted = 1, 1, 0))","report_name":"Vacancy Succession Report"}
{"display_field_name":"SUM(IF(r.no_of_hired = 1, 1, 0))","report_name":"Vacancy Succession Report"}
{"display_field_name":"leave_period","report_name":"Employee Leave Report"}
{"display_field_name":"type","report_name":"Employee Leave Report"}
{"display_field_name":"entitlement","report_name":"Employee Leave Report"}
{"display_field_name":"taken_days","report_name":"Employee Leave Report"}
{"display_field_name":"brought_forward","report_name":"Employee Leave Report"}
{"display_field_name":"(total - taken_days - scheduled_days)","report_name":"Employee Leave Report"}
{"display_field_name":"total","report_name":"Employee Leave Report"}
{"display_field_name":"CONCAT (e.emp_firstname, ' ', e.emp_lastname)","report_name":"Employee Turnover Hiring Report"}
{"display_field_name":"get_sub_unit_path(cs.id)","report_name":"Employee Turnover Hiring Report"}
{"display_field_name":"e.joined_date","report_name":"Employee Turnover Hiring Report"}
{"display_field_name":"jt.job_title","report_name":"Employee Turnover Hiring Report"}
{"display_field_name":"CONCAT (e.emp_firstname, ' ', e.emp_lastname)","report_name":"Employee Turnover Termination Report"}
{"display_field_name":"get_sub_unit_path(cs.id)","report_name":"Employee Turnover Termination Report"}
{"display_field_name":"te.termination_date","report_name":"Employee Turnover Termination Report"}
{"display_field_name":"jt.job_title","report_name":"Employee Turnover Termination Report"}
{"display_field_name":"tr.name","report_name":"Employee Turnover Termination Report"}
{"display_field_name":"CASE WHEN p.id IS NULL THEN get_sub_unit_title(s.id) ELSE p.name END","report_name":"Head Count Report"}
{"display_field_name":"COUNT(emp_number)","report_name":"Head Count Report"}