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.
|
| Post | A District calendar is defined as a calendar of Type D: District.
|
| Put | When the Grading Period Start or End Date is updated and saved and a resync is completed. |
| Delete | When the Grading Period is removed and saved in Resource Preferences and a resync is completed. |
| Delete | When the Grading Period is removed from Resource Preferences. |
| 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
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.
|
Resource Preferences
This table describes the Resource Preferences of this object.
| Data Element Label | Mapping Needed |
|---|---|
| Grading Task/Grading Periods/Sequence/Start Date/End Date | Grading Period Detail |
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 | |||
| gradingPeriod Descriptor | The name of the grading period. |
| M | System Administration > Ed-Fi > Configuration > Resource Preferences> Grading Periods | edfigradingperiod.name |
| periodSequence | The sequence of the grading period. |
| M | System Administration> Ed-Fi > Configuration> Resource Preferences> Grading Periods | |
| _ext.tdoe.submittedForSchoolYear TypeReference.SchoolYear | Key for School Year | Using the End Date tied to the calendar, report the year Format: CCYY | M | System Administration > Calendar > Calendar > End Date | schoolYear.endYear |
| _ext.tdoe.submittedByEducation OrganizationReference.educationOgranizationID | The identifier assigned to an education organization | Populate State School Number Format: Remove leading zeros | M | System Administration > Resources > School | school.number |
