Uploaded image for project: 'Student Success Plan'
  1. Student Success Plan
  2. SSP-1766

Add discriminator to external_student_test natural key

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: SSP 2.0.0, SSP 2.1.0, SSP 2.0.1
    • Fix Version/s: SSP 2.1.0, SSP 2.0.1
    • Component/s: Database, External Data
    • Labels:
      None

      Description

      From the field:

      External_student_test - you qualify a duplicate as someone who has taken the same test multiple times on the same date. Unfortunately, this is a completely valid scenario on our institution. There are approximately 3000 such cases of students taking the same test (often with different grades) on the same day.

      Currently we want a key on external_student_test of:

      school_id,test_code,sub_test_code,test_date

      Sounds like we need to add a discriminator to that. Thinking it could be a single-char column, defaulted to '1'.

      The changeset/s would need to split up the introduction of that column and the re-creation of the key so implementors have the opportunity to update their datasets. I.e. restart with natural keys disabled, get the new column, fix that column via updates to external data feeds, restart with natural key/s enabled.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                dmccallum Dan McCallum
                Reporter:
                dmccallum Dan McCallum
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: