Nebraska Ed-Fi Data v3.1 - Grades

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 and marked as State Reported. Standards do not report to Ed-Fi. Do not report if the Course is marked as Inactive or State Excluded. 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. If the Student Section Association exits, continue with processing the record to Ed-Fi. If the Student Section Association does not exist, the record will go to the Error Log with a message stating: Student (First Name Last Name, Ed-Fi ID) does not have a Student Section Association record for the course (Course Number Course Name). This record must exist before Grades can be sent. Do not send if the student's enrollment is marked as No Show or State Exclude
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.
Delete	When the Student School Association record is deleted for the school in which the grades are associated.
Delete	When any field that is part of the Natural Key is changed.

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. Data will only send for the years that have valid configuration.

Logic

Grades will post to the scope year the course's calendar is aligned to.

Data will only send for the years that have valid configuration.

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),	Reports the Ed-Fi Code from mapping for the Grading Task. If the grading task is not mapped, do not report.	M	Grading & Standards> Grading Tasks	gradingTask
gradingPeriodReference	A reference to the related GradingPeriod resource.	Reports the fields that are part of the Natural Key for the Grading Periods resource.	M
studentSectionAssociationReference	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.	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: If the posted value is not an Integer, then report the posted score here. If the posted value is an Integer, then report in the Numeric Grade Earned field below.	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: If the posted value is an Integer, then report the posted score here If the posted value is not an Integer, then report in Letter Grade Earned field above.	O	Grading & Standards> Score Groups & Rubrics> Score	gradingscore.score
performanceBaseConversionDescriptor	The performance base conversion assessed for the student.	This field is optional, does not report.	O

Type/Descriptor

Click here to expand...

Grade Type Descriptors

Ed-Fi Short Description	Ed-Fi Description
Conduct	Conduct
Exam	Exam
Final	Final
Grading Period	Grading Period
Mid-Term Grade	Mid-Term Grade
Progress Report	Progress Report
Semester	Semester