2624714 - LMS Program - competency table mapping

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.

Successfactors LMS

Learning Management System

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

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

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