How to Query Reported Time for Specific Payroll Time Types Based on Time Category

Summary:

I'm trying to query reported time entries for specific Payroll Time Types that belong to a particular Time Category — in my case, the category is called "**** TA Assignments" (as shown in the screenshot below).

I’m currently using the following tables to retrieve time entry details:

• hwm_ext_timecard_hdr_v
• hwm_ext_timecard_day_v
• hwm_ext_timecard_detail_v
• hwm_ext_attrb_detail_v
• hwm_tm_rec_grp_sum
• hwm_tm_rec

However, I’m unable to identify the table that stores the Time Category information and how it links to the Time Types used in these time entries.