You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Content Items on Talent Profile - Historical View

Received Response
edited Aug 10, 2021 5:27PM in Career and Succession 1 comment


Hello Experts,

Based on my research, it appears that content items captured on a worker's Talent Profile are not date-effective in the typical sense. For example: if I make a change to a content item on a worker's Talent Profile and change the value for a single field (e.g., expiry date for a License), a separate row does not get created in the HRT_PROFILE_ITEMS table. Instead, the values for the row simply get updated with the latest data, along with the latest OBJECT_VERSION_NUMBER (e.g., changing from '1' to '2'). 

My question: is there any way to track historical changes for content items on a worker's talent profile? I was thinking perhaps we could enable the audit policy for the "Person Profile Items" object and then query the respective audit tables, such as those ending with _ (e.g., HRT_PROFILE_ITEMS_). Has anyone attempted this approach, or have another clever way to get at the historical rows here? 


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!