Description

This trigger runs when a Grading Period Setting is inserted or updated.

If ‘Current’ was set to true as part of the update, or if ‘Current’ was already true and the Session or Grading Period Type was changed as part of the update, this trigger will set Current = false for its sibling Grading Period Settings, and update the Session: Grading Period Type on the related Sessions with this Grading Period Setting's Grading Period Type.

If multiple Grading Period Settings for the same Session are set with Current = true in the same transaction, the first GPS will be set with Current = true. The rest in the transaction will have Current = false.