SAP Knowledge Base Article - Public

2615645 - Database Location for Origin Values Displayed in User Assigned Items Tab - LMS

Symptom

  • This KB article discusses the Origin value which is populated for the Users Assigned Items.
  • When creating a custom report, how is this detail recorded in the database?

User Origin.jpg

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors Learning Management System

Resolution

  • The detail for the Origin value is contained in the PA_STUD_CPNT database table in the ORIGIN column.
  • What is popualted in this column does not necessaraly reflect what is displayed to the LMS admin.

  • The ORIGIN database field is only populated for those Items assigned by an Assignment Profile or by a Program.
  • If the item was self-assigned, assigned by a supervisor or by an admin, then the ORIGIN database field will be null/blank.
  • In order to know if the item was assigned by a Scheduled Offering, the LMS admin needs to verify if the SCHD_ID field is populated in the PA_STUD_CPNT table.
  • If it is, then the Origin value displayed on the user record will display Scheduled Offering.

  • If the ADD_USER field has a value of "P", then the Origin value displayed on the user record display Self-Assigned
  • If the ADD_USER field has a value of "A", then the Origin value displayed on the user record display Directly Assigned
  • If the ADD_USER field has a value of "S", then the Origin value displayed on the user record display Manager Assigned

  • If there is a record in the PA_STUD_QUAL_CPNT table, then the Origin value displayed on the user record will be Curriculum

Keywords

SF, success factors, LMS, database column, assignment, supervisor, admin, , KBA , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , LOD-SF-LMS-REP , Reporting Data , How To

Product

SAP SuccessFactors Learning all versions