Competencies by Employees

Ad Hoc Reporting Guide

Version
R2025.2.1
ft:lastEdition
2025-12-01
Competencies by Employees

The Competencies by Employees report uses the Performance Competencies topic to display a list of all competencies assigned to you and to the employees that you can access. It includes recent performance ratings on the competencies, with the records grouped by employee.

Fields

Fields included in the report template
Field Name Group by Sort Order Totals
Name Number Yes A to Z  
Manager Yes A to Z  
Job Assignment   Ascending  
Location   Ascending  
Competency Name   A to Z  
Competency Category      
Assignment Type      
Review Rating Value      
Review Rating Name      
Global Rating Value      
Global Rating Name   A to Z  

Custom Fields

Review Rating Value

The Review Rating Value field displays a numeric rating for the competency from the latest review. It uses the following expression:

cast(CONVERT(Decimal(10, 2), vEmployeeReviewCompetencyReport.FinalReviewRating) AS varchar) + ' / ' + cast(CONVERT(Decimal(10, 2), vEmployeeReviewCompetencyReport.ReviewMaxRatingValue) AS varchar)

Global Rating Value

The Global Rating Value field displays a numeric rating for the competency from the latest review on the global rating scale. It uses the following expression:

cast(CONVERT(Decimal(10,2), vEmployeeReviewCompetencyReport.GlobalFinalRatingValue) as varchar) + ' / ' + cast(CONVERT(Decimal(10,2), vEmployeeReviewCompetencyReport.MaxRatingValue) as varchar)

Filters

The template includes the following filters:

Report filters.