Summary of outcomes for Data Standard 3.2
- Problem Addressed: Implementations need the ability to store multiple phone numbers of the same type for parents and guardians.
- High-level Reasoning: The current key for the TelephoneNumber collection is the TelephoneNumberType descriptor. If a parent has two mobile phones, for example, this is not sufficient to allow all data to be captured. The same may also be true for Address and Email. The natural approach appears to be to have the required fields, like TelephoneNumber, be included in the natural key.
- Changes Made: Added TelephoneNumber to the key for the common type. Added ElectronicMailAddress to the key of ElectronicMail. Added all required fields (StreetNumberName, StateAbbreviation, City, PostalCode) to the key for Address.
Original ticket description follows:
SFUSD has several parents that have multiple phone numbers of the same type (two mobiles, two work numbers, etc.) that currently cannot go into the Ed-Fi ODS, as this throws the following error:
(Ed Fi Error: ' Validation of 'Parent' failed. ParentTelephones enumerable contains duplicate at index: 1 - Result: 400')
It seems the API only allows for one phone number of an individual type to be associated with a parent.
I believe this is a valid use-case, so I'm unsure why there's a restriction on this.