The Performance Review Status by Review Cycle - Details report uses the Performance Review topic to display the status of employees' performance reviews and the overall rating for a selected review with all of the employee and review details. It contains columns such as employee self review and manager ratings, and review status.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Review Cycle | Yes | Ascending | |
| Department | Ascending | ||
| Employee | |||
| Gender | |||
| Location | |||
| Tenure in yrs | |||
| Manager | |||
| Reviewer | |||
| Review Status | |||
| Emp Rating Value | |||
| Emp Rating Name | |||
| Submitted by Emp | |||
| Mgr Rating Value | |||
| Mgr Rating Name | |||
| Submitted by Mgr | |||
| Review Period |
Custom Fields
Organizational Goal
The Organizational Goal custom field indicates if the goal is an organizational goal. It uses the following expression:
CASE
WHEN vIndividualRatingReport.GoalType = 0 THEN 'Yes'
WHEN vIndividualRatingReport.GoalType = 2 THEN 'No'
ELSE ''
END
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
CASE
WHEN vIndividualRatingReport.ReviewCycleStartDate is null THEN ''
ELSE Convert(nvarchar(10), vIndividualRatingReport.ReviewCycleStartDate, 101) + ' - ' + Convert(nvarchar(10), vIndividualRatingReport.ReviewCycleEndDate, 101)
END
Filters
The template includes the following filters: