Classic View: System Administration > Ed-Fi
Search Terms: Ed-Fi
This entity represents a day in the district calendar.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger |
|---|---|
| Post | When a Day is created with the Instruction check box checked or a Day Event that is mapped to an Ed-Fi Code is added to a day.
|
| Put | When fields that are not part of the natural key are changed. |
| Delete/Post | If the Day Event Type changes:
|
| Delete | If the Instruction check box on day is unchecked:
|
School Exclude, Calendar Exclude, Resource Toggle and Resync Logic
This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.
| Action | Trigger |
|---|---|
| None | If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send. |
| Delete | If a resource is toggled to 'OFF" after data has sent and an action is performed that would trigger a delete, that data will remain in the ODS until a resync is done. |
| Resync | If a Calendar Event record is in the Ed-Fi Identity Mapping table and not in the ODS, it will be deleted from the Ed-Fi Identity Mapping table. |
| Resync | If a Calendar Event record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it will be deleted from the ODS. |
| Resync | If a mapping is changed in Resource Preferences, a resync will need to be done to reflect the changes. |
Natural Key Changes, Cascading Updates, and Deletes Logic
This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.
| Action | Trigger |
|---|---|
| Post/Delete | Natural Key change: If a 2nd schedule structure is added after data is sent, the first Calendar record will need to be Deleted/Posted with new Calendar Code logic to be Calendar ID + Schedule Structure ID.
|
| Delete | Cascading Deletes: This resource will delete if a calendar is marked as exclude after dependent data has been sent or a 2nd Schedule Structure is added after 1st Calendar is sent. |
Scope Year Logic
This table describes scope year logic of this object.
| Logic |
|---|
Calendar Dates will only send for the school year to which they are aligned.
|
Resource Preferences
This table describes the Resource Preferences of this object.
| Data Element Label | Mapping Needed |
|---|---|
| Calendar Event Descriptors | Day Detail/Event Type |
Identity Mapping Object Key
This table describes the Identity Mapping Object Key of this object.
| campusObjectType | Object Key Data Source |
|---|---|
| Day | dayID |
Event Queue Detail
This table describes the Event Queue Detail of this object.
| Campus Table | Ed-Fi Action | Fields |
|---|---|---|
| day/dayevent | Post/Put/Delete | The primary table used for sending data for this resource. |
Object Data Elements
This table describes data elements sent within the Calendars resource.
| Data Element Label | Business Requirement | Business Rule | M, C or O | Data Source GUI Path | Database Field | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | The unique identifier of the resource. | M | |||||||||||||||
| calendarEvents | The type of scheduled or unscheduled event for the day. Reports the data from the Day or Day Event for the Date being reported. | Reports the data from the Day or Day Event for the Date being reported See array for field specific logic. | M | ||||||||||||||
| date | Month, day, and year of the date being reported. Reports the Date being reported. | Reports the Date being reported. | M | System Administration> Calendar> C.alendar> Days> Date | day.date | ||||||||||||
| LocalEducation AgencyCalendar Reference | A reference to the related Local Education Agency Calendar resource. |
| M | ||||||||||||||
| _ext.tdoe.submitted ForSchoolYear TypeReference. schoolYear | Indicates the school year for which the record is reporting. | Using the End Year tied to the calendar, report the year. | M | System Administration > Calendar > Calendar | schoolYear. endYear | ||||||||||||
| _ext.tdoe.submitted ByEducation Organization Reference.education OrgnizationID | The identifier assigned to an education organization. | Populate State District Number. | M | System Administration > Resources | district. number |
Array
Type/Descriptor
