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). | Report 'Final'. | M | ||
| gradingPeriodReference | A reference to the related GradingPeriod resource | Reports the fields that are part of the Natural Key for the Grading Periods resource. | M | ||
| studentSectionAssociation Reference | A reference to the related Student Section Association resource. | Reports the fields that are part of the Natural Key for the Student Section Association resource. If the student has multiple enrollments in the same class, report the id for the most recent studentSectionAssociations resource. | M | ||
| diagnosticStatement | A statement provided by the teacher that provides information in addition to the grade or assessment score. | This field is optional, does not report. | O | ||
| letterGradeEarned | A final or interim (grading period) indicator of student performance in a class as submitted by the instructor. | Determine if the posted score is an integer or not:
| 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. | Determine if the posted score is an integer or not:
| 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 |
