report to show timecards that aren't approved (when the last editor was not the worker him/herself)

Summary: Just sharing BI SQL. We have a need to output instances onto a report to show which worker did not re-approve a timecard that was edited by a member of our time administrators team. Want to share in case this can be helpful to others. You may have to modify the SQL accordingly to fit the requirements of your organization.

Content (required):

with SUBMISSIONS_WITH as (

   select

   HWM_EXT_TIMECARD_HDR_V.ORIG_TM_REC_GRP_ID TM_REC_GRP_ID,

   to_char(HWM_TM_SUBMITTED_TS_V.SUBMITTED_TIMESTAMP, 'mm/dd/yyyy HH12:MI PM') SUBMITTED_TIMESTAMP,

   HWM_EXT_TIMECARD_HDR_V.LAST_UPDATED_BY UPDATER_USERNAME,