Move all 334 persons times to CH3
/*GET A LIST OF ALL EMPLOYEES THAT NEED TO HAVE TIMES MOVED 334 -> CH3 */
SELECT DISTINCT EMPLOYEE_ID,
LAST_NAME,
FIRST_NAME,
TITLE,
POS_CODE
FROM EMPLOYEE_PROFILE
WHERE unit_id = 'CH3'
AND POS_CODE <> 2;
/*Delete all entered times for CH3 for 9/20 forward */
DELETE
(SELECT *
FROM EMPLOYEE_TIMES
WHERE EMPLOYEE_ID IN
( SELECT DISTINCT EMPLOYEE_ID
FROM EMPLOYEE_PROFILE
WHERE UNIT_ID = 'CH3'
AND POS_CODE <> 2
)
AND UNIT_ID = 'CH3'
AND END_DTTM >= TO_DATE('09-20-15 00:00:00','mm-dd-yy hh24:mi:ss')
);
/*MOVE ALL 334 TIMES ENTERED FOR CH3 FOLKS TO CH3 for 9/20 forward */
UPDATE
(SELECT *
FROM EMPLOYEE_TIMES
WHERE EMPLOYEE_ID IN
( SELECT DISTINCT EMPLOYEE_ID
FROM EMPLOYEE_PROFILE
WHERE UNIT_ID = 'CH3'
AND POS_CODE <> 2
)
AND UNIT_ID = '334'
AND END_DTTM >= TO_DATE('09-20-15 00:00:00','mm-dd-yy hh24:mi:ss')
)
SET UNIT_ID = 'CH3';