Symptom
- In some database tables, for example pa_cbt_stud_cpnt_mod, there is a column TOTAL_TIME
- The LMS does not perform any calculations on Time Spent, this is the incremented time sent to the LMS from the content in cmi.core.session_time
- This KBA covers how the database stores the time value and how to calculate what 78080 from the above screenshot consists of in terms of HH:MM:SS
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Read more...
Environment
SAP SuccessFactors Learning
Product
SAP SuccessFactors Learning all versions
Keywords
sf, success factors, LMS, milliseconds, seconds, HH:MM:SS pa_cbt_stud_cpnt , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-DB , DB Data & Services , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.