Symptom
The 'DURATION' column of the 'PA_PROGRAM' table does not display durations for open-ended programs.
Environment
SAP SuccessFactors Learning
Cause
The "Duration" column in the PA_PROGRAM table is specifically stores the duration of a program, but it is populated only when the program type is 'Duration-based'.
Resolution
The PA_PROGRAM table does not currently store the duration for open-ended programs. However, if you would like to see this feature included in future releases of LMS, we recommend submitting an Enhancement Request.
If you need the duration of Open-ended programs, this information can be found in the `PA_CPNT` table. The "CPNT_LEN" column within this table stores the program duration/hours.
See Also
Keywords
open-ended programs, program duration, hours, custom report, PA_PROGRAM table, PA_CPNT table, CPNT_LEN column, sap successfactors learning, LMS module, reporting issue, duration-based programs, data dictionary, custom report, duration , KBA , LOD-SF-LMS-CRI , Custom Report Issues , Product Enhancement
SAP Knowledge Base Article - Public