Tool Search: Ed-Fi
This entity represents the time span for which grades are reported. Quarter, Semester, Final, etc. The Start and End dates must have an calendar event in the Calendar Dates resource before Grading Periods can send. User needs to perform a day reset prior to filling out Grading Periods tab. In Indiana, the Grading Periods resource represents the reporting of progress reports (such as report cards) for a student. It does not represent the reporting of the actual grading periods where credits are assigned to students for their courses. The reporting for this is done in the Sessions resource.
The following Grades resource preference configuration is required for the appropriate set up of the Grading Periods resource.
- Grading Task = Semester Grade + Ed-Fi Code = Semester
- Grading Task = Term Grade + Ed-Fi Code = Grading Period
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger |
|---|---|
| Post | When a new Grading Period is created and saved in Resource Preferences and a resync is completed.
|
| Put | When the Grading Period Start or End Date is updated, saved, and a resync is completed. |
| Put | When the Instructional checkbox is checked or unchecked, the Total Instructional Days field updates with the correct number of instructional days. |
| Put | When the Period Sequence is changed. |
| Delete | When the Grading Period is removed and saved in Resource Preferences and a resync is completed. |
| Delete | When the last day record is deleted from the days table. |
| Delete/Post | When the Grading Period’s Grading Period Descriptor or Sequence is edited and saved in the Resource Preferences and a resync is completed. |
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 | Business Rule |
|---|---|
| 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. |
| Resync | When doing a resync, look to make sure the Grading Task is still mapped in the Grades Resource Preferences prior to sending. |
Natural Key Changes, Cascading Updates, and Deletes Logic
| Action | Trigger |
|---|---|
| Delete/Post | If the Natural Key changes: 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 the Grading Period Descriptor or Sequence changes and a resync is completed. |
| Delete/Post | If the natural key changes or the record is deleted, the Sessions Grading Periods reference will be updated. |
| Delete/Post | If the natural key of Grading Periods changes, all existing dependent data will be deleted or moved to the correct Grading Period. If a grade has not been posted yet and a Grading Period changes, a resync on the Grades resource will need to be completed. |
| Dependent Resources | Sessions Reference, Grades |
Scope Year Logic
| Logic |
|---|
Reports the grading periods in the configured year to which they are aligned.
|
Resource Preferences
| Data Element Label | Mapping Needed |
|---|---|
| Schools/Calendars/Schedule Structures/Term Schedules | Grading Period Detail |
Identity Mapping Object Key
campusObjectType | Object Key Data Source |
|---|---|
| EdFiGradingPeriod | edFiGradingPeriodID |
Event Queue Detail
Campus Table | Ed-Fi Action | Fields |
|---|---|---|
| edfiGradingPeriods | Post/Put/Delete | The primary table used for sending data for this resource. |
Error Log
| Error | Possible Causes/Resolutions |
|---|---|
| Student Over, 57744 does not have a Student Section Association record for the course 1014 ACP English 9. This record must exist before Grades can be sent. | Causes: Student has a grade for a course section that attempted to send during a resync of gradingPeriods. Student did not have a studentSectionAssociation on record. Resolution: Resync studentSectionAssociation for this student to send studentSectionAssociation and grade to Ed-Fi. |
Object Data Elements
This table describes data elements sent within the Grading Periods resource.
| Data Element Label | Business Requirement | Business Rules | M, C or O | Location |
|---|---|---|---|---|
| id | The unique identifier of the resource. | M | ||
| gradingPeriodDescriptor | The name of the grading period. | Reports the code value from the Grading Period Name selected. | M | System Administration > Ed-Fi > Configuration> Resource Preferences > Grading Periods > Grading Period Descriptor edfigradingperiod.name |
| periodSequence | The sequence of the grading period. | Reports the period sequence for the Grading Period being reported.
The sequence is determined based on the name of the 'number' in the Grading Period Descriptor up to 6. Example 'First Semester' will have a sequence of 1, 'First Nine Weeks' will have a sequence of 1. If the Grading Period Descriptor number is over 6 or cannot be determined, a default value of 1 reports. | M | System Administration > Ed-Fi > Configuration > Resource Preferences > Grading Periods > Grading Period Sequence edfigradingperiod.sequence |
| schoolReference | Provides user information to lookup and link to an existing school record. | Reports the natural key of the School resource to which the grading period is aligned. | M | |
| schoolYearTypeReference | A reference to the related SchoolYearType resource. | Reports the end year from the calendar the term is reported
| M | |
| beginDate | The start date of the grading period. | Reports the start date from the Grading Period being reported.
| M | System Administration > Ed-Fi > Configuration > Resource Preferences > Grading Periods > Grading Period Start Date edfigradingperiod. startDate |
| endDate | The end date of the grading period. | Reports the end date from the Grading Period being reported.
| M | System Administration > Ed-Fi > Configuration > Resource Preferences > Grading Periods > Grading Period End Date edfigradingperiod. endDate |
| descriptor | The name of the grading period. | Report the code value from the Grading Period Descriptor selected. | M | System Administration > Ed-Fi > Ed-Fi Configuration > Resource Preferences > Grading Periods > Grading Period Descriptor edfigradingperiod. name |
| totalInstructional Days | The total number of instructional days in the grading period. | Counts the number of instructional days on the Days tab that occur during the start and end date for the grading period.
| M | System Administration > Calendar > Calendar > Days |
| _etag | O |
