Nebraska Ed-Fi Data v3.1 - Calendars

This entity represents a set of dates associated with an organization.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	A Calendars record will be created for each Calendar/Schedule Structure combination. When a new Calendar and Schedule Structure is created and saved via the Calendar Wizard. When a new Schedule Structure in an existing Calendar is created and saved. Do not send a record if the Calendars resource is toggled 'OFF' in the Calendars Resource Preferences. When the Secondary School field is populated, report the student's information from this new school as an override to the current school.
Put	When fields that are not part of the natural key are changed. Type - if the type is changed on the Calendar tab. Grade Levels - when a grade level is deleted from the Grade Levels tab it will be removed from the array. Grade Levels - when a grade level is added to the Grade Levels tab and a mapping exists already for that grade level. When Grade Level on Calendar Day Event is changed or added. When Start of calendar or end of calendar codes are used on Calendar Day Event.
Delete	If a calendar and/or schedule structure is deleted.
Delete/Post	Delete if a 2nd Schedule Structure is added after 1st Calendar is sent.

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	No data will send if the School or Calendar is marked as Exclude.
Delete	If the Calendar is marked as exclude after the Calendar or any dependent data is sent, the calendar and all dependent data will delete upon a resync even if the resource is toggled 'OFF'.
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.
Resync	If a Calendar 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 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. If a calendar or schedule structure is moved via script, all data send to the ODS will remain and the Delete tool will need to be used to remove all data sent. If the School ID changes, all data will remain under the old number and a resync will need to be completed to populate data under the new number. The delete tool would need to be used to remove all data from the old School ID.

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.

If a calendar or schedule structure is moved via script, all data send to the ODS will remain and the Delete tool will need to be used to remove all data sent.
If the School ID changes, all data will remain under the old number and a resync will need to be completed to populate data under the new number. The delete tool would need to be used to remove all data from the old School ID.

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. Data will only send for years that have valid configuration. A resync must be completed on the resource when a new scope year is connected in order for this data to send.

Logic

Calendar Dates will only send for the school year to which they are aligned.

Data will only send for years that have valid configuration.
A resync must be completed on the resource when a new scope year is connected in order for this data to send.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label	Mapping Needed
calendarTypeDescriptor	calendar.type

Identity Mapping Object Key

This table describes the Identity Mapping Object Key of this object.

campusObjectType	Object Key Data Source
ScheduleStructure	structureID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
calendar	Post/Put/Delete	The primary table used for sending data for this resource.
gradelevel	Put	Will update the Grade Levels field if a grade level is added/removed to the school and a mapping exists for that grade level.

Error Log

Error	Possible Causes/How to Fix
403 Forbidden: {"message": "Access to the resource could not be authorized for the requested action 'http://ed-fi.org/odsapi/actions/create'."}	This is usually caused by a security set up error in the ODS. Contact the Ed-Fi Alliance for assistant on correct security setup in the ODS
Error code return from Ed-Fi. 400: [message:Validation of 'Calendar' failed. CalendarTypeDescriptorId is required. ].	The Type field is not selected on the Calendar that is being sent or the Type selected on the Calendar is not mapped to an Ed-Fi Code in Resource Preferences

Object Data Elements

This table describes data elements sent within the Calendars resource.

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
id	The unique identifier of the resource.		M
Calendar Code	CalendarCode is a required key. We will be concatenating the schoolNumber, calendarID, scheduleStructureID and gradeLevel. example: School Number 004, calendarID 1855, structure ID 21055, grade level 12. CalendarCode = 00418552105512	Report the following values in the following order: School number calendar ID Schedule Structure ID Grade level	M	Index> Sys Admin> Resources> School> School Number Index> Sys Admin> Calendar> calendar> CalendarID Index> Sys Admin> Calendar> Calendar> Schedule Structure> scheduleStructureID Index> Sys Admin> Calendar> Calendar> gradeLevel> State Grade Level
SchoolReference	A reference to the related School resource.	Reports the fields that are part of the Natural Key for the Schools resource.	M
SchoolYearTypeReference	A reference to the related School Year resource.	Reports the End Year the calendar is associated.	M
calendarTypeDescriptor	Indicates the type of Calendar.	Reports the Ed-Fi Code the Calendar Type is mapped to in Calendar Resource Preferences If the Type is not selected on the Calendar or not mapped, an error will occur.	M	System Administration> Calendar> Calendar> Type	calendar.type
gradeLevels	Indicates the Grade Level associated with the Calendar.	See array logic below.	O

Arrays

Click here to expand...

Grade Levels

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
gradeLevelDescriptor	Indicates the GradeLevel associated with the Calendar.	Report all unique Grade Levels for the Calendar/Schedule Structure. Do not report if the Grade Level is in a Calendar marked as Exclude.	M	System Administration> Calendar> Calendar> Grade Levels	gradelevel.name

Type/Descriptor