What's new in Customer Journeys?

Connect and learn more!
How to join a Timesheet Row to an Absence Row (HWM_TM_RPT_ENTRY_V to ANC_PER_ABS_ENTRIES) — Cloud Customer Connect
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

How to join a Timesheet Row to an Absence Row (HWM_TM_RPT_ENTRY_V to ANC_PER_ABS_ENTRIES)

Accepted answer
122
Views
8
Comments
edited Aug 22, 2023 7:10AM in Workforce Management 8 comments

Summary:

If we have a person with 2 timesheet rows on the same day, each representing half day of absence, and we have 2 absence rows each of a different absence type - how can we join the correct row to the correct row?

Content (required):

Trying to write a report which takes the number of hours from the timesheet row (HWM_TM_RPT_ENTRY_V.TE_MEASURE_ABSENCE) and the type from the absence row (ANC_PER_ABS_ENTRIES.ABSENCE_TYPE_ID).

We were joining on the resource/person id and date of entry, however if you have 2 timesheet records for the same day, and 2 absence rows for that day, then you end up with 4 rows coming back in the report (2*2) as we cannot match 1 timesheet row to 1 absence row.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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