{"extra_roles":["AppraisalReviewer"],"entity":"EmployeeAppraisal","attribute":"dueDate","employeeJoinAttribute":"emp_number,id AS app.id","dateFormat":"YYYY-MM-DD","employeeReference":"foreign","conditions":["state_id IN (SELECT eas.state_id FROM AppraisalStatus eas WHERE eas.name <> 'NOT INITIATED')","0 <> (SELECT count(eae.id) FROM EmployeeAppraisalEvaluator eae WHERE eae.ReviewStatus.stateId IN (SELECT prs.stateId FROM ReviewStatus prs WHERE prs.name IN ('INITIATED','IN PROGRESS')) AND EmployeeAppraisal.id = eae.EmployeeAppraisal.id)"]}