How to join pay_time_periods table to hwm_tm_rec

Summary:

Need to join the workforce management table hwm_tm_rec to the pay_time_periods table to get the Period Names that are being used for all the different kinds of hours being recorded in the hwm_tm_rec table.

Content (please ensure you mask any confidential information):

I am creating a sql query in BI Publisher that will report on the number of hours our hourly employees are recording in a given time period.

The hours are being recorded in the hwm_tm_rec table.

SELECT h.measure, h.resource_id

FROM hwm_tm_rec h 

JOIN hwm_tm_rep_m_ptt_atrbs_v at ON at.usages_source_id = h.tm_rec_id