Tennessee Ed-Fi Data v3.1 - Local Education Agency Calendar Dates

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. When a Day Event of Type NOT NULL is added to a day. Do not send a record if the Calendar Exclude checkbox is checked. Do not send a record if the School Exclude checkbox is checked. Do not send a record if the Calendar Number is equal to 0 (zero). Calendar must have a Type = D: District.
Put	When fields that are not part of the natural key are changed.
Delete/Post	If the Day Event Type changes: If the Duration on the Day Event Type changes.
Delete	If the Instruction check box on day is unchecked: If the Day Event Type is removed.

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. 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 Calendar Dates resource is toggled 'OFF" and a natural key change is made to the Calendar, the Calendar Dates record will be deleted.
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.

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 Calendar Dates resource is toggled 'OFF" and a natural key change is made to the Calendar, the Calendar Dates record will be deleted.

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. Data will only send for years that have valid configuration.

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.

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

The unique identifier of the resource.

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.

date

Month, day, and year of the date being reported. Reports the Date being reported.

Reports the Date being reported.

System Administration> Calendar> C.alendar> Days> Date

day.date

LocalEducation
AgencyCalendar
Reference

A reference to the related Local Education Agency Calendar resource.

IC Field

JSON Field

Logic

State District Number

localEducation
AgencyId

Report State District Number.

End Year

schoolYear

Report End Year of associated School Year.

Calendar Number

localEducation
Agency
Calendar
Code

Populate the Number of the calendar.

Format: 2 digit integer left zero padded.

_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.

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.

System Administration > Resources

district.
number

Array

Calendar Event Descriptor

Data Element

Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

calendarEvent
Descriptor

The types of scheduled or unscheduled event for the day (e.g., Instructional day, Teacher-only day, Holiday, Make-up day, Weather day, Student late arrival/early dismissal day).

If Instruction is selected and Day has no day events, report the ID.

Else, reports the Ed-Fi Code from mapped Day Event.

If Instruction is not checked and there is not a day event mapped to an Ed-Fi Code, do not report a record.

System Administration> Calendar> Calendar> Days> Day Detail> Instruction

System Administration> Calendar> Calendar> Day Event

day.instruction

dayevent.type

_ext.tdoe.event
Duration

The portion of the school day occupied by this event.

TN Sharepoint Requirements

Fraction of school day for this event, allowable values 1.00 (EIS record uses 100), 0.50 (EIS record uses 050), and 0.33 (EIS record uses 033)

Populate the Reported Ed-Fi Value based on the value populated in Duration on Day Event using the following logic:

Please note that if three day events of the same day event type are scheduled for a day where the value in the duration is 033; those day events would be summed to report a full day (1.00).

The Value in Duration on Day Event	Reported Ed-Fi Value
033	0.33
050	0.50
100	1.00

System Administration> Calendar> Calendar> Day Event > Duration

DayEvent.duration

Type/Descriptor

This table describes the Ed-Fi Value mapped and reported for Calendar Event Descriptor:

Code Value	Namespace	Description	Short Description
AD	uri://tdoe.edu/CalendarEventDescriptor	An instructional day that has been shortened.	Abbreviated Day
AE	uri://tdoe.edu/CalendarEventDescriptor	The last day students are scheduled to attend for the service program.	Attendance End Date
AS	uri://tdoe.edu/CalendarEventDescriptor	The first day students are scheduled to attend for the service program.	Attendance Start Date
CE	uri://tdoe.edu/CalendarEventDescriptor	The last day of the calendar for the service program.	Calendar End Date
CH	uri://tdoe.edu/CalendarEventDescriptor	A day where students and school approved personnel do not attend school. Christmas must have at least one day scheduled.	Christmas
CS	uri://tdoe.edu/CalendarEventDescriptor	The first day of the calendar for the service program.	Calendar Start Date
ID	uri://tdoe.edu/CalendarEventDescriptor	Days used for classroom instruction. Note: No restrictions have been placed on which days of the week can be designated as instructional or non-instructional. Therefore, the ability to designate a Saturday or Sunday as an instructional day will be supported.	Instructional Days
IO	uri://tdoe.edu/CalendarEventDescriptor	The number of days for staff development that do not have a scheduled date.	In Service Optional
IS	uri://tdoe.edu/CalendarEventDescriptor	A day for staff development.	In Service Day
MA	uri://tdoe.edu/CalendarEventDescriptor	An instructional day that is used to make up instructional time missed. Method: Saturday	Make-up Day - Saturday
MD	uri://tdoe.edu/CalendarEventDescriptor	An instructional day that is used to make up instructional time missed. Method: Extend School Day. (Must meet the minimum amount time that the day must be extended as per the Attendance manual.)	Make-up Day - Extend School Day
MH	uri://tdoe.edu/CalendarEventDescriptor	An instructional day that is used to make up instructional time missed. Method: Day previously designate as a Holiday	Make-up Day - Day previously designate as a Holiday
MI	uri://tdoe.edu/CalendarEventDescriptor	A missed instructional day can occur for one of the following reasons:\nInclement weather (non-stockpiled day) or Other (for example, a strong smell in the school or the school’s heating unit is not working). Note: Currently the number of hours required.	Missed Instructional Day
MS	uri://tdoe.edu/CalendarEventDescriptor	An instructional day that is used to make up instructional time missed. Method: Extend Service Program.	Make-up Day - Extend Service Program
MU	uri://tdoe.edu/CalendarEventDescriptor	An instructional day that is used to make up instructional time missed. Method: Sunday	Make-up Day - Sunday
OA	uri://tdoe.edu/CalendarEventDescriptor	The local board upon recommendation of the superintendent designates a discretionary day. Administrative	Discretionary Day - Administrative
OI	uri://tdoe.edu/CalendarEventDescriptor	The local board upon recommendation of the superintendent designates a discretionary day. Instructional	Discretionary Day - Instructional
OH	uri://tdoe.edu/CalendarEventDescriptor	A day where students and school approved personnel do not attend school. Other	Other Holiday
OO	uri://tdoe.edu/CalendarEventDescriptor	The local board upon recommendation of the superintendent designates a discretionary day. Other	Discretionary Day - Other
OS	uri://tdoe.edu/CalendarEventDescriptor	The local board upon recommendation of the superintendent designates a discretionary day. In-Service	Discretionary Day - In-Service
OV	uri://tdoe.edu/CalendarEventDescriptor	The local board upon recommendation of the superintendent designates a discretionary day. Teacher Vacation	Discretionary Day - Teacher Vacation
PT	uri://tdoe.edu/CalendarEventDescriptor	A day set up to allow parents and teachers time to address accomplishments and/or concerns regarding a child’s education.	Parent- Teacher Conference
SH	uri://tdoe.edu/CalendarEventDescriptor	A day where students and school approved personnel do not attend school. Spring Break must have at least one day scheduled. Spring Break must have at least one day scheduled	Spring Break
SI	uri://tdoe.edu/CalendarEventDescriptor	A stockpiled day used for the following: Inclement weather. Note: Inclement weather is applied to an entire day.	Stockpiled Day - Inclement Weather
SP	uri://tdoe.edu/CalendarEventDescriptor	A stockpiled day used for the following: Professional Development. Note: Professional Development may be applied in partial days.	Stockpiled Day - Professional Development
TV	uri://tdoe.edu/CalendarEventDescriptor	The designated days that are set aside during the service program for all teachers to be off.	Teacher Vacation
WN	uri://tdoe.edu/CalendarEventDescriptor	Commissioner Waived School Day	Commissioner Waived School Day