3638153 - Data entries in PA_SCHED_ENROLL and PH_SCHED_ENROLL tables are automatically removed after 180 days

Entries in the PA_SCHED_ENROLL and PH_SCHED_ENROLL tables of SAP SuccessFactors Learning are automatically removed after 6 months (180 days).

SAP SuccessFactors Learning

PA_SCHED_ENROLL and PH_SCHED_ENROLL tables were created by SAP SuccessFactors LMS as temporary tables  for internal purposes. They were introduced to solve the race condition where multiple users were being registered into the last seat leading to overbooking on classes. These tables were intended to be used internally by SAP for the calculations that needs to be done when a user registers into the class. 

• PA_SCHED_ENROLL: This table is to store the number of enrolled users for a class at the current time (temporary table for internal purpose)
• PH_SCHED_ENROLL: This table is to store historical data for the enrolment count of the class (temporary table for internal purpose)

As these are internal and temporary tables, SAP SuccessFactors LMS is required to purge the data from these tables after 180 days due to compliance reasons. Therefore, these tables should not be used by the Customers for reporting purposes on class entities, to avoid any misunderstanding or incorrect reporting data.

Data dictionary:

You can find the following information regarding the enrolment counter temporary tables in the downloadable Data Dictionary_SuccessFactors Learning_version.xlsx file starting from 2H 2025 release (login on Help portal might be required to download it):

• PA_SCHED_ENROLL    : This table is to store the number of enrolled users for a class at any point of time. It is a temporary table for internal purpose.
• PH_SCHED_ENROLL    : This table is to store history data for classes enrolled count. It is a temporary table for internal purpose.

Data Services Extracts:

While PA_SCHED_ENROLL table was an optional table available to be included in DSE packages upon request for a short timeframe, due to the above reasoning Product Management decided to remove this optional table from the extracts. Deprecation will start in the 2H 2025 release (not available anymore for new requests) and removal will happen in 1H 2026 release (removed from those Customers as well whom are already utilizing it at the moment in their extract packages).

In the 2H 2025 Release specifically you will find the following information in the downloadable  Data Dictionary and Database Changes > DataServices > LMS_EXTRACT_Changes.csv file:

• PA_SCHED_ENROLL - Deprecate - The table is deprecated and will be removed with 2605

Recommendation from SAP:

• If you would like to see the list of the enrolled learners for a certain class, please utilize PA_ENROLL_SEAT table instead. If you need the historical audit data of the same, then please utilize the PH_ENROLL_SEAT table.

pa_sched_enroll, ph_sched_enroll, sap successfactors learning, data removal, enroll_count, custom reports, data missing, enrollment data, temporary, internal, tables, DSE, Data Services Extract, Data Dictionary, deprecate , KBA , LOD-SF-LMS-CRI , Custom Report Issues , Problem