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

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.