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:
|
| Put | When a grade is updated on a Grading Task that is mapped to an Ed-Fi Grade Type. |
| Put | When a student CTE Program Participation record is created or deleted for a CTE Program in the same cluster as the Course the grade is for. |
| Put | When a Student CTE Program Participation record in the same cluster as the course for the grade is updated and status is added, changed, or removed. |
| Delete | When a grade is deleted from a Grading Task that is mapped to an Ed-Fi Grade Type. |
| Delete | When Grade Type Descriptor is no longer mapped and a resync is performed. |
| Delete | When the Course is marked Exclude from State Reporting or the Active box is unchecked. |
| Delete | When the No Show or State Exclude or WISE Exclude check boxes are checked on the Student's enrollment. |
| Delete | When the State Enrollment Type is changed on the student's enrollment. |
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 | 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 | ||
| gradingPeriodReference | A reference to the related GradingPeriod resource |
| M | ||
| studentSectionAssociation Reference | A reference to the related Student Section Association resource. |
| M | ||
| diagnosticStatement | A statement provided by the teacher that provides information in addition to the grade or assessment score. |
| O | ||
| letterGradeEarned | A final or interim (grading period) indicator of student performance in a class as submitted by the instructor. |
| O | Grading & Standards> Score Groups & Rubrics> Score | gradingscore.score |
| numericGradeEarned | A final or interim (grading period) indicator of student performance in a class as submitted by the instructor. |
| O | Grading & Standards> Score Groups & Rubrics> Score | gradingscore.score |
| performanceBaseConversion Descriptor | Pass/ Fail/ Incomeplete Indicator is expected to be submitted for 'CTE' courses and all courses associated to 'CCR'. |
| M | Grading & Standards > Score Groups & Rubrics > (Score Group) > Ed-Fi Grade Type | |
certificatedProgramStatus Descriptor (wi_gradeExtension) | This element does not report for the 2021-22 school year. This status is an indication of student's progress towards earning a 'certificate' within the 'certified Career Education Programs (Program Type)}. This field is required only when the student is participating in a 'certifiedCareerEducatonProgram' that is associated to a course. |
| O | Student Information > Academic Planning > Career Tech Program > Status |
