is -10 earnigns higher than -20 earnings
// Queries used for updates to the AUDIT tables
SELECT * FROM GUDA.AUDIT WHERE CHANGED_FIELD = 'STATUS';
SELECT * FROM GUDADEV.AUDIT WHERE CHANGED_FIELD = 'STATUS';
SELECT * FROM GUDATEST.AUDIT WHERE CHANGED_FIELD = 'STATUS';
SELECT * FROM GUDA.AUDIT WHERE CHANGED_FIELD = 'DEPT_STATUS';
SELECT * FROM GUDADEV.AUDIT WHERE CHANGED_FIELD = 'DEPT_STATUS';
SELECT * FROM GUDATEST.AUDIT WHERE CHANGED_FIELD = 'DEPT_STATUS';
UPDATE GUDA.AUDIT ga SET ga.CHANGED_FIELD = 'STATUS_ID' WHERE ga.CHANGED_FIELD = 'STATUS';
UPDATE GUDADEV.AUDIT ga SET ga.CHANGED_FIELD = 'STATUS_ID' WHERE ga.CHANGED_FIELD = 'STATUS';
UPDATE GUDATEST.AUDIT ga SET ga.CHANGED_FIELD = 'STATUS_ID' WHERE ga.CHANGED_FIELD = 'STATUS';
UPDATE GUDA.AUDIT ga SET ga.CHANGED_FIELD = 'STATUS_ID' WHERE ga.CHANGED_FIELD = 'DEPT_STATUS';
UPDATE GUDADEV.AUDIT ga SET ga.CHANGED_FIELD = 'STATUS_ID' WHERE ga.CHANGED_FIELD = 'DEPT_STATUS';
UPDATE GUDATEST.AUDIT ga SET ga.CHANGED_FIELD = 'STATUS_ID' WHERE ga.CHANGED_FIELD = 'DEPT_STATUS';
UPDATE GUDADEV.AUDIT ga SET ga.CHANGED_FIELD = 'STATUS_ID' WHERE ga.CHANGED_FIELD IN ('STATUS','DEPT_STATUS');