Query to get Absence type from timesheet / timecard row?

Summary:

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.

Content (required):

Version (include the version you are using, if applicable):

23D

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT *

FROM hwm_tm_rec

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'