Content Items on Talent Profile - Historical View
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?