SAP Knowledge Base Article - Public

2600769 - Custom Column Database Table for Scheduled Offering

Symptom

To confirm the database tables for referenced and non referenced custom columns for a Scheduled Offering.

Environment

SuccessFactors Learning Management System (LMS) - All Supported Versions

Resolution

For referenced custom columns details, search the following table:

PA_USRCL_SCHED

PA_USRRF_SCHED>Table where Scheduled Offering referenced custom column details are stored (the list of referenced values)

For non referenced custom columns details, search the following table:

PA_SCHED_USER

From the above mentioned tables, you could get the label details and those details are subsequently stored under PA_I18N_LABEL or PA_I18N_LOCALIZED_LABEL. Please merge both the tables (based on the requirement and the data set you want to pull) to get the desired output.

Keywords

PA_USRCL_SCHED, PA_SCHED_USER, PA_USRRF_SCHED, scheduled offering, custom columns, referenced , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , How To

Product

SAP SuccessFactors Learning all versions