2592319 - LMS: What table stores the data for prorgrams in a catalog?

SAP Knowledge Base Article - Public

2592319 - LMS: What table stores the data for prorgrams in a catalog?

Symptom

What table stores the data for programs in a catalog?

Environment

SuccessFactors LMS
Learning Management System

Resolution

Program data is stored in the table PA_CATALOG_ITEM

The CPNT_ID will be the Program ID. The CPNT_TYP_ID should be SYSTEM_PROGRAM_ENTITY

For Example:

SELECT * FROM PA_CATALOG_ITEM WHERE CPNT_TYP_ID = "SYSTEM_PROGRAM_ENTITY";

This query will return all the Programs which are a part of any catalog.

Refining the query further, you should be able to get the results as per your requirement.

Keywords

PA_CATALOG_ITEM, SYSTEM_PROGRAM_ENTITY, Program, Catalog , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-PRO , LMS Programs , How To

Product

SAP SuccessFactors Learning all versions