Close down old evals from prior to Sept. 1 - Cacher Snippet

1/14/2016 - 5:11 PM

Close down old evals from prior to Sept. 1

Close down old evals from prior to Sept. 1

close out evals.sql

UPDATE EVAL_EMPL_PR
SET EVAL_STATUS = 'CLOSED', EMPL_DS_STATUS = 'n', EVAL_DS_STATUS='n'
WHERE EVAL_STATUS != 'Finalized'
AND EVAL_STATUS != 'CLOSED'
AND EVAL_STATUS NOT LIKE '%Paper%'
AND UNIT_ID != 'test'
AND UNIT_ID != 'Workshop'
AND DATE_LAST_MODIFIED < TO_DATE('09-01-15 00:00:00','mm-dd-yy hh24:mi:ss');