Timecard Layout Report

Team,

We have a requirement to build many timecard reports and would like to understand the table structure to develop the same.

We are using hwm_tm_rpt_entry_v view to fetch the time entry details (Additionally few tables for other information hwm_tm_rep_atrb_usages,hwm_tm_rep_atrbs,hwm_tm_d_tm_ui_status_v,hwm_ext_attrb_detail_v,etc.,)

But we are not getting the right information. attribute_category in hwm_tm_rep_atrbs has different values (ORA_CUSTOM, ST, etc.,). We are not sure which row should be fetched. There are many rows for same timecard date we are getting.