You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Accepted answer
51
Views
2
Comments

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!