Details
-
Improvement
-
Resolution: Obsolete
-
Minor
-
None
-
None
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.