The Classes displayed for a student in a school using Flex Scheduling are not in period order

Environment

  • Scheduling type: Flexible (Flex) Scheduling

Cause

Classes have values in and are sorting on MST.PD, which is not used in flex scheduling


Resolution

Update the MST.PD field to 0 for all Sections at schools using Flex Scheduling

EXAMPLE:

UPDATE MST SET MST.PD = 0 WHERE SC = (SC)
SQL



NOTE: If MST.PD has values, other traditional scheduling fields may also be populated. This article provides a query to clear all traditional scheduling fields