2342550 - Which table needs to be used to create a Custom report on Admin its associated Roles

SAP Knowledge Base Article - Public

2342550 - Which table needs to be used to create a Custom report on Admin its associated Roles

Symptom

  • This KBA specifies which columns are needed to create a custom report to return Admin Users and their associated Roles
  • The LMS currently does not have a system report that returns this data

Environment

SAP SuccessFactors Learning Management System (LMS)

Resolution

The table PA_USER_PRFL_ROLE contains the data related to Admins and their associated Role

  • USER_NAME contains the admin ID
  • ROLE_ID contains the role ID
  • LST_UPD_USR is the ID of the user who last updated the Admin role
  • LST_UPD_TSTMP is when the Admin role was last updated

An Enhancement Request exists to add an LMS Role Assignment Audit Report.  Please review, vote up and add comments to help Product Management decide what to add in our upcoming releases:

https://influence.sap.com/sap/ino/#/idea/48058

See Also

Enhancement Request 48058

Keywords

LMS Learning SF SuccessFactors Admin Role Custom report PRD Tool BIRT return show audit assign system out of box standard , KBA , LOD-SF-LMS , SuccessFactors Learning , LOD-SF-LMS-REP , Reporting Data , How To

Product

SAP SuccessFactors Learning all versions