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 grade is posted to a Grading Task that is mapped to an Ed-Fi Grade Type, or a grade is posted to a standard tied to a Rubric that is mapped to an Ed-Fi Grade Type. Standards will report to Ed-Fi if they are contained in a Standard Group that is mapped in Learning Standards. Do not report if the Course is marked as Inactive. Do not send records if the School or Calendar Exclude check box is checked. Check to see if the student has a Student Section Association in the Ed-FI identity Mapping table before sending.
The Grading Task must be mapped to a Grading Period to report.
|
| Put | When a grade is updated on a Grading Task that is mapped to an Ed-Fi Grade Type. |
| Delete | When a grade is deleted from a Grading Task that is mapped to an Ed-Fi Grade Type. When Grade Type Descriptor is no longer mapped and a resync is performed. When a Student Section Association no longer exists. |
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. |
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 | Natural Key change: If the Natural Key of the Grading Period Reference or Student Section Association changes, a delete/post will occur. |
| Delete/Post | If the Grade Type Descriptor is changed or removed. |
Scope Year Logic
This table describes scope year logic of this object.
| Logic |
|---|
Grades will post to the scope year the course's calendar is aligned to.
|
Resource Preferences
This table describes the Resource Preferences of this object.
| Data Element Label | Mapping Needed |
|---|---|
| Grading Tasks | Grade Type Descriptors |
Event Queue Detail
This table describes the Event Queue Detail of this object.
Campus Table | Ed-Fi Action | Fields |
|---|---|---|
| gradingscore.score | Post/Put/Delete | The primary table used for sending data for this resource |
| gradingTask | Post/Put/Delete | The primary table used for sending data for this resource |
Object Data Elements
This table describes data elements sent within the Grades resource.
| Data Element Label | Business Requirement and Business Rules | M, C or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|
| id | The unique identifier of the resource. | M | ||
| gradeTypeDescriptor | The type of grade (e.g., Exam, Final, Grading Period, Progress Report).
| M | Grading & Standards > Grading Tasks | gradingTask |
| gradingPeriodReference | A reference to the related GradingPeriod resource. Reports fields that are part of the Natural Key for the Programs resource.
| M | ||
| studentSectionAssociationReference | A reference to the related Student Section Association resource. Reports the fields that are part of the Natural Key for the Programs resource.
| M |
