Symptom
Admin has created a Program in LMS.
Under the program settings, a Contact's Email has been added. You are unable to find the mapping to the data dictionary.
Environment
SuccessFactors Learning Management System (LMS) - All Supported Versions
Reproducing the Issue
- Create Program in LMS - Learning Admin -> Learning -> Programs.
- Under the Program's Settings add a Contact's Email.
- Admin wants to find the details in the database / find where the contact email address 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 Contact's Email will be stored in the field CONTACT.
Keywords
Database field, Contact's Email, CONTACT, Plateau Report Designer, CPNT_TYP_ID, SYSTEM_PROGRAM_ENTITY, CPNT_ID, CONTACT , KBA , LOD-SF-LMS-DB , DB Data & Services , LOD-SF-LMS , Learning Management System , How To