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 an Assessment is assigned to a student, and the Assessment date is on or within the config year start and end dates. Does not send when a student does not have an active enrollment on the Assessment start date. 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.
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 the assessment 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 records exist within the scope year. Test Date must occur within the Scope Year.

Logic

Record reports for students where student test records exist 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	M, C, or O	Location
id	The unique identifier of the resource.	M
studentAssessmentIdentifier	A unique number or alphanumeric code assigned to an assessment administered to a student. Pass a unique number or alphanumeric code assigned to an assessment administered to a student. (Ex StudentUniqueId + AssessmentIdentifier + SchoolYear)	M
assessmentReference	A reference to the related Assessment resource. Reports the data that is part of the Natural Key for the Assessment resource assessmentIdentifier = Reports Assessment Type-Subject-EdOrgID (Ex. ASVAB-26006 or EOCFAL-ENGLI2-26006) ASVAB Assessment Type - Reports ASVAB when a student has a Test Score record with a National Code of ASVAB Subject - NA EOC Exception Assessment Type - Reports EOCEX2 or EOCEX3 or EOCEX4 from the Result field from the student’s Assessment list. Subject - Can report one of 2 ways: Look for the following user-entered state codes in System Admin> Custom> Attribute/Dictionary> Test> Test Type> Dictionary Detail. If the state codes are not entered on the Dictionary Detail as described above, report value is mapped to the Subject from the Test Detail as follows: ENGLI2 ALGEB1 BIOLO1 AMGOV1 OR When Student Info > General > Enrollments > Special Ed Fields > Map-A = checked, report each of the 4 state assessment subject codes (ENGLI2, ALGEB1, BIOLO1, AMGOV1). Do not return > 1 record for each of the above state subject codes per student in the Subject field. If > 1 assessment record with an EOC exception code exists for a student for one of the 4 required EOCs, use the record where the Date on the Test Score Detail is the most recent. EOCFAL, EOCSPR, EOCSUM Assessment Type - Reports EOCFAL or EOCSPR or EOCSUM from the Assessment Type field on a student’s Course Section. Subject - Reports the subject from the Assessment Subject field on a student’s Course. LEPELL Assessment Type - Reports LEPELL when a student has an EL record (status = LEP, Pending, or Exited within the current year) and have a section with an Assessment Type of LEPELL Subject - NA MAP Assessment Type - Reports MAPSPR when a student is registered in a course that has a Course Assessment Subject of MATH, ELA, or SC Subject - Reports the subject from the Assessment Subject field on a student’s Course. namespace = Report assessment namespace based upon the Assessment Type being reported above. Hardcode ASVAB to uri://dese.mo.gov/ASVAB Hardcode EOCEX2 to uri://dese.mo.gov/EOCEX2 Hardcode EOCEX3 to uri://dese.mo.gov/EOCEX3 Hardcode EOCEX4 to uri://dese.mo.gov/EOCEX4 Hardcode EOCFAL to uri://dese.mo.gov/EOCFAL Hardcode EOCSPR to uri://dese.mo.gov/EOCSPR Hardcode LEPELL to uri://dese.mo.gov/LEPELL Hardcode MAPSPR to uri://dese.mo.gov/MAPSPR	M
schoolYearTypeReference	Reports the data that is part of the Natural Key for the School Year Type resource schoolYear = End year of Current School Year	M
studentReference	A unique alphanumeric code assigned to a student. Reports the data that is part of the Natural Key for the referenced Student resource. studentUniqueId = Student State ID	M
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. For tests through Test Setup, report the date the Assessment was taken For assessments through course/section - report the section end date, unless the student has a roster end date	M	Student Information > Assessment > Test Scores > Date TestScore.date Test.startDate
studentObjectiveAssessments	An unordered collection of studentAssessmentStudentObjectiveAssessments. The student's score and/or performance levels earned for an objective assessment. See the Array section.	M
whenAssessedGradeLevelDescriptor	The grade level of a student when assessed. Report the Grade level from the enrollment as of the time data is being submitted. Follow typical priority list (Primary/Partial/SPED, Latest Start Date, Highest Enrollment ID)	O	Enrollments > General Enrollment Info > Grade
period	See the Array section.	O
platformTypeDescriptor	The platform with which the assessment was delivered to the student during the assessment session. Report the method used to administer the assessment.	C	Course/Section > Section > Section Editor > Test Method
administratorFirstName	The first name of the educator who will be administering the assessment. administratorFirstName is required when Assessment is EOCFAL, EOCSUM, EOCSPR, OR LEP/ELL. MAPSPR : Report primary teacher's first name and last name, from the primary teacher who is active. (Primary teacher > Current Identity > First Name) Report when Course > Assessment Subject = ELA, LEP/ELL, MATH, or SC and Course > Section > Assessment Type = MAPSPR If the teacher's first name is blank, do not report. If student does not have any courses where subject area = ELA, MATH or SC, do not report. Pull the administratorFirstName from the most recent active primary teacher record as of the date range entered in the extract editor. IF Assessment Type = EOCEXP or ASVAB, do not report	C	Course/Section > Sections > Staff History > Primary Teacher (First Name)
administratorLastName	The last name of the educator who will be administering the assessment. administratorLastName is required when Assessment is EOCFAL, EOCSUM, EOCSPR, OR LEP/ELL. MAPSPR : Report primary teacher's first name and last name, from the primary teacher who is active as of report generation end date. (Primary teacher > Current Identity > Last Name) Report when Course > Assessment Subject = ELA, LEP/ELL, MATH or SC and Course > Section > Assessment Type = MAPSPR If the teacher's last name is blank, do not report. If student does not have any courses where subject area = ELA, MATH or SC, do not report. Pull the administratorLastName from the most recent active primary teacher record as of the date range entered in the extract editor. IF Assessment Type = EOCEXP or ASVAB, do not report	C	Course/Section > Sections > Staff History > Primary Teacher (Last Name)
schoolReference	The identifier assigned to a school. Reports the data that is part of the Natural Key for the School resource schoolId = Reporting School Code	O
electronicMail	The type of email listed for an individual or organization. For example: Home/Personal, Work, etc.) The electronic mail (e-mail) address listed for an individual or organization. electronicMailTypeDescriptor = Work electronicMailAddress = Report the Email address, if exists, for the individual returned in the administratorFirstName and administratorLastName fields above. If the administratorFirstName and administratorLastName fields are not reporting or there is no email address in the system, do not report electronicMail.	C	Demographics > Personal Contact Information > Email
sort	The final value in which the labels will be sorted. If Assessment is 'MAPSPR' then SORT value is expected. The Map Sort is on the Section of a course. If the Map Sort value is "1: Room Number". report the room number of the section the student is on the roster of. If a section or the course for a section is flagged as homeroom, and the Map Sort value is "2: Homeroom teacher", report the last name of the primary teacher of the section the student is on the roster of. IF Assessment Type = EOCEXP, LEPELL, or ASVAB, do not report.	O	Student Information > General > Assessment Precode > MAP Sort
_etag	A unique system-generated value that identifies the version of the resource.	O

Arrays

Click here to expand...

Student Objective Assessments

Data Element Label	Business Requirement/Rules	Database Location
objectiveAssessmentReference	Reports the data that is part of the Natural Key for the Objective Assessment resource assessmentIdentifier = Report the Test Type Code. Reports Parent only. Hardcode to ASVAB-EdOrgID (Ex ASVAB-26006) identificationCode = Reports ASVAB Child assessment name Arithmetic Reasoning Auto and Shop Information Electronics Information General Science Math Skills Mathematics Knowledge Mechanical Comprehension Military Entrance Score OR Armed Forces Qualification Test Paragraph Comprehension Science and Tech Skills Verbal Skills Word Knowledge namespace = Hardcode to "uri://dese.mo.gov/ASVAB"	Assessment > Assessment Center > Test Information > Name
scoreresults	An unordered collection of studentAssessmentStudentObjectiveAssessmentScoreResults. A meaningful score or statistical expression of the performance of an individual. The results can be expressed as a number, percentile, range, level, etc. assessmentReportingMethodDescriptor = Hardcode to "Number score" resultDatatypeTypeDescriptor = Report the ASVAB Score Type for each objectiveAssessmentReference.identificationCode being reported for the student result = Report the ASVAB Grade Standard Score for each objectiveAssessmentReference.identificationCode being reported for the student \

Data Element Label

Business Requirement/Rules

Database Location

objectiveAssessmentReference

Reports the data that is part of the Natural Key for the Objective Assessment resource

assessmentIdentifier = Report the Test Type Code. Reports Parent only. Hardcode to ASVAB-EdOrgID (Ex ASVAB-26006)
identificationCode = Reports ASVAB Child assessment name
- Arithmetic Reasoning
- Auto and Shop Information
- Electronics Information
- General Science
- Math Skills
- Mathematics Knowledge
- Mechanical Comprehension
- Military Entrance Score OR Armed Forces Qualification Test
- Paragraph Comprehension
- Science and Tech Skills
- Verbal Skills
- Word Knowledge
namespace = Hardcode to "uri://dese.mo.gov/ASVAB"

Assessment > Assessment Center > Test Information > Name

scoreresults

An unordered collection of studentAssessmentStudentObjectiveAssessmentScoreResults. A meaningful score or statistical expression of the performance of an individual. The results can be expressed as a number, percentile, range, level, etc.

assessmentReportingMethodDescriptor = Hardcode to "Number score"
resultDatatypeTypeDescriptor = Report the ASVAB Score Type for each objectiveAssessmentReference.identificationCode being reported for the student
result = Report the ASVAB Grade Standard Score for each objectiveAssessmentReference.identificationCode being reported for the student

Period

Data Element Label	Business Requirements and Rules	M, C, or O	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). Period is required when Assessment is EOCFAL, EOCSUM, EOCSPR, or any of the MAPSPR assessment types (MATH, ELA, SC).	C	Course/Section > Sections > Section Editor > Section Schedule Placement

Type/Descriptor