SAP Knowledge Base Article - Public

2752903 - Extract URL details from within the Agenda of a Program

Symptom

Where in the database tables can you located the URL details from within the Agenda of a Program

program url.jpg

Environment

  • SAP SuccessFactors Learning Management System (LMS) - All Supported Versions
  • Plateau Report Designer - PRD

Resolution

The URL which is saved within the Program Agenda can be found in the PA_PROGRAM_CUSTOM_ENTRY table.

  1. To get to this table you will need to fristly search the PA_PROGRAM table and got the PROGRAM_SYS_GUID_VALUE
  2. Next check the PA_PROGRAM_SECTION table with the PROGRAM_SYS_GUID_VALUE value to get the PROGRAM_SECTION_SYS_GUID value.
  3. Then check the PA_PROGRAM_SECTION_ENTRY table which gives you the CUSTOM_ENTRY_SYS_GUID value which you can then link back to the PA_PROGRAM_CUSTOM_ENTRY table to get your URL value.

program db url.jpg

Keywords

URL, Program, Program Agenda, PA_PROGRAM,  PROGRAM_SYS_GUID_VALUE, PA_PROGRAM_SECTION, PROGRAM_SECTION_SYS_GUID, PA_PROGRAM_SECTION_ENTRY, CUSTOM_ENTRY_SYS_GUID, PA_PROGRAM_CUSTOM_ENTRY , KBA , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , LOD-SF-LMS-REP , Reporting Data , How To

Product

SAP SuccessFactors Learning all versions