The Employees with Low Performance Rating report uses the Performance Review topic to display a list of employees who scored equal to or below a specified percentage on their performance review. It contains details about employees and their manager ratings.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Review | Yes | Ascending | |
| Rating PCT | Yes | Smallest to Largest | |
| Employee | A to Z | ||
| Job Assignment | Ascending | ||
| Location | Ascending | ||
| Manager | A to Z | ||
| Rating Value | A to Z | ||
| Rating Name | A to Z |
Custom Fields
Rating (%)
The Rating (%) custom field displays the manager rating score in percentage. It uses the following expression:
CASE
WHEN vEmployeeReviewCycleReport.ManagerRating IS NULL THEN NULL
ELSE CONVERT(Decimal(10, 2), vEmployeeReviewCycleReport.ManagerRating * 100.0 / vEmployeeReviewCycleReport.RatingScaleMaxValue)
END
Rating Value
The Rating Value custom field displays the manager rating value. It uses the following expression:
CASE
WHEN vEmployeeReviewCycleReport.ManagerRating IS NULL THEN 'Not Rated'
ELSE CONVERT(nvarchar(10), CONVERT(Decimal(10, 2), vEmployeeReviewCycleReport.ManagerRating))+' / '+CONVERT(nvarchar(10), CONVERT(Decimal(10, 2), vEmployeeReviewCycleReport.RatingScaleMaxValue))
END
Filters
The template includes the following filters: