HWM_TM_STATUSES - Many entries for a given timecard entry (Human Workforce Management / Timecards)
We would like to know how the HWM_TM_STATUSES table works in regards to timecard entry changes (when a timecard is submitted, approved, then modfied).
In our observed behavior on our environment, if a user saves a timecard and has it approved, we would expect 1 row to be inserted into the HWM_TM_STATUSES table (filtering on 'APPROVED' status_value). If the user then updates the timecard and it is approved again, we would expect a second row in HWM_TM_STATUSES. We are encountering 5 entries for the example that has been attached.
If we only query the HWM_TM_STATUSES table and count entries for a single time entry record (TM_BLDG_BLK_ID / TM_BLDG_BLK_VERSION / PART_GRP_TYPE_ID / STATUS_VALUE), we are seeing as many as 32 rows with a distinct STATUS_ID (primary key of the table). This seems very high, given the timecard would need to be approved 32 times for this to happen, which is not valid business test case.