Ed-Fi Data v3.X - Bell Schedules

Classic ViewSystem Administration > Ed-Fi

Search Terms: 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.

ActionTrigger
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
DeleteWhen 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.

ActionTrigger
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
DeleteIf 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.
ResyncIf 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.
ResyncIf 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.
ResyncIf 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.

ActionTrigger
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/PostIf 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.


Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
periodschedulePost/Put/DeleteThe primary tables used for sending data for this resource.
periodPutClass Periods Reference
daysPutDates
gradelevelPutGrade levels


Object Data Elements

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

Data Element LabelBusiness RequirementBusiness RulesM, 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
  1. 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.
  1. 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.

OSystem Administration> Calendar> Calendar> Periodsperiodschedule.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
  1. 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.
  1. See array section below.
O

etag




Arrays

Class Periods

Data Element Label

Business Requirement

Business Rules

M,C or O

Data Source GUI Path

Database Field

classPeriodNameAn 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.
  1. Report a space between each value.
M

System Administration> Calendar> Calendar> Periods

System 

Administration> Calendar> Calendar> Schedule Structure

periodschedule.name + period.name + schedulestructure.structureID
schoolIDA reference to the related School resource.

Report the School ID the Period Schedule is assigned.

M

Dates

Data Element Label

Business Requirement

Business Rules

M,C or O

Data Source GUI Path

Database Field

dateThe dates for which the Bell Schedule applies.Report all of the dates on the Days tab that the period schedule is aligned.
  1. It must be an instructional day to report.
MSystem Administration> Calendar> Calendar> Daysday.periodScheduleID

Grade Levels

Data Element Label

Business Requirement

Business Rules

M,C or O

Data Source GUI Path

Database Field

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

MSystem Administration> Calendar> Calendar> Grade Levelsgradelevel.name


Type/Descriptors

Grade Level Descriptor

Code ValueDescriptionName SpaceShort Description
Adult EducationAdult Educationuri://ed-fi.org/GradeLevelDescriptorAdult Education
Early EducationEarly Educationuri://ed-fi.org/GradeLevelDescriptorEarly Education
Eighth gradeEighth gradeuri://ed-fi.org/GradeLevelDescriptorEighth grade
Eleventh gradeEleventh gradeuri://ed-fi.org/GradeLevelDescriptorEleventh grade
Fifth gradeFifth gradeuri://ed-fi.org/GradeLevelDescriptorFifth grade
First gradeFirst gradeuri://ed-fi.org/GradeLevelDescriptorFirst grade
Fourth gradeFourth gradeuri://ed-fi.org/GradeLevelDescriptorFourth grade
Grade 13Grade 13uri://ed-fi.org/GradeLevelDescriptorGrade 13
Infant/toddlerInfant/toddleruri://ed-fi.org/GradeLevelDescriptorInfant/toddler
KindergartenKindergartenuri://ed-fi.org/GradeLevelDescriptorKindergarten
Ninth gradeNinth gradeuri://ed-fi.org/GradeLevelDescriptorNinth grade
No grade levelNo grade leveluri://ed-fi.org/GradeLevelDescriptorNo grade level
OtherOtheruri://ed-fi.org/GradeLevelDescriptorOther
PostsecondaryPostsecondaryuri://ed-fi.org/GradeLevelDescriptorPostsecondary
Preschool/PrekindergartenPreschool/Prekindergartenuri://ed-fi.org/GradeLevelDescriptorPreschool/Prekindergarten
Second gradeSecond gradeuri://ed-fi.org/GradeLevelDescriptorSecond grade
Seventh gradeSeventh gradeuri://ed-fi.org/GradeLevelDescriptorSeventh grade
Sixth gradeSixth gradeuri://ed-fi.org/GradeLevelDescriptorSixth grade
Tenth gradeTenth gradeuri://ed-fi.org/GradeLevelDescriptorTenth grade
Third gradeThird gradeuri://ed-fi.org/GradeLevelDescriptorThird grade
Twelfth gradeTwelfth gradeuri://ed-fi.org/GradeLevelDescriptorTwelfth grade
UngradedUngradeduri://ed-fi.org/GradeLevelDescriptorUngraded