Close out evaluations that were not active this year and are not for this year - Cacher Snippet

11/4/2014 - 3:21 PM

Close out evaluations that were not active this year and are not for this year

Close out evaluations that were not active this year and are not for this year

CloseOutOldEvals.sql

UPDATE
  ( SELECT *
  FROM EVAL_EMPL_PR
  WHERE LOWER(EVAL_STATUS) NOT IN ('finalized','paper','paper recieved','closed')
  AND YEAR LIKE '2013%'
  )
SET EVAL_STATUS  = 'CLOSED',
  EMPL_DS_STATUS = 'n';