The Employee by Competencies report uses the Performance Competencies topic to display a list of all competencies assigned to you and the employees that you can access. It includes the most recent performance rating for each competency, with the records grouped by competency.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Competency Name | Yes | A to Z | |
| Manager | Yes | A to Z | |
| Competency Category | |||
| Assignment Type | |||
| Employee | |||
| Job Assignment | Ascending | ||
|
Location |
|
Ascending |
|
| 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: