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

Enforce LocalEducationAgencyId in Schools

    XMLWordPrintable

Details

    • DS Refinement

    Description

      Based on the SC deployment we have run into an issue that may require a slight change to Schools. Currently the only field in School that is non-nullable is SchoolID, but that doesn't allow for situations like in SC where districts may have a summer school school ID that may not be unique in the state but is unique when combined with the LEA ID.

      The issue stems from the int length limit on the EdOrg and related ID fields. Our solution was to send the School + LEA ID pairs to schools table for district ODS, but in the state ODS this fails because only SchoolID is required. For an initial solution, expanding the required field and the keys on that table to include LEA ID.

      Tagging ea-mtenhooremondal1026 for further background and visibility.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Roshd87 Rosh Dhanawade
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Salesforce