SAP Knowledge Base Article - Public

2490094 - How is data in TOTAL_TIME calculated

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 (see KBA 2337470)
  • 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

Environment

SAP SuccessFactors Learning Management System (LMS) - All Supported Versions

Resolution

  • The final three digits are milliseconds, and the digits preceding are seconds.
  • Therefore in this case 78080 is 78 seconds or 1min 18 seconds. Running the Online Item Status (CSV) report, as MS Excel uses this column displays the time in the HH:MM:SS format

    report.jpg

Keywords

SF SuccessFactors LMS Learning TOTAL_TIME, milliseconds, seconds, HH:MM:SS pa_cbt_stud_cpnt , KBA , LOD-SF-LMS , SuccessFactors Learning , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-DB , DB Data & Services , LOD-SF-LMS-PRD , Plateau Report Designer , How To

Product

SAP SuccessFactors Learning all versions