Uploaded image for project: 'Ed-Fi Data Standard'
  1. Ed-Fi Data Standard
  2. DATASTD-917

Change GradingPeriod key to make non-volatile

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Won't Do
    • Major
    • Data Standard v2.1a - RFC
    • Data Standard v2.0
    • None
    • None

    Description

      GradingPeriod contains a BeginDate as part of the natural key. As with most dates this entity is subject to modification and likely more prone to error in data entry than with other fields.

      Vendors have reported concerns that shifts in school calendars - perhaps retroactively (e.g. a state issuing a mandate that a snow day or other event should result in a retroactive shift to school calendars) could result in significant issues with updating already-reported entities that rely on GradingPeriod, such as Grades.

      This entity seems to be a candidate for the partial key surrogate pattern, perhaps even by relying on the existing CodeValue element.

      Attachments

        1. screenshot-1.png
          screenshot-1.png
          57 kB
        2. screenshot-2.png
          screenshot-2.png
          55 kB
        3. screenshot-3.png
          screenshot-3.png
          281 kB
        4. Session ETC.pdf
          34 kB
        5. Session Revised ETC.jpg
          Session Revised ETC.jpg
          115 kB

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ejansson-inactive Eric Jansson (inactive account) (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Salesforce