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

EducationOrganizationId type from int to long or string

    XMLWordPrintable

Details

    Description

      Right now the EducationOrganizationId is a "number" json data type and SQL "int" internal type. This effectively limits the field to 9 digits numeric (technically 10 in some cases but I digress) . As the education space becomes more dynamic and varied over time more and more org types will be loaded into edorgid this and this will start to be limiting.

      Given that so much is loaded on edorg structurally, I would like to request this be changed minimally to SQL bigint and optimally to a string type as it is naturally/fundamentally a descriptive and therefore a string data point anyway (which is many times represented as a string of numbers). This would allow for ID typologies that allow for more than 9 characters.

      I understand this is likely somewhat (changing to bigint) to very (changing to string) breaking so understand if this can not be accommodated in the near term.

      Attachments

        Activity

          People

            Unassigned Unassigned
            hibatt Andrew Rice
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Salesforce