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
          57 kB
          Geoff McElhanon
        2. screenshot-2.png
          55 kB
          Geoff McElhanon
        3. screenshot-3.png
          281 kB
          Geoff McElhanon
        4. Session ETC.pdf
          34 kB
          Ed Comer
        5. Session Revised ETC.jpg
          115 kB
          Silvia Jones (old account)

        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