SAP Knowledge Base Article - Preview

2490094 - Total_Time storage formats in Database vs. Reports

Symptom

  • In some database tables, for example pa_cbt_stud_cpnt_mod, there is a column TOTAL_TIME

DB column.jpg

  • 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.