Employee Certifications

The Employee Certifications report uses the Employee Certifications topic to display a list of employees and the certifications that they currently hold.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Employee	Yes	A to Z
Job Assignment		Ascending
Location		Ascending
Certification		Ascending
Effective Start		Oldest to Newest
Effective End		Oldest to Newest
Assigned By		A to Z
Status

Custom Fields

Assigned By

The Assigned By custom field displays who assigned the certification. It uses the following expression:

CASE
    WHEN [LMSEmployeeCertification].[AssignedByUserId] IS NOT NULL THEN [EmployeeManager].ManagerDisplayName
    WHEN [LMSEmployeeCertification].[TrainingProgramId] IS NOT NULL THEN COALESCE(TrainingProgramCulture.ShortName, TrainingProgram.ShortName)
    WHEN [LMSEmployeeCertification].[CourseId] IS NOT NULL THEN COALESCE(CourseCulture.ShortName, Course.ShortName)
END

Filters

The template includes the following filters: