SAP Knowledge Base Article - Public

2632395 - LMS: How does Content Level Tracking work?


  •  You want to create a custom report for Content level tracking but needs to Know how it gets updated in the database table


SAP Successfactors Learning Management System (LMS)


In 1711, PA_CBT_STUD_CPNT_MOD_AUDIT table was created to store the total amount spent by users on a content as of last launch. The total time is stored on table column 'TOTAL_TIME'.

Whatever amount of time is spent is added to the current 'TOTAL_TIME'.

TOTAL_TIME is displayed in milliseconds.

For example:

User spends 30 minutes on the content today. TOTAL_TIME = 1800000.

User launches the content again and spends 10 minutes. TOTAL_TIME = 1800000 + 600000 = 2400000


This audit data can be used in different ways for custom reporting. However, how to create a custom report using this table is out of scope for Customer Support. For assistance on this, please see KBA 2379690 - LMS: Custom Report Development and Support.

See Also

2559160 - LMS: Enabling Content level tracking (b1711 Enhancement: LRN-20176

2379690 - LMS: Custom Report Development and Support

See current enhancement request to vote for Standard report for content auditing:


Content Level Tracking, PA_CBT_STUD_CPNT_MOD_AUDIT, content, report, learning, launch, access, object, time, total time, TOTAL_TIME, LMS, learning , KBA , LOD-SF-LMS-CNT , Content , LOD-SF-LMS , Learning Management System , Problem


SAP SuccessFactors Learning 1711