Course Compliance Reporting

The Course Compliance Reporting template shows details of the compliance courses for each employee.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Course Name	Yes
Course Status	Yes	A to Z
Manager Details	Yes	A to Z
Employee Details		A to Z
Employee Email
Deadline Start Date UTC
Deadline End Date UTC
Days Left
Course Score
Employee Location
Employee Country
Course Required

Custom Fields

Course Name

The Course Name custom field displays the course name and course code. It uses the following expression:

CASE WHEN NULLIF(Course.CourseCode,'') IS NOT NULL 
     THEN CONCAT(Course.ShortName,' - ',Course.CourseCode)
ELSE Course.ShortName
END

Manager Details

The Manager Details custom field displays the details of the manager. It uses the following expression:

CASE WHEN NULLIF(EmployeeManager.ManagerDisplayName,'') IS NULL
     THEN '!No Manager Assigned'
     WHEN NULLIF(EmployeeManager.ManagerElectronicAddress,'') IS NOT NULL 
     THEN CONCAT(EmployeeManager.ManagerDisplayName,' - ',EmployeeManager.ManagerElectronicAddress)
ELSE EmployeeManager.ManagerDisplayName
END

Days Left

The Days Left custom field displays the number of days left to complete the course. It uses the following expression:

DATEDIFF(day,CURRENT_TIMESTAMP,EmployeeCourseDetailsCustom.DeadlineEndDate)

Filters

The template includes the following filters: