Find all evaluations between a time frame that may have ended up hung up.
/*
Find all persons that have recently reached a %inalized% status
*/
select *
FROM EVAL_EMPL_PR
WHERE REVIEW_DT >= TO_DATE('08-01-15 00:00:00','mm-dd-yy hh24:mi:ss')
AND review_dt <= TO_DATE('09-30-15 15:00:00','mm-dd-yy hh24:mi:ss')
and eval_status like '%inalized%'
AND EMPL_DS_DT IS NOT NULL
order by review_dt ASC;
/*
Find all evaluations that may be hung up; status = 'Finalized,Signed Off'
*/
select *
from eval_empl_pr
where eval_status like 'Finalized,%';