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.
with SUBMISSIONS_WITH as (
to_char(HWM_TM_SUBMITTED_TS_V.SUBMITTED_TIMESTAMP, 'mm/dd/yyyy HH12:MI PM') SUBMITTED_TIMESTAMP,