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

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

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

SAP SuccessFactors Learning Management System

• 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

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