Michigan Ed-Fi Data - v2.0

Classic View: System Administration > Ed-Fi

Search Terms: Ed-Fi

This article defines all of the elements of data sent per entity between Campus and the Ed-Fi system. 

    • Certain future data is suppressed when syncing data from Campus to Ed-Fi which requires a resync to be performed when the active year is changed. Only past and present data is synced with a valid configuration.
    • Data in schools and calendars marked as Exclude will not send data to Ed-Fi.
    • Person-related records do not trigger a send of data to Ed-Fi if the person does not have an Ed-Fi ID value assigned.
    • Ed-Fi ignores custom field data entered in Campus.

An entity is a collection of related data which is sent in a cluster of data elements from Campus to Ed-Fi. Select the following links to view what data elements are contained and sent within that entity:

Understand Object Triggering Tables

The Object Triggering Logic Tables describe what actions within Campus result in data being triggered to sync to Ed-Fi.

The following table lists the definition of each potential Action:

ActionDefinition
PostThis will insert new records and data within Ed-Fi.
PutThis action will update existing information within Ed-Fi.
GetThis action is used for items that are pre-loaded. For example, Courses and Programs.
DeleteThis will delete records and data within Ed-Fi.

Understand Object Data Element Tables

The Object Data Element tables describe all of the elements contained within a reporting entity. Each element is given a description of what it is and any potential logic used to calculate the element, if the element is mandatory for reporting to Ed-Fi (indicated by an M), where the data is pulled from the Campus database and where the pulled information is entered within the Campus UI.

Elements marked as M are mandatory elements which must report data to Ed-Fi in order to meet reporting requirements. Elements marked as O are optional elements which are not mandatory for the Ed-Fi requirement but can be populated and report data for additional state-specific reporting purposes. Elements listed as C are conditional elements which are not required to report but will report data if the data is present within Campus.

Image 2: Example of a Object Data Elements Table

Understand Type/Descriptor Tables

The Type/Descriptor section describes each element and their corresponding Campus to Ed-Fi value translation that is occurring.

If the element is reporting a Descriptor, the Ed-Fi Code Value is reported.

If the element is reporting a Type, the Ed-Fi Short Description is reported.


Entites and Elements

The following lists all the currently available and syncing entities and their respective elements. 


Assessment

This entity represents a tool, instrument, process, or exhibition composed of a systematic sampling of behavior for measuring a student's competence, knowledge, skills, or behavior. An assessment can be used to measure differences in individuals or groups and changes in performance from one occasion to the next.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

Early Childhood Special Education Assessment (Student Information > Special Education > Documents > OMP)

When a student in the year and calendar reporting has the following:

  • A locked OMP - Child Outcomes Review (Print Format: 'miOMP')
  • Locked document has Type = Early Childhood
  • EC Assessment Tool = NOT NULL
Post

Part C Assessment (Student Information > Special Education > Documents > OMP)

When a student in the year and calendar reporting has the following:

  • A locked OMP - Child Outcomes Review (Print Format: 'miOMP')
  • Locked document has Type = Part C
  • Part C Data Source = NOT NULL
DeleteAssessments are not deleted once they are created.


Scope Year Logic

This table describes scope year logic of this object.

Logic

Early Childhood Special Education Assessment: Record will report for each year in which there is a locked OMP.

If the school year Start and End Date = Null, then report 07/01/XXXX as the Start Date and an End Date of 06/30/XXXX

Part C Assessment: Record will report for each year in which there is a locked OMP.

If the school year Start and End Date = Null, then report 07/01/XXXX as the Start Date and an End Date of 06/30/XXXX

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


Object Data Elements

This table describes data elements sent within the Calendar Dates resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
assessmenFamilyReference

A reference to the related AssessmentFamily resource.

This field is optional and does not report. 


ON/AN/A
title

The title or name of the assessment. NEDM: Assessment Title.

  • Early Childhood - reports name from EC Assessment Tool
  • Part C Assessment - reports name from Part C Data Source
M

SEPOutcomeMeasures. assessmentTool (Early Childhood)

SEPlan.codeDescription (Part C)

Student Information > Special Education > Documents > OMP
assessedGradeLEvelDescriptor

The typical grade level for which an assessment is designed. If the test assessment spans a range of grades, then this attribute holds the highest grade assessed. If only one grade level is assessed, then only this attribute is used. 

For example: Adult, Prekindergarten, First grade, Second grade, etc.

Always reports 30.

MN/AN/A
academicSubjectDescriptor

The description of the content or subject area (e.g., arts, mathematics, reading, stenography, or a foreign language) of an assessment. NEDM: Assessment Content, Academic Subject

Always reports Other.

MN/AN/A
version

The version identifier for the assessment.

Always reports 1.

MN/AN/A
categoryDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. 

  1. Reports the mapped Ed-Fi Code from Part C Data Source.
  2. Reports the mapped Ed-Fi Code from EC Assessment Tool.


M
Student Information > Special Education > Documents > OMP
lowestAssessed GradeLevelDescriptor

If the test assessment spans a range of grades, then this attribute holds the lowest grade assessed. If only one grade level is assessed, then this attribute is omitted.

This field is optional and does not report.


ON/AN/A
form

Identifies the form of the assessment, for example a regular versus makeup form, multiple choice versus constructed response, etc

This field is optional and does not report.


ON/AN/A
revisionDate

The month, day, and year that the conceptual design for the assessment was most recently revised substantially

This field is optional and does not report.


ON/AN/A
maxRawScore

The maximum raw score achievable across all assessment items that are correct and scored at the maximum.

This field is optional and does not report.


ON/AN/A
nomenclature

Reflects the common nomenclature for an element.

This field is optional and does not report.


ON/AN/A
periodDescriptor

The ID of the Assessment Period Descriptor.

This field is optional and does not report.


ON/AN/A
namepsace

Namespace for the Assessment.

Always reports http://midatahub.org/namespaces/IC/assessment.

ON/AN/A
contentStandrd

An indication as to whether an assessment conforms to a standard.

This field is optional and does not report.


ON/AN/A
essays

An unordered collection of assessmentEssays. (Mi EXT) The set of essay items that are associated with an assessment. 

This field is optional and does not report.


ON/AN/A
identificationCodes

An unordered collection of assessmentIdentificationCodes. A unique number or alphanumeric code assigned to an assessment by a school, school system, a state, or other agency or entity.

O

assessmentIdentificationSystemDescriptor

A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to an assessment.

  1. Always report 'District'.
M

identificationCode 

A unique number or alphanumeric code assigned to an assessment by a school, school system, state, or other agency or entity.

  1. Always report 'District'.
M

assigningOrganizationIdentificationCode

The organization code or name assigning the assessment identification code.

This field is optional and does not report.


O

languages

An unordered collection of assessmentLanguages. An indication of the languages in which the Assessment is designed.

This field is optional and does not report.


ON/AN/A
performanceLevels

An unordered collection of assessmentPerformanceLevels. Definition of the performance levels and the associated cut scores. Three styles are supported: 

  1. Specification of performance level by minimum and maximum score 
  2. Specification of performance level by cut score, using only minimum score 
  3. Specification of performance level without any mapping to scores. 

This field is optional and does not report.


ON/AN/A
programs

An unordered collection of assessmentPrograms. The programs associated with the Assessment.

This field is optional and does not report.


ON/AN/A
scores

An unordered collection of assessmentScores. Definition of the scores to be expected from this assessment.

This field is optional and does not report.


ON/AN/A
sections

An unordered collection of assessmentSections. The section(s) to which the Assessment is associated.

This field is optional and does not report.


ON/AN/A


Type/Descriptors


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for EC Assessment Tool:

Ed-Fi Code ValueEd-Fi Short Description
01AEPS
02FULL Battelle
03Battelle SCREENER
04Brigance
05Carolina
06COR
07Creative Curriculum
08LAP-3
09Part C Exit Tool: AEPS
10Part C Exit Tool: Battelle
11Part C Exit Tool: Bayley
12Part C Exit Tool: Brigance
13Part C Exit Tool: Carolina
14Part C Exit Tool: EIDP
15Part C Exit Tool: E-LAP
16Part C Exit Tool: HELP
17Part C Exit Tool: IDA
18Part C Exit Tool: Other
19Teaching Strategies GOLD
20COR Advantage
21BRIGANCE Inventory of Early Development – III (IED-III)

This table describes the Ed-Fi Value mapped and reported for Part C Data Source:

Ed-Fi Code ValueEd-Fi Short Description
AAEPS
BE-LAP
CHELP
DEIDP
EBrigance
FOther
GCarolina
HIDA
IBattelle
JBayley

This table describes the Ed-Fi Value mapped and reported for Academic Subject Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
CompositeCompositeComposite
Critical ReadingCritical ReadingCritical Reading
EnglishEnglishEnglish
English Language ArtsEnglish Language ArtsEnglish Language Arts
ReadingReadingReading
MathematicsMathematicsMathematics
Life and Physical SciencesLife and Physical SciencesLife and Physical Sciences
Social Sciences and HistorySocial Sciences and HistorySocial Sciences and History
Social StudiesSocial StudiesSocial Studies
ScienceScienceScience
Fine and Performing ArtsFine and Performing ArtsFine and Performing Arts
Foreign Language and LiteratureForeign Language and LiteratureForeign Language and Literature
WritingWritingWriting
Physical, Health, and Safety EducationPhysical, Health, and Safety EducationPhysical, Health, and Safety Education
Career and Technical EducationCareer and Technical EducationCareer and Technical Education
Religious Education and TheologyReligious Education and TheologyReligious Education and Theology
Military ScienceMilitary ScienceMilitary Science
OtherOtherOther
English Language AcquisitionEnglish Language AcquisitionEnglish Language Acquisition
0State Approved CTE CourseState approved CTE Courses reported in CTEIS. Data for these courses will be obtained through CTEIS. These data may be, but are not required to be reported in TSDL.
1English language and literatureEnglish language and literature
2MathematicsMathematics
3Life and Physical SciencesLife and Physical Sciences
4Social Sciences and HistorySocial Sciences and History
5Fine and Performing ArtsFine and Performing Arts
6Foreign language and LiteratureForeign language and Literature
7Religious Education and TheologyReligious Education and Theology
8Physical, Health and Safety EducationPhysical, Health and Safety Education
9Military ScienceMilitary Science
10Computer and Information SciencesComputer and Information Sciences
11Communication and Audio/Visual TechnologyCommunication and Audio/Visual Technology
12Business and marketingBusiness and marketing
13ManufacturingManufacturing
14Health Care SciencesHealth Care Sciences
15Public, Protective, and Government ServicePublic, Protective, and Government Service
16Hospitality and TourismHospitality and Tourism
17Architecture and ConstructionArchitecture and Construction
18Agriculture, Food and natural ResourcesAgriculture, Food and natural Resources
19Human ServicesHuman Services
20Transportation, Distribution and LogisticsTransportation, Distribution and Logistics
21Engineering and TechnologyEngineering and Technology
22MiscellaneousMiscellaneous
51English Language and LiteratureAcademic subject area related to English language and literature.
52MathematicsAcademic subject area related to mathematics.
53Life and Physical SciencesAcademic subject area related to life or physical science.
54Social Sciences and HistoryAcademic subject area related to social science or history.
55Fine and Performing ArtsAcademic subject area related to the fine or performing arts.
56Foreign Language and LiteratureAcademic subject area related to foreign language and literature.
57Religious Education and TheologyAcademic subject area related to religion and theology.
58Physical, Health and Safety EducationAcademic subject area related to physical, health or safety education.
60Computer and Information SciencesAcademic subject area related to computer or information sciences.
61Communication and Audio/Visual TechnologyAcademic subject area related to communication and audio/video technology.
62Business and marketingAcademic subject area related to business and marketing.
63ManufacturingAcademic subject area related to manufacturing.
64Health Care SciencesAcademic subject area related to health care sciences.
65Public, Protective, and Government ServiceAcademic subject area related to public, protective, and government services.
66Hospitality and TourismAcademic subject area related to hospitality and tourism.
67Architecture and ConstructionAcademic subject area related to architecture and construction.
68Agriculture, Food and natural ResourcesAcademic subject area related to agriculture, food, and natural resources.
69Human ServicesAcademic subject area related to human services.
70Transportation, Distribution and LogisticsAcademic subject area related to transportation, distribution, and logistics.
71Engineering and TechnologyAcademic subject area related to engineering and technology.
72MiscellaneousAcademic subject area, taught prior to the secondary school level, not represented in any other category.
73Nonsubject SpecificCourses that are not differentiated by subject area--that is, where students are enrolled in a grade-specific course and are taught various subjects throughout the day, rather than being enrolled in subject-specific courses.




Calendar Dates

This entity represents a day in the school calendar.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Days report by school not calendar in Ed-Fi, so when working with multiple calendars/schedule structures it is possible a day could be reporting even if it is not in the calendar you are working in.


ActionTrigger
Post

When a Day and/or a Day Event is created and saved or the Instruction checkbox is checked.

  • Days can be set either manually or by the Day Reset tool.
  • Day Events can be set either manually or by the Multi Day Event Wizard.
  • Send a record for each date that meets the reporting criteria.
  • When there is more than 1 calendar/schedule structure, any day that has a day event will report. If the same day in multiple calendars has events that are not the same, all events will report.
  • If the same day in different calendar/schedule structures has the same event, only 1 record will report. 
  • Do not send a record if the Calendar Exclude checkbox is checked.
PutWhen a Day Event or Duration is changed and saved.
Delete

When the Instruction checkbox is unchecked or a Day Event is deleted and saved.

  • When removing a day event there must only be one day event reported to send a delete. If there is more than one, it updates the day, not deletes.


Scope Year Logic

This table describes scope year logic of this object.

Logic
Reports the calendar dates in the scope year to which the calendar is aligned.
Data will only send for the years that have a valid configuration.

Future Years data will be suppressed until the Active Year is changed:

  • This allows the Schedule Wizard to be used and reduces the number of records sent until the final schedule is completed.
  • A resync must be done after the Active Year is changed to send data.


Object Data Elements

This table describes data elements sent within the Calendar Dates resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
schoolReference

Reports data from the SchoolID field that is part of the natural key for the Schools resource. The following elements are reported:

  • schoolID
MSchool.entityIDSystem Administration > Resources > School > Entity ID
date

Month, day, and year of the date being reported.

MDay.dateSystem Administration > Calendar > Calendar > Days > Date
calendarEvents

An unordered collection of calendarDateCalendarEvents. This entity represents a day in the school calendar.

  • Data is reported from the Day or Day Event for the Date being reported. 

See the Calendar Event Descriptor table in the Type/Descriptor section below.


N/AN/A
Calendar Event Descriptor

This descriptor holds the types of scheduled or unscheduled events for the day.

Logic reports as follows:

  • Reports 'Instructional Day' if the Instructional Day box is marked on the day.
  • Otherwise, logic reports the Ed-Fi code from the data dictionary of the Day Event that is selected and saved.
  • If Instruction is not marked for the day and there is not a day event mapped to an Ed-Fi code, no record is reported.

See the Calendar Event Descriptor table in the Type/Descriptor section below.

M

day.duration

OR

calendar.studentDay

System Administration> Calendar> Calendar> Days> Day Detail> Duration

OR

System Administration > Calendar > Calendar > Day

eventDuration

Reports the duration of the day event being reported.

This element is optional and does not report.

ON/AN/A
_etag

A unique system-generated value that identifies the version of the resource. 

This does not report.

ON/AN/A


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Calendar Event Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01Instructional DayInstructional Day
02Teacher only dayTeacher only day
03HolidayHoliday
04Make-up dayMake-up day
05Weather DayWeather Day
06Student late arrival/early dismissalStudent late arrival/early dismissal
07Emergency dayEmergency day
08StrikeStrike
09OtherOther





Class Periods

This entity represents the designation of a regularly scheduled series of class meetings at designated times and days of the week.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a Period Schedule is created and saved.

  • A separate record will be sent for each Period Schedule/Period Name/Schedule Structure ID combination created.
  • Do not send records if the Calendar Exclude checkbox is marked.
  • Do not send a record if the School Exclude checkbox is marked.
PostWhen a Period Schedule Name or Period Name is changed and saved.
DeleteWhen a Period Schedule Name or Period Name is changed and saved.
DeleteWhen a Period Schedule or Period is deleted.


Scope Year Logic

This table describes scope year logic of this object.

Logic
Reports the class periods in the scope year to which the calendar is aligned.
Data is only sent for the years that havea valid configuration.

Future Years data will be suppressed until the Active Year is changed:

  • This allows the Schedule Wizard to be used and reduces the number of records sent until the final schedule is completed.
  • A resync must be done after the Active Year is changed to send data.


Object Data Elements

This table describes data elements sent within the Class Periods resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
schoolReference

Reports data from the SchoolID field that is part of the natural key for the Schools resource. The following elements are reported:

  • schoolID
MSchool.numberSystem Administration> Resources> School> State School Number
name

Indicates the portion of a typical daily session in which students receive instruction in a specified subject (e.g., morning, sixth period, block period, etc).

The Period Schedule Name + Period Name + Schedule Structure ID reports (with a space between each value).

The maximum value for this field is 20 characters. The Period Schedule Name or Period Name may have to be abbreviated if the concatenation exceeds the 20 character limit. 

M

PeriodSchedule.name

Period.name

ScheduleStructure. structureID

System Administration > Calendar > Calendar > Periods

System Administration > Calendar > Calendar > Schedule Structure

etag

A unique system-generated value that identifies the version of the resource.

This is optional and does not report.

ON/AN/A




Course Offering

This entity represents an offering of a course by school during a session, representing the course catalog of available courses.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

This resource will not push data for Courses marked as Inactive or State Exclude. 


ActionTrigger
Post

When a section with Section Placements is created and saved.

  • Do not send if course is marked as Inactive or State Exclude.
  • Do not send records in the Calendar Exclude checkbox is marked.
  • Do not send if the School Exclude checkbox is marked.
  • One record reports per Course and Term Type combination.
Delete/PostWhen the Local Course number is changed.
Delete/PostIf the Term Descriptor changes either via section placement or mapping override and a course offering already exists with non-matching Term Descriptors.
Put

When the Course Information is changed and saved.

  • Send a Put when the local course name, attendance, unit attendance or SCED Seq Number is changed.
DeleteWhen a section is deleted.
DeleteWhen a section schedule placement is removed and saved.
Delete/PostWhen there are two Courses with the same natural key and 1 is deleted, the other record will post with the remaining records data.


Scope Year Logic

This table describes scope year logic of this object.

Logic
Reports course offerings for the scope year to which the courses calendar is aligned.
Data will only send for the years that have valid configuration.

Future Years data will be suppressed until the Active Year is changed:

  • This allows the Schedule Wizard to be used and reduces the number of records sent until the final schedule is completed.
  • A resync must be done after the Active Year is changed to send data.


Object Data Elements

This table describes data elements sent within the Course Offering resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
courseReference

Reports the following elements that are part of the Natural Key for the Course resource:

  • educationOrganizationReference
  • code
MN/AN/A
schoolReference

Reports the following elements that are part of the Natural Key for the Schools resource:

  • EntityID
MSchool.entityIDSystem Administration > Resources > School > Entity ID
sessionReference

Reports the following elements that are part of the Natural Key for the Sessions resource:

  1. Term Descriptor will report based on section schedule placement of the sections of the course.
  2. If Term Descriptor Override is checked and there is an existing mapping for the course, Term Descriptors will report based on the mapping.

M

N/AN/A
localCourseCode

The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students.

MCourse.numberScheduling > Course > Number
localCourseTitleThe descriptive name given to a course of study offered in the school, if different from the CourseTitle.OCourse.nameScheduling > Course > Name
InstructionalTimePlannedThe planned total number of clock minutes of instruction for this course offering. Generally, this should be at least as many minutes as is required for completion by the related state- or district-defined Course.ON/AN/A
curriculumUsedAn unordered collection of courseOfferingCurriculumUseds. This entity represents an offering of a course by school during a session, representing the course catalog of available courses.ON/AN/A
etagA unique system-generated value that identifies the version of the resource.ON/AN/A




Course Transcripts

This entity is the final record of a student's performance in their courses at the end of a semester or school year.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When transcript records are posted for a student and they have a valid Student School Association for the Scoped Year.

  • When a resync is completed, all valid transcript records for all years will send for the Student
  • The School that the Student is enrolled must be selected in the Resync Tool
  • If the District Number on the Transcript record matches the reporting district, send the record
  • Ed-Fi will send an error if the Course does not already exist in the ODS and a resync will need to be done on the Course
  • Do not send a record if the course is marked as inactive or state exclude

If the District Number on the Transcript record does not match the reporting district look to see if the course number exists in the School:

  • If the Course Number exists anywhere in the School for the scope year, and is not marked as inactive or exclude,  report the record with the Course Reference for that course/school
    • If more than 1 Course exits with that Course Number in different schools in the scope year, report the course reference with the School where the student is enrolled
  • If the Course Number does not exist in the School for the scope year, do not report the record
Post/DeleteWhen a transcript record is modified we always do a post/delete and never do a "Put".
Delete

When a transcript record is deleted for a student.

Delete

Transcript records delete when a student has only one Student School Association record for a specific Year and that record is deleted.

If a new Student School Association record is created, existing records will not re-post, a resync must be completed to resend the data.



Scope Year Logic

This table describes scope year logic of this object.

Logic
Transcript records will send to each scope year where the student has a Student School Association, regardless of the Transcript School Year. 
Data will only send for the years that have valid configuration.
A resync must be completed at the beginning of each year so that all years transcript records will be loaded in the ODS.


Object Data Elements

This table describes data elements sent within the Course Transcripts resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
courseReference

The unique identifier of the resource.

Natural Key fields for the Course resource:

  • Education Organization Reference
  • Code
M N/AN/A
schoolReference

A reference to the related School resource.

Reports the Natural Key fields for the School resource:

  • schoolID

If the School ID is not valid, this field will report blank.

ON/AN/A
studentAcademic
RecordReference

A reference to the related Student Academic Record resource.

Reports the Natural Key fields for the Student Academic Record resource:

  • educationOrganizationReference
  • schoolYearTypeReference
  • studentReference
  • termDescriptor
MN/AN/A
courseAttemptResultType

The result from the student's attempt to take the course, for example: Pass, Fail, Incomplete, Withdrawn.

When reporting from Transcript Records use the Credits Earned vs. Credit Attempted to determine the Result Type. 

Report the Ed-Fi Code from the mapping for the following options:

  1. When the sum of credits Earned is >= the sum of credits Attempted.
  2. When the sum of credits Earned is blank or = 0.
  3. When the sum of credits Earned is not blank or = 0 and < than the sum of credits Attempted.


M

Transcriptcredit.
creditsAttempted

Transcriptcredit.
creditsEarned


Student Information > General > Transcripts > Earned

Student Information > General > Transcripts> Attempted

attemptedCreditType

The type of credits or units of value attempted for the completion of a course. 

This field is optional and does not report.


ON/AN/A
attemptedCreditConversion

Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units. 

This field is optional and does not report.


ON/AN/A
attemptedCredits

The number of credits attempted for a course.

Report the sum of credits from the Attempted field on the Transcript record being reported.

OTranscriptcredit.
creditsAttempted
Student Information > General > Transcripts > Attempted
earnedCreditType

The type of credits or units of value awarded for the completion of a course. 

This field is optional and does not report.


ON/AN/A
earnedCreditConversion

Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units. 

This field is optional and does not report.


ON/AN/A
earnedCredits

The number of credits awarded or earned for the course.

Report the sum of credits from the Earned field on the Transcript record being reported.

MTranscriptcredit.
creditsEarned
Student Information > General > Transcripts > Earned
whenTakengrade
LevelDescriptor

Student's grade level at time of course.

  1. If the grade selected on the transcript record matches a valid Ed-Fi code, report the grade.
  • When no matching grade found with a grade level mapping, do not report this property.
ON/AStudent Information > General > Transcript > Transcript Course Editor > Grade


methodCreditEarnedType

The method the credits were earned, for example: Classroom, Examination, Transfer. 

This field is optional and does not report.


ON/AN/A
finalLetterGradeEarned

The final letter grade earned for the course.

Logic determines if the posted score is an integer or not:

  1. If the posted value is not an Integer, then report the posted score here.
  2. If the posted value is an Integer, then report in Final Number Grade Earned field below.
O

Transcriptcourse.score

Student Information > General > Transcripts > Current Score

finalNumericGradeEarned

The final numeric grade earned for the course.

Logic determines if the posted score is an integer or not:

  1. If the posted value is an Integer, then report the posted score here.
  2. If the posted value is not an Integer, then report in Final Letter Grade Earned field above.
O

Transcriptcourse.score

Student Information > General > Transcripts > Current Score

courseRepeatCodeType

Indicates that an academic course has been repeated by a student and how that repeat is to be computed in the student''s academic grade average. 

This field is optional and does not report.


ON/AN/A
courseTitle

Reports the name of the course completed.

Report the Course Name from the transcript record.

OTranscriptcourse.
courseName
Student Information > General > Transcripts > Course Name
alternativeCourseCode

The local code assigned by the school that identifies the course offering, the code from an external educational organization, or other alternate course code. 

This field is optional and does not report.


ON/AN/A
earnedadditionalCredits

An unordered collection of courseTranscriptAdditionalCredits. This entity is the final record of a student's performance in their courses at the end of a semester or school year. This field is only reported if the student has a grading task with an associated credit to report. 

Reports College Credit from the associated Grading Task.

ON/AN/A
additionalCreditType

The type of credits awarded or earned for the course.

Reports Dual Credit.

MN/AN/A
credits

The number of credits awarded or earned for the course.

Reports credit from the grading task multiplied by the credit coefficient associated with the score the student received.

  1. The grading task must have State Reported = Selected and a Code = CC64b.
  2. The grading task is determined from the sectionID found on the transcript record.
MN/AGrading & Standards > Grading Task > Code, State Reported


Grading & Standards > Score Groups


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Course Attempt Result Type:

Ed-Fi Short DescriptionEd-Fi Description
PassPass
FailFail
IncompleteIncomplete
WithdrawnWithdrawn

This table describes the Ed-Fi Value mapped and reported for Additional Credit Type:

Ed-Fi CodeEd-Fi Short DescriptionEd-Fi Description
124-001Advanced PlacementAdvanced Placement
124-002Career and Technical EducationCareer and Technical Education
124-003Dual creditDual credit
124-004International BaccalaureateInternational Baccalaureate
124-005OtherOther




Course

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

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a course is created and saved. 

  • Do not send if course is marked as Inactive or State Exclude.
  • Do not send if course is in a calendar marked as exclude.
  • Do not send if course is in a school marked as exclude.
Delete/InsertIf the course number is changed, do a delete/insert of the record.
Put

When course information not part of the natural key is changed and saved:

  • Title
  • Number of Part
  • Academic Subject Descriptor
  • Identification Codes
  • Type Level and Rigor Descriptor
DeleteWhen a course is deleted.


Only courses that are mapped to an NCES course are sent.


Object Data Elements

This table describes data elements sent within the Course resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
education
Organization
Reference

A reference to the related EducationOrganization resource.

Reports the school number associated with the course.

MN/AN/A
codeThe code that identifies the organization of subject matter and related learning experiences provided for the instruction of students.MCourse.numberScheduling > Course > Number
title

The descriptive name given to a course of study offered in a school or other institution or organization. 

In departmentalized classes at the elementary, secondary, and post-secondary levels (and for staff development activities), this refers to the name by which a course is identified (e.g., American History, English III).

For elementary and other non-departmentalized classes, it refers to any portion of the instruction for which a grade or report is assigned (e.g., reading, composition, spelling, and language arts).

MCourse.nameScheduling > Course > Name
numberOfPartsThe number of parts identified for a course. The number in the SCED Sequence Part N field is reported. This field reports a default value of 1 for all courses.Mcourse.sced
SequenceNum
Defaults to 1 for all courses
academicSubject
Descriptor

The intended major subject area of the course. NEDM: Secondary Course Subject Area. See the Type/Descriptor table below.

Reports mapped Ed-Fi Code for the SCED Subject Area.

OCourse.SCEDScheudling > Course > Courses > SCED Subject Area
description

A description of the content standards and goals covered in the course. Reference may be made to state or national content standards. 

This field does not report.

ON/AN/A
dateCourseAdopted

The date the district adopted the course.

This field does not report. 

ON/AN/A
highSchoolCourse
Requirement

An indication that this course credit is required for a high school diploma.

This field does not report. 

ON/AN/A
gpaApplicability
Type

An indicator of whether or not this course being described is included in the computation of the student’s Grade Point Average, and if so, if it is weighted differently from regular courses.

This field does not report. 

ON/AN/A
definedByType

Specifies whether the course was defined by the SEA, LEA, school or national organization.

This field does not report. 

ON/AN/A
minimumAvailable
CreditType

The type of credits or units of value awarded for the completion of a course.

This field does not report. 

ON/AN/A
minimumAvailable
CreditConversion
Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.ON/AN/A
minimumAvailable
Credit

The minimum amount of credit available to a student who successfully completes the course.

This field does not report. 

ON/AN/A
maximumAvailable
CreditType

The type of credits or units of value awarded for the completion of a course.

This field does not report. 

ON/AN/A
maximumAvailable
CreditConversion

Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.

This field does not report. 

ON/AN/A
maximumAvailable
Credit

The maximum amount of credit available to a student who successfully completes the course.

This field does not report. 

ON/AN/A
careerPathwayType

The career cluster or pathway representing the career path of the Vocational/CTE concentrator.

This field does not report. 

ON/AN/A
timeRequired
ForCompletion

The actual or estimated number of clock minutes required for class completion. This number is especially important for career and technical education classes and may represent (in minutes) the clock hour requirement of the class.

This field does not report. 

ON/AN/A
competencyLevels

An unordered collection of courseCompetencyLevels. 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.

This field does not report. 

ON/AN/A
gradeLevels

An unordered collection of courseGradeLevels. 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.

This field does not report. 

ON/AN/A
IdentificationCodes

An unordered collection of courseIdentificationCodes. 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.

Reports from the NCES area of the course. This field is an array.

ON/AN/A
courseIdentification SystemDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. 

Reports NCES.

ON/AN/A
assigningOrganization IdentificationCode

The organization code or name assigning the staff Identification Code.

This field does not report.

ON/AN/A
identificationCode

A unique number or alphanumeric code assigned to a space, room, site, building, individual, organization, program, or institution by a school, school system, a state, or other agency or entity.

Reports the 5-digit SCED Course identifier. This is the concatenation of the 2 digit SCED Subject Area Code and the 3 digit SCED Course Identifier Code.

MCourse.scedCourseIDScheduling > Courses > Course > NCES > SCED Subject Area, SCED Course Identifier
typeLevelAndRigor Descriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

Reports the Ed-Fi code from the Homors field. If null, does not report.

OCourse.honorsCodeScheduling > Courses > Course > Honors
learningObjectives

An unordered collection of courseLearningObjectives. 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.

This field does not report. 

ON/AN/A
learningStandards

An unordered collection of courseLearningStandards. 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.

This field does not report. 

ON/AN/A
levelCharacteristics

An unordered collection of courseLevelCharacteristics. 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.

This field does not report. 

ON/AN/A
etagA unique system-generated value that identifies the version of the resource. ON/AN/A


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Academic Subject Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description

00

State Approved CTE Course

State approved CTE Courses reported in CTEIS. Data for these courses will be obtained through CTEIS. These data may be, but are not required to be reported in TSDL.

01

English language and literature

English language and literature

02

Mathematics

Mathematics

03

Life and Physical Sciences

Life and Physical Sciences

04

Social Sciences and History

Social Sciences and History

05

Fine and Performing Arts

Fine and Performing Arts

06

Foreign language and Literature

Foreign language and Literature

07

Religious Education and Theology

Religious Education and Theology

08

Physical, Health and Safety Education

Physical, Health and Safety Education

09

Military Science

Military Science

10

Computer and Information Sciences

Computer and Information Sciences

11

Communication and Audio/Visual Technology

Communication and Audio/Visual Technology

12

Business and marketing

Business and marketing

13

Manufacturing

Manufacturing

14

Health Care Sciences

Health Care Sciences

15

Public, Protective, and Government Service

Public, Protective, and Government Service

16

Hospitality and Tourism

Hospitality and Tourism

17

Architecture and Construction

Architecture and Construction

18

Agriculture, Food and natural Resources

Agriculture, Food and natural Resources

19

Human Services

Human Services

20

Transportation, Distribution and Logistics

Transportation, Distribution and Logistics

21

Engineering and Technology

Engineering and Technology

22

Miscellaneous

Miscellaneous

51

English Language and Literature

Academic subject area related to English language and literature.

52

Mathematics

Academic subject area related to mathematics.

53

Life and Physical Sciences

Academic subject area related to life or physical science.

54

Social Sciences and History

Academic subject area related to social science or history.

55

Fine and Performing Arts

Academic subject area related to the fine or performing arts.

56

Foreign Language and Literature

Academic subject area related to foreign language and literature.

57

Religious Education and Theology

Academic subject area related to religion and theology.

58

Physical, Health and Safety Education

Academic subject area related to physical, health or safety education.

60

Computer and Information Sciences

Academic subject area related to computer or information sciences.

61

Communication and Audio/Visual Technology

Academic subject area related to communication and audio/video technology.

62

Business and marketing

Academic subject area related to business and marketing.

63

Manufacturing

Academic subject area related to manufacturing.

64

Health Care Sciences

Academic subject area related to health care sciences.

65

Public, Protective, and Government Service

Academic subject area related to public, protective, and government services.

66

Hospitality and Tourism

Academic subject area related to hospitality and tourism.

67

Architecture and Construction

Academic subject area related to architecture and construction.

68

Agriculture, Food and natural Resources

Academic subject area related to agriculture, food, and natural resources.

69

Human Services

Academic subject area related to human services.

70

Transportation, Distribution and Logistics

Academic subject area related to transportation, distribution, and logistics.

71

Engineering and Technology

Academic subject area related to engineering and technology.

72

Miscellaneous

Academic subject area, taught prior to the secondary school level, not represented in any other category.

73

Nonsubject Specific

Courses that are not differentiated by subject area--that is, where students are enrolled in a grade-specific course and are taught various subjects throughout the day, rather than being enrolled in subject-specific courses.

This table describes the Ed-Fi Value mapped and reported for Course Type Level and Rigor  Descriptor:

Code Value

Short Description

Description

00OtherOther

01

Regular (Default)

General concepts for the appropriate grade level

02

Honors

Advanced-level course for students with honors status

03

Pre-Advanced

Preparation course for admission to AP Program

04

Advanced Placement

Advanced Placement, college-level course

05

International Baccalaureate

Part of a program designed by International Baccalaureate Organization

06

Not Applicable

No applicable course type

07

Dual Enrollment/Early Middle College

Course taught by post-secondary instructor as part of dual enrollment or early middle college program

10

64b Dual / Concurrent Enrollment Course

Course resulting in high school and college credit under Section 64b

This table describes the Ed-Fi Value mapped and reported for Course Identification System Descriptor:

Code Value

Short Description

Description

CSSC course code

CSSC course code

CSSC course code

Intermediate agency course code

Intermediate agency course code

Intermediate agency course code

LEA course code

LEA course code

LEA course code

NCES Pilot SNCCS course code

NCES Pilot SNCCS course code

NCES Pilot SNCCS course code

Other

Other

Other

SCED course code

SCED course code

SCED course code

School course code

School course code

School course code

State course code

State course code

State course code

University course code

University course code

University course code

NCES

NCES Course Code

NCES Course Code (from the NCES Secondary School Course Classification System or NCES Prior to Secondary School Course Classisfication System)




Discipline Action

This event entity represents actions taken by an education organization after a disruptive event that is recorded as a discipline incident.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

Reports when a Behavior Resolution is added to an incident that is marked as Complete and is aligned to a reported Behavior Event.

  • Behavior Resolution must have a State Code is not null.
  • Do not send if the student's enrollment is marked as No Show or State Exclude.
  • Do not send if the student is in a calendar marked as Exclude.
  • Do not send if the student is in a School marked as  Exclude.
Put

A change is found to the following fields:

  • length
  • disciplines
Delete/Post

When data that is part of the Natural Key is changed.

  • If the resolution date is changed do a delete and post.
Delete/Post

When the Incident's status is changed.

  • Delete when the status is changed from Completed to In Progress.
  • Post when the status is changed from In Progress to Completed.
DeleteWhen a resolution is deleted.
DeleteWhen all resolutions are removed from the incident.
DeleteWhen all Behavior Events are removed from the Incident.
DeleteWhen the student's Role changes to anything other than Offender or Participant.
DeleteWhen all non-excluded enrollments in the school and year are deleted.


Scope Year Logic

This table describes scope year logic of this object.

Logic

Discipline records will only send to the school year that the incident date is aligned to based on the School Year Start and End dates.

  • If School Year Start Date is NULL, 7/1/xxxx will be the default start date used
  • If School Year End Date is NULL, 6/30/xxxx will be the default end date used
Data will only send for the years that have valid configuration.


Object Data Elements

This table describes data elements sent within the Discipline Action resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
assignmentschool
Reference

A reference to the related School resource

This is optional and does not report.

ON/AN/A
responsibility
schoolReference

Reports data from the SchoolID field that is part of the natural key for the Schools resource of the school where the incident occurred. The following elements are reported:

  • schoolID
MSchool.entityIDSystem Administration > Resources > School > Entity ID
studentReference

Reports data from the Ed-Fi ID field that is part of the natural key for the Student resource of the school where the incident occurred. The following elements are reported:

  • studentUniqueId
MPerson.edfiIDCensus > People > Demographics > EdFi ID
identifierIdentifier assigned by the education organization to the discipline action.MBehaviorResolution.
resolutionID
Behavior > Behavior Management > Resolution > Resolution ID
disciplineDateThe month, day, and year of the discipline action.MBehaviorResolution.
timestamp
Behavior > Behavior Management > Resolution > Resolution Start Date
length

The length of time in school days for the Discipline Action (e.g. removal, detention), if applicable.

The entered Duration reports on all reported resolutions.If null, reports 0. Values round to the nearest whole number.

ON/ABehavior > Behavior Management > Resolution> Duration
actualDiscipline
ActionLength

The length of time in school days for the Discipline Action (e.g. removal, detention), if applicable.

This is optional and does not report.

ON/AN/A
lengthDifference
ReasonType

Indicates the reason for the difference, if any, between the official and actual lengths of a student s disciplinary assignment.

This is optional and does not report.

ON/AN/A

relatedToZero
TolerancePolicy

An indication of whether or not this disciplinary action taken against a student was imposed as a consequence of state or local zero tolerance policies.

This is optional and does not report.

ON/AN/A
disciplines

An unordered collection of disciplineActionDisciplines.


N/AN/A
Discipline Descriptor

This descriptor defines the type of action or removal from the classroom used to discipline the student involved as a perpetrator in a discipline incident.

  1. Report the Ed-Fi Code value from the mapping for the state resolution code selected.
  2. If the Ed-Fi Code is NULL or is not mapped to a state code, then do not report..

See the Discipline Descriptor table in the Type/Descriptor section below.

O

N/A

Behavior > Behavior Management > Resolution Details > Resolution Type
disciplineIncidents

An unordered collection of disciplineActionDisciplineIncidents.

ON/AN/A
staffs

An unordered collection of disciplineActionStaffs.

This is optional and does not report.

ON/AN/A
orderOfDiscipline

The order of the administrative decision of the referral assigned by SWIS.

  1. Report the order of resolution based on the resolution Start Date. 
    1. The earliest resolution found reports '1'. Second earliest reports '2'. Etc.
    2. The Resolution must have a State Code = NOT NULL to be considered.
ON/ABehavior > Behavior Resolution
etagA unique system-generated value that identifies the version of the resource.ON/AN/A


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Discipline Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description

1

In-School Suspension

Instances in which a student is temporarily removed from his/her regular classroom(s) for disciplinary purposes but remains under the direct supervision of school personnel.

Direct supervision means a school staff member is physically in the same location as students under his/her supervision.

Do not include suspensions that are less than one half of a school day. Do not report detentions served outside of the regularly scheduled school day

2

Out-Of-School Suspension

Out-Of-School Suspension

3

Removal By Hearing Office(Special Ed Participant Only)

Removal By Hearing Office(Special Ed Participant Only)

4

Unilateral Removal(Special Ed Participant Only)

Unilateral Removal(Special Ed Participant Only)

5

Expulsion

Expulsion




Discipline Incident

This event entity represents an occurrence of an infraction ranging from a minor behavioral problem that disrupts the orderly functioning of a school or classroom (such as tardiness) to a criminal act that results in the involvement of a law enforcement official (such as robbery).

A single event (e.g., a fight) is one incident regardless of how many perpetrators or victims are involved. Discipline incidents are events classified as warranting discipline action.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

Reports a behavior incident when the incident's Status is marked and saved as "Complete."

  • Incident must have at least 1 behavior event associated and a Role that is mapped to an Ed-Fi Value
  • Posting can occur if a new event is added after Incident is marked as "Complete"
  • Do not send if the student's enrollment is marked as No Show or State Exclude
  • Do not send if the student is in a calendar marked as Exclude
  • Do not send if the student is in a School marked as Exclude
Put

When a change is found to the following fields:

  • behaviors
  • seriousBodilyInjury
  • sexualAssault
Delete/Post

When data that is part of the Natural Key is changed.

  • If the Date of Incident is changed and saved
  • If the Event Type is changed and saved
Delete/Post

When the Incident's status is changed.

  • Delete when the status is changed from Completed to In Progress
  • Post when the status is changed from In Progress to Completed
DeleteWhen an incident is deleted.
Delete

When the associated student enrollment is deleted.


Scope Year Logic

This table describes scope year logic of this object.

Logic

Discipline records will only send to the school year that the incident date is aligned to based on the School Year Start and End dates.

  • If School Year Start Date is NULL, 7/1/xxxx will be the default start date used
  • If School Year End Date is NULL, 6/30/xxxx will be the default end date used
Data will only send for the years that have valid configuration.


Object Data Elements

This table describes data elements sent within the Discipline Incident resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.M N/A N/A
schoolReference

Reports data from the SchoolID field that is part of the natural key for the Schools resource. The following elements are reported:

  • schoolID
MSchool.entityIDSystem Administration > Resources > School > Entity ID
staffReference

A reference to the related Staff resource.

This is optional and does not report.

ON/AN/A
incidentIdentifierThe locally assigned unique identifier (within the school or school district) to identify each specific incident or occurrence. The same identifier should be used to document the entire incident even if it included multiple offenses and multiple offenders.MBehaviorIncident.
incidentID
Behavior > Behavior Management > Incident ID
incidentDateThe month, day, and year on which the incident occurred.MBehaviorIncident.
timestamp
Behavior > Behavior Management > Date of Incident
incidentTime

An indication of the time of day the incident took place.

This is optional and does not report.

ON/AN/A
incidentLocationType

Identifies where the incident occurred and whether or not it occurred on campus.

Logic reports the Ed-Fi code mapped to the selection in the Location field on the Incident.

OBehaviorIncident.
location
Behavior Management > Location
reporterDescription
Descriptor

Information on the type of individual who reported the incident.

This is optional and does not report.

ON/AN/A
reporterName

Identifies the reporter of the incident by name.

This is optional and does not report.

ON/AN/A
reportedTo
LawEnforcement

Indicator of whether the incident was reported to law enforcement.

This is optional and does not report.

ON/AN/A
caseNumber

The case number assigned to the incident by law enforcement or other organization.

This is optional and does not report.

ON/AN/A
incidentDescription

The description for an incident.

This is optional and does not report.

ON/AN/A
incidentCost

The value of any quantifiable monetary loss directly resulting from the incident.

This is optional and does not report.

ON/AN/A
behaviors

An unordered collection of disciplineIncidentBehaviors. This event entity represents an occurrence of an infraction ranging from a minor behavioral problem that disrupts the orderly functioning of a school or classroom (such as tardiness) to a criminal act that results in the involvement of a law enforcement official (such as robbery).

 ON/AN/A
behaviorDescriptor

Report all behavior events that are associated with the incident.

  1. Report the Ed-Fi code value from the mapping for the state code selectedon the event
  2. If the event is not mapped to a state code or the Ed-Fi Code is blank, report the code from the mapping for the District/School code.
  3. If a code is not mapped, do not report.
M

N/A

Behavior > Behavior Management > Event Type
behaviorDetailedDescriptionReport the Details entered on the Incident
  1. Ed-Fi accepts 1024 characters in this field, truncate remaining information from Campus if there are more characters
OBehaviorIncident. descriptionBehavior > Behavior Management > Incident Detail Information
seriousBodilyInjury

Indicates if the Incident Type involved physical violence with injury and the injury inflicted meets the definition of Serious Bodily Injury per the United States Code paragragh (3) of subsection (h) of section 1365 of title 18: "(3) the term serious bodily injury means bodily injury which involves (A) a substantial risk of death; (B) extreme physical pain; (C) protracted and obvious disfigurement; or (D) protracted loss or impairment of the function of a bodily member, organ, or mental faculty;" 0=No, 1=Yes.

  • This field only reports if Event Name is 60 or 61.
  • If Injury = 4: Serious Bodily Injury, reports true. Otherwise, this fields does not report.
ON/ABehavior > Behavior Management > Event > Injury
sexualAssault

Indicates if an incident of the Incident Type involved physical violence involved oral, anal, or vaginal penetration forcibly or against the person's will or where the victim is incapable of giving consent. Includes rape, fondling, indecent liberties, child molestation, and sodomy. 0=No, 1=Yes,

  • This field only reports if Event Name is 60 or 61.
  • If Injury = 4: Serious Bodily Injury, reports true. Otherwise, this fields does not report.
ON/ABehavior > Behavior Management > Event > Sexual Assault
weapons

An unordered collection of disciplineIncidentWeapons. This event entity represents an occurrence of an infraction ranging from a minor behavioral problem that disrupts the orderly functioning of a school or classroom (such as tardiness) to a criminal act that results in the involvement of a law enforcement official (such as robbery).

This does not report.

ON/AN/A
etagA unique system-generated value that identifies the version of the resource.ON/AN/A


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Behavior Descriptors:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description

01

State Offense

State Offense

02

School Violation

School Violation

03

Other

Other

04

School Code of Conduct

School Code of Conduct

06

Abuse Of Volatile Chemical

Abuse Of Volatile Chemical

09

Abuse Of Volatile Chemical

Abuse Of Volatile Chemical

20

Firearm Possession - Handgun

Firearm Possession - Handgun

21

Firearm Possession - Rifle or Shotgun

Firearm Possession - Rifle or Shotgun

22

Firearm Possession - other than Handgun, Rifle or Shotgun

Firearm Possession - other than Handgun, Rifle or Shotgun

23

Other Weapon Possession

Other Weapon Possession

30

Illicit Drug

Illicit Drug

31

Alcohol

Alcohol-related incidents are incidents where students: 

  • Possess or use alcohol on school grounds  
  • Were under the influence of alcohol on school grounds

44

Bomb or Similar Threat

Bomb or Similar Threat

55

Arson

Arson

56

Other

Other

60

Physical Violence with injury

Physical Violence with injury

61

Physical Violence without injury

Physical Violence without injury




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.

ActionTrigger
Post

When a grade is posted to a Grading Task that is mapped an Ed-Fi Grade Type:

  • Standards will not report to Ed-Fi
  • Do not report if the Course is marked as Inactive or State Excluded
  • Do not send records if the Calendar Exclude checkbox is checked
  • Do not send records is the student's enrollment is marked as no show or State Excluded
  • Do not send if the student's enrollment is in a School marked as Exclude
  • 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 exists, 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.
PutWhen a grade is updated on a Grading Task that is marked as State Reported and has an Ed-Fi Grade Type populated.
Delete

When a grade is deleted from a Grading Task that is marked as State Reported and has an Ed-Fi Grade Type populated.

DeleteWhen the Student School Association record is deleted for the school in which the grades are associated.
DeleteWhen the No Show or State Exclude checkboxes are checked.
Delete/InsertWhen any field that is part of the Natural Key is changed.


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


Object Data Elements

This table describes data elements sent within the Grade resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/A N/A 
gradingPeriodReference

Reports the fields that are part of the Natural Key for the Grading Periods resource:

  • schoolReference
  • beginDate
  • descriptor
MN/A N/A 
studentSection
AssociationReference

Reports the fields that are part of the Natural Key for the Student Section Association.

  • sectionReference
  • studentReference
  • beginDate

When a student has more than 1 eligible Student Section Association record (for example, a course that covered 2 periods and or multiple period schedules) the grade will report on section association with the highest period schedule sequence and or period sequence.

MN/A N/A 
type

The type of grade (e.g., Exam, Final, Grading Period, Progress Report). 

  • Reports the Ed-Fi Code from the mapping on the Grading Task or Standard being reported.
  • If the grading task is not mapped, do not report.

See the Grade Type table in the Type/Descriptors section below.

MN/A Grading & Standards > Grading Tasks
performanceBase
ConversionType

The performance base conversion assessed for the student.

This field is optional and will not report.


N/A N/A 
 letterGradeEarned

 A final or interim (grading period) indicator of student performance in a class as submitted by the instructor.

Logic will determine if the posted score is an integer or not:

  1. If the posted value is not an Integer, then report the posted score here
  2. If the posted value is an Integer, then report in the Numeric Grade Earned field below.
 O GradingScore.scoreGrading & Standards > Score Groups & Rubrics > Score
numericGradeEarned

A final or interim (grading period) indicator of student performance in a class as submitted by the instructor.

Logic determines if the posted score is an integer or not:

  1. If the posted value is an Integer, then report the posted score.
  2. If the posted value is not an Integer, then report in Letter Grade Earned field above.
OGradingScore.scoreGrading & Standards > Score Groups & Rubrics > Score
 diagnosticStatement

 A statement provided by the teacher that provides information in addition to the grade or assessment score.

This field is optional and will not report.


N/A N/A 


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Grade Type:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
1ConductConduct
2ExamExam
3FinalFinal
4Grading PeriodGrading Period
5Mid-Term GradeMid-Term Grade
6Progress ReportProgress Report
7SemesterSemester




Grading Periods

This entity represents the time span for which grades are reported.  Quarter, Semester, Final, etc.  The Start and End dates must have a calendar event in the Calendar Dates resource before Grading Periods can send.  User needs to perform a day reset prior to filling out Grading Periods tab.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a new Grading Period is created and saved on the Grading Periods tab.

  • Do not send records if the Calendar Exclude checkbox is checked.
  • Do not send if the School is marked as Exclude.
  • If the start date on an existing Grading Period is changed, the "old" record will remain in Ed-Fi and a new record will post with the new date.
PutWhen the Grading Period End Date is updated and saved.
Delete

Grading Periods cannot be deleted due to the dependency of the core Ed-Fi model where it is required for Sessions to report grading periods.


Scope Year Logic

This table describes scope year logic of this object.

Logic

Reports the grading periods in the scope year to which the calendar is aligned.

  • Data will only send for the years that have valid configuration.
  • Future Years data will be suppressed until the Active Year is changed:
    • This allows the Schedule Wizard to be used and reduces the number of records sent until the final schedule is completed.
    • A resync must be done after the Active Year is changed to send data.


Object Data Elements

This table describes data elements sent within the Grading Periods resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
schoolReference

Reports the Natural Key for the Schools resource to which the grading period is aligned.

MN/A N/A 
beginDate

The start date of the grading period.

Report the start date from the Grading Period being reported:

  • If there is more than 1 calendar or schedule structure, report a record for each Grading Period & Start Date Combination.
  • The date entered must be an Instructional day on the Days tab.
Medfigradingperiod.startDateSystem Administration > Calendar > Calendar > Ed-Fi Grading Periods > Grading Period Start Date
endDate

The end date of the grading period.

Report the end date from the Grading Period being reported:

  • If there is more than 1 calendar or schedule structure, report the latest end date.
  • The date entered must be an Instructional day on the Days tab.
Medfigradingperiod.endDate System Administration > Calendar > Calendar > Ed-Fi Grading Periods > Grading Period End Date
descriptor

The name of the grading period. See the Grading Period Descriptor table in the Type/Descriptor section below.

  • Report the code value from the Grading Period Name selected.
Medfigradingperiod.nameSystem Administration > Calendar > Calendar > Ed-Fi Grading Periods > Grading Period Name
 totalInstructionalDays

 The total number of instructional days in the grading period.

  • Count the number of instructional days on the Days tab that occur during the start and end date for the grading period
    • If there is more than 1 calendar or schedule structure, report the distinct number of instructional days from all calendars/schedule structures
    • Instructional days will not send an update if changed after original post unless a resync is completed.
N/A System Administration > Calendar > Calendar >Days
 periodSequence

 The sequence of the grading period.

This element is optional and does not report.


 term.seq System Administration> Calendar> Terms> Seq
 _etag N/AON/A N/A 


Type/Descriptors


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Grading Period Descriptors Type:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01End of YearEnd of Year
02Fifth Six WeeksFifth Six Weeks
03First Nine WeeksFirst Nine Weeks
04First SemesterFirst Semester
05First Six WeeksFirst Six Weeks
06First Summer SessionFirst Summer Session
07First TrimesterFirst Trimester
08Fourth Nine WeeksFourth Nine Weeks
09Fourth Six WeeksFourth Six Weeks
10Second Nine WeeksSecond Nine Weeks
11Second SemesterSecond Semester
12Second Six WeeksSecond Six Weeks
13Second Summer SessionSecond Summer Session
14Second TrimesterSecond Trimester
15Sixth Six WeeksSixth Six Weeks
16Summer SemesterSummer Semester
17Third Nine WeeksThird Nine Weeks
18Third Six WeeksThird Six Weeks
19Third Summer SessionThird Summer Session
20Third TrimesterThird Trimester




Graduation Plan

This entity is a plan outlining the required credits, credits by subject, credits by course, and other criteria required for graduation. A graduation plan may be one or more standard plans defined by an education organization and/or individual plans for some or all students.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a Career Tech Program or a Graduation Program is mapped to a Graduation Plan Descriptor in Graduation Plan Preferences:

  • The program must be flagged as active to report.
  • For a Career Tech Program the Cohort/Graduation Active Start Year field must be populated to report.
  • For a Graduation Program, the Ed-FI Graduation Plan and Cohort/Graduation Active Start Year fields must be populated to report
    • A separate record will report for each School Year that aligns with the Cohort/Graduation Active Start Year and Cohort/Graduation Active End Year
    • If the Cohort/Graduation Active End Year is NULL, a separate record will report starting with the Cohort/Graduation Active Start Year and ending 3+ years from the current year.
  • If two programs have the same Graduation Program Type/Descriptor and School Year, the last record to be updated will be the one reported.
  • Use the Scope Year logic below to determine if the record is eligible to report.
Put

If the sum of the total number of required credits changes on a reported Graduation program.

DeleteGraduation Plans will not delete due to the association across multiple cohort years.


Scope Year Logic

This table describes scope year logic of this object.

Logic

Records will report for each year the Career Tech Program or a Graduation Program is active.

  • Data will only send for the years that have valid configuration.
  • A resync will need to be done at the beginning of each new scope year to be populated.


Object Data Elements

This table describes data elements sent within the Graduation Plan resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
educationOrganization
Reference
 

A reference to the related Education Organization resource. Reports the District Number.

M

N/A N/A 
graduationSchool
YearTypeReference
A reference to the related SchoolYearType resource. Reports the End Year in the School Year being reported based on the Cohort years the Graduation Plan covers.MN/A N/A 
typeDescriptor 

This descriptor defines the set of graduation plan types.

  • Report 'Career and Technical Education' when the program is created and saved (the cte field in the program table is = 1).
  • Report the Ed-Fi Code from the value selected in the Ed-FI Graduation Plan field.

See the Graduation Plan Type table in the Type/Descriptors section below.

Program.
edfiPlanType
Program Admin > Programs > Graduation Programs > Graduation Program Detail or Career Tech Programs
individualPlan 

 An indicator of whether the GraduationPlan is tailored for an individual.

This field is optional and does not report.


N/A N/A
totalRequiredCredits

The total number of credits required for graduation under this plan.

  • Report '0' when the program is 'Career and Technical Education'.
  • When reporting from a Graduation Plan, sum the total number of required credits associated with the program being reported.
N/A Calculated value from the CreditRequirement table
totalRequiredCreditType

The type of credits or units of value awarded for the completion of a course. 

This field is optional and does not report.


 O N/A N/A
totalRequired
CreditConversion

Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units. 

This field is optional and does not report.


 O N/A N/A
creditsByCourses 

An unordered collection of graduation Plan Credits By Courses. The total credits required for graduation by taking a specific course, or by taking one or more from a set of courses. 

This field is optional and does not report.


 O N/A N/A
creditsBySubjects 

An unordered collection of graduation Plan Credits By Subjects. The total number of credits required in a subject to graduate. Only those courses identified as a high school course requirement are eligible to meet subject credit requirements. 

This field is optional and does not report.


ON/AN/A
requiredAssessments 

An unordered collection of graduation Plan Required Assessments. The total credits required for graduation by taking a specific course, or by taking one or more from a set of courses. 

This field is optional and does not report.


ON/AN/A
curriculumDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent tableA.

This field does not report. 

ON/AN/A
creditModifications

An unordered collection of graduationPlanCreditModifications. (MI-EXT) To indicate the academic area that is being modified by the personal curriculum.

This field does not report. 

ON/AN/A
creditModification DescriptorA unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.ON/AN/A
creditModifications AsOfDate

The most recent date of changes to CreditModification.

This field does not report. 

ON/AN/A


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Graduation Plan Type Descriptors:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01Career and Technical EducationCareer and Technical Education
02DistinguishedDistinguished
03MinimumMinimum
04RecommendedRecommended
05StandardStandard

This table describes the Ed-Fi Value mapped and reported for Curriculum Descriptors:

Code ValueShort DescriptionDescription

1

IEP

The student has an IEP showing a documented need to make modifications because: 

  • The student's disability affects access to and/or demonstration of proficiency in the curriculum and/or   
  • The student demonstrates a lack of progress on the MMC despite documented interventions, supports and accommodations.

2

Transfer

The student transfers from out of state or from a nonpublic school after successful completion of the equivalent of two years of high school credit.

3

General Enhanced

The student has demonstrated:  

  • The ability or desire to access advanced or specialized content that cannot be met through electives (e.g., district lacks the resources to provide the course/content or schedule does not allow student to access district offering) and/or   
  • The ability to succeed in accelerated or advanced math, science, English language arts or world languages.

4

General Modified

The student has demonstrated the academic need to reduce the Algebra II credit requirement from 1.0 credit to 0.5 credit.

This table describes the Ed-Fi Value mapped and reported for Credit Modification Descriptors:

Code ValueShort DescriptionDescription

1

English Language Arts

Modifications to the MMC ELA credit requirements for students with an IEP and for transfer students who have completed two (2) years of high school.

2

Mathematics

Modification to the MMC Mathematics credit requirements under the following circumstances:  

  • Student has completed a minimum of 1.5 credits aligned to math content expectations prior to any modification.  
  • One (1) credit of Algebra II may be modified to one-half (1/2) credit.  
  • Additional modifications are allowed for students with an IEP and transfer students who have completed two (2) years of high school.

3

Science

Modifications to the MMC Science credit requirements for students with an IEP and for transfer students who have completed two (2) years of high school.

4

Social Studies

Modification to the MMC Social Studies credit requirements under the following circumstances:  

  • No modification of Civics.   Student has completed a minimum of two (2) social studies credits prior to modification.   
  • One (1) social studies credit (other than Civics) can be exchanged for an additional English language arts, math, science or world languages credit.   
  • Additional modifications are allowed for students with an IEP and transfer students who have completed two (2) years of high school.

5

Visual, Performing, and Applied Arts

Modification where credit is exchanged for an additional English language arts, math, science or world languages credit.  

Additional modifications are allowed for students with an IEP and transfer students who have completed two (2) years of high school.

6

World Languages

Modifications to the MMC World Languages credit requirements for students with an IEP and for transfer students who have completed two (2) years of high school.

8

Health/Physical Education

Modification where credit is exchanged for an additional English language arts, math, science or world languages credit.  

Additional modifications are allowed for students with an IEP and transfer students who have completed two (2) years of high school.




Local Education Agency

This entity represents an administrative unit at the local level, which exists primarily to operate schools or to contract for educational services. It includes school districts, charter schools, charter management organizations or other local administrative organizations.

Object Triggering Logic

LEA data is preloaded to Ed-Fi so there is no trigger logic necessary for Michigan. The District Number is the number used to identify the district being reported.

Scope Year Logic

This table describes scope year logic of this object.

Logic
Districts are not aligned to a year so all Districts will send to each scoped year.
Data will only send for the years that have valid configuration.

A resync must be completed on the resource when a new scope year is connected in order for this data to send


Object Data Elements

This table describes data elements sent within the Local Education Agency resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
educationService
CenterReference

A reference to the related EducationServiceCenter resource.

This element is optional and does not report.

ON/AN/A
stateEducation
AgencyReference

A reference to the related StateEducationAgency resource.

This element is optional and does not report.

ON/AN/A
localEducationAgencyIdEducationOrganization Identity Column. Logic reports the State District Number.MDistrict.numberSystem Administration > Resources > District Information
stateOrganizationIdThe identifier assigned to an education agency by the State Education Agency (SEA). Also known as the State LEP ID. NEDM: IdentificationCode, LEA Identifier.MDistrict.numberSystem Administration > Resources > District Information
nameOfInstitutionThe full, legally accepted name of the institution. NEDM: Name of Institution.MDistrict.numberSystem Administration > Resources > District Information
shortNameOfInstitution

A short name for the institution.

This element is optional and does not report.

ON/AN/A
webSite

The public web site address (URL) for the educational organization.

This element is optional and does not report.

ON/AN/A
operationalStatusType

The current operational status of the education organization (e.g., active, inactive).

This element is optional and does not report.

ON/AN/A
parentLocal
EducationAgencyId

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

This element is optional and does not report.

ON/AN/A
categoryTypeThe category of LEA/District (e.g., Independent or Charter). Always report 'Independent'MN/AN/A
addresses

An unordered collection of educationOrganizationAddresses. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups.

Reports the Physical Address. If blank, do not report.

ON/AN/A
educationOrganizationCategories

An unordered collection of educationOrganizationCategories. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups.


MN/AN/A

educationOrganizationCategoryType - Always report 'Local Education Agency'.MN/AN/A
identificationCodes

An unordered collection of educationOrganizationIdentificationCodes. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups.

This element is optional and does not report.

ON/AN/A
institutionTelephones

An unordered collection of educationOrganizationInstitutionTelephones. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups.

Reports the Phone Number for the District. If blank, do not report.

ON/AN/A
internationalAddresses

An unordered collection of educationOrganizationInternationalAddresses. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups.

This element is optional and does not report.

ON/AN/A
accountabilities

An unordered collection of localEducationAgencyAccountabilities. This entity represents an administrative unit at the local level, which exists primarily to operate schools or to contract for educational services. It includes school districts, charter schools, charter management organizations or other local administrative organizations.

This element is optional and does not report.

ON/AN/A
etag

A unique system-generated value that identifies the version of the resource.

ON/AN/A




Locations

This entity represents the physical space where students gather for a particular class/section. The location may be an indoor or outdoor area designated for the purpose of meeting the educational needs of students.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
PostWhen a new Room is created and saved.
PostWhen a Room is added to a section that does not already exist in Ed-Fi.
PostWhen a Room Name is changed and saved.
PutWhen the Maximum Number Of Seats is modified.
DeleteWhen a Room Name is changed and saved.
Delete

When a Room is deleted.


Scope Year Logic

This table describes scope year logic of this object.

Logic
Rooms are not aligned to a year so all Rooms will send to each scoped year.
Data will only send for the years that have valid configuration.
A resync must be completed on the Locations resource when a new scope year is connected in order for this data to send.


Object Data Elements

This table describes data elements sent within the Locations resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
schoolReference

Reports the following elements that are part of the Natural Key for the Schools resource:

  • EntityID
MSchool.entityIDSystem Administration > Resources > School > EntityID
classroom
IdentificationCode
A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or entity.M

Room.name

System Administration > Resources > Resources > Rooms > Name
maximumNumber
OfSeats
The maximum number of seats the class can maintain. The value in the Capacity field is reported. If blank, do not report.ORoom.capacitySystem Administration > Resources > Resources > Capacity
optimalNumber
OfSeats

The number of seats that is most favorable to the class. 

This field is not collected or reported.


ON/AN/A
etag

A unique system-generated value that identifies the version of the resource. 

This field is optional and does not report.


ON/AN/A




Parents

This entity represents a parent or guardian of a student, such as mother, father or caretaker. 

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When the Guardian checkbox is marked AND 1 person is a student and 1 person is not a student.

  • The guardian does NOT have to be a member of the same household as the student to report.
  • Start date must be on or before today's date.
  • End date must be on or after today's date.
  • Person must have an Ed-Fi ID to send.
  • A record will not send if the student they are associated with has an enrollment marked as a no show, state exclude or enrollment is in a calendar marked as Exclude.
Put

A record will be updated when any of the following are changed and saved:

  • When the person’s identity record is changed.
  • When one of the person’s household locations is changed.
  • When one of the person’s household memberships is changed.
  • When one of the person’s relationships that is marked Guardian is changed.
  • When the contact information has changed (phone or email).
DeleteA Parent record is a shared resource among all districts in the state and cannot be deleted. When the Student Parent Association is removed, the district will no longer have authorization to see the parent record.


Scope Year Logic

This table describes scope year logic of this object.

Logic

A parent record will report when they are a guardian to a student with an enrollment aligned to a scoped year.

  • The related pair start date must be null or on/before the scope year end date to report.
  • The related pair end date must be null or on/after the scope year end date to report.
  • Data will only send for the years that have valid configuration.
  • A resync must be completed on the Parents resource when a new scope year is connected in order for this data to send.

When using data in Campus that has an effective date, the following logic will be applied to determine the scope year(s) to report the data to.

  • Current Year:  Records will be compared to today's date to determine if the record is eligible to report.
  • Previous Years:  The record's date must be on or before the schools year's end date defined in the School Years editor.  If blank, the default date of 6/30/xxxx is used.
  • Future Years:  The record's date must be on or after the schools year's start date defined in the School Years editor.  If blank, the default date of 7/01/xxxx is used.

When using data in Campus that have start and end dates, the following logic will be applied to determine the scope year(s) to report the data to.

  • Current Year:  The records start date must be on or before today's date and the records end date must be on or after today's date.
  • Previous Years:  The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor.  If blank, the default date of 6/30/xxxx is used.
  • Future Years:  The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor.  If blank, the default date of 7/01/xxxx is used.


Object Data Elements

This table describes data elements sent within the Parents resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
parentUniqueIdA parent's Ed-Fi ID is reported.MPerson.edFiIdCensus > People > Demographics > EdFi ID
personalTitlePrefix

A prefix used to denote the title, degree, position or seniority of the person. 

This element is not collected or reported.


CN/AN/A
firstNameThe reporting parent's first name. This is reported from the person's most recent identity record.M

Identity.firstName

Census > People > Identities > First Name

middleNameThe reporting parent's middle name. This is reported from the person's most recent identity record.C

Identity.middleName

 Census > People > Identities > Middle Name

lastSurnameThe reporting parent's last name. This is reported from the person's most recent identity record.M

Identity.lastName

 Census > People > Identities > Last Name

generationCodeSuffixAn appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III). This is reported from the person's most recent identity record.C

Identity.suffix

 Census > People > Identities > Suffix

maidenName

The person's maiden name, if applicable.

This element is not collected or reported.


ON/AN/A
sexType

A person's gender. 

This element is not collected or reported.


ON/AN/A
loginId

The login ID for the user; used for security access control interface.

This element is not collected or reported.


MN/AN/A
addresses

Report the person's address(s).

Reports the Primary address that is marked as "Mailing."

  1. If more than 1 Primary Address is marked as Mailing, report address with most recent Household Membership Start Date
  2. Else, report the address with most recent Address Start Date
  3. Do not report if the Address Location Detail or Household Membership is marked as "Private"
O

Household Addresses > Mailing

Household Membership > Start Date

Household Addresses > Start Date

addressType

The type of home address. See the Address Type table in the Type/Description section below.

M

streetNumberName

The street number and street name or post office box number of an address.

  • Reports Address PO Box + Number + Street + Tag + Prefix + Dir
M

Address.postOfficeBox

Address.number

Address.street

Address.tag

Address.prefix

Address.dir

Households > Address Info
apartmentRoom
SuiteNumber
The apartment, room, or suite number of an address.OAddress.aptHouseholds > Address Info > Apt
buildingSiteNumber

The number of the building on the site, if more than one building shares the same address. 

This is optional and does not report.


ON/AN/A
cityThe name of the city in which an address is located.MAddress.cityHouseholds > Address Info > City
stateAbbreviation
Type
The abbreviation for the state (within the United States) or outlying area in which an address is located.MAddress.stateHouseholds > Address Info > State
postalCodeThe five or nine digit zip code portion of an address.MAddress.zipHouseholds > Address Info > Zip Code
nameOfCounty

The name of the county, parish, borough, or comparable unit (within a state) in which an address is located. 

This is optional and does not report.


Oaddress.county Households> Address Info> County
countyFIPSCode

5 digit code consisting of the two digit state code followed by the three digit FIPS code for the county. 

This is optional and does not report.


ON/AN/A
latitude

The geographic latitude of the physical address. 

This is optional and does not report.


ON/AN/A
longitude

The geographic longitude of the physical address. 

This is optional and does not report.


ON/AN/A
beginDate

The first date the address is valid. For physical addresses, the date the person moved to that address. 

This is optional and does not report.


ON/AN/A
endDate

The last date the address is valid. For physical addresses, this would be the date the person moved from that address. 

This is optional and does not report.


ON/AN/A
electronicMails

An unordered collection of parentElectronicMails. This entity represents a parent or guardian of a student, such as mother, father or caretaker.

  1. Reports the email address entered for that person
    1. Do not report if Email is marked as "Private"
  2. If blank, does not report
OContact.emailCensus > People > Demographics > Email
electronicMailTypeReports the mail type. See the Electronic Mail Type table in the Type/Description section below.MN/AN/A
electronic
MailAddress
The numbers, letters, and symbols used to identify an electronic mail (e-mail) user within the network to which the individual or organization belongs.MContact.emailCensus > People > Demographics > Email
primaryEmail
AddressIndicator
An indication that the electronic mail address should be used as the principal electronic mail address for an individual or organization.ON/AN/A
identification
Documents

Reports an unordered collection of the parent's identification documents.

This element is not collected or reported..


ON/AN/A
international
Addresses

Reports an unordered collection of the parent's international addresses.

This element is not collected or reported.


ON/AN/A
otherNames

Reports an unordered collection of the parent's other known names (aliases).

This field is optional and does not report.


ON/AN/A
telephones

An unordered collection of parentTelephones. This entity represents a parent or guardian of a student, such as mother, father or caretaker.

  1. Reports the Phone numbers entered in the Personal Contact Information for that person
    • Do not report Phone Number is marked as "Private"
  2. If blank, does not report
O

Contact.homephone

Contact.workphone

Contact.cellphone

Contact.pager

Census > People > Demographics > Personal Contact Information > Other Phone, Work Phone, Cell Phone, Pager
telephone
NumberType
Reports the number type. See the Telephone Number Type table in the Type/Description section below.MN/AN/A
orderOfPriority

The order of priority assigned to telephone numbers to define which number to attempt first, second, etc. 

This field is optional and does not report.


ON/AN/A
telephoneNumberThe 10-digit telephone number, including the area code, for the person.M

Contact.homephone

Contact.workphone

Contact.cellphone

Contact.pager

Census > People > Demographics > Personal Contact Information > Other Phone, Work Phone, Cell Phone, Pager
textMessage
CapabilityIndicator

An indication that the telephone number is technically capable of sending and receiving Short Message Service (SMS) text messages. 

This field is optional and does not report.


ON/AN/A
etag

A unique system-generated value that identifies the version of the resource. 

This field is optional and does not report.


ON/AN/A


Type/Descriptor Layout

This table describes the Ed-Fi Value mapped and reported for Telephone Number Types.

Campus ValueEd-Fi TypeEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
Other Phone1HomeHomeHome
Does not report, not collected in Campus2FaxFaxFax
Cell Phone3MobileMobileMobile
Does not report, not collected in Campus4UnlistedUnlistedUnlisted
Work Phone5WorkWorkWork
Pager6OtherOtherOther
Does not report, not collected in Campus7Emergency 1Emergency 1Emergency 1
Does not report, not collected in Campus8Emergency 2Emergency 2Emergency 2


This table describes the Ed-Fi Value mapped and reported for Electronic Mail Types.

Campus ValueEd-Fi Type IDEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
Primary email reports as "Home/Personal"1Home/PersonalHomeHome
Primary email reports as "Home/Personal"2OrganizationOrganizationOrganization
Primary email reports as "Home/Personal"3OtherOtherOther
Secondary email reports as "Work"4WorkWorkWork


This table describes the Ed-Fi Value mapped and reported for Address Types.

Campus ValueEd-Fi Type IDEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
All address report as "Home"1HomeHomeHome
2PhysicalPhysicalPhysical
3MailingMailingMailing
4OtherOtherOther
5WorkWorkWork
6BillingBillingBilling
7TemporaryTemporaryTemporary
8Father AddressFather AddressFather Address
9Guardian AddressGuardian AddressGuardian Address
10Mother AddressMother AddressMother Address
11ShippingShippingShipping
12SheltersShelters, Transitional housing, Awaiting Foster CareShelters, Transitional housing, Awaiting Foster Care
13DoubledDoubled - up (i.e., living with another family)Doubled - up (i.e., living with another family)
14UnshelteredUnsheltered (e.g. cars, parks, campgrounds, temp trailers including FEMA trailers, or abandoned buildings)Unsheltered (e.g. cars, parks, campgrounds, temp trailers including FEMA trailers, or abandoned buildings)
15HotelMotelHotels/MotelsHotels/Motels




Programs

This 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

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

Special Education

When a student in the year and calendar reporting has the following:

  • A locked IEP or IFSP
  • Print Format is miIEP% or miIFSP%
Post

Early Learning

When a student in the year and calendar reporting has the following:

  • A locked IFSP
  • Print Format is miIFSP%
Post

English Learners

When a student has an assigned EL service mapped to a State Service Code (Student Information > Program Participation > English Learners (EL) > EL Services, Program Admin > English Learners > EL Setup).

Post

Title 1

When a student is associated with a Title 1 program on the MSDS tab (Student Information > General > MSDS).

DeletePrograms are not deleted once they are created.


Scope Year Logic

Data does not send for any of the resources if they reference a school that is marked as Exclude on the School editor.

Logic
Special Education

A record reports for each year in which there is a locked IEP. 

If the school year start and end date is null, a date of 07/01/XXXX (start date) and 06/30/XXXX (end date) reports.

Early Learning

A record reports for each year in which there is a locked IFSP. 

If the school year start and end date is null, a date of 07/01/XXXX (start date) and 06/30/XXXX (end date) reports. 

English Learners

A record reports for each year where an active EL service exists. The EL service must be active at least one day within the Scope Year.

If the school year start and end date is null, a date of 07/01/XXXX (start date) and 06/30/XXXX (end date) reports.

Title 1

A record reports for each year in which there is a student with or more fields selected.

The enrollment with the selection must be within the Ed-Fi Scope Year.

Data is only sent for the years that have a valid configuration.


Object Data Elements

This table describes data elements sent within the Programs resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
educationOrgranization Reference

A reference to the related Education Organization resource. 

This sends the State District Number associated with the school. If the State District Number is changed, a resync on the school needs to be performed. 

ODistrict.stateDistrict NumberSystem Administration > Resources > District Information > State District Number
type

Reports the type of program.

  • Special Education
  • Early Intervention Services Part C
  • English as a Second Language
  • Title I Part A
MN/AN/A
name

The formal name of the program of instruction, training, services or benefits available through the federal,state or local agencies. 


  • Special Education
  • Early Intervention Services Part C
  • English as a Second Language
  • Title I Part A
MN/AN/A
programID

A unique number or alphanumeric code assigned to a program by a school, school system, a state, or other agency or entity.

This field does not report. 


ON/AN/A
sponsorType

Key for ProgramSponsor.

This field does not report. 


ON/AN/A
beginDate


This field does not report. 


ON/AN/A
characteristics

An unordered collection of programCharacteristics. Reflects important characteristics of the Program, such as categories or particular indications.

This field does not report. 


ON/AN/A
learningObjectives

An unordered collection of programLearningObjectives. Learning Standard followed by this program.

This field does not report. 


ON/AN/A
learningStandards

An unordered collection of programLearningStandards. References the Learning Objective(s) the Program is associated with.

This field does not report. 


ON/AN/A
services

An unordered collection of programServices. Defines the services this program provides to students.

This field does not report. 


ON/AN/A


Type/Descriptors


The highlighted column indicates the reported value.

This table describes the Program Type.

Ed-Fi Code ValueShort DescriptionDescription

212-004

Bilingual

Bilingual

212-005

Bilingual Summer

Bilingual Summer

212-006

Career and Technical Education

Career and Technical Education

212-016

English as a Second Language (ESL)

English as a Second Language (ESL)

212-021

Gifted and Talented

Gifted and Talented

212-049

Special Education

Special Education

212-054

Title I Part A

Title I Part A

212-001

Adult/Continuing Education

Adult/Continuing Education

212-002

Alternative Education

Alternative Education

212-003

Athletics

Athletics

212-007

Cocurricular Programs

Cocurricular Programs

212-008

College Preparatory

College Preparatory

212-009

Community Service Program

Community Service Program

212-010

Community/Junior College Education Program

Community/Junior College Education Program

212-011

Compensatory Services for Disadvantaged Students

Compensatory Services for Disadvantaged Students

212-012

Counseling Services

Counseling Services

212-017

Even Start

Even Start

212-019

Extended Day/Child Care Services

Extended Day/Child Care Services

212-022

Head Start

Head Start

212-023

Health Services Program

Health Services Program

212-024

High School Equivalency Program (HSEP)

High School Equivalency Program (HSEP)

212-026

IDEA

IDEA

212-027

Immigrant Education

Immigrant Education

212-029

Indian Education

Indian Education

212-030

International Baccalaureate

International Baccalaureate

212-034

Library/Media Services Program

Library/Media Services Program

212-035

Magnet/Special Program Emphasis

Magnet/Special Program Emphasis

212-036

Migrant Education

Migrant Education

212-037

Neglected and Delinquent Program

Neglected and Delinquent Program

212-038

Optional Flexible School Day Program (OFSDP)

Optional Flexible School Day Program (OFSDP)

212-039

Other

Other

212-045

Regular Education

Regular Education

212-046

Remedial Education

Remedial Education

212-048

Service Learning

Service Learning

212-050

Student Retention/Dropout Prevention

Student Retention/Dropout Prevention

212-051

Substance Abuse Education/Prevention

Substance Abuse Education/Prevention

212-052

Teacher Professional Development/Mentoring

Teacher Professional Development/Mentoring

212-053

Technical Preparatory

Technical Preparatory

212-057

Vocational Education

Vocational Education

212-013

District-Funded GED

District-Funded GED

212-018

Expelled Education

Expelled Education

212-028

Independent Study

Independent Study

212-047

Section 504 Placement

Section 504 Placement

212-014

Early Head Start

Early Head Start

212-015

Early Intervention Services Part C

Early Intervention Services Part C

212-020

Fee For Service

Fee For Service

212-025

Home Visiting

Home Visiting

212-043

Preschool Special Education

Preschool Special Education

212-044

Public Preschool

Public Preschool

212-032

Kindergarten - Full Day

Kindergarten - Full Day

212-033

Kindergarten - Half Day

Kindergarten - Half Day

212-031

Kindergarten - Extended Day

Kindergarten - Extended Day

212-041

Prekindergarten - Full Day

Prekindergarten - Full Day

212-042

Prekindergarten - Half Day

Prekindergarten - Half Day

212-040

Prekindergarten - Extended Day

Prekindergarten - Extended Day

212-055

Title I Part D Subpart 1

Title I Part D Subpart 1

212-056

Title I Part D Subpart 2

Title I Part D Subpart 2

212-058

Foreign Exchange

Foreign Exchange

ECAP

ECAP

ECAP

Part B

Part B Section 619

Part B Section 619

Part C

Part C

Part C

POC

Purchase of Care

Purchase of Care




Restraint Events

This event entity represents the instances where a special education student was physically or mechanically restrained due to imminent serious physical harm to themselves or others, imminent serious property destruction or a combination of both imminent serious physical harm to themselves or others and imminent serious property destruction.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

Reports a behavior incident's Behavior Response when the incident's Status is marked and saved as 'Complete'.

  • The student must have at least one associated behavior response.
  • The Response must be a Response Type of Physical Restraint or Seclusion.
  • Posting can occur if a new response is added after the Incident is marked as 'Complete'.
  • Do not send if the student's enrollment is marked as No Show or State Exclude.
  • Do not send if the student is in a calendar marked as Exclude.
  • Do not send if the student's enrollment is in a school marked as Exclude.
Delete/Post

When data that is part of the Natural Key is changed.

  • If the Date of Incident is changed and saved.
  • If the Event Type is changed and saved
Delete/Post

When the Incident's status is changed.

  • Delete when the status is changed from 'Completed' to' in 'Progress'.
  • Post when the status is changed from 'In Progress' to 'Completed'.
DeleteWhen an incident is deleted.
DeleteWhen all non-excluded enrollments in the school and year are deleted.


Scope Year Logic

Data does not send for any of the resources if they reference a school that is marked as Exclude on the School editor.

Logic

Discipline records will only send to the school year that the incident date is aligned to based on the School Year Start and End dates.

  • If the School Year Start Date is NULL, 7/1/xxxx is the default start date used.
  • If the School Year End Date is NULL, 6/30/xxxx is the default end date used.
Data only sends for the years that have a valid configuration.


Object Data Elements

This table describes data elements sent within the Calendar Dates resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
schoolReference

A reference to the related Discipline Incident resource. Reports the fields that are part of the Natural Key for the  Schools resource.

M

studentReference

A reference to the related Student resource. Reports the data that is part of the Natural Key for the Student resource.

M

identifierA unique number or alphanumeric code assigned to a restraint event by a school, school system, a state, or other agency or entity. Reports the Incident ID.OBehavior Incident.incidentIDBehavior> Behavior Management> Incident ID
eventDateMonth, day, and year of the RestraintEvent. Reports the Date of Incident.OBehavior Incident.timestampBehavior> Behavior Management> Date of Incident
educationalEnvironmentType

The setting where the RestraintEvent was exercised.

This field is optional and does not report.


O

programs

An unordered collection of restraintEventPrograms. The Special Education program associated with the restraint event.



This field is optional and does not report.



O

reasons

An unordered collection of restraintEventReasons. The items of categorization of the circumstances or reasons for the restraint.

This field is optional and does not report.


O

restraintCategories

An unordered collection of restraintEventRestraintCategories. (MI EXT) Additional details of seclusion and/or restraint event.

O
Behavior> Behavior Management>Behavior Response
restraintCategoryDescriptor

Indicates the type of event: seclusion or restraint.

  1. If Response Type = Seclusion, report 01.
  2. If Response Type = Physical Restraint, Report 02.
M

eventCount

Indicates the total number of times the RestraintCategory event occurred on the EventDate.

SUM of Response Types = 01 or 02 that occur on the same Incident.

O

_etag

A unique system-generated value that identifies the version of the resource. 

This does not report.

ON/AN/A


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Restraint Event Reason Type.

Ed-Fi Code ValueEd-Fi Short DescriptionEd-FiDescription
Imminent Serious Physical Harm To ThemselvesImminent Serious Physical Harm To ThemselvesImminent Serious Physical Harm To Themselves
Imminent Serious Physical Harm To OthersImminent Serious Physical Harm To OthersImminent Serious Physical Harm To Others
Imminent Serious Property DestructionImminent Serious Property DestructionImminent Serious Property Destruction

This table describes the Restraint Category Descriptor.

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01Seclusion EventRestraint Event
02Restraint EventRestraint Event



Schools

This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a new school is created and saved OR the State School Number changes. 

  • Do not send if the Exclude checkbox is marked.
  • If the Exclude checkbox is selected after the school is sent, the school remains.
  • Most resources have a school reference, if the state school number changes after data has been sent, all data for the previous number will remain and a resync will need to be performed for data to be sent to the new school.
Put

When any of the fields not part of the Natural Key change:

  • Name
  • Address
  • Telephone
  • Grade Levels
DeleteA delete is not sent.


Scope Year Logic

Data does not send for any of the resources if they reference a school that is marked as Exclude on the School editor.

Logic
Schools are not aligned to a year so all schools send to each scoped year.
Data only sends for the years that have a valid configuration.
A resync must be completed on the resource when a new scope year is connected in order for this data to send.


Object Data Elements

This table describes data elements sent within the Schools resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
localEducation
AgencyReference

A reference to the related Local Education Agency resource. 

This sends the State District Number associated with the school. If the State District Number is changed, a resync on the school needs to be performed. 

ON/AN/A
schoolIdIndicates the School Entity ID.MSchool.entityIdSystem Administration > Resources > School > Entity ID
stateOrganizationId

The identifier assigned to an education agency byt the State Education Agency. This is also known as State LEP ID. NEDML Identification Code, LEA Identifier. 

  1. Report the Ed-Fi School Number.
  2. If the Ed-Fi School Number is blank, report the State School Number.
MSchool.stateNumberSystem Administration > Resources > School > State School Number
nameOfInstitution

The full, legally accepted anme of the institution. NEDM: Name of Institution. 

Reports the school name. 

MSchool.nameSystem Administration > Resources > School > Name
shortNameOfInstitution

A short name for the institution.

This field does not report. 


ON/AN/A
webSite

The public web site address (URL) for the educational organization.

This field does not report. 


ON/AN/A
operationalStatus
Type

The current operational status of the education organization (e.g., active, inactive)

This field does not report. 


ON/AN/A
type

The instructional categorization of the school (e.g., Regular, Alternative, etc.) 

This field does not report. 


ON/AN/A
charterStatusType

A school or agency providing free public elementary or secondary education to eligible students under a specific charter granted by the state legislature or other appropriate authority and designated by such authority to be a charter school.

This field does not report. 


ON/AN/A
titleIPartASchool
DesignationType

Denotes the Title I Part A designation for the school.

This field does not report. 


ON/AN/A
magnetSpecialProgram
EmphasisSchoolType

A school that has been designed: 1) to attract students of different racial/ethnic backgrounds for the purpose of reducing, preventing, or eliminating racial isolation; and/or 2)to provide an academic or social focus on a particular theme (e.g., science/math, performing arts, gifted/talented, or foreign language). 

This field does not report. 


ON/AN/A
administrativeFunding
ControlDescriptor

This descriptor holds the type of education institution as classified by its funding source (e.g., public or private)

This field does not report. 


ON/AN/A
internetAccessType

Indicates the type of Internet access that is available.

This field does not report. 


ON/AN/A
addresses












An unordered collection of educationOrganizationAddresses. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups. 

Reports the Physical Address for the school. If blank, does not report. 

This element is an array that reports the following data:

O

HouseholdLocation.
mailing

HouseholdMember.
startDate

Householdlocation.
startDate

Household Addresses > Mailing

Household Membership > Start Date

Household Addresses > Start Date

addressTypeAll addresses will report as 'Home'. This will report the Ed-Fi mapped value in the Address Type table in the section below.MN/AN/A
streetNumberName

The street number and street name or post office box number of an address. 

Reports the Address PO Box + Number + Street + Tag + Prefix + Dir

M

Address.postOfficeBox

Address.number

Address.street

Address.tag

Address.prefix

Address.dir

Households > Address Info
apartmentRoom SuiteNumberThe apartment, room, or suite number of an address.OAddress.aptHouseholds > Address Info > Apt
buildingSiteNumber

The number of the building on the site, if more than one building shares the same address.

This field does not report. 


ON/AN/A
cityThe name of the city in which an address is located.MAddress.cityHouseholds > Address Info > City
stateAbbreviationTypeThe abbreviation for the state (within the US) or outlying area in which an address is located.MAddress.stateHouseholds > Address Info > State
postalCodeThe five or nine digit zip code portion of an address.MAddress.zipHouseholds > Address Info > Zip
nameOfCounty

The name of the county, parish, borough, or comparable unit (within a state) in which an address is located.

This field does not report. 


ON/AN/A
countyFIPS

5-digit code consisting of the two digit state code followed by the three digit FIPS code for the county.

This field does not report. 


O

N/AN/A
latitude

The geographic latitude of the physical address.

This field does not report. 


ON/AN/A
longitude

The geographic longitude of the physical address

This field does not report. 


ON/AN/A
beginDate

The first date the address is valid. For physical addresses, the date the person moved to that address

This field does not report. 


ON/AN/A
endDate

The last date the address is valid. For physical addresses, this would be the date the person moved from that address.

This field does not report. 


ON/AN/A
educationOrganization
Categories

An unordered collection of educationOrganizationCategories. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups.

This element is an array that reports the following data:

ON/AN/A
institutionTelephone NumberTypeType of phone number. Always reports 'Main.'MN/AN/A
telephoneNumber

The telephone number including the area code, and extension, if applicable.

Reports the phone number entered. If blank, does not report.

MSchool.phoneNumberSystem Administration > Resources > School Information
identificationCodes

An unordered collection of educationOrganizationIdentificationCodes. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups. 

This field does not report. 


ON/AN/A
institutionTelephones

An unordered collection of educationOrganizationInstitutionTelephones. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups.

Reports the Phone Number for the school. If blank, does not report.

This element is an array that reports the following data:

ON/AN/A
type

The classification of the education agency within the geographic boundaries of a state according to the level of administrative and operational control granted by the state.

Always reports 'School.'

MN/AN/A
internationalAddresses

An unordered collection of educationOrganizationInternationalAddresses. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups.

This field does not report. 


ON/AN/A
schoolCategoriesAn unordered collection of schoolCategories. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups.O


type

The category of school. For example: High School, Middle School, Elementary School.

  1. Reports the Ed-Fi Code from the Grade Type droplist.
  2. If Ed-Fi Code is NULL or field is blank, do not report.
Mschools.gradeTypeSystem Administration > Resources > Schools > Grade Type
gradeLevels

An unordered collection of schoolGradeLevels. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups.

Reports the Ed-Fi Code Value from all state grade levels. 

This element is an array that reports the following data:

ON/AN/A
gradeLevelDescriptor

The grade levels served at the school.

Reports the mapped Ed-Fi code for  the State Grade Level Code for all grades in all Calendars/Schedule Structures associated with the reporting School and Year. Calendar End Year must equal the scoped end year.

Ocalendar.gradeLevelSystem Administration > Calendar > Calendar > Grade Levels
etagN/AON/AN/A


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Institution Telephone Number Type.

Ed-Fi Code ValueShort DescriptionDescription
MainMainMain
AdministrativeAdministrativeAdministrative
Health ClinicHealth ClinicHealth Clinic
AttendanceAttendanceAttendance
OtherOtherOther
FaxFaxFax
Food ServiceFood ServiceFood Service

This table describes the Education Organization Category Type.

Ed-Fi Code ValueShort DescriptionDescription
Education Service CenterEducation Service CenterEducation Service Center
Local Education AgencyLocal Education AgencyLocal Education Agency
SchoolSchoolSchool
State Education AgencyState Education AgencyState Education Agency
Education Organization NetworkEducation Organization NetworkEducation Organization Network
OtherOtherOther

This table describes the Ed-Fi Value mapped and reported for Grade Levels Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
00KindergartenKindergarten
01First GradeFirst Grade
02Second GradeSecond Grade
03Third GradeThird Grade
04Fourth GradeFourth Grade
05Fifth GradeFifth Grade
06Sixth GradeSixth Grade
07Seventh GradeSeventh Grade
08Eighth GradeEighth Grade
09Ninth GradeNinth Grade
10Tenth GradeTenth Grade
11Eleventh GradeEleventh Grade
12Twelfth GradeTwelfth Grade
14Special Education TransitionSpecial Education Transition
20Adult EducationAdult Education
30Early Childhood/Early On (Below Kindergarten level)Early Childhood/Early On (Below Kindergarten level)




Section

This educational entity represents a setting in which organized instruction of course content is provided to one or more students for a given period of time. A course may be offered to more than one class/section. Instruction, provided by one or more teachers or other staff members, may be delivered in person or via a different medium.

This entity reports per section per term type combination. 

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a section is created and saved.

  • Room and Section Placement are required in order for the section to send.
  • One record reports for each section, term type, class period combination.
  • If the Calendar Exclude checkbox is marked, data is not sent.
  • If the Course is marked as State Exclude, data is not sent.
  • If the School Exclude checkbox is marked, data is not sent.
PostWhen a section schedule placement is changed and saved.
PostWhen the Local Course Number or Term type Override is changed.
Put

When any fields listed below are changed:

  • When the local course name, attendance, unit attendance or SCED Seq Number is changed and saved on the Course editor.
  • When the Room or Instructional Setting is changed and saved on a section.
  • When the Credit field is changed and saved on a Grading Task assigned to the course.
DeleteWhen a section is deleted.
DeleteWhen Section Placement is changed or removed and saved on a section.
DeleteWhen the Local Course Number or Term type Override is changed.


Scope Year Logic

This table describes scope year logic of this object.

Logic
Reports Sections in the scope year the course's calendar is aligned to.
Data will only send for the years that have valid configuration.

Future Years data will be suppressed until the Active Year is changed:

  • This allows the Schedule Wizard to be used and reduces the number of records sent until the final schedule is completed.
  • A resync must be done after the Active Year is changed to send data.


Object Data Elements

This table describes data elements sent within the Section resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
 id The unique identifier of the resource.MN/AN/A
classPeriod
Reference  

Reports the following elements that are part of the Natural Key for the Class Periods:

  • id
  • name     

M

N/AN/A
courseOffering Reference 

Reports the following elements that are part of the Natural Key for the Course Offering:

  •  schoolReference 
  •  sessionReference  
  •  localCourseCode    
MN/AN/A
locationReference 

Reports the following elements that are part of the Natural Key for the Locations resource:

  • schoolReference 
  • classroomIdentificationCode   
MN/AN/A
schoolReference 

Reports the following elements that are part of the Natural Key for the Schools resource:

  •  EntityID  
MN/AN/A
uniqueSectionCodeA unique identifier for the section, that is defined for a campus by the classroom, the subjects taught, and the instructors that are assigned. This element reports the section ID of the section being reported.MN/AN/A
sequenceOfCourse

When a section is part of a sequence of parts for a course, the number if the sequence. If the course has only onle part, the value of this section attribute should be 1.

  1. Report the code selected in Scheduling > Courses > Course > Course Editor > Course Inventory Sequence Part (Course.sequencePart)
  2. When Course Inventory Sequence Part = Null, report 1.
MN/AN/A
educational EnvironmentType

The setting in which a child receives education and related services. For example, Center-based instruction Home-based instruction, Hospital class, Mainstream Residential care, treatment facility.

This element does not report in Michigan.


ON/AN/A
mediumOf InstructionType

The media through which teachers provide instruction to students and students and teachers communicate about instructional matters.

  • If Virtual Method is not null on the course or section, this field reports Virtual/On-Line Distance Learner. 
  • If Virtual Method is blank, this field does not report. 
OCourse.virtualMethod

Scheduling > Courses > Course/Section > Virtual Method


populationServed Type

The population for which the course was designed.

This element is optional and does not report.

ON/AN/A
availableCredit Type

The type of credits or units of value awarded for the completion of a course.

This element is optional and does not report.

ON/AN/A
availableCredit
Conversion

Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.

This element is optional and does not report.

ON/AN/A
instructionLanguage
Descriptor
This element is optional and does not report.ON/AN/A
availableCredit

Credits or units of value awarded for the completion of a course. Logic calculates this as follows:

  • Sum the total number of credits from the Grading Tasks on the course
  • Divide by the number of terms the course section occurs
OGradingTaskCredit.
Credit
Scheduling > Courses > Course > Grading Tasks > Credit
characteristics

This descriptor defines characteristics of a section, such as whether attendance is taken and the section is graded. 

  • Reports '01' when Attendance and/or Positive Attendance checkbox is checked on a course.
  • Reports '02' when a grading task is added and saved to a course.


OGradingTaskCredit.
 Credit

Scheduling > Course > Attendance/Positive Attendance

Scheduling > Course > Grading Tasks

sectionCharacteristic Descriptor

Defines the characteristics of a section, such as whether attendance is taken and the section is graded.

See the Type/Description Layout for more information.

ON/AN/A
msixCourseSectionDescriptor

Indicates the timespan of the migrant student course when reporting migrant students by educating entities when the Local Course ID cannot uniquely identify a given course.

  1. Reports the MSIX Course Section ID. Reports first from Section, then Course.
  2. If blank, does not report.
ON/A

Course > Section > MSIX Course Section ID

Course > MSIX Course Section ID

programs

An unordered collection of sectionPrograms. This educational entity represents a setting in which organized instruction of course content is provided to one or more students for a given period of time.

This element is optional and does not report.
ON/AN/A
etag

A unique system-generated value that identifies the version of the resource.

This element is optional and does not report.

ON/AN/A

Type/Descriptor Layout

This table describes the Ed-Fi Value mapped and reported for Section Characteristic Descriptors.

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01Attendance TrackedAttendance Tracked
02Graded CreditGraded Credit Available

This table describes the Ed-Fi Value mapped and reported for Medium of Instruction Types.

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description

196-011

Televised

Televised

196-010

Telepresence/video conference

Telepresence/video conference

196-012

Videotaped/prerecorded video

Videotaped/prerecorded video

196-008

Other technology-based instruction

Other technology-based instruction

196-009

Technology-based instruction in classroom

Technology-based instruction in classroom

196-002

Correspondence instruction

Correspondence instruction

196-004

Face-to-face instruction

Face-to-face instruction

196-013

Virtual/On-line Distance learning

Virtual/On-line Distance learning

196-001

Center-based instruction

Center-based instruction

196-005

Independent study

Independent study

196-006

Internship

Internship

196-007

Other

Other

196-003

Distance Learning (other than online)

Distance Learning (other than online)





Sessions

This entity represents the prescribed span of time when an education institution is open, instruction is provided and students are under the direction and guidance of teachers and/or education institution administration. A session may be interrupted by one or more vacations

In order to report properly, the Ed-Fi Term Type field needs to be populated on the Calendar Term Detail editor. This ties the Course Section to the Term. If the Course Section needs to use a different term type, the Ed-Fi Term Type Override field needs to be populated on the Course Section Editor. 

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Data will not report for calendars, schools, and courses marked as Exclude.


ActionTrigger
Post

When a new Term Schedule is created and saved that is mapped to a Term Type and a resync of Sessions is completed.

  • If the same Term Type is selected on multiple Terms, group the Terms together so only 1 record will report per Term Type.
  • If there are multiple Calendars or Schedule structures in a School with the same Term Types, only 1 record can report to Ed-Fi.  Report the earliest Term Start Date and latest Term End Date.
Post

When a Term Descriptor Override is selected on a Course or Section and saved and the course is mapped to a Term Descriptor Override and a resync of Sessions is completed.

  • The Session will report the start and end dates based on the section schedule placement of the course section
  • If the same Term Type is selected in the Terms tab and the Term Descriptor Override field on Course/Section, a record will not send from the override field
  • If the same Term Type is selected in the Override field on Course/Section with different Section Schedule Placements, the last one created or changed will report

Start and End dates are not part of the natural Key so only 1 record per Term Type can be sent to Ed-Fi.  Logic has been implemented to determine the priority of what start and end dates to use for a Term Type.


Put

When the Grading Period, term name, start or end dates are changed and saved.

  • The term dates can change either on the Terms tab or by changing Section Schedule Placement on a section
Delete

Terms are never deleted; they are only used as a reference. They remain if a Term Schedule is deleted or Term Types are changed. 

Start and End dates are not part of the natural Key so only 1 record per Term Type can be sent to Ed-Fi.  Logic has been implemented to determine the priority of what start and end dates to use for a Term Type.



Scope Year Logic

This table describes scope year logic of this object.

Logic
. Reports Sessions for the scope year to which the calendar is aligned.
Data will only send for the years that have valid configuration.

Future Years data will be suppressed until the Active Year is changed:

  • This allows the Schedule Wizard to be used and reduces the number of records sent until the final schedule is completed.
  • A resync must be done after the Active Year is changed to send data.


Object Data Elements

This table describes data elements sent within the Sessions resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
schoolReference

Reports the following elements that are part of the Natural Key for the School resource:

  • EntityID
MN/AN/A
schoolYearTypeReferenceA reference to the related SchoolYearType resource. This element reports the End year from the calendar term reported. MN/AN/A
nameThe identifier for the calendar for the academic session. MTerm.edfiTypeNameSystem Administration > Calendar > Calendar > Terms > Term Type Name
termDescriptor

This descriptor defines the term of a session during the school year (e.g., Fall Semester). See the Term Descriptor mapping in the Type/Descriptor section below.

  1. When reporting from Term Descriptors mapping, report the Ed-Fi Code for the value selected.
    1. When Ed-Fi Term Type = Null, or when no Ed-Fi code exists, do not report.
  2. When reporting from the Term Descriptors Override on Course or Section, report the Ed-Fi code value selected.
 O

Term.edFiTermType

Course.edFiTermType

Section.edFiTermType

System Administration > Calendar > Calendar > Terms > Term Type

OR

Scheduling > Courses/Sections

beginDate

The term start date. This element reports the start date of the term being reported. 

  1. When reporting from a Term Schedule, report the start date of the term being reported 
    1. If more than 1 term has the same Term Type selected, report the earliest start date
  2. When reporting from a Term Type Override on a section:
    1. Report the start date from the mapping the course is aligned to.
MTerm.startDateSystem Administration > Calendar > Calendar > Terms > Start Date
endDate

The term end date. This element reports the end date of the term being reported.

  1. When reporting from a Term Schedule, report the end date of the term being reported 
    1. If more than 1 term has the same Term Type selected, use the latest end date
  2. When reporting from a Term Type Override on a section:
    1. Report the end date from the mapping the course is aligned to.
Term.endDateSystem Administration > Calendar > Calendar > Terms > End Date
totalInstructionalDays

This element reports the total number of instructional days from the Days tab from the calendar and schedule structure the term is associated with. 

  1. When reporting from Term Schedule, count the total number of instructional days from the Days tab from the calendar and schedule structure the term is associated with
    1. A day reset must be completed before the days will calculate.  Use the resync after day reset is completed to have instructional days calculated and sent.
    2. If more than 1 term schedule has the same Term Type, count the distinct number of instructional days from all terms for that Term Type
  2. When reporting from Term Type Override, find all section placements that Term Type is associated and count the distinct number of instructional days that fall on/between the start and end dates.

A day reset must be completed before the days will calculate.  Use the resync function of Ed-Fi Tools to have instructional days calculated and sent.


MN/AN/A
academicWeeksAn unordered collection of sessionAcademicWeeks.ON/AN/A
gradingPeriodsAn unordered collection of sessionGradingPeriods.ON/AN/A
gradingPeriodReference

Report a record for each Grading Period reported in the Grading Periods Resource that occurs in the session being reported.

When reporting from Term Type Override, reference all grading periods that are associated with any course or section with the same Term Type Override

  • The course is associated with the grading task of the grading period
  • The section is placed in the term of the grading period

If there is not a Grading Period association with the Session, the array will be NULL and the Session record will error

MN/AN/A
etagA unique system-generated value that identifies the version of the resource.ON/AN/A


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Term Descriptor:

CodeNameEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
1SFall SemesterFall SemesterFall SemesterFall Semester
2SSpring SemesterSpring SemesterSpring SemesterSpring Semester
SSSummer SemesterSummer SemesterSummer SemesterSummer Semester
1TFirst TrimesterFirst TrimesterFirst TrimesterFirst Trimester
2TSecond TrimesterSecond TrimesterSecond TrimesterSecond Trimester
3TThird TrimesterThird TrimesterThird TrimesterThird Trimester
FYFull YearFull YearFull YearFull Year
MTMiniTermMiniTermMiniTermMiniTerm
1QFirst QuarterFirst QuarterFirst QuarterFirst Quarter
2QSecond QuarterSecond QuarterSecond QuarterSecond Quarter
3QThird QuarterThird QuarterThird QuarterThird Quarter
4QFourth QuarterFourth QuarterFourth QuarterFourth Quarter
OTOtherOtherOtherOther





Staff Education Organization Assignment Association

This association indicates the education organization to which a staff member provides services; also known as school of service.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a person has a District Employment with the District Staff check box checked and a District Assignment Code populated.

OR

When a person has a District Assignment record and the District Staff check box is not checked.

Do NOT report a record if any one of the following scenarios are true:  

  1. There is not an Ed-FI ID for the staff person.
  2. The staff records are not active based on the Scope Year logic listed below.
  3. If the record is being triggered from a District Assignment record and it is marked as Exclude.
  4. If the record is being triggered from a District Assignment record and the School is marked as Exclude.
  5. If data is sent prior to the Exclude checkboxes are checked, the data will remain and the user will need to use the Delete Tool to remove data.
  6. If the Assignment Code field is not mapped in Resource Preferences.
If school staff member has more than 1 qualifying District Assignment record, a record will generate for each eligible School/Start date.
Put

N/A, a delete and insert occurs when any field is edited and saved. 

Delete/PostWhen the person’s employment assignment record is changed
Delete/Post

When the person’s employment record is changed

Delete/Post

When the Assignment Code, Start Date or End date is modified on the District Assignment record

DeleteWhen a District Assignment record is deleted.
DeleteWhen a District Employment record is deleted
DeleteWhen a District Employment record > District Staff is unchecked AND no district assignment exists for the staff.


Scope Year Logic

This table describes scope year logic of this object.

Logic

A record will report when a person has a District Assignment record that is aligned to a scoped year.

  • Report when a staff has an active District Assignment record that overlaps with the School year Start and End Dates.
    • If School Year Start Date is NULL, 7/1/xxxx will be the default start date used.
    • If School Year End Date is NULL, 6/30/xxxx will be the default end date used.
  • Data will only send for the years that have valid configuration.

When using data in Campus that has an effective date, the following logic will be applied to determine the scope year(s) to report the data to.

  • Current Year:  Records will be compared to today's date to determine if the record is eligible to report.
  • Previous Years:  The record's date must be on or before the schools year's end date defined in the School Years editor.  If blank, the default date of 6/30/xxxx is used.
  • Future Years:  The record's date must be on or after the schools year's start date defined in the School Years editor.  If blank, the default date of 7/01/xxxx is used.


 Object Data Elements

This table describes data elements sent within the Staff Education Organization Agreement Association resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
StaffEducationOrganization
EmploymentAssociationReference

Reports the data that is part of the Natural Key for the Staff Education Organization Employment Association resource:

  • educationOrganizationReference
  • staffReference
  • employmentStatusDescriptor
  • hireDate
N/AN/A
educationOrganizationReference

A reference to the related EducationOrganization resource. 

  1. First look to District Employment > District Staff.  If the checkbox is checked, report staff with the District Number.
  2. If the District Staff checkbox is not checked, report the State School Number.
MN/AN/A
staffReference

Reports the data that is part of the Natural Key for the Staff resource:

  • staffUniqueId
MN/AN/A
staffClassificationDescriptor

The titles of employment, official status, or rank of education staff.

Report the Ed-Fi code mapped to the value selected:

  1. If reporting from District Employment, report the Ed-Fi Code mapped to the District Assignment Code selected.
  2. If reporting from District Assignment, report the Ed-Fi Code mapped to the Assignment Code selected.
  3. Look to see if a default value is saved in the Attribute Dictionary when reporting.
MEmploymentAssignment.
assignmentCode
Census > People > District Assignment > Assignment Code
beginDate

The month, day and year of the start or effective date of a staff member's employment, contract or relationship with the LEA. This element reports the Start Date from the District Assignment being reported.

  • When reporting from the District Employment record, report the District Employment Start Date
  • When reporting from the District Assignment record, report the District Assignment Start Date
EmploymentAssignment.
startDate
Census > People > District Assignment > Start Date
positionTitle

The descriptive name of an individual's position. 

  • Do not report this field if reporting from District Employment.
  • If reporting from District Assignment, report name from associated Title. If NULL, do not report this field.
OEmployment.assignmentCensus > People > District Assignment Title
endDate

The month, day and year of the end or termination date of a staff member's employment, contract or relationship with the LEA.

  1. When reporting from the District Employment record, report the District Employment End Date
    1. If NULL, do not report
  2. When reporting from the District Assignment record, report the District Assignment End Date
    1. If NULL, do not report
EmploymentAssignment.
endDate
Census > People > District Assignment > End Date
orderOfAssignment

Describes whether the assignment is the staff member's primary assignment, secondary assignment. 

This element is optional and does not report.


ON/AN/A
staffREPCredentual Reference

A reference to the related StaffREPCredential resource.

This element is optional and does not report.


ON/AN/A
administratorContinuing EducationDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

This element is optional and does not report.


ON/AN/A
fundedPosition StatusDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

This element is optional and does not report.


ON/AN/A
repTeacherFunded TypeDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

This element is optional and does not report.


ON/AN/A
assignedSubjectAreas

An unordered collection of staffEducationOrganizationAssignmentAssociation AssignedSubjectAreas. (MI EXT) To capture REP assigned subject area details.

This element is optional and does not report.


ON/AN/A
etagA unique system-generated value that identifies the version of the resource.ON/AN/A


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Staff Classification Descriptors:

Ed-Fi CodeEd-Fi Short DescriptionEd-Fi Description
Assistant PrincipalAssistant PrincipalAssistant Principal
Assistant SuperintendentAssistant SuperintendentAssistant Superintendent
CounselorCounselorCounselor
Instructional AideInstructional AideInstructional Aide
Instructional CoordinatorInstructional CoordinatorInstructional Coordinator
LEA AdministratorLEA AdministratorLEA Administrator
LEA SpecialistLEA SpecialistLEA Specialist
LEA System AdministratorLEA System AdministratorLEA System Administrator
Librarians/Media SpecialistsLibrarians/Media SpecialistsLibrarians/Media Specialists
Operational SupportOperational SupportOperational Support
OtherOtherOther
PrincipalPrincipalPrincipal
School AdministratorSchool AdministratorSchool Administrator
School LeaderSchool LeaderSchool Leader
School SpecialistSchool SpecialistSchool Specialist
State AdministratorState AdministratorState Administrator
Substitute TeacherSubstitute TeacherSubstitute Teacher
SuperintendentSuperintendentSuperintendent
Support Services StaffSupport Services StaffSupport Services Staff
TeacherTeacherTeacher




Staff Education Organization Employment Association

This association indicates the education organization an employee, contractor, volunteer or other service provider is formally associated with typically indicated by which organization the staff member has a services contract with or receives compensation from.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a person has a District Employment record with the District Staff check box checked and a District Assignment Code populated.

OR

When a person has a District Assignment record and the District Staff check box is not checked.

Do NOT report a record if any one of the following scenarios are true:  

  1. There is not an Ed-FI ID for the staff person.
  2. The staff records are not active based on the Scope Year logic listed below.
  3. If the record is being triggered from a District Assignment record and it is marked as Exclude.

  4. If the record is being triggered from a District Assignment record and the School is marked as Exclude.

  5. If data is sent prior to the Exclude checkboxes are checked, the data will remain and the user will need to use the Delete Tool to remove data.
  6. The Employment Status field is not mapped in Resource Preferences.
PutN/A, a delete and insert occurs when any field is edited and saved. 
Delete/PostWhen the person’s employment assignment record is changed
Delete/PostWhen the person’s employment record is changed
Delete/PostWhen the Assignment Code, Start Date or End date is modified on the District Assignment record
DeleteWhen a District Assignment record is deleted
DeleteWhen a District Employment record is deleted
DeleteWhen a District Employment record > District Staff checkbox is removed AND no district assignment exists for the staff.


Scope Year Logic

This table describes scope year logic of this object.

Logic

A record will report when a person has a District Assignment record that is aligned to a scoped year.

Report when a staff has an active District Assignment record that overlaps with the School year Start and End Dates.

  • If School Year Start Date is NULL, 7/1/xxxx will be the default start date used.
  • If School Year End Date is NULL, 6/30/xxxx will be the default end date used.
Data will only send for the years that have valid configuration.


Object Data Elements

This table describes data elements sent within the Staff Education Organization Employment Association resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
educationOrganization
Reference

A reference to the related EducationOrganization resource

  1. First look to District Employment > District Staff.  If the checkbox is checked, report staff with the District Number.
  2. If the District Staff checkbox is not checked, report the State School Number from the District Assignment record.
MN/A

 System Administration> Resources> District Information> State District Number

OR

System Administration> Resources> School> State School Number

staffReference

Reports the data that is part of the Natural Key for the Staff resource:

  • staffUniqueId
MN/AN/A
employmentStatus
Descriptor

This descriptor defines the type of employment or contract.

  1. When reporting from the District Employment record, report the mapped code from Employment Status. 
  2. When reporting from District Assignment, report mapped code from Type.
  3. Report the attribute Default Value if available and the field is NULL in the DB.
  4. If field is blank, report '04'.


MEmployment
assignment.type
Census > People > District Assignment > Type
hireDate

The month, day, and year on which a contract between an individual and a governing authority specifies that employment is to begin (or the date on which the agreement is made valid).

  1. When reporting from the District Employment record, report the District Employment Start Date
  2. When reporting from the District Assignment record, report the District Assignment Start Date
MEmployment
assignment.startDate
Census > People > District Assignment > Start Date
endDate

The month, day, and year on which a contract between an individual and a governing authority ends or is terminated under the provisions of the contract (or the date on which the agreement is made invalid). 

  1. When reporting from the District Employment record, report the District Employment End Date
    1. If NULL, do not report
  2. When reporting from the District Assignment record, report the District Assignment End Date
    1. If NULL, do not report
OEmployment
assignment.endDate
Census > People > District Assignment > End Date
separationType

The type of employment separation (e.g., Voluntary separation, Involuntary separation, Mutual agreement, Other, etc).

This is not collected within Campus and is not reported.

ON/AN/A 
separationReason
Descriptor

This descriptor defines the reasons for terminating the employment.

This is not collected within Campus and is not reported.

N/A N/A 
department

The department or su-organization the employee/contractor is associated with in the Education Organization.

This is not collected within Campus and is not reported.

ON/AN/A
fullTimeEquivalency

The ratio between the hours of work expected in a position and the hours of work normally expected in a full-time position in the same setting.

This is not collected within Campus and is not reported.

N/AN/A
offerDate

Date at which the staff member was made an official offer for this employment.

This is not collected within Campus and is not reported.

ON/AN/A
hourlyWage

Hourly wage associated with the employment position being reported.

This is not collected within Campus and is not reported.

O  N/AN/A
repFullTimeBaseAnnualSalary

The full-time base annual salary for the employee is the base salary (basic contract) for a first-year full-time employee at this educational level. It does not include increments for years of service or longevity payments.

This is not collected within Campus and is not reported.

ON/AN/A
accountingFunctionCodeDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

This is not collected within Campus and is not reported.

ON/AN/A
etagA unique system-generated value that identifies the version of the resource.ON/AN/A


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Employment Status Descriptors:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01ProbationaryProbationary
02ContractualContractual
03Substitute/temporarySubstitute/temporary
04Tenured or permanentTenured or permanent
05Volunteer/no contractVolunteer/no contract
06Employed or affiliated with outside organizationEmployed or affiliated with outside organization
07Non-contractualNon-contractual
08Employed part-timeEmployed part-time
09Employed or affiliated with outside agency part-timeEmployed or affiliated with outside agency part-time
10OtherOther


 


Staff

This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a person has a District Employment record or a District Assignment record in the configured year and they have an Ed-Fi ID.

Do NOT report a record when the following scenario is true: 

  • There is no Ed-FI ID for the staff person. 
  • The staff records are not active based on the Scope Year logic listed below
  • If the record is being triggered from a District Assignment record and it is marked as Exclude
  • If the record is being triggered from a District Assignment record and the School is marked as Exclude
  • If data is sent prior to the Exclude checkboxes are checked, the data will remain and the user will need to use the Delete Tool to remove data.
Put

When any data is edited for the person in the Data Elements fields below.

  • When the person’s identity record is changed (identificationCodes, repRaceOrders).
  • When the person’s employment assignment record is changed.
  • When the person’s employment record is changed.
  • When one of the person’s section staff history records is changed.
  • When one of the person’s employment credentials is changed.
DeleteStaff records are a shared resource among all districts, this record will not delete.


Scope Year Logic

This table describes scope year logic of this object.

Logic

A record will report when a person has a District Assignment record that is aligned to a scoped year.

Report when a staff has an active District Assignment record that overlaps with the School year Start and End Dates.

  • If School Year Start Date is NULL, 7/1/xxxx will be the default start date used.
  • If School Year End Date is NULL, 6/30/xxxx will be the default end date used.

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

When using data in Campus that has an effective date, the following logic will be applied to determine the scope year(s) to report the data to.

  • Current Year:  Records will be compared to today's date to determine if the record is eligible to report.
  • Previous Years:  The record's date must be on or before the schools year's end date defined in the School Years editor.  If blank, the default date of 6/30/xxxx is used.
  • Future Years:  The record's date must be on or after the schools year's start date defined in the School Years editor.  If blank, the default date of 7/01/xxxx is used.

When using data in Campus that has start and end dates, the following logic will be applied to determine the scope year(s) to report the data to.

  • Current Year: The records start date must be on or before today's date and the records end date must be on or after today's date.
  • Previous Years: The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor.  If blank, the default date of 6/30/xxxx is used.
  • Future Years: The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor.  If blank, the default date of 7/01/xxxx is use.


Object Data Elements

This table describes data elements sent within the Staff resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
staffUniqueIdA unique alpha-numeric code assigned to a staff. The staff member's Ed-Fi ID is reported.MCensus.edFiIdCensus > People > Demographics > EdFi ID
personalTitlePrefix

A prefix used to denote the title, degree, position or seniority of the person. 

This element is currently not reported or collected.


CN/AN/A
firstNameThe staff member's legal first name. The first name from the person's current identity record is reported.MIdentity.firstNameCensus > People > Identities > First Name
middleNameThe staff member's legal middle name. The middle name from the person's current identity record is reported.CIdentity.
middleName
Census > People > Identities > Middle Name
lastSurnameThe staff member's legal last name. The last name from the person's current identity record is reported.MIdentity.lastNameCensus > People > Identities > Last Name
generationCodeSuffixAn appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III). The suffix form the person's current identity record is reported.CIdentity.suffixCensus > People > Identities > Suffix
maidenName

The person''s maiden name, if applicable.

This element is currently not reported or collected.


ON/A N/A 
sexTypeThe person's gender.MIdentity.genderCensus > People > Identities > Gender
birthDateThe month, day, and year on which an individual was born. The Birth Date from the person's current identity record is reported.MIdentity.birthDateCensus > People > Identities > Birth Date
hispanicLatinoEthnicity

An indication that the individual traces his or her origin or descent to Mexico, Puerto Rico, Cuba, Central and South America, and other Spanish cultures, regardless of race. 

Report from "Is the individual Hispanic/Latino?" from the person's current identity:

  1. If droplist is = Yes, report "true"
  2. If droplist is = No or NULL, report "false"
MIdentity.
hispanicEthnicity
Census > People > Identities > Date Entered US
oldEthnicityType

Previous definition of Ethnicity combining Hispanic/latino and race 1 - American Indian or Alaskan Native 2 - Asian or Pacific Islander 3 - Black, not of Hispanic origin 4 - Hispanic 5 - White, not of Hispanic origin. 

This element is optional and is not reported.


OIdentity.
raceEthnicityFed
Historical data in Campus database
highestCompletedLevel
OfEducationDescriptor

The highest level of completed for a staff member. The Education value from the person's Credentials tab is reported. 

  1. Report the Ed-Fi Code value from from the person's Credentials tab when the Credential Type is = ED:  Education.
  2. If there is not a valid credential, report the Ed-Fi Code Value from Education droplist on the person's District Employment record. 
  3. If there is no Education record or the Ed-Fi code value is NULL, do not report.

Scope Year logic is used to determine the Scope Year to post or update.

See the Level of Education Descriptors table in the section below for the Ed-Fi value that is reported.

ON/A

Census > People > Credentials

Census > People > District Employment

yearsOfPrior
ProfessionalExperience

The total number of years that an individual has previously held a similar professional position in one or more education institutions. 

This element is currently not reported or collected.


ON/AN/A
yearsOfPrior
TeachingExperience

The total number of years that an individual has previously held a teaching position in one or more education institutions. 

This element is currently not reported or collected.


ON/AN/A
highlyQualifiedTeacher

An indication of whether a teacher is classified as highly qualified for his/her assignment according to state definition. This attribute indicates the teacher is highly qualified for ALL sections being taught.

This element reports True when the person has a Credential Type = HQ: Highly Qualified.

  • Start date must be on or before today's date
  • End date must be NULL, or on or after today's date 

This element reports False when the person is a teacher on any active course section and does not have an HQ: Highly Qualified Credential.

If person is not a teacher, do not report a record.

Scope Year logic is used to determine the Scope Year to post or update.

ON/ACensus > People > Credentials
loginId

The login ID for the user; used for security access control interface.

This element is currently not reported or collected.


ON/A N/A 
citizenshipStatusType

 A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

This element is currently not reported or collected.


ON/A N/A 
addresses

 Report the person's address(es). 

This element is optional and is not reported.


ON/AN/A
credentials

 An unordered collection of staffCredentials. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion.

This element is optional and is not reported.


ON/AN/A
electronicMails

An unordered collection of staffElectronicMails. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion. 

See the Electronic Mail table in the section below for the Ed-Fi value that is reported. This element is an array which also reports the following data:

OContact.email

Census > People > Demographics > Email

Census> People> Demographics> Secondary Email

electronicMailTypeThis element reports the Electric Mail mapping. The Email (primary) address reports as 'Work'. The Secondary Email address reports as 'Home/Personal'.MN/AN/A
electronicMailAddressThe numbers, letters, and symbols used to identify an electronic mail (e-mail) user within the network to which the individual or organization belongs.MContact.email

Census > People > Demographics > Email

Census> People> Demographics> Secondary Email

primaryEmail
AddressIndicator
An indication that the electronic mail address should be used as the principal electronic mail address for an individual or organization.ON/AN/A
identificationCodes

An unordered collection of staffIdentificationCodes. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion.

ON/ACensus > People >Demographics > State Staff ID

and/or

Census > People > District Employment > License

or

Credentials > License Number

Staff Identification System TypeReports District when reporting the local stff number; reports State when reporting the staff state ID.M

Person.stateID

Person.staffNumber

Census > People > Demographics > State Staff ID/Local Staff ID, Staff State ID
Assigning Organization Identification Code

The organization code or name assigning the Staff Identification Code.

This does not report.

ON/AN/A
Identification Code

A unique number or alphanumeric code assigned to a staff member by a school, school system, a state, or other agency or entity. Reporting Logic is as follows:

  1. Report the Local  Staff Number if populated.
  2. Reports the Staff State ID if populated.
M

Person.stateID


Person.staffNumber
Census > People > Demographics > State Staff ID/Local Staff ID, Staff State ID
identificationDocuments

An unordered collection of staffIdentificationDocuments. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion.

This element is currently not reported or collected.


ON/A N/A 
internationalAddresses

An unordered collection of staffInternationalAddresses. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion.

This element is currently not reported or collected.


ON/AN/A 
languages

An unordered collection of staffLanguages. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion.

This element is currently not reported or collected.


ON/AN/A
otherNames

 An unordered collection of staffOtherNames. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion.

This element is currently not reported or collected.


ON/AN/A 
races

An unordered collection of staffRaces. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion. 

This element looks at the Race Ethnicity checkboxe(s) marked on the person's Identity record. See the Race Type table in the section below for the Ed-Fi value that is reported.

This element is also an array which reports the following data:

O

Identity.
raceEthnicity

and

RaceEthnicity.
raceid

Census > People > Identities > Race/Ethnicity
raceType

The general racial category which most clearly reflects the individual's recognition of his or her community or with which the individual most identifies.

This element reports the short description mapped based on the Race Type table in the section below.

Identity.
raceEthnicity

and

RaceEthnicity.
raceid

 Census > People > Identities > Race/Ethnicity
telephones

An unordered collection of staffTelephones. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion.

This element reports the phone numbers entered in the person's Personal Contact Information editor. See the Telephone Number table in the section below for the Ed-Fi value that is reported.

This element is an array which reports the following additional data:

O

Contact.homephone

Contact.workphone

Contact.cellphone

Contact.pager

Census > People > Demographics > Personal Contact Information > Other Phone, Work Phone, Cell Phone, Pager

telephoneNumberTypeThis element reports the short description mapped in the Telephone Number Type table listed in the section below.MN/AN/A
orderOfPriorityThe order of priority assigned to telephone numbers to define which number to attempt first, second, etc.ON/AN/A
textMessage
CapabilityIndicator
An indication that the telephone number is technically capable of sending and receiving Short Message Service (SMS) text messages.ON/AN/A
telephoneNumberThe 10-digit telephone number, including the area code, for the person. This element reports the phone numbers entered in the person's Personal Contact Information editor.M

Contact.homephone

Contact.workphone

Contact.cellphone

Contact.pager

Census > People > Demographics > Personal Contact Information > Other Phone, Work Phone, Cell Phone, Pager
visas

An unordered collection of staffVisas. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion.

This element is currently not reported or collected.


ON/AN/A
repRaceOrdersAn unordered collection of staffREPRaceOrders. This element is an array which reports the following additional data:ON/AN/A
raceOrderChoice DescriptorAlways reports a value of 1.MN/AN/A
raceType

The general racial category which most clearly reflects the individual's recognition of his or her community or with which the individual most identifies.

Report the short description from the Race Type page linked under the Type/Descriptor section below based on the mapping provided.

M

Identity.raceEthnicity

RaceEthnicity.raceID

Census> People> Identities> Race/Ethnicity


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Level of Education Descriptors:

Ed-Fi CodeEd-Fi Short DescriptionEd-Fi Description

00

None

None

01

High School Diploma or its equivalent

High School Diploma or its equivalent

02

Associate Degree

Associate Degree

03

Bachelor's Degree

Bachelor's Degree

04

Master's Degree

Master's Degree

05

Specialist's Degree

Specialist's Degree

06

Doctoral Degree

Doctoral Degree

07

Juris Doctorate

Juris Doctorate

08

Medical Degree

Medical Degree

09

Other License, Credential or Professional Degree

Other License, Credential or Professional Degree

10

Paraprof on St Academic Assessment; Completion Wrk Keys Assessment

Paraprof on St Academic Assessment; Completion Wrk Keys Assessment




Staff School Association

This association indicates the school(s) to which a teacher provides instructional services.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a District Assignment record is created or changed and saved for a staff member.

Do NOT report a record if any one of the following scenarios are true:

  • There is not an Ed-FI ID for the staff person.
  • The District Assignment records are not active based on the Scope Year logic listed below.
  • If the record is being triggered from a District Assignment record and it is marked as Exclude.

  • If the record is being triggered from a District Assignment record and the School is marked as Exclude.

  • If data is sent prior to the Exclude checkboxes are checked, the data will remain and the user will need to use the Delete Tool to remove data.
PutN/A, a delete and insert occurs when any field is edited and saved. 
Delete/InsertWhen the person’s employment assignment record is changed.
DeleteWhen a District Assignment record is deleted.


Scope Year Logic

This table describes scope year logic of this object.

Logic

A record will report when a person has a District Assignment or District Employment record that is aligned to a scoped year.

  • Report when a staff has an active District Assignment or District Employment record that overlaps with the School year Start and End Dates
    • If School Year Start Date is NULL, 7/1/xxxx will be the default start date used
    • If School Year End Date is NULL, 6/30/xxxx will be the default end date used
Data will only send for the years that have valid configuration


Object Data Elements

This table describes data elements sent within the Staff School Association resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resourceMN/A N/A 
schoolReference

Reports data from the SchoolID field that is part of the natural key for the Schools resource. The following elements are reported:

  • schoolID
MN/A N/A 
staffReference

Reports data from the SchoolID field that is part of the natural key for the Staff resource. The following elements are reported:

  • staffUniqueId
MN/A N/A 
programAssignment
Descriptor

The name of the program for which the individual is assigned; for example: Regular education Title I-Academic Title I-Non-Academic Special Education Bilingual/English as a Second Language .A value of 03 reports.

See the Program Assignment Descriptors table in the Type/Descriptor section below.

N/A N/A 
schoolYearThe reporting school year.ON/A N/A 
academicSubjectsAn unordered collection of staffSchoolAssociationAcademicSubjects. This association indicates the school(s) to which a teacher provides instructional services.N/A N/A 
gradeLevels An unordered collection of staffSchoolAssociationGradeLevels. This association indicates the school(s) to which a teacher provides instructional services.N/A N/A 
_etag A unique system-generated value that identifies the version of the resourceN/A N/A 


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Program Assignment Descriptors:

Ed-Fi CodeEd-Fi Short Description Ed-Fi Description
01Bilingual/English as a Second LanguageBilingual/English as a Second Language
02OtherOther
03Regular EducationRegular Education
04Special EducationSpecial Education
05Title I-AcademicTitle I-Academic
06Title I-Non-AcademicTitle I-Non-Academic


 


Staff Section Association

This association indicates the course sections to which a staff person is assigned.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a staff person is added to a course section on Staff History.

  • Must have a Staff Type of P: Primary Teacher in the Section Staff History table or have a Staff Type of T: Teacher in the Section Staff History table with a Role of NOT NULL.
  • Do not send records if the Calendar Exclude checkbox is checked.
  • Do not send a record if the Course is marked Inactive or Exclude.
  • Must have a role mapped to an Ed-Fi code populated to report.
  • Do not report a record if the Staff does not have an Ed-Fi ID.
  • Do not report if the course is in a school marked as exclude.
PostWhen a Role mapped to an Ed-Fi code is added to an existing teacher on the Staff History Record.
Put

When Start or End dates are modified on the Staff History.

If the start or end dates are modified on the District Assignment record, an  update will not occur. 

A resync must be completed to have all the records updated.

Delete

When a staff member is deleted from Staff History.

DeleteWhen a Role is removed from a Teacher on Staff History.


Scope Year Logic

This table describes scope year logic of this object.

Logic

Reports for Sections in the scope year the course's calendar is aligned to.

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

Future Years data will be suppressed until the Active Year is changed. This allows the Schedule Wizard to be used and reduces the number of records sent until the final schedule is completed.

A resync must be done after the Active Year is changed to send data.


Object Data Elements

This table describes data elements sent within the Staff Section Association resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
section
Reference

A reference to the related Section resource.

Reports:

  • Class Period
  • Course Offering
  • Location
  • School
  • Unique Section Code
  • Sequence of Course
MN/AN/A
staffReference

A reference to the related Staff resource.

Reports the Staff Unique ID.

MN/AN/A
classroomPosition Descriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

  • If any staff Role = MT, report ‘05’.
  • If Primary teacher is reported and Role = NULL or SR, report ’01’.
  • If staff from teachers has a Role = SR, report ‘02’.
MsectionStaffhistory.roleScheduling > Courses > Section > Staff History > Role
beginDate

Month, day and year of a teacher''s assignment to the section. If blank, defaults to the first day of the first grading period for the section. 

Report the Staff History Start date if populated.

If not populated, look at the District Assignment record for the teacher for that School and report Assignment Start Date if it is on or after the lowest Term Start Date and on or before the highest Term End Date for that section.

If the District Assignment Start Date is Prior to the lowest Term Start Date, report the lowest Term Start Date for that section.

M

sectionstaffhistory.startdate

employmentassignment.startdate

term.startdate

Scheduling > Courses > Course > Section > Staff History> Start Date

Census > People > District Assignment > Start Date

System Administration > Calendar > Calendar > Terms

endDate

Month, day and year of the last day of a teacher's assignment to the section. NEDM: Ending Date. 

Reports the Staff History End Date if populated.

If not populated, look at the District Assignment record for the teacher for that School and report Assignment End Date if it is on or after the lowest Term Start Date and on or before the highest Term End Date for that section.

Otherwise, reports the Term End Date for that section.

O

sectionstaffhistory.enddate

employmentassignment.enddate

Scheduling > Courses > Course > Section > Staff History > End Date

Census > Peopl e> District Assignment > End Date

highlyQulaifiedTeacher

An indication of whether a teacher is classified as highly qualified for his/her assignment according to state definition. This attribute indicates the teacher is highly qualified for this section being taught.

This is optional and does not report.

ON/AN/A
teacherStudent DataLinkExclusion

Indicates that the student-section combination is excluded from calculation of value-added or growth attribution calculations used for a particular teacher evaluation.

This is optional and does not report.

ON/AN/A
percentageContribution

The percentage of time the teacher is responsible for the student.

This is optional and does not report.

ON/AN/A
_etag

A unique system-generated value that identifies the version of the resource. 

This is optional and does not report.

ON/AN/A


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Classroom Position Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01Teacher of RecordTeacher of Record
02Assistant TeacherAssistant Teacher
03Support TeacherSupport Teacher
04Substitute TeacherSubstitute Teacher
05MentorMentor




Student Academic Record

This educational entity represents the cumulative record of academic achievement for a student.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

Report a StudentAcademicRecord instance for each school year in which the student has a transcript record and they have a Student School Association record for the scoped year.

  • When the Term Type cannot be determined on a Transcript record, provide an error with the following message, "Ed-Fi Transcript Term Override field must not be null."
  • A post action is done to update the Cumulative Earned Credits field when the Earned Credit field is updated or a new transcript record is added added/deleted with a Earned Credit Value that is not null and is greater than 0.
Post/Put

When a student is given a Diploma Date and Diploma Type:

  • Only post for the records in the Scope Year the Diploma Date is associated.
  • If the student already has SAR records from posted Transcript records, update existing records with the Diploma information
    • If all of the student's transcript records are deleted, a new SAR will post from the Diploma Record
  • If the student does not have any SAR records from posted Transcript records, create 1 record with the Term Descriptor that is aligned to the Term that the Diploma Date occurs in
    • If the Diploma date and/or Diploma Type fields are made NULL, the SAR record will delete
DeleteIf records are posted from course transcript records and no Diploma information exits, all Student Academic Records will only delete when a student has only 1 Student School Association record for a specific Year and all Student School Association records are deleted
Delete/Post
  • If the natural key is changed.
  • If a term descriptor mapping changed either in the Sessions Preferences or the Ed-Fi Transcript Term Override.
  • If the Actual Term is changed on a Course Transcript Record and the Ed-Fi Transcript Term Override field is NULL.
  • If the Ed-Fi Transcript Term Descriptor Override mapping is changed.


Scope Year Logic

This table describes scope year logic of this object.

Logic

Records will send to each scope year in which the Course Transcript record is posted.

Records will only post to the SAR records for the year the diploma date occurs in but SAR records will post to all scoped years.

  • The Diploma Date must be on or after the school year's start date and on or before the school year's end date defined in the School Years editor.  If blank, the default start date of 7/1/xxxx and end date of 6/30/xxxx are used.
Data will only send for the years that have valid configuration.


Object Data Elements

This table describes data elements sent within the Student Academic Record resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
educationOrganization
Reference

A reference to the related EducationOrganization resource.

Reports the District Number

MN/AN/A
schoolYearTypeReference

A reference to the related SchoolYearType resource.

Reports the end year for the transcript record being reported. Reports the end year the Diploma Date is aligned to

MN/AN/A
studentReference

Reports the fields that are part of the Natural Key for the Student resource

  • studentUniqueId
MN/AN/A
termDescriptor

The term for the session during the school year. See the Term Descriptor table in the Type/Descriptor section below.

  1. Report the Ed-Fi code for the value selected in "Ed-Fi Transcript Term Override" field on the transcript.
    1. If NULL, report the Term Descriptor based on the Course Term Type Override, else Section Term Type Override.  
  2. When the Ed-Fi Transcript Term Override and both the Course Term and the Section Term Override fields are Null, report the Term Descriptor for the term aligned to the Grading Score for the posted Grade.
  3. Else, report the Ed-Fi Code from the Ed-Fi Transcript Term Descriptor Override in the SAR preferences.
  4. If an Term cannot be determined, provide error.
  5. When the SAR is posted only from the Graduation Record because there are no Course Transcripts records for the student, report the Ed-Fi Term Descriptor from the Sessions Resource Preferences that the Diploma Date falls in.   
    1. If the Diploma Date is outside of any of the Term Dates for that School Year, report the Ed-Fi Term Descriptor from the Term with the latest End Date
    2. If the Diploma Date is aligned to more than 1 Term Descriptor, report the value from the highest TermId
MN/AN/A
cumulativeEarnedCreditType

Key for Credit.

This is optional and does not report.

ON/AN/A
cumulativeEarnedCredit
Conversion

Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.

This is optional and does not report.

ON/AN/A
cumulativeEarnedCredits

The cumulative number of credits an individual earns by completing courses or examinations during his or her enrollment in the current school as well as those credits transferred from schools in which the individual had been previously enrolled.

  1. Sum the total number of credits the student has earned based on the total number of Credits Earned the student has in the Transcript Credit table.
    1. Report '0' if the student does not have any Credits Earned
  2. This value will be the same for all Student Academic Records that are being updated, regardless of Term Type or Year.
  3. If the student does not have any Course Transcript records and is only reporting from Graduation, this field will be NULL
OCalculated value from the earned credit field in the transcriptcredit tableStudent Information > General > Transcripts
cumulativeAttemptedCreditType

Key for Credit

This is optional and does not report.

ON/AN/A
cumulativeAttempted
CreditConversion

Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.

This is optional and does not report.

ON/AN/A
cumulativeAttemptedCredits

The cumulative number of credits an individual earns by completing courses or examinations during his or her enrollment in the current school as well as those credits transferred from schools in which the individual had been previously enrolled.

  1. Logic reports the Sm total number of credits the student has attempted based on the total number of Credits Attempted the student has in the Transcript Credit table.
  2. Report '0' if the student does not have any Attempted Credits Earned
    1. This value will be the same for all Student Academic Records that are being updated, regardless of Term Type or Year.
  3. If the student does not have any Course Transcript records and is only reporting from Graduation, this field will be NULL
ON/AN/A
cumulativeGradePointsEarned

The cumulative number of grade points an individual earns by successfully completing courses or examinations during his or her enrollment in the current school as well as those transferred from schools in which the individual had been previously enrolled.

This is optional and does not report.

ON/AN/A
cumulativeGradePointAverage

A measure of average performance in all courses taken by an individual during his or her school career as determined for record-keeping purposes. This is obtained by dividing the total grade points received by the total number of credits attempted. This usually includes grade points received and credits attempted in his or her current school as well as those transferred from schools in which the individual was previously enrolled.

This is optional and does not report.

ON/AN/A
gradeValueQualifier

The scale of equivalents, if applicable, for grades awarded as indicators of performance in schoolwork. For example, numerical equivalents for letter grades used in determining a student's Grade Point Average (A=4, B=3, C=2, D=1 in a four-point system) or letter equivalents for percentage grades (90-100%=A, 80-90%=B, etc.).

This is optional and does not report.

ON/AN/A
projectedGraduationDate

The month and year the student is projected to graduate.

This is optional and does not report.

ON/AN/A
sessionEarnedCreditType

Key for Credit

This is optional and does not report.

ON/AN/A
sessionEarnedCreditConversion

Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.

This is optional and does not report.

ON/AN/A
sessionEarnedCredit

The number of an credits an individual earned in this session.

This is optional and does not report.

ON/AN/A
sessionAttemptedCreditType

Key for Credit.

This is optional and does not report.

ON/AN/A
sessionAttempted
CreditConversion

Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units

This is optional and does not report.

ON/AN/A
sessionAttemptedCredit

The number of an credits an individual attempted to earn in this session

This is optional and does not report.

ON/AN/A
sessionGradePointsEarned

The number of grade points an individual earned for this session

This is optional and does not report.

ON/AN/A
sessionGradePointAverage

The grade point average for an individual computed as the grade points earned during the session divided by the number of credits attempted

This is optional and does not report.

ON/AN/A
classRanking

This educational entity represents the cumulative record of academic achievement for a student

This is optional and does not report.

ON/AN/A
academicHonors

An unordered collection of studentAcademicRecordAcademicHonors. This educational entity represents the cumulative record of academic achievement for a student

This is optional and does not report.

ON/AN/A
diplomas

An unordered collection of studentAcademicRecordDiplomas. This educational entity represents the cumulative record of academic achievement for a student.

ON/AN/A
Diploma TypeThe type of diploma/credential that is awarded to a student in recognition of his/her completion of the curricular requirements.MN/AN/A
Diploma DateThe month, day, and year on which the student met graduation requirements and was awarded a diploma. Reports the Diploma DateMN/AN/A
achievementCategory
Descriptor

This descriptor defines the category of achievement attributed to the learner.

  1. Report '6' for Diploma Earned when Diploma Type is =
    1. 01: Grad from gen ed, diploma
    2. 02: Grad from gen ed, diploma, applied to college
    3. 03: Grad from alternate program
    4. 04: Grad from gen ed, diploma, applied to non-degree
  2. Report '5' for Certificate Earned when Diploma Type is =
    1. 05: Completed gen ed, equivalency certificate
    2. 06: Completed gen ed, other certificate
    3. 20: Received Special Ed certificate, exited
MStudent Information > General > Graduation > Diploma TypeGraduation.
diplomaType
recognitions

An unordered collection of studentAcademicRecordRecognitions. This educational entity represents the cumulative record of academic achievement for a student

This is optional and does not report.

ON/AN/A
reportCards

An unordered collection of studentAcademicRecordReportCards. This educational entity represents the cumulative record of academic achievement for a student

This is optional and does not report.

ON/AN/A
_etag

A unique system-generated value that identifies the version of the resource. 

This is optional and does not report.

ON/AN/A


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Term Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
Fall SemesterFall SemesterFall Semester
Spring SemesterSpring SemesterSpring Semester
Summer SemesterSummer SemesterSummer Semester
First QuarterFirst QuarterFirst Quarter
Second QuarterSecond QuarterSecond Quarter
Third QuarterThird QuarterThird Quarter
Fourth QuarterFourth QuarterFourth Quarter
First TrimesterFirst TrimesterFirst Trimester
Second TrimesterSecond TrimesterSecond Trimester
Third TrimesterThird TrimesterThird Trimester
MiniTermMiniTermMiniTerm
OtherOtherOther
Full YearFull YearFull Year
ContinuousContinuousContinuous




Student Assessment

 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

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

Early Childhood Special Education Assessment

When a student in the year and calendar reporting has the following:

  • A locked OMP - Child Outcomes Review (Print Format: 'miOMP')
  • Locked document has Type = Early Childhood
  • EC Assessment Tool = NOT NULL

OMP test date must overlap an enrollment.

If the student has multiple enrollments that are overlapping in the same school and year, report based on Service Type:

  1. P: Primary
  2. S: Partial
  3. N: Special Ed

If the student only has one enrollment, report a record regardless of Service Type.

Do not send a student record for an enrollment that is marked as State Exclude or No Show.

Do not send a record if an enrollment is in a calendar marked as Exclude.

Do not send a record if an enrollment is in a School marked as Exclude.

PostWhen a new enrollment is created for a student that has an active OMP.
Post

Part C Assessment

When a student in the year and calendar reporting has the following:

  • A locked OMP - Child Outcomes Review (Print Format: 'miOMP')
  • Locked document has Type = Part C
  • Part C Data Source = NOT NULL

OMP must overlap an enrollment.

If the student has multiple enrollments that are overlapping in the same school and year, report based on Service Type:

  1. P: Primary
  2. S: Partial
  3. N: Special Ed

If the student only has one enrollment, report a record regardless of Service Type.

Do not send a student record for an enrollment that is marked as State Exclude or No Show.

Do not send a record if enrollment is in a calendar marked as Exclude.

Do not send a record if an enrollment is in a School marked as Exclude.

PostWhen a new enrollment is created for a student that has an active OMP.
Delete/Post

When any part of the natural key is changed.

When the test Date is changed in an existing OMP, and is re-locked.

If a student has 2 miOMP plans with the same assessmentTitle and administrationDate in Ed-Fi (which in Campus is the SEPOutcomeMeasures referredDate).

Put

When any field that is not part of the natural key is changed, including the following:

  • assessmentReasonDescriptor
  • parentConferenceMethodDescriptor
  • parentConferenceDate
  • studentAssessmentActionAssessmentOutcome
  • studentAssessmentKnowledgeSkillAssessmentOutcome
  • studentAssessmentSocialRelationshipAssessmentOutcome
DeleteOMP is deleted for a student
DeleteA test Date is changed for the assessment.
DeleteAll overlapping enrollments are deleted for a school
DeleteWhen an OMP is unlocked it will delete


Scope Year Logic

This table describes scope year logic of this object.

Logic

Record will report for students where an OMP test record exists within the scope year.

  • Test Date must occur within the Scope Year.
  • If School Year Start Date is NULL, 7/1/xxxx will be the default start date used.
  • If School Year End Date is NULL, 6/30/xxxx will be the default end date used.


Object Data Elements

This table describes data elements sent within the Student Assessment resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.M N/AN/A
assessmentReference

Reports data from the fields that are part of the natural key for the Assessment resource.

MN/AN/A
studentReferenceThe title or name of the assessment. NEDM: Assessment Title. Reports data from the fields that are part of the natural key for the Studentresource. MN/AN/A
administrationDate

The month(s), day(s), and year on which an assessment is administered or first day of administration if over multiple days.

Reports the test date of the Early Childhood Special Education Assessment or Part C Assessment.

MSEPOutcomeMeasures. referredDateStudent Information > Special Education > Documents > OMP > Child Outcomes Review > Date
administrationEndDate

Assessment Administration End Date, if administered over multiple days.

This field is optional and does not report.


ON/AN/A
serialNumber

The unique number for the assessment form or answer document.

This field is optional and does not report.


ON/AN/A
administrationLanguageDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

This field is optional and does not report.


ON/AN/A
administrationEnvironmentType

The environment in which the test was administered. For example: Electronic Classroom Testing Center.

This field is optional and does not report.


ON/AN/A
retestIndicatorType

Indicator if the test was retaken. For example: Primary administration First retest Second retest.

This field is optional and does not report.


ON/AN/A
reasonNotTestedType

The primary reason student is not tested. For example: Absent Refusal by parent Refusal by student Medical waiver Illness Disruptive behavior EL Exempt.

This field is optional and does not report.


ON/AN/A
whenAssessedGrade LevelDescriptor

The grade level of a student when assessed.

This field is optional and does not report.


ON/AN/A
eventCircumstanceType

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

This field is optional and does not report.


ON/AN/A
eventDescription

Describes special events that occur before during or after the assessment session that may impact use of results.

This field is optional and does not report.


ON/AN/A
assessmentReason Descriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

Reports the following based on the checkbox checked at the top of the Outcomes Review editor:

  • If Entry = selected, report 01.
  • If Annual = selected, report 02.
  • If Exit = selected, report 03.
OSEPOutcomeMeasures. outcomeTypeStudent Information > Special Education > Documents > OMP > Child Outcomes Review > Entry, Annual, Exit
invalidReason CodeDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

This field is optional and does not report.


ON/AN/A
parentConference MethodDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

  • Early Childhood Special Education Assessment - does not report.
  • Part C Assessment - Report Ed-Fi Code value of Parent Input.
OSEPlan.parentInputStudent Information > Special Education > Documents > OMP
attemptedness

Identifies whether the student attempted the assessment and answered enough questions to calculate an overall scale score.

This field is optional and does not report.


ON/AN/A
barcode

Student's barcode number providing detailed information regarding the student and the assessment.

This field is optional and does not report.


ON/AN/A
misadministration

Identifies whether there was a misadministration of the assessment to the student. Misadministration of an assessment includes.

This field is optional and does not report.


ON/AN/A
nonstandard Accommodation

 Identifies whether a student received accommodations that do not qualify as standard accommodations. 

This field is optional and does not report.


ON/AN/A
online

Identifies whether the assessment was administered in an online testing environment.

This field is optional and does not report.


ON/AN/A
outOfLevel

Identifies whether student tested in an incorrect grade.

This field is optional and does not report.


ON/AN/A
parentConferenceDate

Date the parent conference occurred.

  • Early Childhood Special Education Assessment - does not report. 
  • Part C Assessment - Reports Parent Input Date.
OSEPlan.parent InputdateStudent Information > Special Education > Documents > OMP
prohibitedBaehavior

Identifies whether the student was involved in prohibited behavior while the assessment was being administered.

This field is optional and does not report.


ON/AN/A
standardAccommodation

 Identifies whether a student received a standard accommodation while the assessment was administered. Standard accommodations are listed and includes: Braille, Text-to-speech passage, Read-aloud, Enlarged Print.

This field is optional and does not report.


ON/AN/A
valid

 Identifies whether the student received a valid test score for the assessment.

This field is optional and does not report.


ON/AN/A
actionAssessment Outcome

The child's assessment rating on the ability to take appropriate actions to meet his/her needs.

Reports from 3. Child takes appropriate actions to meet his/her needs.

This field reports as an object.

ON/AN/A
actionAssessmentOutcome LevelDescriptor

This descriptor holds the rating of the child's Part C Assessment outcome.

Reports the Ed-Fi Code value from 3. Child takes appropriate action to meet his/her needs.

MSEPOutcomeMeasures.behaviorScoreStudent Information > Special Education > Documents > OMP > Child Outcomes Review > 3. Child takes appropriate action to meet hiis/her needs
newAction AssessmentOutcome

When reporting an annual or exit assessment, providers must indicate if the child has shown any new skill or behaviors related to taking action to meet his/her needs.

EXIT AND ANNUAL TEST ONLY

  • If Exit or Annual checkbox = selected
  • Report Progress from question 3. Child takes appropriate action to meet his/her needs. Note: Do not report this field if Entry assessment information is being reported.
    • If Yes, report true.
    • If No, report false.
OSEPOutcomeMeasures.behaviorCheckStudent Information > Special Education > Documents > OMP > Child Outcomes Review > 3. Child takes appropriate action to meet hiis/her needs. > Progress Made
knowledgeSkill AssessmentOutcome

The child's assessment rating for acquisition and use of knowledge and skills. 

Reports from 2. Child acquires and uses knowledge and skills.

This field reports as an object.

ON/AN/A
knowledgeSkillAssessment OutcomeLevelDescriptor

This descriptor holds the rating of the child's Part C Assessment outcome.

Report Ed-Fi code from 2. Child acquires and uses knowledge and skills.

M

SEPOutcomeMeasures.skillsScore

Student Information > Special Education > Documents > OMP > Child Outcomes Review >  2. Child acquires and uses knowledge and skills
newKnowledgeSkill AssessmentOutcome

When reporting an annual or exit assessment, providers must indicate if the child has shown any new skill or behaviors related to taking action to meet his/her needs.

EXIT AND ANNUAL TEST ONLY

  • If Exit or Annual checkbox = selected
  • Report Progress from question 2. Child acquires and uses knowledge and skills. Note: Do not report this field if Entry assessment information is being reported.
    • If Yes, report true.
    • If No, report false.
OSEPOutcomeMeasures.skillsCheckStudent Information > Special Education > Documents > OMP > Child Outcomes Review >  2. Child acquires and uses knowledge and skills. > Progress Made
socialRelationship AssessmentOutcome

The child's assessment rating for positive social relationships.

Reports from 1. Child has positive social relationships.

This field reports as an object.

ON/AN/A
socialRelationship AssessmentOutcome LevelDescriptor

This descriptor holds the rating of the child's Part C Assessment outcome.

Reports from 1. Child has positive social relationships.

MSEPOutcomeMeasures.socialScoreStudent Information > Special Education > Documents > OMP > Child Outcomes  Review > 1. Child has positive social relationships.
newSocialRelationship AssessmentOutcome

When reporting an annual or exit assessment, providers must indicate if the child has shown any new skill or behaviors related to taking action to meet his/her needs.

EXIT AND ANNUAL TEST ONLY

  • If Exit or Annual checkbox = selected.
  • Report Progress from question 1. Child has positive social relationships. Note: Do not report this field if Entry assessment information is being reported.
    • If Yes, report true
    • If No, report false
OSEPOutcomeMeasures.socialCheckStudent Information > Special Education > Documents > OMP > Child Outcomes Review > 1. Child has positive social relationships > Progress Made
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).

This field is optional and does not report.


ON/AN/A
essays

An unordered collection of studentAssessmentEssays. (MI EXT) This entity represents the analysis or scoring of a student's response on an assessment essay. The analysis results in a value that represents a student's performance on a set of items on a test. 

This field is optional and does not report.


ON/AN/A
items

An unordered collection of studentAssessmentItems. This entity represents the student's response to an assessment item and the item-level scores such as correct, incorrect, or met standard.

This field is optional and does not report.


ON/AN/A
performanceLevels

An unordered collection of studentAssessmentPerformanceLevels. Indicates the various levels or thresholds for the performance achieved by the student on the assessment.

This field is optional and does not report.


ON/AN/A
scoreResults

An unordered collection of studentAssessmentScoreResults. 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.

This field is optional and does not report.


ON/AN/A
studentObjectiveAssessments

An unordered collection of studentAssessmentStudentObjectiveAssessments. This entity holds the score and or performance levels earned for an objective assessment by a student.

This field is optional and does not report.


ON/AN/A


Type/Descriptors


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Assessment Reason Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
1EntranceEntrance assessment taken when the child enters Part C services
2AnnualAnnual assessment taken while the child is receiving services
3ExitExit assessment taken upon exit from Part C services

This table describes the Ed-Fi Value mapped and reported for Assessment Outcome Level Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
1Not YetChild does not yet show functioning expected of a child his/her age in any situation. Child's skills and behaviors also do not yet include any immediate foundational skills upon which to build age appropriate functioning. Child's functioning might be described as that of a much younger child.
2Between Not Yet and EmergingSome of the foundational skills are there, though not all the immediate foundational skills.
3EmergingChild does not yet show functioning expected of a child his/her age in any situation. Child's behavior and skills include immediate foundational skills upon which to build age appropriate functioning. Functioning might be described as that of a younger child.
4Between Emerging and SomewhatImmediate foundational skills are in place, and child has demonstrated age appropriate skills once or twice, perhaps not deliberately.
5SomewhatChild's functioning is a mix of age appropriate and not appropriate functioning. Functioning might be described as that of a slightly younger child.
6Between Somewhat and CompletelyChild's functioning generally is considered appropriate for his/her age but there are some concerns about his/her functioning in this outcome area.
7CompletelyChild shows functioning expected for his/her age in all or nearly all everyday situations that are part of the child's life. Functioning is considered appropriate for his/her age. No one has any concerns about this child's functioning in this outcome area.

This table describes the Ed-Fi Value mapped and reported for Parent Conference Method Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
AMeeting(s)The parent input about the child outcomes rating was gathered and incorporated into the rating as a result of a conversation during an IFSP meeting, annual review and/or exit meeting.
BCollected separatelyThe parent input about the child outcomes rating was gathered and incorporated into the rating as a result of a conversation that took place outside of an IFSP, annual or exit meeting.
CIncorporated in assessmentThe parent input about the child's development was gathered during the assessment process and subsequently incorporated into the child outcomes rating, but there were no discussions specific to the child outcomes rating.
DNot includedNo parent input was included in determining the child outcomes rating.




Student Discipline Incident Association

This event entity represents an occurrence of an infraction ranging from a minor behavioral problem that disrupts the orderly functioning of a school or classroom (such as tardiness) to a criminal act that results in the involvement of a law enforcement official (such as robbery).

A single event (e.g., a fight) is one incident regardless of how many perpetrators or victims are involved. Discipline incidents are events classified as warranting discipline action.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

Reports a behavior incident when the incident's Status is marked and saved as "Complete"

  • Incident must have at least 1 behavior event associated and a Role that is mapped to an Ed-Fi Value
  • Posting can occur if a new event is added after Incident is marked as "Complete"
  • Do not send if the student's enrollment is marked as No Show or State Exclude
  • Do not send if the student is in a calendar marked as Exclude
  • Do not send if the student's enrollment is in a school marked as Exclude
Put

When a change is made to:

  • behaviors
  • follow ups
Delete/Post

When data that is part of the Natural Key is changed

  • If the Date of Incident is changed and saved
  • If the Event Type is changed and saved
Delete/Post

When the Incident's status is changed

  • Delete when the status is changed from Completed to In Progress
  • Post when the status is changed from In Progress to Completed
DeeteWhen an incident is deleted
Delete

When all non-excluded enrollments in the school and year are deleted


Scope Year Logic

This table describes scope year logic of this object.

Logic

Discipline records will only send to the school year that the incident date is aligned to based on the School Year Start and End dates.

  • If School Year Start Date is NULL, 7/1/xxxx will be the default start date used
  • If School Year End Date is NULL, 6/30/xxxx will be the default end date used

Data will only send for the years that have valid configuration


Object Data Elements

This table describes data elements sent within the Student Discipline Incident Association resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.M N/AN/A
discipline Incident Reference

Reports data from the fields that are part of the natural key for the Discpline Incident resource. The following elements are reported:

  • schoolReference
  • incidentIdentifier
MN/AN/A
studentReference

Reports data from the fields that are part of the natural key for the Student resource. The following elements are reported:

  • studentUniqueId
MN/AN/A
Student Participation Code Type

The role or type of participation of a student in a discipline incident.

Report the Ed-Fi Code value from the Role that is selected for the Student being reported

  • If the student has more that one role with different Ed-Fi Code values, the last one to sync wins
MBehaviorEvent.roleBehavior > Behavior Management > Participant Details > Role
behaviors

An unordered collection of disciplineIncidentBehaviors. This event entity represents an occurrence of an infraction ranging from a minor behavioral problem that disrupts the orderly functioning of a school or classroom (such as tardiness) to a criminal act that results in the involvement of a law enforcement official (such as robbery). A single event (e.g., a fight) is one incident regardless of how many perpetrators or victims are involved. Discipline incidents are events classified as warranting discipline action.

 ON/AN/A
Behavior Descriptor

Reports all behavior events that are associated with the student.

This is optional and does not report.

O

N/A

Behavior > Behavior Management > Event Type
Detailed Description

Specifies a more granular level of detail of a behavior involved in the incident.

This is optional and does not report.

ON/AN/A
followUpsAn unordered collection of studentDisciplineIncidentAssociationFollowUps. The follow-up and/or educational services provided to the student after the discipline incident.ON/AN/A
followUp Descriptor

An unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

  • Report Follow Up from behavior resolution(s).
  • All unique Follow Up codes related to the student should report from the incident resolutions. Resolution must be mapped to an Ed-Fi Code.
ON/AN/A
swisBehaviors


An unordered collection of studentDisciplineIncidentAssociationSwisBehaviors. Describes SWIS behavior by category and provides a detailed description.

ON/AN/A
behaviorDescriptor

The ID of the Behavior Descriptor.

Report all behavior events that are associated with the student

  1. Report the Ed-Fi code value from the mapped behavior event.
  2. If the event is not mapped to a state code or the Ed-Fi Code is blank, report '02'.
MN/ABehavior> Behavior Management> Event Type
orderOfBehaviorReport based on earliest eventID found on incident.
  1. The earliest record ID reports '1'. Second earliest reports '2'. Etc.
O

disciplineIncidentBehaviorSubTypeDescriptor

Discipline Incident Behavior SubTypes.

This is optional and does not report.

O

_etagA unique system-generated value that identifies the version of the resource.ON/AN/A


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Student Participation Code Types:

Campus RoleEd-Fi Short DescriptionEd-Fi Description
VictimVictimVictim
OffenderPerpetratorPerpetrator
Witness

Witness

Reporter

Witness

Reporter

This table describes the Ed-Fi Value mapped and reported for Behavior Descriptors:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description

01

State Offense

State Offense

02

School Violation

School Violation

03

Other

Other

04

School Code of Conduct

School Code of Conduct

06

Abuse Of Volatile Chemical

Abuse Of Volatile Chemical

09

Abuse Of Volatile Chemical

Abuse Of Volatile Chemical

20

Firearm Possession - Handgun

Firearm Possession - Handgun

21

Firearm Possession - Rifle or Shotgun

Firearm Possession - Rifle or Shotgun

22

Firearm Possession - other than Handgun, Rifle or Shotgun

Firearm Possession - other than Handgun, Rifle or Shotgun

23

Other Weapon Possession

Other Weapon Possession

30

Illicit Drug

Illicit Drug

31

Alcohol

Alcohol-related incidents are incidents where students: 

  • Possess or use alcohol on school grounds.  
  • Were under the influence of alcohol on school grounds

44

Bomb or Similar Threat

Bomb or Similar Threat

55

Arson

Arson

56

Other

Other

60

Physical Violence with injury

Physical Violence with injury

61

Physical Violence without injury

Physical Violence without injury



Student Education Organization Association

This association indicates any relationship between a student and an education organization other than however the state views enrollment. Enrollment relationship semantics are covered by Student School Association.

This resource uses both the enrollment table and custom student table. See the Object Data Elements section below on how to determine what values to report from:

  1. The first Resident District value saved for a student will populate the resident district field on the enrollment table.
  2. A record is reported regardless if the Resident District value does not equal the enrolled district.
  3. Any additional resident district values saved for a student populate the custom student table in the Resident District Campus Attribute.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When an enrollment is saved with Resident District field populated and/or Serving District field = NULL.

  • A separate record posts for each unique District Number that is posted in the Resident and Serving District fields.
  • Default values are used if populated on the attributes.
  • Do not send a student record for an enrollment that is marked as State Exclude or No Show.
  • Do not send a record if enrollment is in a calendar marked as State Exclude.
  • Do not send a record if enrollment is in a school marked as Exclude.
Delete/Insert

When an enrollment Serving or Resident District is changed on an existing enrollment.

  • If both Resident and Serving districts have the same District Number and one is changed to a different District Number, the original record should remain and a new record is posted.
  • If both Resident and Serving districts have the same District Number and both are changed to a different District Numbers, the original record(s) will delete and new record(s) are posted.
Post

When an enrollment start date is changed on an existing enrollment.

  • When a student has more than 1 Resident District record, only post for the Resident District Record tied to the enrollment record
  • If a student has more than 1 Resident District record, the end date will need to be populated with an end date
PutWhen the start date for an enrollment is changed.
DeleteWhen an enrollment resident district is changed to NULL on an existing enrollment and a serving district with the same key (District Number) does not exist.
DeleteWhen an enrollment serving district is changed to NULL on an existing enrollment and a resident district with the same key (District Number) does not exist.
DeleteWhen the enrollment is deleted.


Scope Year Logic

This table describes scope year logic of this object.

Logic

The record will send to the scope year for the school year the enrollment is associated with.

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


Object Data Elements

This table describes data elements sent within the Student Education Organization Association resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
educationOrganization
Reference

A reference to the related EducationOrganization resource. 

  • Reports the Resident District if NOT NULL. 
  • Reports the Serving District if NOT NULL.


M

Enrollment.
residentDistrict

Enrollment. servingDistrict


Student Information General > Enrollments > Resident District

Student Information General > Enrollments > Resident District

studentReference

Reports the fields that are part of the Natural Key for the Student resource:

  • studentUniqueId
MN/AN/A
responsibility
Descriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

  • If the Resident and Serving District are the same as the reporting district, reports a value of '03'.
  • If reporting a record from the Resident District field, reports a value of '01'.
  • If reporting a record from the Serving District field, reports a value of '03'.


MN/AN/A
responsibiliyAsOfDate

Report the start date in which the students district association began. If the student has multiple enrollments with different start dates, the most recent start date reports.

MEnrollment.startdateStudent Information > General > Enrollments > Start Date

etag

A unique system-generated value that identifies the version of the resource.ON/AN/A


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Responsibility Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01AccountabilityAccountability
02AttendanceAttendance
03FundingFunding
04GraduationGraduation
05Individualized Education ProgramIndividualized Education Program
06TransportationTransportation




Student Parent Association

This association relates students to their parents, guardians or caretakers.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When the Guardian checkbox is marked on the Relationships tab.

  • The guardian does NOT have to be a member of the same household as the student to report.
  • Ed-Fi does not have relationship start or end dates, if a relationship is started anytime within a school year, the record will be added for that year. 

    • End Date must be blank or after school year end date defined in the School Years editor

    • Start Date must be on or before school year end date defined in the School Years editor

  • Report the person from the related pair that does not have an enrollment for the Parent Reference and the person that has an enrollment as the student reference.
    • If the student is a guardian of themselves (emancipated) then report the student as both the Parent and the Student.
    • If both people have a current enrollment, report the person with the higher age. 

    • If age cannot be determined, do not report a record

  • A record does not send if the student they are associated with has an enrollment marked as a no show, is marked as state exclude, or is in a calendar marked as Exclude.
PutWhen the relationship type is changed.
PutWhen leaNotification or seaNotification are changed.
Delete

When the Guardian checkbox is unchecked, relationship is end dated or deleted.

  • Ed-Fi does not have relationship start or end dates, if a relationship is ended within a school year, the record will be deleted for that year. 
  • End Date must be blank or after school year end date defined in the School Years editor
Delete

Records delete when a student has only 1 Student School Association record for a specific School and Year that record is deleted for. 

If a new Student School Association record is created, existing records will not re-post, a resync must be completed to resend the data


Delete

When the State Exclude or No Show checkboxes are marked. 

if the boxes are unchecked the data will not re-post, a resync must be completed to resend the data



Scope Year Logic

This table describes scope year logic of this object.

Logic

A record will report when they are a guardian to a student with an enrollment aligned to a scoped year.

  • The related pair start date must be null or on/before the scope year end date to report.
  • The related pair end date must be null or on/after the scope year end date to report

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

A resync must be completed on the resource when a new scope year is configured in order for this data to send.

When using data in Campus that have start and end dates, the following logic will be applied to determine the scope year(s) to report the data to:

  • Current Year:  The records start date must be on or before today's date and the records end date must be on or after today's date.
  • Previous Years:  The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor.  If blank, the default date of 6/30/xxxx is used (start date would have to be on or prior to the scope year).
  • Future Years:  The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor.  If blank, the default date of 7/01/xxxx is used.


Object Data Elements

This table describes data elements sent within the Student Parent Association resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resourceMN/AN/A
parentReference

Reports the fields that are part of the Natural Key for the Parents resource:

  • parentUniqueId
MN/AN/A
studentReference

Reports the fields that are part of the Natural Key for the Student resource:

  • studentUniqueId
MN/AN/A
relationType

The nature of an individual's relationship to a student; for example: Father/Mother, Step Father/Step Mother, Foster Father/Foster Mother, Guardian

  1. Report the Ed-Fi Code from the Ed-Fi Relation Type field that is mapped.
  2. If no mapping, do not report.

See the Relationship Type table in the section below for the Ed-Fi value that is reported.

ORelatedPair.nameCensus > People > Relationships > Relationship
primaryContactStatus

Indicator of whether the person is a primary parental contact for the student.

This element reports True if the Guardian checkbox is marked on the Relationships tab. If the student has more than one guardian, the guardian with the earliest start date is reported. If start dates are the same or null for two guardians, the guardian with the lowest personID is reported.

ON/ACensus > People > Relationships > Guardian
livesWith

Indicator of whether the student lives with the associated parent. This element reports True if the student is in the same household of the parent being reported. Otherwise, reports False.

  • Both Student and Parent Household start date must be null or on/before the scope year end date to report.
  • Both Student and Parent Household end date must be null or on/after the scope year end date to report.
ON/ACensus > People > Households
emergency
ContactStatus
Indicator of whether the person is a designated emergency contact for the student. This element will report true if there is a number entered in the Emergency Priority field for the parent being reported.ON/ACensus > People > Relationships > Emergency Priority
contactPriority

The numeric order of the preferred sequence or priority of contact. 

This data is not collected in Campus is not reported.


O N/AN/A 
contactRestrictions

Restrictions for student and/or teacher contact with the individual.

This data is not collected in Campus is not reported.


N/AN/A 
leaNotification

Notification to the LEA where the toddler resides must occur at least 90 days prior to the toddler's third birthday for toddlers potentially eligible for Part B preschool services.

  • If student has a Part C Exit Reason = 30 AND Part C Indicator 8 B: Did notification to the LEA where the toddler resides occur at least 90 days and at the discretion of all parties, no more than 9 months prior to the toddler's third birthday for toddlers potentially eligible for Part B preschool services? is Yes, reports True; otherwise, reports False.
  • If condition does not exist, do not report this field.

IFSP must be locked and overlap scope year. Use IFSP Start/End Dates to determine. If more than one plan is found report from highest planID.

Print Format: 'miIFSP%'

ON/AStudent Information > Special Education > Documents > IFSP > Part C Indicator 8 B, Part C Exit Reason, Start Date, End Date
seaNotification

Notification to the SEA must occur at least 90 days prior to the toddler's third birthday for toddlers potentially eligible for Part B preschool services.

  • If student has a Part C Exit Reason = 30 AND Part C Indicator 8 B: Did notification to the SEA occur at least 90 days and at the discretion of all parties, no more than 9 months prior to the toddler's third birthday for toddlers potentially eligible for Part B preschool services? is Yes, reports True; otherwise, reports False.
  • If condition does not exist, do not report this field.

IFSP must be locked and overlap scope year. Use IFSP Start/End Dates to determine. If more than one plan is found report from highest planID.

Print Format: 'miIFSP%'

ON/AStudent Information > Special Education > Documents > IFSP > Part C Indicator 8 B, Part C Exit Reason, Start Date, End Date
householdID

Household identifier for Transportation record

This data is not collected in Campus is not reported.


ON/AN/A
primaryPatB ReferralContactStatus

Indicator of whether the person is the primary parental contact for the student for the Part B Referral.

  • If student has a Part C Exit Reason = 30 AND
    • If reported parent matches parent found in Student Info > SPED > Docs > IFSP > Parent/Guardian Demographics, report true.
    • If parent does not match, report false.
  • If condition does not exist, do not report this field.

IFSP must be locked and overlap scope year. Use IFSP Start/End Dates to determine. If more than one plan is found report from highest planID.

Print Format: 'miIFSP%'

ON/A

Student Information > Special Education > Documents > IFSP > Transition Plan > Part C Exit Reason, Parent/Guardian Demographics, Start Date, End Date

etagA unique system-generated value that identifies the version of the resource. N/AN/A


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Relationship Type:

Ed-Fi Short DescriptionEd-Fi Description
AuntAunt
BrotherBrother
BrotherInLawBrotherInLaw
CourtAppointedGuardianCourtAppointedGuardian
CousinCousin
DaughterDaughter
DaughterInLawDaughterInLaw
EmployerEmployer
FatherFather
Father, stepFather, step
FathersSignificantOtherFathersSignificantOther
FathersCivilPartnerFathersCivilPartner
FatherInLawFatherInLaw
FianceFiance
FianceeFiancee
Foster parentFoster parent
FriendFriend
GrandfatherGrandfather
GrandmotherGrandmother
Great auntGreat aunt
Great uncleGreat uncle
Great GrandparentGreat Grandparent
HusbandHusband
MothersSignificantOtherMothersSignificantOther
MotherMother
Mother, stepMother, step
MothersCivilPartnerMothersCivilPartner
NephewNephew
NieceNiece
OtherOther
SignificantOtherSignificantOther
SisterSister
SonSon
UnknownUnknown
UncleUncle
WardWard
WifeWife



Student Program Association

This association represents the Program(s) that a student participates in or is served by. A student may have multiple records; one for each program they participate in.

English Learners (EL) Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

A record reports for each EL record with a distinct identified date and has state-mapped services that overlap the scope year. OR a new enrollment is created for a student and there is an existing EL record that qualifies.

  • A record is not sent for enrollments marked as State Exclude or No Show, or enrolled in a calendar marked as State Exclude, or in a school marked as Exclude.
  • A record is not sent if the student does not have an EL Identified Date.
  • Students must have at least one actively reported enrollment in the scope year to send a record.
Delete/Post

When data that is part of the Natural Key is changed.

  • If the Identified Date is changed and saved.
  • If the highest priority enrollment is changed to a different school (Primary enrollment is deleted and Partial enrollment still exists).
PutWhen any field that is not part of the natural key is changed, including the endDate or services.
Delete

When all non-excluded enrollments in all schools and year are deleted.

DeleteWhen all state-mapped EL services or the EL record in a scoped year is deleted.


Title 1 Programs Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post
  • When a student is associated with one or more programs that have:

    1. State Reported = selected

    2. Code = 6011, 6012, 6013, 6014, 6015, 6016, 6017, 6021, 6022, 6023, 6024, 6025, 6026, 6027, or 6028
  • If the student has Title 1 program records with a Location = NOT NULL for a School in which they are enrolled, report a record.
  • If the student has Title 1 program records with a Location = NOT NULL for a School in which they are not enrolled, do not report a record.
  • If the student has Title 1 program records with a Location = NULL, report a record for each school they are enrolled.
  • Do not send a student record for an enrollment that is marked as State Exclude or No Show.
  • Do not send a record if enrollment is in a calendar marked as Exclude.
  • Do not send a record if enrollment is in a School marked as Exclude.
Delete/Post

When data that is part of the Natural Key is changed.

  • Start Date is changed for a Title 1 program.
DeleteWhen Location is changed from NULL to a school, delete any school records not associated with the selected school.
DeleteWhen Location is changed from one school to another school, delete any school records not associated with the selected school.
Put

When any field that is not part of the natural key is changed:

  • services
  • programSupports
Delete

When Title 1 program is deleted.

DeleteAll overlapping enrollments are deleted for a school.


Special Education Programs Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post
  • When a student in the year and calendar reporting has the following:
    1. A locked IEP.
      1. IEP has a Special Ed Program(s) mapped to a state code with an Ed-Fi Code.
      2. Print Format: ‘miIEP%’
    2. A locked NPSP.
      1. NPSP has a Special Ed Program(s) mapped to a state code with an Ed-Fi Code.
        1. Print Format: 'miNPSP%'
    3. A locked IFSP.
      1. IFSP has an Early Intervention Service(s) mapped to a state code with an Ed-Fi Code.
      2. Print Format: ‘miIFSP%’
  • IEP/IFSP must overlap an enrollment.
  • An IEP will trump an IFSP if more than one document is found with the same Start Date.
  • If the student has multiple enrollments that are overlapping in the same school and year, report based on Service Type:

    1. P: Primary
    2. S: Partial
    3. N: Special Ed
  • If the student only has one enrollment, report a record regardless of Service Type.
  • Do not send a student record for an enrollment that is marked as State Exclude or No Show.
  • Do not send a record if enrollment is in a calendar marked as Exclude.
  • Do not send a record if enrollment is in a School marked as Exclude.
Post

When a new enrollment is created for a student that has an active IEP/IFSP:

  1. Enrollment start date must be after IEP/IFSP start date.
  2. IEP/IFSP end date must be NULL or after Enrollment start date.
Delete/Post

When data that is part of the Natural Key is changed.

  • When a SPED Entry Date is changed.
Delete/Post

When any field that is not part of the natural key is changed, including the following:

  • endDate
  • reasonExitedDescriptor
  • section52FTE
  • section53FTE
Delete/Post

Fields in the Evaluation/ESR will trigger a Delete/Post.

  • partCTransitionTimelinessDescriptor
  • resultOfInitialIEPDescriptor
  • timelinessOfInitialIEPDescriptor
  • initialIEPCompletionDate
DeleteA Sped Start Date is changed for a student.
DeleteAll overlapping enrollments are deleted for a school
Delete

When an IEP/IFSP is unlocked it will delete.


Scope Year Logic

This table describes scope year logic of this object.

Logic

The record and state mapped Services must both overlap the scope year to report

Record will report for each year where an active record and service exists.

If the school year Start and End date is null, a value of 07/01/XXXX (start date) and 06/30/XXXX (end Date) reports.


Object Data Elements

This table describes data elements sent within the Student Program Association resource.

Data ElementDescriptionCampus Database FieldCampus GUI Interface
idThe unique identifier of the resource.M N/AN/A
educationOrganizationReference

A reference to the related EducationOrganization resource.

Reports the state school number that is aligned to the student's enrollment.

Reports enrollments in Primary, Partial, Special Ed order.

MSchool.numberSystem Administration > Resources > School > State School Number
programReference

A reference to the related Program resource. Reports Program reference (EL, Title 1, Special Educaiton).

MN/AN/A
studentReference

A reference to the related Student resource.

Reports the studentUniqueId from the Student Resource.

MN/AN/A
beginDateThe month, day, and year on which the Student first received services. Reports the EL Identified Date.MLep.identifiedDate

Student Information > Program Participation > English Learners (EL) > EL > Identified Date

endDate

The month, day, and year on which the Student exited the Program or stopped receiving services.

Reports the Program Exit Date.

OLep.exitDateStudent Information > Program Participation > English Learners (EL) > EL > Exit Date
reasonedExitedDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table

This field is optional and does not report. 


ON/AN/A
servedOutsideOf regularSession

Indicates whether the student received services during the summer session or between sessions.

This field is optional and does not report.


ON/AN/A
enrollmentStatus


This field is optional and does not report.


ON/AN/A
servicesAn unordered collection of studentProgramAssociationServices. Indicates the services being provided to the student by the program. This field is an array. See below for more information.ON/AN/A
serviceDescriptor

The ID of the Service Descriptor.

English Learners (EL)

  1. Report the Code from the State Defined Service Type.
    1. IIf the service is not mapped to a state code, do not report.
  2. Service must be active at least one day in the Scope Year to report.

Title I Programs

  1. Reports Code from program.
    1. State Reported must be selected.
    2. Code must be 6011, 6012, 6013, 6014, 6015, 6016, or 6017.

Special Education Programs

 IEP/NPSP

  1. Report the Ed-Fi Code associated with the assigned Special Education Program service.
  2. Service must be active at least one day in the Scope Year to report.
MLepservicetype.code

Student Information > Program Participation > EL > EL Services

Student Information > Program Participation > Programs

Student Information > Special Education > Documents >IEP > Special Education Programs

primaryIndicator


This field is optional and does not report. 


ON/AN/A
serviceBeginDate

The month, day, and year on which the Student first received service.

English Learners (EL)

  1. Report Start Date of Service.

Title I Programs

  1. Report Program Start Date.

Special Education Programs

  1. Report Start Date of IEP/NPSP/IFSP.
Mlepservice.startdate

Student Information > Program Participation > EL > EL Services

Student Information > Program Participation > Programs > Start Date

Student Information > Special Education > Documents >IEP > Special Education Programs > Start Date

serviceEndDate

The month, day, and year on which the Student first received service.

English Learners (EL)

  1. Report Program Exit Date.

Title I Programs

  1. Report Program End Date.

Special Education Programs

  1. Report End Date of IEP.
Mlep.exitDate

Student Information > Program Participation > English Learners (EL) > Program Exit Date

Student Information > Program Participation > Programs > End Date

Student Information > Special Education > Documents >IEP > Special Education Programs > End Date


Type/Descriptors


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Service Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description

04

Sheltered Instruction Observation Protocol (SIOP)

The SIOP model uses instructional strategies connected to eight components that address the linguistic and academic needs of English learners, which include Lesson Preparation, Building Background, Comprehensible Input, Strategies, Interaction, Practice/Application, Lesson Delivery, Review & Assessment. When applying SIOP, teachers infuse both language and content objectives by including metacognitive, cognitive, and social/affective strategies along with scaffolding techniques in order to support students’ learning, practicing, and developing independent learning skills.

05

Bilingual Dual-Language Instruction

The goal of these bilingual programs (also known as two-way or developmental) is for students to develop language proficiency in two languages by receiving instruction in English and another language in a classroom that is usually composed of half native English speakers and half native speakers of the other language.

06

Bilingual Two-Way Immersion

Bilingual two-way immersion is a program in which a second language (English) is used along with the student's first language for curriculum instruction during some part of elementary or secondary schooling. The goal of two-way immersion programs is functional competence in both languages.

07

Transitional Bilingual Instruction

This program, also known as early-exit bilingual education, utilizes a student's primary language instruction. The program maintains and develops skills in the primary language and culture while introducing, maintaining and developing skills in English. The primary purpose of a TBI program is to facilitate the English-language learner's transition to an all-English instructional program, while receiving academic subject instruction in the native language to the extent necessary.

08

Bilingual Heritage Language Instruction

An instructional program that aims to develop fully bilingual and bi-literate students by conducting core curriculum classes in English and in the student's home language.

09

English As a Second Language (ESL) Instruction

A program of techniques, methodology, and special curriculum designed to teach English-language learners skills, which may include listening, speaking, reading, writing, study skills, content vocabulary and cultural orientation. ESL instruction is usually in English with little use of the native language.

10

Sheltered ESL Instruction

An instructional approach used to make academic instruction in English understandable to English language learners. In the sheltered classroom, teachers use physical activities, visual aids and the environment to teach vocabulary for concept development in mathematics, science, social studies and other subjects.

11

Structured English Immersion

The goal of this program is acquisition of English language skills so that the English language learner can succeed in an English-only mainstream classroom.

12

Content-based English as a Second Language

This approach makes use of instructional materials, learning tasks and classroom techniques from academic content areas as the vehicle for developing language, content, cognitive and study skills. English is used as the medium of instruction.

13

Newcomer Program

Newcomer programs are separate, relatively self-contained educational interventions designed to meet the academic and transitional needs of newly arrived immigrants. Typically, students attend these programs before they enter more traditional interventions (e.g., English-language development programs or mainstream classrooms with supplemental ESL instruction).

14

Other Program

Student participates in an EL program other than one described.

15

Refused Services

The student is EL eligible but is not receiving services because services have been refused.

16

No Services Offered

No EL services are offered by the district. NOTE: Under Title VI of the Civil Rights Act of 1964, which prohibits discrimination based on race, color or national origin, a school district is required by law to take steps to help EL students and English language learners overcome language barriers and ensure that they can participate meaningfully in the districts' educational programs. A complete discussion of the law and guidance is available at: http://www.ed.gov/about/offices/list/ocr/ell/index.html.




Student School Association

This association represents the school in which a student is enrolled.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a new enrollment is saved for a student or the No Show or State Exclude checkbox is unchecked.

  • Do not post a record when the No Show or State Exclude checkbox is marked.
  • When a student has two enrollments in the same school for the same start date report from the enrollment service type in the following order:

    1. P: Primary Enrollment
    2. S: Partial/Ancillary
    3. N: Special Ed Services
  • When an enrollment with a higher priority is deleted, the enrollment with lower priority will post a new record.
  • Do not send records if the Calendar Exclude checkbox is markd in the calendar the student is enrolled.
  • Do not sent records if the School Exclude checkbox is marked in the calendar the student is enrolled.
Post

When the start date for an enrollment is changed.

  • When an enrollment with a lower priority is changed, data will not send.
Put

When an enrollment is updated for a student.

  • enrollmentPercent
  • districtResidencyStatusAsOfDate
  • districtResidencyStatusDescriptor
  • earlyReadingIntervention
PutWhen a change is made to the Graduation > NCLB Cohort End Year field.
PutWhen a student is assigned to a Graduation or CTE Program or the start and/or end dates are modified.
Delete

When an enrollment is deleted or the No Show or the State Exclude checkboxes are marked.

  • When a student has two enrollments in the same school for the same start date, records with lower priority will not trigger a delete.
DeleteWhen the start date of an enrollment is changed


Scope Year Logic

This table describes scope year logic of this object.

Logic
The record will send to the scope year for the school year the enrollment is associated with.
Data will only send for the years that have valid configuration.


Object Data Elements

This table describes data elements sent within the Student School Association resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
graduationPlan
Reference

A reference to the related GraduationPlan resource.

  1. Report the associated Graduation Plan when a student is assigned to a Graduation Program or Career Tech Program that is eligible to report to Ed-Fi
    1. The Program must overlap the enrollments that are aligned to the Student School Association record being reported.
    2. Program Start Date must be on or before today's date to report.
    3. Program End Date must be null or after today's date to report.
      1. If an end date is added in the current scoped year, delete the reference.
  2. Report the Graduation Plan School year that is aligned to the student's NCLB Cohort End Year.
    1. If the student does not have an NCLB Cohort End Year, do not report a record.
  3. If the student has both a CTE and Graduation Plan, report the Graduation Plan.
  4. If the student has more than one Graduation Plan, report the plan with the most recent start date.
ON/AStudent Information > Academic Planning > Programs
schoolReference

Reports the fields that are part of the Natural Key for the School resource:

  • schoolReference
  • studentReference
  • entryDate
MN/AN/A
classOfSchool
YearTypeReference

The year the student is expected to graduate.

Report only for students with an enrollment in grade 9-12:

  1. Populate the year selected in Student Info > General > Graduation > NCLB Cohort End Year.
  2. When NCLB Cohort End Year = Null, do not report.
CGraduation.gradYearStudent Information > General > Graduation > NCLB Cohort End Year
schoolYearType
Reference

The school year the student is being reported in. The end year of the calendar year is reported.

ON/AN/A
studentReference

Reports the fields that are part of the Natural Key for the Student resource:

  • studentUniqueId
MN/AN/A
entryDateThe month, day, and year on which an individual enters and begins to receive instructional services in a campus. MEnrollment.startDateStudent Information > General > Enrollments > Start Date
entryGradeLevel
Descriptor

The grade level or primary instructional level at which a student enters and receives services in a school or an educational institution during a given academic session.

  1. Report the Ed-Fi Code from the Grade Level mapping for the grade selected on the student's enrollment.
  2. If a mapping is not available, the record will error.
MEnrollment.gradeStudent Information > General > Enrollments > Grade
entryGradeLevel
ReasonType

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

This is optional and does not report.


ON/AN/A
entryTypeDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. 

Reports the Ed-Fi Code Value from the Start Status selected. If blank, does not report.

See the Entry Type Descriptor table in the section below for reported Ed-Fi code values.

OEnrollment.
startStatus
Student Information > General > Enrollments > Start Status
repeatGradeIndicator

An indicator of whether the student is enrolling to repeat a grade level, either by failure or an agreement to hold the student back.

This is optional and does not report.


ON/AN/A
schoolChoiceTransfer

An indication of whether students transferred in or out of the school did so during the school year under the provisions for public school choice in accordance with Title I, Part A, Section 1116.

This is optional and does not report.


ON/AN/A
exitWithdrawDateThe month, day, and year of the first day after the date of an individual's last attendance at a campus (if known), the day on which an individual graduated, or the date on which it becomes known officially that an individual left school. NEDM: Exit/Withdraw Date. OEnrollment.endDateStudent Information > General > Enrollments > End Date
exitWithdrawType
Descriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. 

Reports the Ed-Fi Code Value from the End Status selected.

See the Exit Withdrawal Reason Descriptor table in the section below for more information on the Ed-Fi code reported.

O

Enrollment.endStatus

Student Information > General > Enrollments > End Status
residencyStatus
Descriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

This is optional and does not report.


ON/AN/A
primarySchoolIndicates if a given enrollment record should be considered the primary record for a student. If omitted, the default is true. This element reports a value of True if Service Type = P: Primary; otherwise, reports False.OEnrollment.typeStudent Information > General > Enrollments > Service Type
employedWhile
Enrolled

An individual who is a paid employee or works in his or her own business, profession, or farm and at the same time is enrolled in secondary, postsecondary, or adult education.

This is optional and does not report.


ON/AN/A
educationPlans

An unordered collection of studentSchoolAssociationEducationPlans. This association represents the school in which a student is enrolled.

This is optional and does not report.


ArrayN/AN/A
enrollmentPercentThe full-time equivalency (FTE) that the participant spends in the program, service, or education organization reported. Range 0.00 - 1.00OEnrollment. percentEnrolledStudent Information > General > Enrollments > State Reporting > FTE in General Education
districtResidency StatusAsOfDateReports the enrollment start date ONLY when the districtResidencyStatusDescriptor reports.OEnrollment.startDateStudent Information> General> Enrollments> Start Date
districtResidency StatusDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

Reports the Ed-Fi Code from Student Residency.

OEnrollmentMI. studentResidencyStudent Information > General > Enrollments > State Reporting > Student Residency
exitWithdrawDateAsofDate

To support state reporting: captures when ExitWithdrawDate changed.

This is optional and does not report.


ON/AN/A
earlyReadingIntervention

Indicates student receiving early reading intervention services.

If 'Was there a reading deficiency identified any time during the current school year?' = Y or N, report array.

O
Student Information > General > Enrollments > Early Reading Deficiency
etagA unique system-generated value that identifies the version of the resource.ON/AN/A


Arrays

Student School Association Early Reading Intervention 

Data ElementDescriptionCampus Database FieldCampus GUI Location
readingDeficiencyIdentified

A reading deficiency was identified during the current school year.

  1. If 'Was there a reading deficiency identified any time during the current school year?' = Y, report true OR = N, report false.


Student Information > General > Enrollments > Early Reading Deficiency
readingDeficiencyContinuation

A reading deficiency still exists at the end of the school year.

1. If 'Is there a reading deficiency that still exists at the end of the school year?' = Y, report true.

    a. If = N, report false.

O
Student Information > General > Enrollments > Early Reading Deficiency
readingDeficiencyActivities

An unordered collection of studentSchoolAssociationEarlyReadingInterventionReadingDeficiencyActivities. Indicates the type of additional instructional time related activities delivered to the student.

  1. If any checkboxes are selected under the question, 'What additional instructional time grant related activities were delivered to the student?', report array.
O
Student Information > General > Enrollments > Early Reading Deficiency


Student School Association Early Reading Intervention Reading Deficiency Activity 

Data ElementDescriptionCampus Database FieldCampus GUI Location
readingDeficiencyActivityDescriptor

Indicates the type of additional instructional time related activities delivered to the student.

  1. If Before School = selected, report 01.
  2. If During School = selected, report 02.
  3. If After School = selected, report 03.
  4. If Summer Program = selected, report 04.
  5. If Other Allowable Grant Activities = selected, report 05.
  6. If Read At Home = selected, report 06.
M
Student Information > General > Enrollments > Early Reading Deficiency


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Entry Type Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01TransferTransfer
02Re-entryRe-entry
03Next year schoolNext year school
04New to education systemNew to education system
05OtherOther

This table describes the mapping for the Start Status/Entry Type Descriptor:

CodeNameEd-Fi Code

From public school, same district05
02From public school, different state district01
03From public school, different state01
04From private non-religious school, same district01
05From private non-religious school, different state district01
06From private, non-religious school, different state01
07From private religious school, same district01
08From private religious school, different state district01
09From private religious school, different state01
10From a school outside of the US01
11From an institution01
12From a charter school01
13From home schooling01
14Matriculation from another school01
15Continuous within same school05
16Re-entry after voluntary withdrawal02
17Re-entry after involuntary withdrawal02
18First entry into a US school04
19First entry into a US school, previously in school04
20First entry into a US school, not previously in school04
21Placement in district by another district IEP05
99Other05
TINTransferred InNULL
SOYStart of YearNULL
ESCEnrollment Status ChangeNULL

This table describes the Ed-Fi Value mapped and reported for Exit Withdrawal Type Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
00Not enrolledUse for a child/student who is served but not enrolled in your district. When this code is reported the record may only contain these components: Submitting Entity, Personal Core, School Demographics, Personal Demographics, Enrollment, Membership and Initial 01
01Graduated from general education with a high school diplomaUse for a student who earned a high school diploma. Include early graduates who earn high school diplomas. Also use for a student with an IEP who met the Michigan Merit Curriculum graduation requirements. Exclude any students who met IEP requirements but did not receive a high school diploma.
02Graduated from general education with a high school diploma;collegeUse for a student who graduated with a high school diploma and, to the best of the district's knowledge, enrolled in a two- or four-year degree-granting college or university
03Graduated from an alternative program with a high school diplomaUse for a graduate receiving a diploma from an alternative program in a regular high school or a separate building.
04Graduated from general education with a high school diploma;non-degree gradeUse for a student who graduated and, to the best of the district's knowledge, enrolled in a non-degree-granting institution (e.g., trade, technical, vocational or business school).
05Completed general education with an equivalency certificate (GED)Use for a student known to have passed the GED test and to be younger than 20 years of age as of the date reported in District Exit Date.
06Completed general education with other certificateUse for a student who completed school with some other type of certificate, such as a certificate of attendance/completion or a district competency test.
07Dropped out of schoolUse when a student, upon reaching age 16, stopped attending school and no reason was given. For special education, use when the student left school before reaching age 26 as of September 1 of the current school year without completing his/her educational program.
08Enrolled in another public school district in MichiganUse when a student moved to another public school district in Michigan and is known to be continuing in education. This code is also used for students who withdraw from a district to attend a public in-state cyber school or virtual school. Movement to another district includes moving to state institutions, except when the student is incarcerated (see code \"13\"). The student's residency may or may not change districts. NOTE: Movement is referring to the student's enrollment, not necessarily his/her home address.
09Moved out of stateUse when students and their parents/guardians physically move outside the original district of residence to another state or country. This code should also be used when a foreign exchange student left midyear to return to his/her home country.
10Expelled from the school district (no further services)Use when a general education student has been permanently expelled from school by official board action. This does not include a student with disabilities receiving special education programs/services on longterm suspension or a student who is placed in an alternate educational setting. A student with this code requires further information be reported in the Discipline Component. Students who are expelled for less than the remainder of the current school year and continue to receive services should be reported with code 19 (expected to continue).

11

Enlisted in military or Job Corps

Use when the student left the school district prior to graduation to enlist in a branch of the U.S. Military.

12

Deceased

Use when a student has passed away.

13

Adjudicated

The student is placed under jurisdiction of a juvenile or criminal justice authority. The student may continue to receive educational services from a PSA-, LEA- or ISD-run program. NOTE: If the student is placed in a facility where the educational program is run by the current district, the student's exit status should be entered as \"19\" (expected to continue).

14

Enrolled in home school

Use when a student receives instruction offered in a home for reasons other than health. This code is also used for students who withdraw from a district to attend an out-of-state cyber school or virtual school. An out-of-state cyber school or virtual school is not a registered school in Michigan. This can be confirmed by checking to see if the school exists in the Educational Entity Master.

15

Enrolled in non-public school

Use when a student attends a nonpublic school, such as a parochial school. This code is also used for students who withdraw from a district to attend a nonpublic in-state cyber school or virtual school. It is also used for nonpublic students who have been taking non-core classes from the district, who are no longer receiving services, and are continuing in their nonpublic setting. NOTE: This code should not be used for students transferring to a Public School Academy (PSA). Use code 08.

16

Unknown

Use when the current status of the student is unknown. For reporting purposes, this student is considered a dropout, unless s/he can be located in another district.

17

Placed in a recovery or rehabilitative program

Use when the student was placed in a recovery program, rehabilitative program or under psychiatric care. The student may continue to receive educational services from a PSA-, LEA- or ISD-run program. NOTE: If the student is placed in a facility where the educational program is run by the current district, (either homebound or hospitalized), the student should be reported as code 19 (expected to continue).

18

Left adult education

Participant is no longer enrolled in an adult education program.

19

Expected to continue in the same school district

Use when the student is expected to continue normal matriculation through the educational system in the same district.

20

Received special education certificate of completion and exited the K-12 s

Student exited his/her educational program by receiving a modified high school diploma, a certificate of completion of high school or educational program, or some similar document. NOTE: Student must be identified as a special education participant with a valid code in the Primary Disability characteristic in the Special Education Component.

21

Special education - Reached maximum age and exited the K-12 system

Student reached age 26 as of September 1 of the current school year and is no longer eligible to attend school. NOTE: The student must be identified as eligible for special education programs/services with a valid code in the Primary Disability characteristic in the Special Education Component.

30

Exited early childhood or Early On program/service

Child has left early childhood or Early On program/service and will not be continuing in the district. NOTE: If the child has left his or her program and will subsequently be entering kindergarten in the district, report as \"19\" (expected to continue).

40

Graduated from a Middle College with both a high school diploma and an As

Student has completed the requirements to earn both a high school diploma and a post-secondary degree or certificate through an established early/middle college program. NOTE: Students reported with this code must be identified as early/middle college participants with the Program Eligibility Participation characteristic in the Program Participation Component.

41

Graduated from a Middle College with only a high school diploma

Student has completed the requirements for a high school diploma, but did not earn a post-secondary degree or certificate through an established early/middle college program. NOTE: Students reported with this code must be identified as early/middle college participants with a Program Eligibility Participation characteristic in the Program Participation Component.

42

Graduated from another district

Shared student has exited the reporting district and has been issued a high school diploma from a different district. NOTE: This code should only be used when another district is responsible for the graduation of the student. If no other district reports this student as graduating, the student may appear as a dropout on the reporting district's graduation/dropout report.

 This table describes the Ed-Fi Value mapped and reported for Entry Grade Level Type Descriptor:

Code Value

Short Description

Description

00

Kindergarten

Kindergarten

01

First Grade

First Grade

02

Second Grade

Second Grade

03

Third Grade

Third Grade

04

Fourth Grade

Fourth Grade

05

Fifth Grade

Fifth Grade

06

Sixth Grade

Sixth Grade

07

Seventh Grade

Seventh Grade

08

Eighth Grade

Eighth Grade

09

Ninth Grade

Ninth Grade

10

Tenth Grade

Tenth Grade

11

Eleventh Grade

Eleventh Grade

12

Twelfth Grade

Twelfth Grade

14

Special Education Transition

Special Education Transition

20

Adult Education

Adult Education

30

Early Childhood/Early On (Below Kindergarten level)

Early Childhood/Early On (Below Kindergarten level)  

 This table describes the Ed-Fi Value mapped and reported for District Residency Status Type Descriptor.

Code Value

Short Description

Description

01

Non-K-12 district

Student who lives outside of the operating district, whose resident district does not offer all grade levels, kindergarten through twelve.

02

Section 105 school of choice (within same ISD)

(LEA districts only)

03

Section 105c school of choice (outside contiguous ISD)

Student is a resident of a district within another ISD that is contiguous to the ISD to which the operating district belongs, and meets all the requirements of Schools of Choice 105.

04

Non-public school student (Non-Resident)

(LEA districts only)

05

No cooperative agreement, no release, not exempted

Student who lives outside of the operating district who has not been released by the resident district and is not Sec. 6(6) (g) exempt. (LEA districts only)

06

All other non-resident students

Student does not fall into any other non-resident category. (LEA and ISD districts only)

07

Home schooled non-resident

Student who lives outside of the operating district who is being educated through a home-school program, taking a non-essential curriculum or advanced placement course through the operating district. (LEA and ISD districts only)

08

Non-public school student (Resident)

Student who is enrolled in a private or parochial school district, taking a non-essential curriculum or advanced placement course through the operating district.

09

Section 24 juvenile detention facility

Student resides in an approved, on-grounds juvenile detention facility or child-care institute.

10

For new PSAs (fall only)

For new PSAs (fall only)

11

School for the Deaf/blind MSB-Low Incidence Outreach

Student is being educated by the Michigan School for the Deaf. (ISD districts only)

12

Section 6(4) (d) non-special education juvenile detention

Student placed by a court or state agency in an on-grounds child-care institution or a juvenile detention facility under Section 24 and being educated by the ISD. (ISD districts only)

13

Student with disabilities served by DCH facility

Student resides in a DCH-licensed facility. (ISD districts only)

14

All other resident students

Student does not fall into any other resident category.

15

Home-schooled resident

Student being educated through a home-school program, taking non-essential curriculum or advanced placement course through the operating district.




Student School Attendance Event

This event entity represents the recording of whether a student is in attendance on a daily basis at their school.

Object Triggering Logic


ActionTrigger
Post

When a new attendance event is verified for a student and is marked 02 Excused Absent, or 03 Unexcused Absent.

  • Report attendance for each school in which the student has a Student School Association record.
  • Attendance date must fall on or between enrollment start and end dates.
  • Unknown attendance events will not send an event to Ed-Fi. The original post will not appear until an excuseID is entered in the attendance table.
  • Do not send records if the student's enrollment is marked as a No Show or State Exclude.
  • Do not send records if attendance records are associated with a Calendar when the Exclude checkbox is checked.
  • A record will send for each distinct Date and Attendance Event Category Descriptor.
  • Do not send records if attendance records are associated with a School when the Exclude checkbox is checked.
Put

N/A - only deletes and posts are sent for this Resource.

  • If an attendance status is changed, the first event must be deleted from Ed-Fi and a new record sent.  The Attendance Event Category Descriptor is a primary key and does now allow updates in Ed-Fi.
DeleteDelete attendance record if all attendance is removed for the day and determined present minutes or present periods is 50% or more. MSDS Attendance Model for the day will need to be referenced.
DeleteWhen an enrollment is deleted or the No Show or State Exclude checkboxes are checked.


Scope Year Logic

This table describes scope year logic of this object.

Logic
Attendance will send to the scope year for the school year the attendance dates are associated with based on the student's enrollment.
Data will only send for the years that have valid configuration.


Object Data Elements

This table describes data elements sent within the Student School Attendance Event resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resourceMN/AN/A
schoolReference

Reports the fields that are part of the Natural Key for the Schools resource:

  • entityID
MN/AN/A
sessionReference

Reports the fields that are part of the Natural Key for the Sessions resource:

  • id
  • schoolReference
  • schoolYearTypeReference
  • termType
  • name

Only report the Term Type from the Terms tab that is associated with the date and term schedule the attendance is being reported for.

MN/AN/A
studentReference

Reports the fields that are part of the Natural Key for the Student resource:

  • studentUniqueId
MN/AN/A
eventDateDate for this attendance event. MN/AN/A
attendanceEvent
CategoryDescriptor

Report the Ed-Fi Code from the Attendance Event Category Descriptor page below based when the student has an attendance record with the following attendance status and excuse:

  1. Report '02' when the majority of absence for the day is Absent/Excused.
  2. Report '03' when the majority of absence for the day is Absent/Unexcused and/or Absent/Unknown.
  3. If absence times are equal, report '03'.
  4. Use the following attendance rules to determine if the student is absent for the day:
  • If student's enrolled grade has an MSDS Attendance Model that is Minute Based or NULL use the following calculation:
    - Whole Day Present: Student SUM of absence minutes is 50% or less than the scheduled Instructional minutes for the day.
    - Whole Day Absent: Student SUM of absence minutes is more than 50% of scheduled Instructional minutes for the day.
  • If student's enrolled grade has an MSDS Attendance Model that is Period Based use the following calculation:
    - Whole Day Present: Student is flagged as absent for 50% or less than the number of scheduled instructional periods for the day.
    - Whole Day Absent: Student is flagged as absent for more than 50% of scheduled Instructional periods for the day.
  • Absent is defined by the following attendance code combinations:

    StatusExcuse
    AbsentExcused
    AbsentUnexcused
    AbsentUnknown


  • Attendance is calculated from the student's schedule in both attendance models.
    - Scheduled period must be marked as Instructional.
    - Course must be marked for Attendance.
    - Day must be marked as Instructional.

M

v_AttDailyDetail.unexcused

v_AttDailyDetail.tardies

N/A
attendanceEventReason

The reported reason for a student's absence. 

The element is optional and does not report.


ON/AN/A
educational
EnvironmentType

The educational environment. 

This element is optional and does not report.


ON/AN/A
absenceAmountDescriptorN/AON/AN/A
instructionalMinutesN/AON/AN/A
etagA unique system-generated value that identifies the version of the resourceON/AN/A


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Attendance Event Category Type:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
03Unexcused AbsenceUnexcused Absence
02Excused AbsenceExcused Absence
04TardyTardy




Student Section Association

This association indicates the course sections to which a student is assigned.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a student is scheduled into a course section.

  • A record reports for each Section record that is reported based on the Sections logic.
  • If roster start date is after the term end date, do not report a record for the prior term.
  • Only send records if the student has a enrollment in the schedule structure where the student is scheduled and is not marked as No Show or State Exclude.
  • Do not send records if the Calendar Exclude checkbox is marked.
  • Do not send records if the School Exclude checkbox is marked.
  • Do  not send records if the Course is marked as Inactive or Exclude.
PostSend a new record if a student's roster start date is changed.
Put

When section information is updated for a student or section.

  • Update when the course or section's homeroom field is changed.
  • Update when the student's Score is changed on the associated grading task. 
DeleteWhen a student is deleted from a course section.
Delete

Delete any future records if the student is given a roster end date for the course.

Roster End Date must be before the Term Start date of future records.

DeleteDelete the record if a student's roster start date is changed.


Scope Year Logic

This table describes scope year logic of this object.

Logic
Reports records in the scope year the course/section's calendar is aligned to.
Data will only send for the years that have valid configuration.

Future Years data will be suppressed until the Active Year is changed:

  • This allows the Schedule Wizard to be used and reduces the number of records sent until the final schedule is completed.
  • A resync must be done after the Active Year is changed to send data.


Object Data Elements

This table describes data elements sent within the Student Section Association resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
sectionReference

Reports the fields that are part of the Natural Key for the Section resource:

  • id
  • classPeriodReference
  • courseOfferingReference
  • locationReference
  • schoolReference
  • sessionReference
MN/AN/A
studentReference

Reports the fields that are part of the Natural Key for the Student resource:

  • studentUniqueId
MN/AN/A
beginDate

Month, day and year of the student's entry or assignment to the section. If blank, default is the start date of the first grading period. Logic reports based on the following:

  • Report the roster start date for the term record in which the start date occurs
    • For any records in the future terms for that course, use the term start date
  • If Start Date is NULL, report the earliest term start date associated with the term descriptor selected for this section based on section schedule placement.
M

Enrollment.startDate

Terms.startDate

Student Information > General > Enrollments > Start Date

OR

System Administration > Calendar > Calendar > Terms

endDate

Month, day, and year of the withdrawal or exit of the student from the section. Logic reports based on the following:

  1. Report the roster end date for the student 
    1. If a roster end date is entered, delete any records for future terms for that section
  2. If NULL, report the latest term start date associated with the term descriptor selected for this section based on section schedule placement.
O

Roster.endDate

Terms.endDate

Student Information > General > Schedule > Roster End Date

OR

System Administration > Calendar > Calendar > Terms

homeroomIndicatorIndicator that the class is the student's designated homeroom used for daily attendance reporting. This element reports a value of True if the Homeroom checkbox is marked on the section or the course the section is assigned to.O

Course.homeroom

Section.homeroom

Scheduling > Course > Homeroom

or

Scheduling > Course > Section > Homeroom

repeatIdentifierType

An indication as to whether a student has previously taken a given course.

This element is currently not reported or collected.


ON/AN/A
teacherStudent
DataLinkExclusion

Indicates that the student-section combination is excluded from calculation of value-added or growth attribution calculations used for a particular teacher evaluation.

This element is currently not reported or collected.


ON/AN/A
courseAttempt StatusDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

Reports the Ed-Fi Code from State Score tied to selected Score from grading task that has State Reported selected and a Code = TSDL.

  • If grading task assigned to more than one term report from the latest term.
  • If more than one grading task is found, report from highest taskID
  • If section is assigned to more than one term, report this field in the latest term.
    • Example, if assigned to Q1, Q2, Q3, and Q4, this field would only report in Q4.
M

Grading & Standards > Grading Tasks > Code, State Reported

Course > Section > Grading by Task

msixClockHours

Reports the number of clock hours to date that the student has completed.

If the student is actively enrolled in a Program with a Code of MIGRANT and State Reported is selected, and the CompletionStatus is not CP, CF, or CS, report the (number of minutes / 60) the student is scheduled. Round to the nearest integer.

Use Term Start/End Date, Enrollment Start/End Date, and Roster Start/End Date to determine hours.

Reports hours per term if more than one term is assigned to the section.

O
Student Information > Program Participation > Programs
etagA unique system-generated value that identifies the version of the resource. ON/AN/A


Type/Descriptors


Code ValueShort DescriptionDescription

AU

Audited (no credit issued)

The student attended the course without expecting or receiving credit.

CF

Completed/Failed

A course providing instruction (in a given subject-matter area) that focuses primarily on general concepts for the appropriate grade level.

CP

Completed/Passed

The student completed the course, meeting at least the minimum expectations.

CS

Completed/Special Ed Only

The special education student is reported in grade or setting 14 and has completed or aged out of the course. A course grade and credit are not applicable.

ER

Submitted in Error

This status allows districts to mark a record that was submitted in error in a previous certified collection of the TSDL. Courses marked with this Completion Status will not be included in any reporting of TSDL data and will be considered as not submitted.

I

Incomplete

At the time of this reporting, the student must meet additional requirements to receive a grade or credit for the course.

OE

Ongoing Enrolled

The special education student is reported in grade or setting 14 and is expected to continue in this same course next year. This requires the use of Subject Area Code "73" and Course Section ID "039". This status may also be used for any non-special education student who is expected to continue in this same course and will be reported in a later submission when the course is completed.

TO

Tested Out

The student took a test and received credit without having to take the course.

WE

Withdrawn/Exited

The student withdrew or exited the course before completion.

WF

Withdrawn/Failing

At the time the student withdrew or exited the course, he/she was failing the course.

WP

Withdrawn/Passing

At the time the student withdrew or exited the course, he/she was passing the course.




Student Section Attendance Event

This event entity represents the recording of whether a student is in attendance for a class.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a new attendance event is verified for a student on the course section and the Attendance Status + Attendance Excuse combination is mapped to an Ed-Fi code.

  • The student must have a Student Section Association record to report.
  • Unknown attendance events will not send an event to ed-fi.  The original post will not trigger until an excuseID is entered in the attendance table.
  • Do not send records if the student's enrollment is marked as a No Show or State Exclude.
  • Do not send records if attendance records are associated with a Calendar when the Exclude checkbox is checked.
  • A record will send for each distinct Date, Section and Attendance Event Category Descriptor.
  • Do not send records if the course does not have a State Course Code.
Put

N/A - only deletes and posts are sent for this Resource.

  • If an attendance status is changed, the first event must be deleted from ed-fi and a new record sent.  The Attendance Event Category Descriptor is a primary key and does now allow updates in Ed-Fi
DeleteDelete attendance record if all attendance is removed for the day
DeleteWhen an enrollment is deleted or the No Show or State Exclude checkboxes are checked
DeleteIf the student is removed from the course section


Scope Year Logic

This table describes scope year logic of this object.

Logic

Attendance will send to the scope year for the school year the attendance dates are associated with based on the student's enrollment.

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


Object Data Elements

This table describes data elements sent within the Student Section Attendance Event resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
 id

The unique identifier of the resource

MN/AN/A
sectionReference

Reports the fields that are part of the Natural Key for the Section resource.

MN/A N/A 
studentReferenceReports the fields that are part of the Natural Key for the Student resource.MN/A N/A 
eventDateDate for this attendance event.MN/A N/A 
attendanceEvent
CategoryDescriptor

Key for AttendanceEventCategoryType.

Reports when a student has a verified attendance mark for a course section

  • Report '02' when status = A and Excuse = E
  • Report '03e' when status = A and Excuse = U
  • Report '04' when status = T and Excuse is = E or U
MN/A N/A 
attendanceEventReason

The reported reason for a student's absence 

This element is optional and does not report.


O N/AN/A 
educationalEnvironmentType

Key for EducationalEnvironment 

This element is optional and does not report.


O N/AN/A
etag

A unique system-generated value that identifies the version of the resource 

This element is optional and does not report.


O N/AN/A


Type/Descriptors


Code ValueShort DescriptionDescription
02Excused AbsenceExcused Absence
03Unexcused AbsenceUnexcused Absence
04TardyTardy




Student

Provide a summary of what the report/function will cover and the logistics around the data collection or reporting. 

The Student Resource is a shared record among all districts. If two districts have the same student in the same year, the last district to trigger data to Ed-Fi is the data stored in Ed-Fi. 

For example, if one district put in a first name of "Robert" and the second district put in a first name of "Rob", the last district to update the student record is what will appear in Ed-Fi and on both District's reports. This is true for all field logic in the Student Resource.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When an enrollment is created and saved for a person.

  • Do not send a student record for an enrollment that is marked as State Exclude or No Show.
  • Do not send a record if enrollment is in a calendar marked as State Exclude.
  • Do not send a record if enrollment is in a school marked as State Exclude.
Put

When any student data is edited for the person in the Data Elements fields below.

  • When the person’s identity record is changed (elements: languages, yearOfEntry, raceAsOfDate, identificationCodes).
  • When one of the person’s household locations is changed (element: addressAsOfDate).
  • When one of the person’s household memberships is changed.
  • When the person’s FRAM Eligibility is changed (elements: schoolFoodServicesEligibilityDate, economicDisadvantaged).
  • When a student's IEP is locked or unlocked and/or a student's disability is changed.
  • When a student's contact information is changed: email, phone number
  • When a student's EL information is changed (elements: limitedEnglishProficiencyDescriptor).
  • When a student's Multiple Birth Status is changed.
  • When a student's Homeless information is changed (elements: characteristics, homelessDescriptor)
  • When a student's program participation is changed (elements: programParticipation).
DeleteStudent records are never deleted because Student records are a shared resource among all districts.


Scope Year Logic

This table describes scope year logic of this object.

Logic

A record will report when an enrollment is created and saved that is aligned to a scoped year.

  • The enrollment must overlap with the scope year to report
Data will only send for the years that have valid configuration.

When using data in Campus that has an effective date, the following logic will be applied to determine the scope year(s) to report the data to.

  • Current Year:  Records will be compared to today's date to determine if the record is eligible to report.
  • Previous Years:  The record's date must be on or before the schools year's end date defined in the School Years editor.  If blank, the default date of 6/30/xxxx is used.
  • Future Years:  The record's date must be on or after the schools year's start date defined in the School Years editor.  If blank, the default date of 7/01/xxxx is used.

When using data in Campus that have start and end dates, the following logic will be applied to determine the scope year(s) to report the data to.

  • Current Year:  The records start date must be on or before today's date and the records end date must be on or after today's date.
  • Previous Years:  The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor.  If blank, the default date of 6/30/xxxx is used.
  • Future Years:  The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor.  If blank, the default date of 7/01/xxxx is used.


Object Data Elements

This table describes data elements sent within the Student resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
studentUniqueIdA unique alpha-numeric code assigned to a student. This element reports the Ed-Fi ID of the student.MPerson.edFiIdCensus >People >Demographics > EdFi ID
personalTitlePrefix

A prefix used to denote the title, degree, position or seniority of the person.

This element is currently not reported or collected.


CN/AN/A
firstName

The reporting student's first name. This is reported from the person's most recent identity record.

If Legal First and Last name fields are blank, the First Name reports.

M

Identity.legalFirstName

Identity.firstName 

Census > People > Identities > Protected Identity Information > Legal First Name

Census > People > Identities > First Name

middleName

The reporting student's middle name. This is reported from the person's most recent identity record.

If Legal First Name and Legal Last Name are populated and Middle Name is blank, a blank value reports.

If all legal name fields are blank, value reports from the Middle Name field.

O

Identity.legalMiddleName

Identity.middleName

Census > People > Identities > Protected Identity Information > Legal Middle Name

Census > People > Identities > Middle Name

lastSurname

The reporting student's last name. This is reported from the person's most recent identity record.

Reports first from the Legal Last Name field. If Legal First and Last name fields are blank, value reports from the  Last Name field.

M

Identity.legalLastName

Identity.lastName

Census > People > Identities > Protected Identity Information > Legal Last Name

Census > People > Identities > Last Name

generation CodeSuffix

An appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III). This is reported from the person's most recent identity record.

Reports first from the Legal Suffix field.

If Legal First Name and Legal Last Name are populated and Legal Suffix is blank, a blank value reports.

If Legal First and Last name fields are blank, value reports from the Suffix field, if populated.

C

Identity.legalSuffix

Identity.suffix

Census > People > Identities > Protected Identity Information > Legal Suffix

Census > People > Identities > Suffix

maidenName

The person's maiden name, if applicable.

This element is currently not reported or collected.


ON/AN/A
sexType

The person's gender. This is reported from the person's most recent identity record.

Reports the Legal Gender from the student's current identity record. If Legal Gender is not populated, the value reports from the student's Gender from the current Identity record.

Reports the following based on the value selected in the Gender or Legal Gender field:

  • Female
  • Male
  • Not Selected (Gender not populated)
M

Identity.legalGender

Identity.gender

Census > People > Identity > Protected Identity Fields > Gender

 Census > People > Identity > Gender

birthDateThe month, day, and year on which an individual was born. The Birth Date from the student's currently Identity record is reported.MIdentity.birthDateCensus > People > Identities > Birth Date
birthCity

The set of elements that capture relevant data regarding a person's birth, including birth date and place of birth.

This element is currently not reported or collected.


ON/AN/A
birthState
AbbreviationType

The abbreviation for the name of the state (within the United States) or extra-state jurisdiction in which an individual was born.

Logic determines the Birth State from the student's current identity record.

  • If blank, look for default value to report
  • Report the Code selected
    • If the Code does not equal an Ed-Fi Code or the Birth State field is blank with no default value, a null value is reported.
CIdentity.birthStateCensus > People > Identities > Birth State
birthCountry
Descriptor

The name of the country in which an individual was born. 

This element is optional and is not reported.


CIdentity.birthCountryCensus > People > Identities > Birth Country
dateEnteredUSFor students born outside of the US, the date the student entered the US. This element reports the value entered in the Date Entered US field.CIdentity.
dateEnteredUS
Census > People > Identities > Date Entered US

multipleBirthStatus


Indicator of whether the student was born with other siblings (i.e., twins, triplets, etc.)

If Multiple Birth Order is not null, and is not 0 or 1, a value of TRUE reports. Otherwise, a value of FALSE reports. 

OEnrollmentMI. multipleBirthCensus > People > Demographics > Multiple Birth Order
profileThumbnail

File name for the ProfileThumbnail photograph.

This element is currently not reported or collected.


ON/AN/A
hispanicLatino
Ethnicity

An indication that the individual traces his or her origin or descent to Mexico, Puerto Rico, Cuba, Central and South America, and other Spanish cultures, regardless of race. This element reports based on the value in the Is the individual Hispanic/Latino? field on the student's identity record.

Report "Is the individual Hispanic/Latino?" from the student's current identity:

  1. If droplist is = Yes, report "true"
  2. If droplist is = No, report "false"
MIdentity.
hispanicEthnicity
Census > People > Identities > Is the individual Hispanic/Latino?
oldEthnicityType

No longer reports data.

ON/AN/A

economic
Disadvantaged


An indication of inadequate financial condition of an individual''s family, as determined by family income, number of family members/dependents, participation in public assistance programs, and/or other characteristics considered relevant by federal, state, and local policy. NEDM Economic Disadvantaged Status.

If schoolFoodServicesEligibilityDescriptor = 1 or 2, reports true. Otherwise, reports false.

OPosEligibility.eligibilityFRAM > Eligibility > Eligibility

schoolFoodServices
EligibilityDescriptor


This descriptor defines indications of a student's level of eligibility for breakfast, lunch, snack, supper and milk programs.

The student's Meal eligibility status is determined  based on:

  • Eligibility School Year must = Scope Year.
  • Eligibility Type must = Meal
  • Eligibility Status must = 1: Eligible Free or 2: Eligible Reduced. Do not report any other status.

If multiple eligibilities are found, A Free status trumps a Reduced status.

Future statuses can be reported if found beyond today's date. Any eligibility within the scope year should be considered.

Reports the code value from the schoolFoodServicesEligibilitytype Type/Descriptor.

CPosEligibility.eligibility

FRAM > Eligibility > Eligibility

System Administration > Resources > School > School History > USDA Programs

limitedEnglish
ProficiencyDescriptor


 An optional globally unique namespace that identifies this descriptor set. If supplied, the author is strongly encouraged to use the Universal Resource Identifier (http, ftp, file, etc.) for the source of the descriptor definition. Best practice is for this source to be the descriptor file itself, so that it can be machine-readable and be fetched in real-time, if necessary. Actual usage of this element for matching descriptors will be system-specific.

  • Reports 01 when the student has an EL Program Status = EL and today's date is on or after the Identified Date
  • If the Identified date is in the future, report 04.
  • Reports the following when the  student has an EL Program Status = Exited EL and the EL Exit Date falls in the monitoring period:
    • If the date is =< 1 year from today's date, then reports 02
    • If the date is =< 2 years from today's date AND > 1 year from today's date, then reports 03
    • Use the logic in S2 of Scope Year Logic to determine prior or future years logic
  • Otherwise, reports 04
ON/AStudent Information > Program Participation > English Learners (EL)
displacementStatus

Indicates a state health or weather related event that displaces a group of students, and may require additional funding, educational, or social services.

This element is currently not reported or collected.


ON/AN/A
loginId

The login ID for the user; used for security access control interface.

This element is currently not reported or collected.


ON/AN/A
citizenshipStatus
Type

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

This element is currently not reported or collected.


ON/AN/A
learningStyle

This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution.

This element is currently not reported or collected.


ON/AN/A
addresses

Reports the student's address(es). Logic reports the most current Primary address that is marked as "Mailing".

  • If more than 1 Primary Address marked as Mailing, report address with most recent Household Membership Start Date
  • Else, report the address with most recent Address Start Date
  • If the Address Location Detail or Household Membership is marked as "Private" the address will not report

This element is an array that reports the following data:

O

HouseholdLocation.
mailing

HouseholdMember.
startDate

Householdlocation.
startDate

Household Addresses > Mailing

Household Membership > Start Date

Household Addresses > Start Date

addressType

All addresses will report as 'Home'. This will report the Ed-Fi mapped value in the Address Type table in the section below.

MN/A N/A 
streetNumberName

The street number and street name or post office box number of an address. 

Reports the Address PO Box + Number + Street + Tag + Prefix + Dir

M 

Address.postOfficeBox

Address.number

Address.street

Address.tag

Address.prefix

Address.dir

Households > Address Info 
apartmentRoomSuiteNumberThe apartment, room, or suite number of an address. Address.aptHouseholds > Address Info > Apt
buildingSiteNumber

The number of the building on the site, if more than one building shares the same address.

This field is optional and does not report.


ON/AN/A
cityThe name of the city in which an address is located. Address.cityHouseholds > Address Info > City
stateAbbreviationTypeThe abbreviation for the state (within the United States) or outlying area in which an address is located.MAddress.stateHouseholds > Address Info > State
postalCodeThe five or nine digit zip code portion of an address.MSAddress.zipHouseholds > Address Info > Zip
nameOfCounty

The name of the county, parish, borough, or comparable unit (within a state) in which an address is located.

This field is optional and does not report.


ON/AN/A
countyFIPSCode

5 digit code consisting of the two digit state code followed by the three digit FIPS code for the county.

This field is optional and does not report.


ON/AN/A
latitude

The geographic latitude of the physical address.

This field is optional and does not report.


ON/AN/A
longitude

The geographic longitude of the physical address.

This field is optional and does not report.


ON/AN/A
beginDate

The first date the address is valid. For physical addresses, the date the person moved to that address.

This field is optional and does not report.


ON/AN/A
endDate

The last date the address is valid. For physical addresses, this would be the date the person moved from that address.

This field is optional and does not report.


ON/AN/A

characteristics




An unordered collection of studentCharacteristics. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution.

M

Homeless
UnaccompaniedYouth

Student Information > Program Participation > Homeless
descriptor

This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program.

  • If Homeless = NOT NULL, report codeValue = ‘Homeless’
  • If Unaccompanied Youth = selected, report codeValue = “Unaccompanied Youth”
M
beginDate

The organization code or name assigning the assessment identification code.

This element is optional and does not report.


ON/AN/A
endDate

A unique number or alphanumeric code assigned to a student by a school, school system, a state, or other agency or entity.

This element is optional and does not report.


ON/AN/A
designatedBy

The person, organization, or department that designated the characteristic.

This element is optional and does not report.


ON/AN/A
cohortYears

An unordered collection of studentCohortYears. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program.

This element is optional and does not report.


ON/AN/A

disabilities




An unordered collection of studentDisabilities. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution.

  1. Reports the Ed-Fi Code from the disabilities entered for the student on a locked IEP or IFSP
  2. If blank, does not report
O

Enrollment.disability1

Enrollment.disability2

Enrollment.disability3

Student Information > General > Enrollments > Special Ed Fields
disabilityDescriptor

This descriptor defines a student's impairment.

  1. Report the mapped Ed-Fi code for the disability.
M

planstate.disability1

planstate.disability2

Special Ed> Documents> Plan> IEP / IFSP > Primary Disability, Secondary Disability
disabilityDiagnosis

A description of the disability diagnosis.

This element is optional and does not report.


ON/AN/A
orderOfDisability

The order by severity of student's disabilities: 1- Primary, 2 - Secondary, 3 - Tertiary, etc.

  1. Report the order of disability based on the disability being reported from above

    1. If Primary Disability, report '1'
    2. if Secondary Disability, report '2'
ON/AN/A
disabilityDetermination SourceType

Key for Disability Determination Source Type

This element is optional and does not report.


ON/AN/A

electronicMails

An unordered collection of studentElectronicMails. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. 

  1. Reports the email address entered for that person
    1. Do not report if Email is marked as "Private"
  2. If blank, does not report
ON/AN/A

identificationCodes


An unordered collection of studentIdentificationCodes. 

This element reports the Local Student Number, if populated.

This element is an array that reports the following data:

O

Person.
studentNumber

Census > People > Demographics > Local Student Number

studentIdentificationSystemType

Reports the short description from the Student Identification Code mapping listed in the table and section below.

  1. Reports ‘State’ if Student State ID = NOT NULL.
  2. Reports ‘District’ if Local Student Number = NOT NULL.
MN/AN/A
Assigning Organization Identification Code 

The organization code or name assigning the assessment identification code.

  1. Reports ‘84000’ if Student State ID = NOT NULL.
  2. Reports State District Number if Local Student Number = NOT NULL.
ON/AN/A
Identification Code

A unique number or alphanumeric code assigned to a student by a school, school system, a state, or other agency or entity.

  1. Report the Student State ID if populated.
  2. Report the Local Student Number if populated
MPerson.
studentNumber
Census > People > Demographics > Local Student Number
identification
Documents

An unordered collection of studentIdentificationDocuments. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution.

This element is currently not reported or collected.


ON/AN/A
indicators

An unordered collection of studentIndicators. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution.

This element is currently not reported or collected.


ON/AN/A
international
Addresses

An unordered collection of studentInternationalAddresses. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution.

This element is currently not reported or collected.


ON/AN/A

languages


An unordered collection of studentLanguages. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program.

Report the Code from the Home Primary Language saved on the student's current identity record.

  1. If blank, do not report this field
  2. If the code does not match an Ed-Fi code, do not report a record
  3. Report default value if saved on the Attribute and the code matches an Ed-Fi code

This element is an array that reports the following data:

OIdentity.
homePrimaryLanguage
Census > People > Demographics > Home Primary Language
languageDescriptor

An unordered collection of studentLanguageUses. Language(s) the individual uses to communicate.

  1. Report the Code from the Home Primary Language saved on the student's current identity record.

    1. If blank, do not report this field.
    2. If the code does not match an Ed-Fi code, do not report a record.
    3. Report default value if saved on the Attribute and the code matches an Ed-Fi code.

2. Report the Code from the Native Language saved on the student's current identity record.


    1. If blank, do not report this field.
    2. If the code does not match an Ed-Fi code, do not report a record.
    3. Report default value if saved on the Attribute and the code matches an Ed-Fi code.

3. If Home Primary Language and Native Language match, report a single languageDescriptor associated with both uses (Home Language, Native Language).

MIdentity.
homePrimaryLanguage
Census > People > Identities > Home Primary Language, Native Language
uses

An unordered collection of studentLanguageUses. Language(s) the individual uses to communicate. 

ON/AN/A
languageUseType

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

  1. If Home Primary Language = NOT NULL, report ‘Home language’.
  2. If Native Language = NOT NULL, report ‘Native language’.
Midentity.homePrimaryLanguageCensus > People > Identities > Home Primary Language, Native Language
otherNames

An unordered collection of studentOtherNames. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution.

This element reports the student's name from a previous Identity record. 

This element is an array that reports the following data:

ON/ACensus > People > Identities
otherNameTypeThis reports the Other Name Type Ed-Fi value mapped in the Other Name Type table in the section below.MN/AN/A
personalTitlePrefix

A prefix used to denote the title, degree, position or seniority of the person. 

This element is not collected or reported.


CN/AN/A
firstNameA name given to an individual at birth, baptism, or during another naming ceremony, or through legal change. MIdentity.firstNameCensus > People > Identities > First Name
middleNameA secondary name given to an individual at birth, baptism, or during another naming ceremony.CIdentity.middleNameCensus > People > Identities > Middle Name
lastSurnameThe name borne in common by members of a family.MIdentity.lastNameCensus > People > Identities > Last Name
generationCodeSuffixAn appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III).CIdentity.suffixCensus > People > Identities > Suffix Name
programParticipations







An unordered collection of studentProgramParticipations. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution.

ON/AN/A
programType

The Program the student is associated with or receiving services from. The Student program must be active within the Scope Year.

The Program must have:

  • State Reported is selected
  • Report the following programtypes if any of the following programs are found:
    • If Code = 3060, report 'Student Retention/Dropout Prevention'
    • If Code = 3500, report 'Community/Junior College Education Program'
    • If Code = , 6011, 6012, 6013, 6014, 6015, 6016, 6017, 6021, 6022, 6023, 6024, 6025, 6026, or 6027, report 'Title I Part A'
    • If Code = 7760, report 'Remedial Education'
    • If Code = 9110, report 'Regular Education'
    • If Code = 9120, report 'Foreign Exchange'
    • If Code = 9130, report 'Immigrant Education'
    • If Code = 9210, report 'Section 504 Placement'
    • If Code = 9220, report 'Alternative Education'
    • If Code = 9222, report 'Compensatory Services for Disadvantaged Students'
    • If Code = 9229, report 'Other'
    • If Code = 9230, report 'Prekindergarten - Full Day'


Military Connections Reporting

  1. If the student has a relationship with a Guardian that has an active Military Connections record within the Scope Year, report 'Other'.
    a. The Status must be Active Duty, Deployed or Active Duty, or Not Deployed.
    b. The Branch must be other than Air National Guard or Army National Guard.
M

Student Information > Program Participation > Programs


Program Admin > Programs > Programs

beginDate

The date the student was associated with the program or service.  Reports the start date of the program.

  1. Report Start Date of program.


O
Student Information > Program Participation > Programs
endDate

