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.
Note : Screenshot taken from salesdemo instance.
Environment
Successfactors LMS
Learning Management System
Reproducing the Issue
- Create Program in LMS - Learning Admin -> Learning -> Programs
- Under the Program's > Competencies tile Add a Competency ID
- 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
Keywords
CPTY_ID, Program competency, Competencies , KBA , LOD-SF-LMS-DB , DB Data & Services , How To
Product
SAP SuccessFactors Learning all versions