SAP Knowledge Base Article - Public

2459852 - LMS Program Contact Email address mapping

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

  1. Create Program in LMS - Learning Admin -> Learning -> Programs.
  2. Under the Program's Settings add a Contact's Email.
  3. 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 , SuccessFactors Learning , How To

Product

SAP SuccessFactors Learning all versions