The date the Program Participation ended. Reports the end date of the programs.

  1. Report End Date of program
O
Student Information > Program Participation > Programs
designatedBy

The person, organization, or department that made a student designation.

This field is optional and does not report. 

ON/AN/A
enrollmentPercent

(MI-EXT) The full-time equivalency (FTE) that the participant spends in the program reported.

This field is optional and does not report. 

ON/AN/A
programCharacteristics

An unordered collection of studentProgramParticipationProgramCharacteristics. Reflects important characteristics of the Program that a Student participates in, such as categories or particular indications.

This field is optional and does not report.

ON/AN/A
statusesAn unordered collection of studentProgramParticipationStatuses. (MI EXT) To indicate the status of the students participation in the program (i. g. eligible, started, completed, not eligible)ON/ANA
programParticipation StatusDescriptor

The program the student is associated with or receiving services from.

Program Reporting

  1. If Code = 6011, 6012, 6013, 6014, 6015, 6016, 6017, 6021, 6022, 6023, 6024, 6025, 6026, or 6027, report 6010.
  2. Else report Code from program reported.

Military Connections Reporting

  1. Report 9140.


MprogramCodeProgram Admin > Programs > Code
races

An unordered collection of studentRaces. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution.

Logic reports based on the following:

  • Determine the Race/Ethnicity(s) that are checked on the student's current identity record.
    • Use the Identity Race Ethnicity table to determine all of the checkboxes checked for the students current identity id.
  • Do not report if the person does not have a Race/Ethnicity checked.

This element is an array that reports the following data:

O

IdentityRaceEthnicity

and

Racethnicity.raceId

Census > People > Identities > Race/Ethnicity
raceOrderChoiceDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

Always report '1'.

Midentity.homePrimaryLanguageCensus> People> Identities> Home Primary Language, Native Language
raceType

The general racial category which most clearly reflects the individual's recognition of his or her community or with which the individual most identifies.

This reports the Ed-Fi value mapped in the Race Type table in the section below.

M

IdentityRaceEthnicity

and

Racethnicity.raceId

Census > People > Identities > Race/Ethnicity
telephones

An unordered collection of studentTelephones. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program.

  1. Reports the Phone numbers entered in the Personal Contact Information for that person
    1. do not report Phone Number is marked as "Private"
  2. If blank, does not report
  3. See Business Rule S3 in Scope Year logic to determine the eligibility of records
  4. See Array section for data logic for each field
ON/AN/A
visas

An unordered collection of studentVisas. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program.

This element is currently not reported or collected.


ON/AN/A
yearOfEntry

The four-digit calendar year in which the student first attended school in the United States.

Reports the year from the Date Entered US School.

OIdentity.dateEntered USSchoolCensus > People > Demographics > Date Entered US School
raceAsOfDate

The date of the most recent change in Race/Ethnicity.

Reports the Effective Date of the Identity record if there is a change in federal race checkboxes or the hispanic/latino droplist is found on or before the active date/today's date.

O
Census > People > Identity > Effective Date
schoolFoodService EligibilityAsOfDate

The date of the most recent change in the SchoolFoodServicesEligibility.

Reports the Start Date of the FRAM record from the eligibility record selected to report in the schoolFoodServicesEligibilityDescriptor field.

If there are multiple FRAM records with the same status of Free or Reduced, report the earliest Start Date.

OPosEligibility.eligibilityFRAM > Eligibility > Eligibility
addressAsOfDate

The date of the most recent changes to Address.

Reports the Start Date of the current Primary address location that is marked as Mailing. If more than one Primary Address location marked as Mailing, reports the address location with most recent Household Membership Start Date.

Otherwise, reports the address location with most recent Address Start Date. If the Address Location Detail or the Household Membership is marked as Private.

See the Scope Year logic to determine the eligibility of records.


OCensus > Household > Address Location > Start Date
homelessDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

Reports the Ed-Fi Code of Primary Nighttime Residence. If NULL, this field does not report.

Homeless status needs to be active within the Scope Year to report.

If more than one status is found, the most recent status reports.

O
Student Information > Program Participation > Homeless
foodService StatusDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

This field is optional and does not report.

ON/AN/A
medicalNotes

Reports medical notes such as Allergic to Bee Stings for transportation records.

This field is optional and does not report.

ON/AN/A
msdsRaceOrdersAn unordered collection of studentMSDSRaceOrders. (MI EXT) Captures the racial group and order choice for MSDS. Reports the student's race(s).ON/AN/A
etagA unique system-generated value that identifies the version of the resource.ON/AN/A


Type/Descriptor


The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for School Food Services Eligibility Type:

Code in CampusEd-Fi Short DescriptionEd-Fi Description
1Eligible FreeStudent is eligible for free meal/milk program for current school year.
2Eligible ReducedStudent is eligible for reduced price meal program for current school year

This table describes the Ed-Fi Value mapped and reported for Limited English Proficiency Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01LimitedLimited
02Limited Monitored 1Limited Monitored 1
03Limited Monitored 2Limited Monitored 2
04Not LimitedNot Limited

This table describes the Ed-Fi Value mapped and reported for Student Characteristic Descriptors: Only Homeless and Unaccompanied Youth report.

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
AsyleeAsyleeAsylee
Displaced HomemakerDisplaced HomemakerDisplaced Homemaker
Foster CareFoster CareFoster Care
HomelessHomelessHomeless

Immigrant

Immigrant 

Immigrant

MigrantMigrantMigrant
Neglected or DelinquentNeglected or DelinquentNeglected or Delinquent
Parent in MilitaryParent in MilitaryParent in Military
PregnantPregnantPregnant
RefugeeRefugeeRefugee
RunawayRunawayRunaway
Section 504 HandicappedSection 504 HandicappedSection 504 Handicapped
Single ParentSingle ParentSingle Parent
Unaccompanied YouthUnaccompanied YouthUnaccompanied Youth

This table describes the Ed-Fi Value mapped and reported for Disability Descriptors:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
05Cognitive ImpairmentMARSE R340.1705
06Emotional ImpairmentMARSE R340.17069
07Hearing ImpairmentMARSE R340.1707
08Visual ImpairmentMARSE R340.1708
09Physical ImpairmentMARSE R340.1709
10Speech and Language ImpairmentMARSE R340.1710
11Early Childhood Developmental DelayMARSE R340.1711
13Specific Learning DisabilityMARSE R340.1713

14

Severe Multiple Impairment

MARSE R340.1714

15

Autism Spectrum Disorder

MARSE R340.1715

16

Traumatic Brain Injury

MARSE R340.1716

17

Deaf-Blindness

MARSE R340.1717

20

Other Health Impairment

MARSE R340.1709a

22

Legally Blind

Visual acuity of 20/200 or less in the better eye with best correction, a limitation of the field of vision not greater than 20 degrees, or a visual acuity of 20/100 in the better eye with a deteriorating condition.

24

Deaf

Hearing impairment that is so severe that the child is impaired in processing linguistic information through hearing, with or without amplification, which adversely affects a child's educational performance.

This table describes the Ed-Fi Value mapped and reported for Homeless Descriptors:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description

10

Shelters

Supervised publicly or privately operated facilities designed to provide temporary living accommodations. (NOTE: Youth shelters and victim shelters are now included within this category.)

11

Transitional Housing

Temporary accommodations for homeless individuals and families provided as a step toward permanent housing. Residents of transitional housing continue to be considered homeless until they move into permanent housing.

12

Awaiting Foster Care Placement/Temporary Foster Care

A student awaiting foster care placement is defined as homeless under the McKinney-Vento Homeless Assistance Act. Additionally, a student placed in a foster care home is considered temporarily placed, thus eligible for McKinneyVento services, until that student is in the foster care home for a minimum of six (6) months.

13

Doubled-Up

Sharing the housing of other persons because of the loss of housing, economic hardship or a similar reason. This classification requires a case-by-case determination; the determining factor is whether the accommodation is a \"fixed, regular and adequate nighttime residence.\

14

Hotel/Motel

A hotel is a building or commercial establishment where people pay for lodging. A motel is a hotel intended to provide short-term lodging for traveling motorists, usually situated close to a highway and having rooms accessible from the parking area

15

Unsheltered

Includes cars, parks, campgrounds, temporary trailers, abandoned buildings and substandard housing. Substandard housing may be determined by local building codes, community norms and/or as a case-by-case determination as to whether the accommodation is a \"fixed, regular and adequate nighttime residence. (NOTE: Because Federal Emergency Management Agency (FEMA) trailers are considered temporary trailers, the primary nighttime residence category for FEMA trailers would be Unsheltered.

This table describes the Ed-Fi Value mapped and reported for Race Order Choice Descriptors:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description

1

First

First

2SecondSecond
3ThirdThird
4FourthFourth
5FifthFifth
6SixthSixth

This table describes the Ed-Fi Value mapped and reported for Race Type Descriptors:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description

214-001

American Indian – Alaskan Native

American Indian – Alaskan Native

214-002

Asian

Asian

214-003

Black - African American

Black - African American

214-004

Native Hawaiian - Pacific Islander

Native Hawaiian - Pacific Islander

214-005

White

White

214-006

Choose Not to Respond

Choose Not to Respond

214-007

Other

Other

Not Selected

Not Selected

Not Selected

This table describes the Ed-Fi Value mapped and reported for Program Participation Status Descriptors:

Ed-Fi Code Value

Short Description

Description

3060Section 31a At RiskSection 31a At Risk
3500Early/Middle College ParticipantEarly/Middle College Participant
6010Title I Targeted Assistance ProgramTitle I Targeted Assistance Program
776021st Century Community Learning Center Program (21st CCLC)21st Century Community Learning Center Program (21st CCLC)
9110Out-of-State ResidentOut-of-State Resident
9120International StudentInternational Student
9130ImmigrantImmigrant
9210Section 504Section 504
9220Alternative EducationAlternative Education
9222Sec. 6(4)(l)(ii) Pupil Count ExceptionSec. 6(4)(l)(ii) Pupil Count Exception
9229Seat-Time Waiver ParticipantSeat-Time Waiver Participant
9230Developmental KindergartenDevelopmental Kindergarten

This table describes the Ed-Fi Value mapped and reported for Program Type Descriptors:

Ed-Fi Code ValuedescriptionshortDescription
212-004BilingualBilingual
212-005Bilingual SummerBilingual Summer
212-006Career and Technical EducationCareer and Technical Education
212-016English as a Second Language (ESL)English as a Second Language (ESL)
212-021Gifted and TalentedGifted and Talented
212-049Special EducationSpecial Education
212-054Title I Part ATitle I Part A
212-001Adult/Continuing EducationAdult/Continuing Education
212-002Alternative EducationAlternative Education
212-003AthleticsAthletics
212-007Cocurricular ProgramsCocurricular Programs
212-008College PreparatoryCollege Preparatory
212-009Community Service ProgramCommunity Service Program
212-010Community/Junior College Education ProgramCommunity/Junior College Education Program
212-011Compensatory Services for Disadvantaged StudentsCompensatory Services for Disadvantaged Students
212-012Counseling ServicesCounseling Services
212-017Even StartEven Start
212-019Extended Day/Child Care ServicesExtended Day/Child Care Services
212-022Head StartHead Start
212-023Health Services ProgramHealth Services Program
212-024High School Equivalency Program (HSEP)High School Equivalency Program (HSEP)
212-026IDEAIDEA
212-027Immigrant EducationImmigrant Education
212-029Indian EducationIndian Education
212-030International BaccalaureateInternational Baccalaureate
212-034Library/Media Services ProgramLibrary/Media Services Program
212-035Magnet/Special Program EmphasisMagnet/Special Program Emphasis
212-036Migrant EducationMigrant Education
212-037Neglected and Delinquent ProgramNeglected and Delinquent Program
212-038Optional Flexible School Day Program (OFSDP)Optional Flexible School Day Program (OFSDP)
212-039OtherOther
212-045Regular EducationRegular Education
212-046Remedial EducationRemedial Education
212-048Service LearningService Learning
212-050Student Retention/Dropout PreventionStudent Retention/Dropout Prevention
212-051Substance Abuse Education/PreventionSubstance Abuse Education/Prevention
212-052Teacher Professional Development/MentoringTeacher Professional Development/Mentoring
212-053Technical PreparatoryTechnical Preparatory
212-057Vocational EducationVocational Education
212-013District-Funded GEDDistrict-Funded GED
212-018Expelled EducationExpelled Education
212-028Independent StudyIndependent Study
212-047Section 504 PlacementSection 504 Placement
212-014Early Head StartEarly Head Start
212-015Early Intervention Services Part CEarly Intervention Services Part C
212-020Fee For ServiceFee For Service
212-025Home VisitingHome Visiting
212-043Preschool Special EducationPreschool Special Education
212-044Public PreschoolPublic Preschool
212-032Kindergarten - Full DayKindergarten - Full Day
212-033Kindergarten - Half DayKindergarten - Half Day
212-031Kindergarten - Extended DayKindergarten - Extended Day
212-041Prekindergarten - Full DayPrekindergarten - Full Day
212-042Prekindergarten - Half DayPrekindergarten - Half Day
212-040Prekindergarten - Extended DayPrekindergarten - Extended Day
212-055Title I Part D Subpart 1Title I Part D Subpart 1
212-056Title I Part D Subpart 2Title I Part D Subpart 2
212-058Foreign ExchangeForeign Exchange
ECAPECAPECAP
Part BPart B Section 619Part B Section 619
Part CPart CPart C
POCPurchase of CarePurchase of Care



Student Special Education Program Association

This association represents the Special Education program(s) that a student participates in or receives services from. The association is an extension of the StudentProgramAssociation particular for Special Education programs.

Object Triggering Data


ActionTrigger
Post

When a student in the year and calendar reporting has a locked IEP (print format miIEP) or locked IFSP (print format miIFSP%).

  • An IEP trumps an IFSP if more than one document is found with the same start date.
  • The IEP has a Special Ed Program mapped to a state code with an Ed-Fi Code.
  • The IFSP has an Early Intervention Srrvice mapped to a state code with an Ed-Fi Code.
  • The IEP must overlap the enrollment.
  • If the student has multiple enrollments that are overlapping in the same school and year, a record reports based on the student's enrollment service  type.
    • P: Primary
    • S: Partial
    • N: Special Ed
  •  If the student only has one enrollment, a record reports regardless of Service Type.
  • A record is not sent for an enrollment that is marked as State Exclude or No Show.
  • A record is not set if the enrollment is in a calendar marked as State Exclude.
  • A record is not sent if the enrollment is in a school marked as State Exclude.
  • Fields in the Evaluation/ESR do not trigger a Delete/Post. The user is expected to resync if the data is missing or updated.
Post

When a new enrollment record is createdfor a student who has an active IEP/IFSP.

  • The enrollment start date must be after the IEP/IFSP start date.
  • The IEP/IFSP end date must be null or after the enrollment start date.
Delete/Post

When any part of the natural key is chyanged.

When a SPED entry date is changed.

Delete/Post

When any field that is not part of the natural key is changed, including the following:

  • endDate
  • reasonExitedDescriptor
  • section52FTE
  • section53FTE
DeleteWhen an IEP/IFSP is deleted for a student.
DeleteWhen a SPEd entry date is changed for a student.
DeleteWhen all overlapping enrollments are deleted for a school.
DeleteWhen an IEP/IFSP is unlocked.


Scope Year Logic

This table describes the scope year logic of this object.

Logic

A record will report for each year where an active IEP or IFSP record exists.

  • The IEP/IFSP Start or End Date must occur within the Scope Year.
  • The IEP/IFSP must have at least one Special Ed Program or Early Intervention Service with Start or End Date that occurs within the Scope Year.
  • If the school year start date and end date are null, value of 07/01/XXXX (start date) and 06/30/XXXX (end date) report.


Object Data Elements

Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
educationOrganizationReference

A reference to the related EducationOrganization resource.

Reports the state school number. If the student has multiple enrollments, values report in the following order: 

  • Primary
  • Partial
  • Special Ed
MSchool.stateSchool NumberSystem Administration > Resources > School Information > State School Number
programReference

A reference to the related Program resource. Reports the Special Education Program reference.

MN/AN/A
studentReferenceA reference to the related Student resource.Reports the data that is part of the natural key for the student resource.MN/AN/A
beginDateThe month, day, and year on which the Student first received services. Reports the start date of the IEP/IFSP.M

Plan.startDate

Enrollment.startDate

Student Information > Special Ed > General > Documents > Plan > Education Plan Editor > Start Date

endDate

The month, day, and year on which the Student exited the special education program or stopped receiving services.

Reports the Special Ed Exit Date. If there are multiple resources for the student, reports in the resource with the most recent Begin Date prior to the Exit Date.   

OEnrollment.sped ExitDateStudent Information > General > Enrollment > Special Ed Fields > Exit Date
reasonExitedDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

Reports the mapped code for the Special Ed Exit Reason.


OEnrollment.sped ExitReasonStudent Information > General > Enrollments >Special Ed Fields > Exit Reason
servedOutsideofRegularSession

Indicates whether the student received services during the summer session or between sessions.

This field is optional and does not report.


ON/AN/A
enrollmentStatus


This field is optional and does not report.


ON/AN/A
partCTransitionTimelinessDescriptor

This descriptor holds the description of the timeliness of the IEP by the students's third birthday for all students referred by Part C as potentially eligible for Part B.

Reports the Part C Transition Timeliness value.

OEvaluation. timelinessStudent Information > Special Education > Documents > Evaluation > Evaluation Header > Part C Transition Timeliness
resultOfInitialIEPDescriptor

This descriptor holds the description of the outcome of the initial IEP determining if the student is eligible or ineligible for special education programs and services.

Reports the Initial Evaluation Result value.

OEvaluation. evalResultStudent Information > Special Education > Documents > Evaluation > Evaluation Header > Initial Eval Result
specialEducationSettingDescriptor

This descriptor defines the major instructional setting (more than 50 percent of a student's special education program).

Reports the student's Special Education Setting value.

OPlanState. specialEdsetting

Student Information > General > Enrollments > Special Ed Fields > Special Ed Setting

Student Information > Special Education > Documents > IEP > Special Ed Setting

timelinessOfInitialIEPDescriptor

This descriptor holds the description of the timeliness status for the evaluation of eligibility.

Reports the Evaluation Compliance value.

OEvaluation. evalComplianceStudent Information > Special Education > Documents > Evaluation > Evaluation Header > Evaluation Compliance
typeOfPlanDescriptor

Indicates the type of plan under which a child is receiving services.

  • If plan = IFSP, reports 01
  • If plan = IEP, reports 02
  • If plan = NPSP, reports 03

printedFormat: ‘miIEP%’, 'miNPSP%', 'miIFSP%'

OPlanType.printedFormatStudent Information > Special Education > Documents
ideaEligibility

Indicator of the eligibility of the student to receive special education services according to the Individuals with Disabilities Education Act (IDEA).

This field is optional and does not report.


 ON/AN/A
specialEducationHoursPerWeek

The number of hours per week for special education instruction and therapy.

This field is optional and does not report.


ON/AN/A
schoolHoursPerWeek

Indicate the total number of hours of instructional time per week for the school that the student attends.

This field is optional and does not report.


ON/AN/A
multiplyDisabled

Indicates whether the Student receiving special education and related services has been designated as multiply disabled by the admission, review, and dismissal committee as aligned with federal requirements.

This field is optional and does not report.


ON/AN/A
medicallyFragile

Indicates whether the Student receiving special education and related services is: 

  • in the age range of birth to 22 years, and 
  • has a serious, ongoing illness or a chronic condition that has lasted or is anticipated to last at least 12 or more months or has required at least one month of hospitalization, and that requires daily, ongoing medical treatments and monitoring by appropriately trained personnel which may include parents or other family members, and 
  • requires the routine use of medical device or of assistive technology to compensate for the loss of usefulness of a body function needed to participate in activities of daily living, and 
  • lives with ongoing threat to his or her continued well-being. Aligns with federal requirements.

This field is optional and does not report. 


ON/AN/A
lastEvaluationDate

The date of the last special education evaluation.

This field is optional and does not report. 


ON/AN/A
iepReviewDate

The date of the last IEP review.

This field is optional and does not report. 


ON/AN/A
iepBeginDateReports the start date of the IEP/IFSP.OPlan.startDateStudent Information > Special Education > General > Documents > IEP/IFSP > Start Date
iepEndDateReports the end date of the IEP/IFSP.OPlan.endDateStudent Information > Special Education > General > Documents > IEP/IFSP > End Date
planDate

The date of the notice/offer of a Free Appropriate Public Education (FAPE) associated with the student's most recent individualized education program (IEP).

  • If reporting from an IEP, reports Offer of a FAPE date. 
  • If reporting from an IFSP, reports the Initial IFSP date.  
  • If Initial IFSP is not found, reports the Annual IEP/IFSP Date 
  • If Annual IEP/IFSP not found, reports the Other Review Date
O

SEPlan.fapeOfferDate

SEPlan. evaluationDate


Student Information > Special Education > General > Documents > IEP/IFSP > Offer of a FAPE, Initial Date
section52FTEThe full-time equivalency (FTE) for which the student is eligible for special education programs or services provided only to students with disabilities who do not qualify for Section 52 membership.OEnrollment.fteSection52Student Information > General > Enrollments > Special Ed Fields > FTE Section 52
section53FTEThe full-time equivalency (FTE) for which the student is eligible for special education programs or services provided only to students with disabilities who do not qualify for Section 53 membership.OEnrollment.fteSection53Student Information > General > Enrollments > Special Ed Fields > FTE Section 53
dateOfParentalConsentThe date on which the entity received the signed Parental Consent to Evaluate form. It is the beginning of the timeline for completion of the initial IEP.OEvaluation.consentDateStudent Information > Special Education > General > Documents > IEP/IFSP > Consent Date
daysBeyondTimeline

The number of calendar days that the evaluation and completion of the initial IEP went beyond the 30 school-day timeline or agreed-upon written extension.

Reports from most recent ESR prior to or on the Start Date of the IEP. Use ESR Consent Date to determine.

  • If Extension Days is greater than zero, reports DaysBeyondTimeline with corresponding integer.
  • If Extension Days is zero or NULL, this field is not reported.
OEvaluation.extensionDaysStudent Information > General > Special Ed > Documents > Evaluation > Extension Days
initialIEPCompletionDate

The completion of an initial individualized education program (IEP) is the date on the notice of the offer of a free appropriate public education (FAPE).

Reports from the most recent ESR prior to or on the start date of the IEP. Use the ESR Consent Date to determine.

OEvaluation.fapeOfferDateStudent Information > General > Special Ed > Documents > Evaluation > Offer of a FAPE
additionalPlanDateIf a student has had more than plan conducted since s/he was last reported, districts may utilize this characteristic to report the additional plan dates between the previous and current plan. 
N/AN/A
services



An unordered collection of studentProgramAssociationServices. Indicates the services being provided to the student by the program. This field is an array.ON/AN/A
serviceDescriptor

Reports the ID of the Service Descriptor.

  1. Report the Ed-Fi Code associated with the assigned Special Education Program service.
  2. Service must be active at least one day in the Scope Year to report.
MPlanService. stateCode

Student Information > Special Education > Documents > IEP/NPSP > Special Ed Program


primaryIndicator

Reports true if the service is primary.

This field is optional and does not report. 


ON/AN/A
serviceBeginDate

Reports the first date the student was in this option for the school year.


MPlanServiceProvided .startDateStudent Information > Special Education > Documents > IEP > Start Date
serviceEndDateReports the last date the student was in this option for the current school year.OPlanServiceProvided. endDateStudent Information > Special Education > Documents > IEP > End Date
programSupports

An unordered collection of studentSpecialEducationProgramAssociationProgramSupports. (MI EXT) Support services student receives through program. This field is an array.

ON/AN/A
programSupportDescriptor

Reports the ID of the service Descriptor.

  • Reports the mapped code associated with the assigned Special Education Program Related service.
  • The service must be active at least one day in the Scope Year to report.
OPlan.relatedServicesStudent Information > General > Special Education > Documents > IEP > Related Services
serviceProviders

An unordered collection of studentSpecialEducationProgramAssociationServiceProviders. The staff providing Special Education services to the student. This field is an array.

This field is optional and does not report. 


OPlanService. stateCodeN/A


Type/Descriptors


The highlighted column indicates the reported valued.

Service Descriptors

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description

110

Programs for Mild Cognitive Impairment

Programs for Mild Cognitive Impairment

120

Programs for Moderate Cognitive Impairment

Programs for Moderate Cognitive Impairment

130

Programs for Severe Cognitive Impairment

Programs for Severe Cognitive Impairment

140

Programs for Emotional Impairment

Programs for Emotional Impairment

150

Programs for Learning Disabled

Programs for Learning Disabled

160

Programs for Hearing Impairment

Programs for Hearing Impairment

170

Programs for Visual Impairment

Programs for Visual Impairment

180

Programs for Physical or Other Health Impairment

Programs for Physical or Other Health Impairment

190

Programs for Severe Multiple Impairment

Programs for Severe Multiple Impairment

191

Early Childhood Special Education (Classroom) Program

Early Childhood Special Education (Classroom) Program

192

Programs for Severe Language Impairment

Programs for Severe Language Impairment

193

Programs for Autism Spectrum Disorder

Programs for Autism Spectrum Disorder

194

Elementary or Secondary-Level Resource Program

Elementary or Secondary-Level Resource Program

270

Early Childhood Special Education Services

Early Childhood Special Education Services

Program Support Descriptor

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description

200

Teacher Consultant (T.C.) Autism Spectrum Disorder

Teacher Consultant (T.C.) Autism Spectrum Disorder

210

T.C. Mentally Impaired

T.C. Mentally Impaired

220

T.C. Emotionally Impaired

T.C. Emotionally Impaired

230

T.C. Learning Disabled

T.C. Learning Disabled

240

T.C. Hearing Impaired

T.C. Hearing Impaired

250

T.C. Visually Impaired

T.C. Visually Impaired

261

T.C. Physical Impairment

T.C. Physical Impairment

262

T.C. Other Health Impairment

T.C. Other Health Impairment

280

Homebound/Hospitalized

Homebound/Hospitalized

290

Speech and Language Impaired

Speech and Language Impaired

291

Adaptive Physical Education

Adaptive Physical Education

310

School Social Worker

School Social Worker

320

School Psychologist

School Psychologist

360

Occupational Therapy

Occupational Therapy

370

Physical Therapy

Physical Therapy

383

Music Therapy

Music therapy

390

Art Therapy

Art Therapy

400

Audiological Services

Audiological Service

406

Interpreter for the Deaf

Interpreter for the Deaf

410

Recreation Service

Recreation Service

440

Special Transportation

Special Transportation

450

School Health Services

School Health Services

460

Rehabilitation Counseling Services

Rehabilitation Counseling SErvices

470

Orientation & Mobility Services

Orientation & Mobility Services

480

Worksite – Based Learning

Worksite – Based Learning

490

Community Training/Vocational Education (General Education)

Community Training/Vocational Education (General Education)

491

Special Needs (Adapted Vocational Ed.)

Special Needs (Adapted Vocational Ed.)

492

Individual Vocational Education

Individual Vocational Education

493

Community Training/Vocational Education (Special Education)

Community Training/Vocational Education (Special Education)

Reason Exited Descriptor

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description

30

IEP team determined student no longer in need of special education service

The child or student was exited from special education programs and/or services after the IEP team determined that s/he no longer met the criteria to be eligible for special education programs or services.

31

Parent revoked consent for student to receive special education services

The student was exited from special education programs or services because his/her parent or guardian revoked his/her consent for the student to participate in special education programs and/or services.



Student Title I TAS Program Association

This associations represents the Title I TAS Program(s) in which a student participates or from which services are received.

Object Triggering Data


ActionTrigger
Post

When a student is associated with one or more programs that have:

  • State Reported is selected.
  • Code is: 6011, 6012, 6013, 6014, 6015, 6016, 6017, 6021, 6022, 6023, 6024, 6025, 6026, 6027, or 6028

If the student has Title 1 program records with a Location = NOT NULL for a School in which they are enrolled, report a record.

If the student has Title 1 program records with a Location = NOT NULL for a School in which they are not enrolled, do not report a record.

If the student has Title 1 program records with a Location = NULL, report a record for each school they are enrolled.

Do not send a student record for an enrollment that is marked as State Exclude or No Show.

Do not send a record if enrollment is in a calendar marked as Exclude.

Do not send a record if enrollment is in a School marked as Exclude.

Delete/Post

When any part of the natural key is changed.

When Start Date is changed.

DeleteWhen Location is changed from NULL to a school, delete any school records not associated with the selected school.
DeleteWhen Location is changed from one school to another school, delete any school records not associated with the selected school.
PostWhen Location is changed from a school to NULL, post records for any enrollment not associated with the changed school.
Put

When any field that is not part of the natural key is changed, including the following:

  • services
  • programSupports
DeleteWhen all Title 1 programs are deselected for a student
DeleteWhen a Start Date is changed for a student
DeleteWhen all overlapping enrollments are deleted for a school.


Scope Year Logic

This table describes the scope year logic of this object.

Logic

A record will report for each year where an active Title I program record exists.

  • Student Program  must be associated with the school.
  • Student Program must be active within the Scope Year
  • If the school year start date and end date are null, value of 07/01/XXXX (start date) and 06/30/XXXX (end date) report.


Object Data Elements

Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
educationOrganizationReference

A reference to the related EducationOrganization resource.

Reports the state school number. If the student has multiple enrollments, values report in the following order: 

  • Primary
  • Partial
  • Special Ed
MSchool.stateSchoolNumberSystem Administration > Resources > School Information > State School Number
programReference

A reference to the related Program resource. Reports the Special Education Program reference.

MN/AN/A
studentReferenceA reference to the related Student resource.Reports the data that is part of the natural key for the student resource.MN/AN/A
beginDateThe month, day, and year on which the Student first received services. Reports the start date of the program.M


Student Information > Program Participation > Programs > Start Date

endDate

The month, day, and year on which the Student exited the program or stopped receiving services. Reports the end date.



O
Student Information > Program Participation > Programs > End Date
reasonExitedDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

Reports the Special Ed Exit Reason.

If there are multiple resources for the student, reports the most recent Begin Date prior to the Exit Date.

This field is optional and does not report.


OEnrollment.spedExitReasonStudent Information > General > Enrollments >Special Ed Fields > Exit Reason
servedOutsideofRegularSession

Indicates whether the student received services during the summer session or between sessions.

This field is optional and does not report.


ON/AN/A
enrollmentStatus


This field is optional and does not report.


ON/AN/A
services



An unordered collection of studentProgramAssociationServices. Indicates the services being provided to the student by the program. This field is an array.ON/AN/A
serviceDescriptor

The  ID of the Service Descriptor.

Reports the Code from the program:

  1. State Reported must be selected
  2. Code must be 6011, 6012, 6013, 6014, 6015, 6016, or 6017
M

Student Information > Program Participation > Programs

primaryIndicator

Reports true if the service is primary.

This field is optional and does not report. 


ON/AN/A
serviceBeginDate

The first date the student was in this option for the school year.

Reports the program Start Date.


MN/AStudent Information > Program Participation > Programs > Start Date
serviceEndDate

The last date the student was in this option for the current school year.

Reports the program End Date.


ON/AStudent Information > Program Participation > Programs > End Date
programSupports

An unordered collection of studentTitleITASPRogramAssociationProgramSupports. This field is an array.


ON/AN/A
programSupportDescriptor

The ID of the Service Descriptor. State Reported must be marked.


Reports the mapped code for the Program Support Descriptor.
OEnrolmentMI.title1Counseling, title1SocialWork, etc. Student Information > Program Participation > Programs


Type/Descriptors


The highlighted column indicates the reported valued.

This table descriptions the Service Descriptors.

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
6011Reading/Language ArtsSupplemental instruction provided to the student in reading or language arts and funded by Title I.
6012English (ESL) for LEP StudentsSupplemental instruction provided to an English-language learner (ESL, EL) to improve his/her English-language skills and funded by Title I.
6013MathematicsSupplemental instruction provided to the student in mathematics and funded by Title I.
6014ScienceSupplemental instruction provided to the student in science and funded by Title I.
6015Social StudiesSupplemental instruction provided to the student in social studies and funded by Title I.
6016Vocational/CareerSupplemental instruction provided to the student in vocational or career development and funded by Title I.
6017OtherSupplemental instruction provided to the student in an academic area not covered by another category and funded by Title I.

This table describes the Program Support Descriptors.

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
6021Supporting Guidance/CounselingA certified school counselor providing additional supplementary guidance and counseling to eligible students.
6022Social Work, Outreach/AdvocacyA certified school social worker hired to provide one-on-one or small group supplementary support.
6023Prevention EducationA supplementary support program approved in the Consolidated Application.
6024HealthA school nurse hired to provide supplemental health services; does not include immunization, medication or health checks.
6025DentalOnly as all other resources are exhausted.
6026Eye CareOnly as all other resources are exhausted.
6027Pupil TransportationOnly for Title I program and services.
6028OtherTAS service that does not fall within one of the other categories.



A unique number or alphanumeric code assigned to a restraint event by a school, school system, a state, or other agency or entity.