Tool Search: Ed-Fi
This educational entity represents an overall score or assessment tied to a course over a period of time (i.e., the grading period). Student grades are usually a compilation of marks and other scores.
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 and saved and a resync is completed. |
| Delete | When a grade is deleted from a Grading Task that is mapped to an Ed-Fi Grade Type. |
| Delete | When the Grading Period is removed from Resource Preferences. |
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
This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.
| 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
This table describes scope year logic of this object.
| Logic |
|---|
Reports the grading periods in the configured year they are aligned to.
|
Identity Mapping Object Key
campusObjectType | Object Key Data Source |
|---|---|
| EdFiGradingPeriod | edFiGradingPeriodID |
Event Queue Detail
This table describes the Event Queue Detail of this object.
Campus Table | Ed-Fi Action | Fields |
|---|---|---|
| edfiGradingPeriods | Post/Put/Delete | The primary table used for sending data for this resource. |
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 | Data Source GUI Path | Database Field |
|---|---|---|---|---|---|
| id | The unique identifier of the resource. | M | |||
| gradingPeriodDescriptor | The name of the grading period | Report 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 |
| M | System Administration>Ed-Fi > Configuration> Resource Preferences> Grading Periods> Grading Period Sequence | edfigradingperiod.sequence |
| schoolReference | Provide user information to lookup and link to an existing school record. | Reports the natural key of the School resource in 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 | Report 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 | Report 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 |
| totalInstructionalDays | The total number of instructional days in the grading period | Count 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 |
