Bell Schedules (Tennessee v5.3)

Tool Search: Ed-Fi

This entity represents the schedule of class period meeting times.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a Period Schedule is created and saved. A separate record will be sent for each Period Schedule/Period Name/Schedule Structure ID combination created. Do not send records if the Calendar Exclude check box is checked. Do not send a record if the School Exclude checkbox is checked.
Put	When any field not part of the Natural Key is changed: Period Name If the Period Schedule is added or removed to a day on the Days tab. If a Grade Level that is mapped to an Ed-Fi code is added/removed from the Schedule Structure. If the Instructional Day checkbox is added/removed.
Delete/Post	When any field part of the natural key is changed. Period Schedule Name
Delete	When all Periods in a Period Schedule are deleted or the Period Schedule is deleted.

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 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 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
Delete/Post	If any of the following changes in the Schools resource: If the School Number/Ed-Fi School Number changes, a delete/post will occur with the cascading deletes from the School ID change triggers.
Delete/Post	If Period Schedule Name or Period Name Changes.

Action

Trigger

Delete/Post

If any of the following changes in the Schools resource:

If the School Number/Ed-Fi School Number changes, a delete/post will occur with the cascading deletes from the School ID change triggers.

Delete/Post

If Period Schedule Name or Period Name Changes.

Scope Year Logic

This table describes scope year logic of this object.

Logic
Period Schedules will only send for the school year to which they are aligned. Data will only send for years that have valid configuration.

Logic

Period Schedules will only send for the school year to which they are aligned.

Data will only send for years that have valid configuration.

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
periodschedule	Post/Put/Delete	The primary tables used for sending data for this resource.
period	Put	Class Periods Reference
days	Put	Dates
gradelevel	Put	Grade levels

Object Data Elements

This table describes data elements sent within the Bell Schedules resource.

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
id	Id	The unique identifier of the resource.	M
bellScheduleName	Name or title of the Bell Schedule.	Report the Period Schedule Name + Schedule Structure ID Report a space between each value.	M	System Administration> Calendar> Calendar> Periods System Administration> Calendar> Calendar> Schedule Structure	periodschedule.name + schedulestructure.structureID
classPeriods	An unordered collection of bellScheduleClassPeriods. The class periods that compose this BellSchedule.	Reports the Class Period reference for all periods in the period schedule. See array section below .	M
schoolReference	A reference to the related School resource.	Reports the fields that are part of the Natural Key for the Schools resource.	M
alternateDayName	An alternate name for the day (e.g., Red, Blue).	Report the Period Schedule Name.	O	System Administration> Calendar> Calendar> Periods	periodschedule.name
dates	An unordered collection of bellScheduleDates. The dates for which the BellSchedule applies.	Reports all of the dates the period schedule is aligned to See array section below.	O
gradeLevels	An unordered collection of bellScheduleGradeLevels. The grade levels the particular BellSchedule applies to.	Reports all of the grade levels in the schedule structure the period schedule is aligned to. See array section below.	O
etag

Arrays

Click here to expand...

Class Periods

Data Element Label	Business Requirement	Business Rules	M,C or O	Data Source GUI Path	Database Field
schoolID	A reference to the related School resource.	Report the School ID the Period Schedule is assigned.	M

Data Element Label

Business Requirement

Business Rules

M,C or O

Data Source GUI Path

Database Field

classPeriodName

An indication of the portion of a typical daily session in which students receive instruction in a specified subject.

Report the Period Schedule Name + Period Name + Schedule Structure ID.

Report a space between each value.

System Administration> Calendar> Calendar> Periods

System

Administration> Calendar> Calendar> Schedule Structure

periodschedule.name + period.name + schedulestructure.structureID

schoolID

A reference to the related School resource.

Report the School ID the Period Schedule is assigned.

Dates

Data Element Label	Business Requirement	Business Rules	M,C or O	Data Source GUI Path	Database Field
date	The dates for which the Bell Schedule applies.	Report all of the dates on the Days tab that the period schedule is aligned. It must be an instructional day to report.	M	System Administration> Calendar> Calendar> Days	day.periodScheduleID

Grade Levels

Data Element Label	Business Requirement	Business Rules	M,C or O	Data Source GUI Path	Database Field
gradeLevelDescriptor	The grade levels to which the particular Bell Schedule applies.	Report all unique Grade Levels in the schedule structure that are mapped to an Ed-Fi Grade Level.	M	System Administration> Calendar> Calendar> Grade Levels	gradelevel.name

Type/Descriptors