The Employee Review Not Started by Job Assignment report is a variation of the Employee Review Not Started template. This variation uses the Performance Review topic to return the list of employees who haven't started the review, with the records grouped by Job Assignment.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Review Period | Yes | A to Z | |
| Job Assignment | Yes | Ascending | |
| Employee | A to Z | ||
| Location | Ascending | ||
| Manager | A to Z | ||
| Manager Email | A to Z | ||
| Review Cycle | Yes |
Custom Fields
Review Period
The Review Period custom field displays the review period. It uses the following expression:
CASE
WHEN vEmployeeReviewCycleReport.ReviewCycleStartDate IS NULL THEN ''
ELSE Convert(nvarchar(10), vEmployeeReviewCycleReport.ReviewCycleStartDate, 101) + ' - ' + Convert(nvarchar(10), vEmployeeReviewCycleReport.ReviewCycleEndDate, 101)
END
Filters
The template includes the following filters: