Database table holding audit information on Class custom fields (Learning Management System)

[former_member41696]

Hi Everyone,

Can someone please guide on the table name in SuccessFactors LMS which holds audit information on Class Custom Fields.

Current information is available in table - PA_SCHED_USER however, when querying another table - PH_CLASS_USER, I am getting blank output. 

Tried this in multiple instance but didn't work out.

Appreciate your help!

Thanks,

Rahul

[Padraig]

Hi Rahul

The tables you need to review the data for class custom columns are:
      Referenced custom columns: PA_USRCL_SCHED and PA_USRRF_SCHED
      Non referenced custom columns: PA_SCHED_USER

Please see KBA 2600769 for further confirmation

If this information helped you then please consider giving Kudos or accepting this post as solution.

Padraig

[former_member41696]

Is there any table that captures history of changes in Class Custom Columns? The mentioned tables capture current information.

[Padraig]

There are no audit tables currently available which capture the changes made to the custom columns.

Only the current selections are stored in the DB in the PA tables as outlined.