SAP Knowledge Base Article - Public

2342550 - Which table needs to be used to create a Custom Report to verify the Roles associated with Admins

Symptom

This KBA specifies which columns are needed to create a custom report to return Admin Users and their associated Roles

Environment

SAP SuccessFactors Learning

Resolution

The table PA_USER_PRFL_ROLE (PH available) 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

Note: The LMS currently does not have a system report that returns this data.

See Also

We encourage our customers to submit an enhancement request to have this functionality considered within future development cycles.
It can be done at https://influence.sap.com/sap/ino/#/campaign/87

KBA 2090228 - How to Submit Enhancement Requests for SAP SuccessFactors Products

KBA 2326249 - How to find the latest version of LMS data dictionary

Keywords

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

Product

SAP SuccessFactors Learning all versions