Tool Search: Ed-Fi

This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.

Object Triggering Logic

Action	Trigger
Post	When a parent assessment is created. The Test Date must occur witihn the Scope Year. When a pre-existing student assessment's test date is changed to a date within the scope year, an add event is triggered. (This scenario is valid only for those pre-existing assessment dates which weren't within the scope year before.) Scenario: When the scope year is set to year 2022-2023 and there is a test wit a year of 2021-222, when the user changes the test year to 2022-23 and the test is assigned to the student, an add event is triggered. When the student has multiple enrollments that are overlapping in the same school year, reports based on the Service Type: P: Primary S: Partial N: Special Education When the student only has one enrollment, a record reports regardless of the Service Type. Does not send a student record for an enrollment that is marked as State Exclude or No Show. Does not send a record when the enrollment is in a calendar marked as Exclude. Does not send a record when the enrollment is in a school marked as Exclude.
Post	A field is changed and saved on the Test Information for the parent (non-child) assessment. When the test Date is changed.
Delete/Post	When any part of the natural key is changed.
Put	When any field that is not part of the natural key is changed and saved.
Delete	All valid parent or child assessments are removed from the student.
Delete	When all student's overlapping enrollments are deleted. When a student's enrollment is changed to No Show. When a student's Test Date no longer matches the scope year. Note: When assessments scope year is changed to out of scope and that assessment is already tied to a student (which is still within the scope year), a delete isn't sent for StudentAssessment or Assessment as the record is tied to a student.

Scope Year

Logic
Record reports for students where Student test record exists within the scope year. Test Date must occur within the Scope Year.

Logic

Record reports for students where Student test record exists within the scope year.

Test Date must occur within the Scope Year.

Resync Logic

Action	Trigger
None	When a resource is toggled to OFF after data has sent, all sent data remains in the ODS but no new data is sent.
Resync	When a record is in the Ed-Fi Identity Mapping table and not in the ODS, it is deleted from the Ed-Fi Identity Mapping table.
Resync	When a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it is deleted from the ODS.

Natural Key Changes, Cascading Updates, and Deletes Logic

Action	Trigger
Post/Delete	Natural Key changes: When an Ed-Fi ID changes, this happens with the cascading deletes from the Ed-Fi ID Change trigger. When the Test Date changes which no longer matches the scope year.

Action

Trigger

Post/Delete

Natural Key changes:

When an Ed-Fi ID changes, this happens with the cascading deletes from the Ed-Fi ID Change trigger.
When the Test Date changes which no longer matches the scope year.

Event Queue Detail

Campus Table	Ed-Fi Action	Fields
Test Score	Post/Put/Delete	The primary table for sending data for this resource.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label	Mapping Needed
Score Type	Assessment Reporting Method Descriptor
Score Fields Selected	Result Datatype Type Descriptor

Object Data Elements

Data Element Label	Business Requirement and Rules	Mandatory, Conditional, or Optional	Location
id	The unique identifier of the resource.	M
studentAssessmentIdentifier	A unique number or alphanumeric code assigned to an assessment administered to a student. Reports the test score id.	M	TestScore.scoreID
assessmentReference	A reference to the related Assessment resource. Reports the data that is part of the Natural Key for the referenced Assessment resource.	M
reportedSchoolReference	A reference to the reported School resource. A reference to the reported School resource. schoolID	O
schoolYearTypeReference	Optional, does not report.	O
studentReference	A unique alphanumeric code assigned to a student. Reports the data that is part of the Natural Key for the referenced Student resource.	M
accommodations	An unordered collection of studentAssessmentAccommodations. The specific type of special variation used in how an examination is presented, how it is administered or how the test taker is allowed to respond. This generally refers to changes that do not substantially alter what the examination measures. The proper use of accommodations does not substantially change academic level or performance criteria (e.g., Braille, Enlarged Monitor View, Extra Time, Large Print, Setting, Oral Administration). Optional, does not report.	O
administrationDate	The date and time an assessment was completed by the student. The use of ISO-8601 formats with a timezone designator (UTC or time offset) is recommended in order to prevent ambiguity due to time zones. Reports the student's parent assessment date from the student's Assessment record. When there is no assessment date, reports from the Assessment Center Test Detail Start Date. When there is no Start Date in the Assessment Center, does not report.	M	Student Information > Assessment > Test Scores > Date TestScore.date Test.startDate
administrationEndDate	The date and time an assessment administration ended. Optional, does not report.	O
administrationEnvironmentDescriptor	The environment in which the test was administered. Optional, does not report.	O
administrationLanguageDescriptor	The language in which an assessment is written and/or administered. Optional, does not report.	O
assessedMinutes	Reported time student was assessed in minutes. Hard-coded to report 0 (zero).	O
eventCircumstanceDescriptor	An unusual event occurred during the administration of the assessment. This could include fire alarm, student became ill, etc. Optional, does not report.	O
eventDescription	Describes special events that occur before during or after the assessment session that may impact use of results. Optional, does not report.	O
items	An unordered collection of studentAssessmentItems. The student's response to an assessment item and the item-level scores such as correct, incorrect, or met standard. Optional, does not report.	O
performanceLevels	An unordered collection of studentAssessmentPerformanceLevels. The performance level(s) achieved for the student assessment. Optional, does not report.	O
period	The period or window in which an assessment is supposed to be administered. See the Array section below for details.	O
platformTypeDescriptor	The platform with which the assessment was delivered to the student during the assessment session. Optional, does not report.	O
reasonNotTestedDescriptor	The primary reason student is not tested. For example: Absent Refusal by parent Refusal by student Medical waiver Illness Disruptive behavior LEP Exempt. Optional, does not report.	O
reportedSchoolIdentifier	A reported school identifier for the school the enrollment at the time of the assessment used when the assigned SchoolId is not known by the assessment vendor. Optional, does not report.
retestIndicatorDescriptor	Indicator for whether the test was retaken. For example: Primary administration First retest Second retest. Optional, does not report.	O
scoreResults	An unordered collection of studentAssessmentScoreResults. A meaningful score or statistical expression of the performance of an individual. The results can be expressed as a number, percentile, range, level, etc. See the Array section below for details. Does not report when any of the array Data Elements are either not mapped or score value is not entered.	O
serialNumber	The unique number for the assessment form or answer document. Optional, does not report.	O
studentObjectiveAssessments	An unordered collection of studentAssessmentStudentObjectiveAssessments. The student's score and/or performance levels earned for an objective assessment. Optional, does not report.	O
whenAssessedGradeLevelDescriptor	The grade level of a student when assessed. Optional, does not report.	O
_etag	A unique system-generated value that identifies the version of the resource.	O

Arrays

Click here to expand...

Score Results

Data Element Label	Business Requirement and Rules	Mandatory, Conditional, or Optional	Location
assessmentReportingMethodDescriptor	The method that the administrator of the assessment uses to report the performance and achievement of all students. It may be a qualitative method such as performance level descriptors or a quantitative method such as a numerical grade or cut score. More than one type of reporting method may be used. Reports the mapped Ed-Fi Code Value if the reporting assessment Score Fields value is populated. Does not report if not mapped.	M
resultDatatypeTypeDescriptor	The datatype of the result. The results can be expressed as a number, percentile, range, level, etc. Hard-coded value.	M
result	The value of a meaningful raw score or statistical expression of the performance of an individual. The results can be expressed as a number, percentile, range, level, etc. Reports the score value for corresponding assessment mapped score	M	Student Information > General > Assessment > Test Scores > Test Score Detail > Result Student Information > General > Assessment > Test Scores > Test Score Detail > Percent/Scale Score

Data Element Label

Business Requirement and Rules

Mandatory, Conditional, or Optional

Location

assessmentReportingMethodDescriptor

The method that the administrator of the assessment uses to report the performance and achievement of all students. It may be a qualitative method such as performance level descriptors or a quantitative method such as a numerical grade or cut score. More than one type of reporting method may be used.

Reports the mapped Ed-Fi Code Value if the reporting assessment Score Fields value is populated.

Does not report if not mapped.

resultDatatypeTypeDescriptor

The datatype of the result. The results can be expressed as a number, percentile, range, level, etc.

Hard-coded value.

result

The value of a meaningful raw score or statistical expression of the performance of an individual. The results can be expressed as a number, percentile, range, level, etc.

Reports the score value for corresponding assessment mapped score

Student Information > General > Assessment > Test Scores > Test Score Detail > Result

Student Information > General > Assessment > Test Scores > Test Score Detail > Percent/Scale Score

Period

Data Element Label	Business Requirements and Rules	Mandatory, Conditional, or Optional	Location
assessmentPeriodDescriptor	The period of time in which an assessment is supposed to be administered (e.g., Beginning of Year, Middle of Year, End of Year). Reports the mapped Ed-Fi Code Value. Tests available for mapping are those with an end year that matches the configuration end year or test's with no end year at all. Does not report period if test is not mapped.	M
beginDate	The first date the assessment is to be administered. Reports the start date from the assessment when it exists.	O	Assessment Center > Test Detail > Start Date Test.startDate
endDate	The last date the assessment is to be administered. Reports the end date from the assessment if it exists.	O	Assessment Center > Test Detail > End Date Test.endDate

Type/Descriptor