SAP Knowledge Base Article - Public

2681359 - User Compliance Summary (CSV) report query

Symptom

The definitions of the columns of the User Compliance Summary (CSV) report.

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Go to Learning Administration >
  2. Go to Reports tab >
  3. Search for User Compliance Summary (CSV).

Resolution

The User Compliance reports output the data captured in the Compliance table of Learning, which is made of information regarding required training completions the user has done. Basically, the table records at the time of a user completing a required training assignment, what was completed, what were the assignment parameters around it, and was it completed on time or overdue.

  • User ID: User ID.
  • Organization: User Organization.
  • Domain: User Domain.
  • Items: Completed Required Items.
  • Learning Events: Total Learning History Events against those completed required items.
  • Completed Items: Completed Items.
  • Overdue Events: Item Completed after required date.
  • Average Days Remaining: Difference between Completion Date and Required Date.
  • Assignment Via Curricula: Assigned Item via Curriculum.
  • Curricula: number of curriculum associated with the mandatory/required items.
  • Curricula-based event compliance percentage - It calculates percentage depending on Completed Learning Events in time (Before or on required date).
    • The formula used to calculate the "Percentage Curriculum Compliance" value is the following:
      1.  Count distinct curricula items with all these properties:
        1. Completion date less than equal to required date.
        2. Completion provides credit = 'Y' (should be only curricula items that have completion which provides credit).
        3. Item should be coming from Curricula.
      2. Multiply by 100 >
      3. And then divide by:
        1. Count distinct number of learning items.

Keywords

learning, User Compliance Summary, csv, report, column, meaning, available , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-USR , User Entity , How To

Product

SAP SuccessFactors Learning all versions