powerschool does not index newly created blocks, it sorts them and then assigns them an order value. Currently ADV and X block are swapped everywhere. Need to update all of the queries at the end of 2023/2024 PRIOR to course rollover and new course creation.
Changing this prior the end of the school year will break all of the Advisory and misc X-Block courses. We should NOT do this.
The proper sort/decode order is:
1:A
2:B
3:C
4:D
5:E
6:F
7:G
8:H
9:X
10:ADV
powerschool does not index newly created blocks, it sorts them and then assigns them an order value. Currently ADV and X block are swapped everywhere. Need to update all of the queries at the end of 2023/2024 PRIOR to course rollover and new course creation.
Changing this prior the end of the school year will break all of the Advisory and misc X-Block courses. We should NOT do this.
The proper sort/decode order is: 1:A 2:B 3:C 4:D 5:E 6:F 7:G 8:H 9:X 10:ADV