- 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.
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 current enhancement request to vote for Standard report for content auditing: https://influence.sap.com/sap/ino/#/idea/213066
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 , SuccessFactors Learning , Problem