Symptom
When running a report for a class with multiple time slots (segments), the numbers associated with segments assigned are not following a sequence.
Environment
SAP SuccessFactors Learning
Reproducing the Issue
- Navigate to Learning Administration >
- Go to Reports >
- Run a report that returns values for "Seg #" (SSG_SEG_NUM) >
- Check that the order of numbers of time slots do not follow a sequence.
Resolution
When admin creates a class, the segment numbers are copied from the parent item’s agenda template. However, when an admin creates a new segment/time slot manually, then the segment number is generated by PSQ_SCHED_SEGMENT sequence and uses it for SSG_SEG_NUM.
The SSG_SEG_NUM represents the unique identifier of a segment/time slot for classes in the system. This alongside the class ID (SCH_ID) in the PA_SCH_SEG table is a primary key in the table. SSG_SEG_NUM internally is derived in the system using DB sequence PSQ_SCHED_SEGMENT.
This is not meant to be used for deriving functional interpretation of the segment like first segment, last segment etc.
Keywords
Learning, Segment, Numerical, Order, SSG_SEG_NUM, PSQ_SCHED_SEGMENT, PA_SCH_SEG, Class, Seg #, time slots, timeslot , KBA , LOD-SF-LMS-SCH , Class - Scheduled Offerings , LOD-SF-LMS , Learning Management System , How To