What table stores the data for programs in a catalog?
Learning Management System
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
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.
PA_CATALOG_ITEM, SYSTEM_PROGRAM_ENTITY, Program, Catalog , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-PRO , LMS Programs , How To