Query to get Absence type from timesheet / timecard row?
I need to return the Absence type from a time sheet/card day.
Not sure if this is held in an attribute ?
I can get the timesheet row data from hwm_tm_rec, but no idea where to get the absence type from.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
WHERE TRUNC(start_time) BETWEEN :Effective_Start_Date AND :Effective_End_Date
AND layer_Code = 'ABSENCES'
AND NVL(delete_flag,'N') <> 'Y'
AND latest_version = 'Y'