SAP Knowledge Base Article - Public

2638776 - Segment ordering numbering within a class


When running a report for a class with multiple time slots (segments), the numbers associated with segments assigned are not following a sequence.


SAP SuccessFactors Learning

Reproducing the Issue

  1. Navigate to Learning Administration >
  2. Go to Reports >
  3. Run a report that returns values for "Seg #" (SSG_SEG_NUM) >
  4. Check that the order of numbers of time slots do not follow a sequence.


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.


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


SAP SuccessFactors Learning all versions