Details
-
Bug
-
Resolution: Fixed
-
Major
-
Data Standard V1.2
-
None
-
None
Description
In EducationOrgCalendar interchange, the CalendarEvent refers to a DescriptorReferenceType. Looking in the ETL to load this value, the lookup is done to the Descriptor table only to map back to the CalendarEventTypeID in the CalendarEvent Table. This seems incorrect. It seems like it would work better if CalendarDate had a FK to CalendarEventDescriptorID (instead of CalendarEventTypeID). Then the CalendarEventDescriptor table can map specific enumerated values back to the ed-fi enumerated values.
This would allow the ability to have multiple descriptor values go back to a single ed-fi type value. The current method does not allow for this, instead the descriptor granularity is lost. Consider the following:
Descriptor Value / CalendarEventType Value
Instructional = Instructional
Early Release = Instructional
In Service = Teacher Only Day
Parent/Teacher Conference = Teacher Only Day
By assigning the CalendarEvent to CalendarEventTypeID in CalendarDate, when I try to retrieve the Descriptor value for the given CalendarDate I lose the relationship.