SAP Knowledge Base Article - Public

2624714 - LMS Program - competency table mapping

Symptom

Admin has created a Program in LMS.  Under the program > Competencies, a competency ID has been added. You are unable to find the mapping to the data dictionary.

Capture.JPG

Note : Screenshot taken from salesdemo instance.

Environment

Successfactors LMS

Learning Management System

Reproducing the Issue

  1. Create Program in LMS - Learning Admin -> Learning -> Programs
  2. Under the Program's > Competencies tile Add a Competency ID
  3. Admin wants to find the details in the database / find where the Competency ID is mapped in the data dictionary

Resolution

Should you have access to the Plateau Report Designer, this data will be stored in the table PA_CPNT.

The CPNT_TYP_ID will be = SYSTEM_PROGRAM_ENTITY and CPNT_ID will be = Program ID.

The Competency will be stored in the field CPTY_ID

Capture.JPG

Keywords

CPTY_ID, Program competency, Competencies , KBA , LOD-SF-LMS-DB , DB Data & Services , How To

Product

SAP SuccessFactors Learning all versions