Employee Skills

The Employee Skills report shows a list of employees and the skills that they currently hold.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Employee	Employee	A to Z
Job Assignment		Ascending
Location		Ascending
Skill		Ascending
Skill Level		Ascending
Skill Effective Start		Oldest to newest
Skill Effective End		Oldest to newest
Assigned By		A to Z

Custom Fields

Assigned By

The Assigned By custom field displays information on who assigned the skill such as user, course, or learning plan. It uses the following expression:

CASE
    WHEN [EmployeeSkill].[AssignedByUserId] IS NOT NULL THEN COALESCE([AppUserEmployee].[DisplayName], [AppUserEmployee].[LoginId])
    WHEN [EmployeeSkill].[TrainingProgramId] IS NOT NULL THEN COALESCE(TrainingProgramCulture.ShortName, TrainingProgram.ShortName)
    WHEN [EmployeeSkill].[CourseId] IS NOT NULL THEN COALESCE(CourseCulture.ShortName, Course.ShortName)
END

Filters

This template includes the following filters: