Shift Assignment Change History Tables

Hello Community,

I'm trying to identify the database tables (or views) where Oracle HCM Workforce Scheduling stores the history of modifications made to already assigned shifts.

Our requirement is to build a custom report that allows us to audit shift changes made by supervisors or managers. Specifically, we need to retrieve information such as:

• Manager/Supervisor who made the change
• Employee affected by the change
• Date and time of the modification
• Original shift assignment
• Updated shift assignment
• Date of the shift that was modified

In other words, we would like to determine:

Who changed an employee's assigned shift, when the change was made, what the original shift was, and what the shift was changed to.