Michigan Ed-Fi Data - v2.0

Last Modified on 07/01/2024 8:25 am CDT

Tool Search: 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.

For more information about proper Ed-Fi setup for Michigan users, see the following:

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.

Product Information > Michigan Ed-Fi Data > object triggering logic.png

The following table lists the definition of each potential Action:

Action	Definition
Post	This will insert new records and data within Ed-Fi.
Put	This action will update existing information within Ed-Fi.
Get	This action is used for items that are pre-loaded. For example, Courses and Programs.
Delete	This 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.

Product Information > Michigan Ed-Fi Data > object data elements.png

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.

Product Information > Michigan Ed-Fi Data > type description.png

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.

Action

Trigger

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

Delete

Assessments 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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource.

N/A

assessmenFamilyReference

A reference to the related AssessmentFamily resource.

This field is optional and does not report.

N/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

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.

N/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.

N/A

version

The version identifier for the assessment.

Always reports 1.

N/A

categoryDescriptor

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

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

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.

N/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.

N/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.

N/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.

N/A

nomenclature

Reflects the common nomenclature for an element.

This field is optional and does not report.

N/A

periodDescriptor

The ID of the Assessment Period Descriptor.

This field is optional and does not report.

N/A

namepsace

Namespace for the Assessment.

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

N/A

contentStandrd

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

This field is optional and does not report.

N/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.

N/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.

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.

Always report 'District'.

identificationCode

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

Always report 'District'.

assigningOrganizationIdentificationCode

The organization code or name assigning the assessment identification code.

This field is optional and does not report.

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.

N/A

performanceLevels

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

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

This field is optional and does not report.

N/A

programs

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

This field is optional and does not report.

N/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.

N/A

sections

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

This field is optional and does not report.

N/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 Value	Ed-Fi Short Description
01	AEPS
02	FULL Battelle
03	Battelle SCREENER
04	Brigance
05	Carolina
06	COR
07	Creative Curriculum
08	LAP-3
09	Part C Exit Tool: AEPS
10	Part C Exit Tool: Battelle
11	Part C Exit Tool: Bayley
12	Part C Exit Tool: Brigance
13	Part C Exit Tool: Carolina
14	Part C Exit Tool: EIDP
15	Part C Exit Tool: E-LAP
16	Part C Exit Tool: HELP
17	Part C Exit Tool: IDA
18	Part C Exit Tool: Other
19	Teaching Strategies GOLD
20	COR Advantage
21	BRIGANCE 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 Value	Ed-Fi Short Description
A	AEPS
B	E-LAP
C	HELP
D	EIDP
E	Brigance
F	Other
G	Carolina
H	IDA
I	Battelle
J	Bayley

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

Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
Composite	Composite	Composite
Critical Reading	Critical Reading	Critical Reading
English	English	English
English Language Arts	English Language Arts	English Language Arts
Reading	Reading	Reading
Mathematics	Mathematics	Mathematics
Life and Physical Sciences	Life and Physical Sciences	Life and Physical Sciences
Social Sciences and History	Social Sciences and History	Social Sciences and History
Social Studies	Social Studies	Social Studies
Science	Science	Science
Fine and Performing Arts	Fine and Performing Arts	Fine and Performing Arts
Foreign Language and Literature	Foreign Language and Literature	Foreign Language and Literature
Writing	Writing	Writing
Physical, Health, and Safety Education	Physical, Health, and Safety Education	Physical, Health, and Safety Education
Career and Technical Education	Career and Technical Education	Career and Technical Education
Religious Education and Theology	Religious Education and Theology	Religious Education and Theology
Military Science	Military Science	Military Science
Other	Other	Other
English Language Acquisition	English Language Acquisition	English Language Acquisition
0	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.
1	English language and literature	English language and literature
2	Mathematics	Mathematics
3	Life and Physical Sciences	Life and Physical Sciences
4	Social Sciences and History	Social Sciences and History
5	Fine and Performing Arts	Fine and Performing Arts
6	Foreign language and Literature	Foreign language and Literature
7	Religious Education and Theology	Religious Education and Theology
8	Physical, Health and Safety Education	Physical, Health and Safety Education
9	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.

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.

Action

Trigger

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.

Put

When 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 Element	Description			Campus Database Field	Campus GUI Location
id	The 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		M	School.entityID	System Administration > Resources > School > Entity ID
date	Month, day, and year of the date being reported.		M	Day.date	System 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/A	N/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.	O	N/A	N/A
_etag	A unique system-generated value that identifies the version of the resource. This does not report.		O	N/A	N/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 Value	Ed-Fi Short Description	Ed-Fi Description
01	Instructional Day	Instructional Day
02	Teacher only day	Teacher only day
03	Holiday	Holiday
04	Make-up day	Make-up day
05	Weather Day	Weather Day
06	Student late arrival/early dismissal	Student late arrival/early dismissal
07	Emergency day	Emergency day
08	Strike	Strike
09	Other	Other

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.

Action	Trigger
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.
Post	When a Period Schedule Name or Period Name is changed and saved.
Delete	When a Period Schedule Name or Period Name is changed and saved.
Delete	When 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 Element	Description		Campus Database Field	Campus GUI Location
id	The 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	M	School.number	System 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.	O	N/A	N/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.

Action	Trigger
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/Post	When the Local Course number is changed.
Delete/Post	If 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.
Delete	When a section is deleted.
Delete	When a section schedule placement is removed and saved.
Delete/Post	When 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 Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
courseReference	Reports the following elements that are part of the Natural Key for the Course resource: educationOrganizationReference code	M	N/A	N/A
schoolReference	Reports the following elements that are part of the Natural Key for the Schools resource: EntityID	M	School.entityID	System Administration > Resources > School > Entity ID
sessionReference	Reports the following elements that are part of the Natural Key for the Sessions resource: Term Descriptor will report based on section schedule placement of the sections of the course. 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/A	N/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.	M	Course.number	Scheduling > Course > Number
localCourseTitle	The descriptive name given to a course of study offered in the school, if different from the CourseTitle.	O	Course.name	Scheduling > Course > Name
InstructionalTimePlanned	The 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.	O	N/A	N/A
curriculumUsed	An unordered collection of courseOfferingCurriculumUseds. This entity represents an offering of a course by school during a session, representing the course catalog of available courses.	O	N/A	N/A
etag	A unique system-generated value that identifies the version of the resource.	O	N/A	N/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.

Action

Trigger

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/Delete

When 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 Element

Description

Campus Database Field

Campus GUI Location

courseReference

The unique identifier of the resource.

Natural Key fields for the Course resource:

Education Organization Reference
Code

N/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.

N/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

N/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:

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

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.

N/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.

N/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.

Transcriptcredit.
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.

N/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.

N/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.

Transcriptcredit.
creditsEarned

Student Information > General > Transcripts > Earned

whenTakengrade
LevelDescriptor

Student's grade level at time of course.

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.

N/A

Student 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.

N/A

finalLetterGradeEarned

The final letter grade earned for the course.

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

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

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:

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

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.

N/A

courseTitle

Reports the name of the course completed.

Report the Course Name from the transcript record.

Transcriptcourse.
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.

N/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.

N/A

additionalCreditType

The type of credits awarded or earned for the course.

Reports Dual Credit.

N/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.

The grading task must have State Reported = Selected and a Code = CC64b.
The grading task is determined from the sectionID found on the transcript record.

N/A

Grading & 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 Description	Ed-Fi Description
Pass	Pass
Fail	Fail
Incomplete	Incomplete
Withdrawn	Withdrawn

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

Ed-Fi Code	Ed-Fi Short Description	Ed-Fi Description
124-001	Advanced Placement	Advanced Placement
124-002	Career and Technical Education	Career and Technical Education
124-003	Dual credit	Dual credit
124-004	International Baccalaureate	International Baccalaureate
124-005	Other	Other

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.

Action	Trigger
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/Insert	If 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
Delete	When 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 Element	Description			Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.		M	N/A	N/A
education Organization Reference	A reference to the related EducationOrganization resource. Reports the school number associated with the course.		M	N/A	N/A
code	The code that identifies the organization of subject matter and related learning experiences provided for the instruction of students.		M	Course.number	Scheduling > 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).		M	Course.name	Scheduling > Course > Name
numberOfParts	The 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.		M	course.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.		O	Course.SCED	Scheudling > 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.		O	N/A	N/A
dateCourseAdopted	The date the district adopted the course. This field does not report.		O	N/A	N/A
highSchoolCourse Requirement	An indication that this course credit is required for a high school diploma. This field does not report.		O	N/A	N/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.		O	N/A	N/A
definedByType	Specifies whether the course was defined by the SEA, LEA, school or national organization. This field does not report.		O	N/A	N/A
minimumAvailable CreditType	The type of credits or units of value awarded for the completion of a course. This field does not report.		O	N/A	N/A
minimumAvailable CreditConversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.		O	N/A	N/A
minimumAvailable Credit	The minimum amount of credit available to a student who successfully completes the course. This field does not report.		O	N/A	N/A
maximumAvailable CreditType	The type of credits or units of value awarded for the completion of a course. This field does not report.		O	N/A	N/A
maximumAvailable CreditConversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units. This field does not report.		O	N/A	N/A
maximumAvailable Credit	The maximum amount of credit available to a student who successfully completes the course. This field does not report.		O	N/A	N/A
careerPathwayType	The career cluster or pathway representing the career path of the Vocational/CTE concentrator. This field does not report.		O	N/A	N/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.		O	N/A	N/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.		O	N/A	N/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.		O	N/A	N/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.		O	N/A	N/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.	O	N/A	N/A
	assigningOrganization IdentificationCode	The organization code or name assigning the staff Identification Code. This field does not report.	O	N/A	N/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.	M	Course.scedCourseID	Scheduling > 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.		O	Course.honorsCode	Scheduling > 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.		O	N/A	N/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.		O	N/A	N/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.		O	N/A	N/A
etag	A unique system-generated value that identifies the version of the resource.		O	N/A	N/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 Value	Ed-Fi Short Description	Ed-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
00	Other	Other
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.

Action	Trigger
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.
Delete	When a resolution is deleted.
Delete	When all resolutions are removed from the incident.
Delete	When all Behavior Events are removed from the Incident.
Delete	When the student's Role changes to anything other than Offender or Participant.
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 Discipline Action resource.

Data Element	Description			Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.		M	N/A	N/A
assignmentschool Reference	A reference to the related School resource This is optional and does not report.		O	N/A	N/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		M	School.entityID	System 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		M	Person.edfiID	Census > People > Demographics > EdFi ID
identifier	Identifier assigned by the education organization to the discipline action.		M	BehaviorResolution. resolutionID	Behavior > Behavior Management > Resolution > Resolution ID
disciplineDate	The month, day, and year of the discipline action.		M	BehaviorResolution. 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.		O	N/A	Behavior > 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.		O	N/A	N/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.		O	N/A	N/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.		O	N/A	N/A
disciplines	An unordered collection of disciplineActionDisciplines.			N/A	N/A
disciplines	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. Report the Ed-Fi Code value from the mapping for the state resolution code selected. 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.		O	N/A	N/A
staffs	An unordered collection of disciplineActionStaffs. This is optional and does not report.		O	N/A	N/A
orderOfDiscipline	The order of the administrative decision of the referral assigned by SWIS. Report the order of resolution based on the resolution Start Date. The earliest resolution found reports '1'. Second earliest reports '2'. Etc. The Resolution must have a State Code = NOT NULL to be considered.		O	N/A	Behavior > Behavior Resolution
etag	A unique system-generated value that identifies the version of the resource.		O	N/A	N/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 Value	Ed-Fi Short Description	Ed-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.

Action	Trigger
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
Delete	When 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 Element	Description			Campus Database Field	Campus GUI Location
id	The 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		M	School.entityID	System Administration > Resources > School > Entity ID
staffReference	A reference to the related Staff resource. This is optional and does not report.		O	N/A	N/A
incidentIdentifier	The 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.		M	BehaviorIncident. incidentID	Behavior > Behavior Management > Incident ID
incidentDate	The month, day, and year on which the incident occurred.		M	BehaviorIncident. 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.		O	N/A	N/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.		O	BehaviorIncident. location	Behavior Management > Location
reporterDescription Descriptor	Information on the type of individual who reported the incident. This is optional and does not report.		O	N/A	N/A
reporterName	Identifies the reporter of the incident by name. This is optional and does not report.		O	N/A	N/A
reportedTo LawEnforcement	Indicator of whether the incident was reported to law enforcement. This is optional and does not report.		O	N/A	N/A
caseNumber	The case number assigned to the incident by law enforcement or other organization. This is optional and does not report.		O	N/A	N/A
incidentDescription	The description for an incident. This is optional and does not report.		O	N/A	N/A
incidentCost	The value of any quantifiable monetary loss directly resulting from the incident. This is optional and does not report.		O	N/A	N/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).		O	N/A	N/A
	behaviorDescriptor	Report all behavior events that are associated with the incident. Report the Ed-Fi code value from the mapping for the state code selectedon the event 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. If a code is not mapped, do not report.	M	N/A	Behavior > Behavior Management > Event Type
	behaviorDetailedDescription	Report the Details entered on the Incident Ed-Fi accepts 1024 characters in this field, truncate remaining information from Campus if there are more characters	O	BehaviorIncident. description	Behavior > 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.		O	N/A	Behavior > 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.		O	N/A	Behavior > 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.		O	N/A	N/A
etag	A unique system-generated value that identifies the version of the resource.		O	N/A	N/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 Value	Ed-Fi Short Description	Ed-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.

Action	Trigger
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.
Put	When 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.
Delete	When the Student School Association record is deleted for the school in which the grades are associated.
Delete	When the No Show or State Exclude checkboxes are checked.
Delete/Insert	When 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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource.

N/A

gradingPeriodReference

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

schoolReference
beginDate
descriptor

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.

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.

N/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

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:

If the posted value is not an Integer, then report the posted score here
If the posted value is an Integer, then report in the Numeric Grade Earned field below.

GradingScore.score

Grading & 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:

If the posted value is an Integer, then report the posted score.
If the posted value is not an Integer, then report in Letter Grade Earned field above.

GradingScore.score

Grading & 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

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 Value	Ed-Fi Short Description	Ed-Fi Description
1	Conduct	Conduct
2	Exam	Exam
3	Final	Final
4	Grading Period	Grading Period
5	Mid-Term Grade	Mid-Term Grade
6	Progress Report	Progress Report
7	Semester	Semester

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.

Action

Trigger

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.

Put

When 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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource.

N/A

schoolReference

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

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.

edfigradingperiod.startDate

System 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.

edfigradingperiod.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.

edfigradingperiod.name

System 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/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 Value	Ed-Fi Short Description	Ed-Fi Description
01	End of Year	End of Year
02	Fifth Six Weeks	Fifth Six Weeks
03	First Nine Weeks	First Nine Weeks
04	First Semester	First Semester
05	First Six Weeks	First Six Weeks
06	First Summer Session	First Summer Session
07	First Trimester	First Trimester
08	Fourth Nine Weeks	Fourth Nine Weeks
09	Fourth Six Weeks	Fourth Six Weeks
10	Second Nine Weeks	Second Nine Weeks
11	Second Semester	Second Semester
12	Second Six Weeks	Second Six Weeks
13	Second Summer Session	Second Summer Session
14	Second Trimester	Second Trimester
15	Sixth Six Weeks	Sixth Six Weeks
16	Summer Semester	Summer Semester
17	Third Nine Weeks	Third Nine Weeks
18	Third Six Weeks	Third Six Weeks
19	Third Summer Session	Third Summer Session
20	Third Trimester	Third 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.

Action

Trigger

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.

Delete

Graduation 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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource.

N/A

educationOrganization
Reference

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

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.

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

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.

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.

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.

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.

N/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.

N/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.

N/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.

N/A

creditModification Descriptor

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

N/A

creditModifications AsOfDate

The most recent date of changes to CreditModification.

This field does not report.

N/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 Value	Ed-Fi Short Description	Ed-Fi Description
01	Career and Technical Education	Career and Technical Education
02	Distinguished	Distinguished
03	Minimum	Minimum
04	Recommended	Recommended
05	Standard	Standard

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

Code Value	Short Description	Description
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 Value	Short Description	Description
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 Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
educationService CenterReference	A reference to the related EducationServiceCenter resource. This element is optional and does not report.	O	N/A	N/A
stateEducation AgencyReference	A reference to the related StateEducationAgency resource. This element is optional and does not report.	O	N/A	N/A
localEducationAgencyId	EducationOrganization Identity Column. Logic reports the State District Number.	M	District.number	System Administration > Resources > District Information
stateOrganizationId	The identifier assigned to an education agency by the State Education Agency (SEA). Also known as the State LEP ID. NEDM: IdentificationCode, LEA Identifier.	M	District.number	System Administration > Resources > District Information
nameOfInstitution	The full, legally accepted name of the institution. NEDM: Name of Institution.	M	District.number	System Administration > Resources > District Information
shortNameOfInstitution	A short name for the institution. This element is optional and does not report.	O	N/A	N/A
webSite	The public web site address (URL) for the educational organization. This element is optional and does not report.	O	N/A	N/A
operationalStatusType	The current operational status of the education organization (e.g., active, inactive). This element is optional and does not report.	O	N/A	N/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.	O	N/A	N/A
categoryType	The category of LEA/District (e.g., Independent or Charter). Always report 'Independent'	M	N/A	N/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.	O	N/A	N/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.	M	N/A	N/A
	educationOrganizationCategoryType - Always report 'Local Education Agency'.	M	N/A	N/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.	O	N/A	N/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.	O	N/A	N/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.	O	N/A	N/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.	O	N/A	N/A
etag	A unique system-generated value that identifies the version of the resource.	O	N/A	N/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.

Action	Trigger
Post	When a new Room is created and saved.
Post	When a Room is added to a section that does not already exist in Ed-Fi.
Post	When a Room Name is changed and saved.
Put	When the Maximum Number Of Seats is modified.
Delete	When 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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource.

N/A

schoolReference

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

EntityID

School.entityID

System 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.

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.

Room.capacity

System Administration > Resources > Resources > Capacity

optimalNumber
OfSeats

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

This field is not collected or reported.

N/A

etag

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

This field is optional and does not report.

N/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.

Action

Trigger

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).

Delete

A 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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource.

N/A

parentUniqueId

A parent's Ed-Fi ID is reported.

Person.edFiId

Census > 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.

N/A

firstName

The reporting parent's first name. This is reported from the person's most recent identity record.

Identity.firstName

Census > People > Identities > First Name

middleName

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

Identity.middleName

Census > People > Identities > Middle Name

lastSurname

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

Identity.lastName

Census > People > Identities > Last Name

generationCodeSuffix

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.

Identity.suffix

Census > People > Identities > Suffix

maidenName

The person's maiden name, if applicable.

This element is not collected or reported.

N/A

sexType

A person's gender.

This element is not collected or reported.

N/A

loginId

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

This element is not collected or reported.

N/A

addresses

Report the person's address(s).

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

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

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.

streetNumberName

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

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

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.

Address.apt

Households > 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.

N/A

city

The name of the city in which an address is located.

Address.city

Households > Address Info > City

stateAbbreviation
Type

The abbreviation for the state (within the United States) or outlying area in which an address is located.

Address.state

Households > Address Info > State

postalCode

The five or nine digit zip code portion of an address.

Address.zip

Households > 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.

address.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.

N/A

latitude

The geographic latitude of the physical address.

This is optional and does not report.

N/A

longitude

The geographic longitude of the physical address.

This is optional and does not report.

N/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.

N/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.

N/A

electronicMails

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

Reports the email address entered for that person
1. Do not report if Email is marked as "Private"
If blank, does not report

Contact.email

Census > People > Demographics > Email

electronicMailType

Reports the mail type. See the Electronic Mail Type table in the Type/Description section below.

N/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.

Contact.email

Census > 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.

N/A

identification
Documents

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

This element is not collected or reported..

N/A

international
Addresses

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

This element is not collected or reported.

N/A

otherNames

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

This field is optional and does not report.

N/A

telephones

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

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

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.

N/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.

N/A

telephoneNumber

The 10-digit telephone number, including the area code, for the person.

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.

N/A

etag

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

This field is optional and does not report.

N/A

Type/Descriptor Layout

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

Campus Value	Ed-Fi Type	Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
Other Phone	1	Home	Home	Home
Does not report, not collected in Campus	2	Fax	Fax	Fax
Cell Phone	3	Mobile	Mobile	Mobile
Does not report, not collected in Campus	4	Unlisted	Unlisted	Unlisted
Work Phone	5	Work	Work	Work
Pager	6	Other	Other	Other
Does not report, not collected in Campus	7	Emergency 1	Emergency 1	Emergency 1
Does not report, not collected in Campus	8	Emergency 2	Emergency 2	Emergency 2

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

Campus Value	Ed-Fi Type ID	Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
Primary email reports as "Home/Personal"	1	Home/Personal	Home	Home
Primary email reports as "Home/Personal"	2	Organization	Organization	Organization
Primary email reports as "Home/Personal"	3	Other	Other	Other
Secondary email reports as "Work"	4	Work	Work	Work

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

Campus Value	Ed-Fi Type ID	Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
All address report as "Home"	1	Home	Home	Home
	2	Physical	Physical	Physical
	3	Mailing	Mailing	Mailing
	4	Other	Other	Other
	5	Work	Work	Work
	6	Billing	Billing	Billing
	7	Temporary	Temporary	Temporary
	8	Father Address	Father Address	Father Address
	9	Guardian Address	Guardian Address	Guardian Address
	10	Mother Address	Mother Address	Mother Address
	11	Shipping	Shipping	Shipping
	12	Shelters	Shelters, Transitional housing, Awaiting Foster Care	Shelters, Transitional housing, Awaiting Foster Care
	13	Doubled	Doubled - up (i.e., living with another family)	Doubled - up (i.e., living with another family)
	14	Unsheltered	Unsheltered (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)
	15	HotelMotel	Hotels/Motels	Hotels/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.

Action	Trigger
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).
Delete	Programs 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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource.

N/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.

District.stateDistrict Number

System 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

N/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

N/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.

N/A

sponsorType

Key for ProgramSponsor.

This field does not report.

N/A

beginDate

This field does not report.

N/A

characteristics

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

This field does not report.

N/A

learningObjectives

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

This field does not report.

N/A

learningStandards

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

This field does not report.

N/A

services

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

This field does not report.

N/A

Type/Descriptors

The highlighted column indicates the reported value.

This table describes the Program Type.

Ed-Fi Code Value	Short Description	Description
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.

Action	Trigger
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'.
Delete	When an incident is deleted.
Delete	When 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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource.

N/A

schoolReference

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

studentReference

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

identifier

A 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.

Behavior Incident.incidentID

Behavior> Behavior Management> Incident ID

eventDate

Month, day, and year of the RestraintEvent. Reports the Date of Incident.

Behavior Incident.timestamp

Behavior> Behavior Management> Date of Incident

educationalEnvironmentType

The setting where the RestraintEvent was exercised.

This field is optional and does not report.

programs

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

This field is optional and does not report.

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.

restraintCategories

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

Behavior> Behavior Management>Behavior Response

restraintCategoryDescriptor

Indicates the type of event: seclusion or restraint.

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

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.

_etag

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

This does not report.

N/A

Type/Descriptor

The highlighted column indicates the reported value.

This table describes the Restraint Event Reason Type.

Ed-Fi Code Value	Ed-Fi Short Description	Ed-FiDescription
Imminent Serious Physical Harm To Themselves	Imminent Serious Physical Harm To Themselves	Imminent Serious Physical Harm To Themselves
Imminent Serious Physical Harm To Others	Imminent Serious Physical Harm To Others	Imminent Serious Physical Harm To Others
Imminent Serious Property Destruction	Imminent Serious Property Destruction	Imminent Serious Property Destruction

This table describes the Restraint Category Descriptor.

Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
01	Seclusion Event	Restraint Event
02	Restraint Event	Restraint 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.

Action

Trigger

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

Delete

A 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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource.

N/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.

N/A

schoolId

Indicates the School Entity ID.

School.entityId

System 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.

Report the Ed-Fi School Number.
If the Ed-Fi School Number is blank, report the State School Number.

School.stateNumber

System Administration > Resources > School > State School Number

nameOfInstitution

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

Reports the school name.

School.name

System Administration > Resources > School > Name

shortNameOfInstitution

A short name for the institution.

This field does not report.

N/A

webSite

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

This field does not report.

N/A

operationalStatus
Type

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

This field does not report.

N/A

type

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

This field does not report.

N/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.

N/A

titleIPartASchool
DesignationType

Denotes the Title I Part A designation for the school.

This field does not report.

N/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.

N/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.

N/A

internetAccessType

Indicates the type of Internet access that is available.

This field does not report.

N/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:

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.

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

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.

Address.apt

Households > 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.

N/A

city

The name of the city in which an address is located.

Address.city

Households > Address Info > City

stateAbbreviationType

The abbreviation for the state (within the US) or outlying area in which an address is located.

Address.state

Households > Address Info > State

postalCode

The five or nine digit zip code portion of an address.

Address.zip

Households > 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.

N/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.

N/A

latitude

The geographic latitude of the physical address.

This field does not report.

N/A

longitude

The geographic longitude of the physical address

This field does not report.

N/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.

N/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.

N/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:

N/A

institutionTelephone NumberType

Type of phone number. Always reports 'Main.'

N/A

telephoneNumber

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

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

School.phoneNumber

System 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.

N/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:

N/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.'

N/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.

N/A

schoolCategories

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

type

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

Reports the Ed-Fi Code from the Grade Type droplist.
If Ed-Fi Code is NULL or field is blank, do not report.

schools.gradeType

System 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:

N/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.

calendar.gradeLevel

System Administration > Calendar > Calendar > Grade Levels

etag

N/A

Type/Descriptor

The highlighted column indicates the reported value.

This table describes the Institution Telephone Number Type.

Ed-Fi Code Value	Short Description	Description
Main	Main	Main
Administrative	Administrative	Administrative
Health Clinic	Health Clinic	Health Clinic
Attendance	Attendance	Attendance
Other	Other	Other
Fax	Fax	Fax
Food Service	Food Service	Food Service

This table describes the Education Organization Category Type.

Ed-Fi Code Value	Short Description	Description
Education Service Center	Education Service Center	Education Service Center
Local Education Agency	Local Education Agency	Local Education Agency
School	School	School
State Education Agency	State Education Agency	State Education Agency
Education Organization Network	Education Organization Network	Education Organization Network
Other	Other	Other

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

Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi 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)

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.

Action	Trigger
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.
Post	When a section schedule placement is changed and saved.
Post	When 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.
Delete	When a section is deleted.
Delete	When Section Placement is changed or removed and saved on a section.
Delete	When 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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource.

N/A

classPeriod
Reference

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

id
name

N/A

courseOffering Reference

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

schoolReference
sessionReference
localCourseCode

N/A

locationReference

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

schoolReference
classroomIdentificationCode

N/A

schoolReference

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

EntityID

N/A

uniqueSectionCode

A 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.

N/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.

Report the code selected in Scheduling > Courses > Course > Course Editor > Course Inventory Sequence Part (Course.sequencePart)
When Course Inventory Sequence Part = Null, report 1.

N/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.

N/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.

Course.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.

N/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.

N/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.

N/A

instructionLanguage
Descriptor

This element is optional and does not report.

N/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

GradingTaskCredit.
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.

GradingTaskCredit.
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.

N/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.

Reports the MSIX Course Section ID. Reports first from Section, then Course.
If blank, does not report.

N/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.

N/A

etag

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

This element is optional and does not report.

N/A

Type/Descriptor Layout

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

Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
01	Attendance Tracked	Attendance Tracked
02	Graded Credit	Graded Credit Available

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

Ed-Fi Code Value	Ed-Fi Short Description	Ed-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.

Action

Trigger

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.

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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource.

N/A

schoolReference

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

EntityID

N/A

schoolYearTypeReference

A reference to the related SchoolYearType resource. This element reports the End year from the calendar term reported.

N/A

name

The identifier for the calendar for the academic session.

Term.edfiTypeName

System 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.

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.
When reporting from the Term Descriptors Override on Course or Section, report the Ed-Fi code value selected.

Term.edFiTermType

Course.edFiTermType

Section.edFiTermType

System Administration > Calendar > Calendar > Terms > Term Type

Scheduling > Courses/Sections

beginDate

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

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
When reporting from a Term Type Override on a section:
1. Report the start date from the mapping the course is aligned to.

Term.startDate

System Administration > Calendar > Calendar > Terms > Start Date

endDate

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

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
When reporting from a Term Type Override on a section:
1. Report the end date from the mapping the course is aligned to.

Term.endDate

System 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.

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
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.

N/A

academicWeeks

An unordered collection of sessionAcademicWeeks.

N/A

gradingPeriods

An unordered collection of sessionGradingPeriods.

N/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

N/A

etag

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

N/A

Type/Descriptor

The highlighted column indicates the reported value.

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

Code	Name	Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
1S	Fall Semester	Fall Semester	Fall Semester	Fall Semester
2S	Spring Semester	Spring Semester	Spring Semester	Spring Semester
SS	Summer Semester	Summer Semester	Summer Semester	Summer Semester
1T	First Trimester	First Trimester	First Trimester	First Trimester
2T	Second Trimester	Second Trimester	Second Trimester	Second Trimester
3T	Third Trimester	Third Trimester	Third Trimester	Third Trimester
FY	Full Year	Full Year	Full Year	Full Year
MT	MiniTerm	MiniTerm	MiniTerm	MiniTerm
1Q	First Quarter	First Quarter	First Quarter	First Quarter
2Q	Second Quarter	Second Quarter	Second Quarter	Second Quarter
3Q	Third Quarter	Third Quarter	Third Quarter	Third Quarter
4Q	Fourth Quarter	Fourth Quarter	Fourth Quarter	Fourth Quarter
OT	Other	Other	Other	Other

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.

Action	Trigger
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: There is not an 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. 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/Post	When 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
Delete	When a District Assignment record is deleted.
Delete	When a District Employment record is deleted
Delete	When 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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource.

N/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/A

educationOrganizationReference

A reference to the related EducationOrganization resource.

First look to District Employment > District Staff. If the checkbox is checked, report staff with the District Number.
If the District Staff checkbox is not checked, report the State School Number.

N/A

staffReference

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

staffUniqueId

N/A

staffClassificationDescriptor

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

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

If reporting from District Employment, report the Ed-Fi Code mapped to the District Assignment Code selected.
If reporting from District Assignment, report the Ed-Fi Code mapped to the Assignment Code selected.
Look to see if a default value is saved in the Attribute Dictionary when reporting.

EmploymentAssignment.
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.

Employment.assignment

Census > 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.

When reporting from the District Employment record, report the District Employment End Date
1. If NULL, do not report
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.

N/A

staffREPCredentual Reference

A reference to the related StaffREPCredential resource.

This element is optional and does not report.

N/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.

N/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.

N/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.

N/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.

N/A

etag

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

N/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 Code	Ed-Fi Short Description	Ed-Fi Description
Assistant Principal	Assistant Principal	Assistant Principal
Assistant Superintendent	Assistant Superintendent	Assistant Superintendent
Counselor	Counselor	Counselor
Instructional Aide	Instructional Aide	Instructional Aide
Instructional Coordinator	Instructional Coordinator	Instructional Coordinator
LEA Administrator	LEA Administrator	LEA Administrator
LEA Specialist	LEA Specialist	LEA Specialist
LEA System Administrator	LEA System Administrator	LEA System Administrator
Librarians/Media Specialists	Librarians/Media Specialists	Librarians/Media Specialists
Operational Support	Operational Support	Operational Support
Other	Other	Other
Principal	Principal	Principal
School Administrator	School Administrator	School Administrator
School Leader	School Leader	School Leader
School Specialist	School Specialist	School Specialist
State Administrator	State Administrator	State Administrator
Substitute Teacher	Substitute Teacher	Substitute Teacher
Superintendent	Superintendent	Superintendent
Support Services Staff	Support Services Staff	Support Services Staff
Teacher	Teacher	Teacher

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.

Action	Trigger
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.
Post	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 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. The Employment Status field is not mapped in Resource Preferences.
Put	N/A, a delete and insert occurs when any field is edited and saved.
Delete/Post	When 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
Delete	When a District Assignment record is deleted
Delete	When a District Employment record is deleted
Delete	When 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 Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
educationOrganization Reference	A reference to the related EducationOrganization resource First look to District Employment > District Staff. If the checkbox is checked, report staff with the District Number. If the District Staff checkbox is not checked, report the State School Number from the District Assignment record.	M	N/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	M	N/A	N/A
employmentStatus Descriptor	This descriptor defines the type of employment or contract. When reporting from the District Employment record, report the mapped code from Employment Status. When reporting from District Assignment, report mapped code from Type. Report the attribute Default Value if available and the field is NULL in the DB. If field is blank, report '04'.	M	Employment 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). 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	M	Employment 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). When reporting from the District Employment record, report the District Employment End Date If NULL, do not report When reporting from the District Assignment record, report the District Assignment End Date If NULL, do not report	O	Employment 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.	O	N/A	N/A
separationReason Descriptor	This descriptor defines the reasons for terminating the employment. This is not collected within Campus and is not reported.	O	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.	O	N/A	N/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.	O	N/A	N/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.	O	N/A	N/A
hourlyWage	Hourly wage associated with the employment position being reported. This is not collected within Campus and is not reported.	O	N/A	N/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.	O	N/A	N/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.	O	N/A	N/A
etag	A unique system-generated value that identifies the version of the resource.	O	N/A	N/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 Value	Ed-Fi Short Description	Ed-Fi Description
01	Probationary	Probationary
02	Contractual	Contractual
03	Substitute/temporary	Substitute/temporary
04	Tenured or permanent	Tenured or permanent
05	Volunteer/no contract	Volunteer/no contract
06	Employed or affiliated with outside organization	Employed or affiliated with outside organization
07	Non-contractual	Non-contractual
08	Employed part-time	Employed part-time
09	Employed or affiliated with outside agency part-time	Employed or affiliated with outside agency part-time
10	Other	Other

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.

Action	Trigger
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.
Post	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.
Delete	Staff 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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource.

N/A

staffUniqueId

A unique alpha-numeric code assigned to a staff. The staff member's Ed-Fi ID is reported.

Census.edFiId

Census > 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.

N/A

firstName

The staff member's legal first name. The first name from the person's current identity record is reported.

Identity.firstName

Census > People > Identities > First Name

middleName

The staff member's legal middle name. The middle name from the person's current identity record is reported.

Identity.
middleName

Census > People > Identities > Middle Name

lastSurname

The staff member's legal last name. The last name from the person's current identity record is reported.

Identity.lastName

Census > People > Identities > Last Name

generationCodeSuffix

An 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.

Identity.suffix

Census > People > Identities > Suffix

maidenName

The person''s maiden name, if applicable.

This element is currently not reported or collected.

N/A

sexType

The person's gender.

Identity.gender

Census > People > Identities > Gender

birthDate

The month, day, and year on which an individual was born. The Birth Date from the person's current identity record is reported.

Identity.birthDate

Census > 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:

If droplist is = Yes, report "true"
If droplist is = No or NULL, report "false"

Identity.
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.

Identity.
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.

Report the Ed-Fi Code value from from the person's Credentials tab when the Credential Type is = ED: Education.
If there is not a valid credential, report the Ed-Fi Code Value from Education droplist on the person's District Employment record.
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.

N/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.

N/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.

N/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.

N/A

Census > People > Credentials

loginId

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

This element is currently not reported or collected.

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.

N/A

addresses

Report the person's address(es).

This element is optional and is not reported.

N/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.

N/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:

Contact.email

Census > People > Demographics > Email

Census> People> Demographics> Secondary Email

electronicMailType

This element reports the Electric Mail mapping. The Email (primary) address reports as 'Work'. The Secondary Email address reports as 'Home/Personal'.

N/A

electronicMailAddress

The numbers, letters, and symbols used to identify an electronic mail (e-mail) user within the network to which the individual or organization belongs.

Contact.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.

N/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.

N/A

Census > People >Demographics > State Staff ID

and/or

Census > People > District Employment > License

Credentials > License Number

Staff Identification System Type

Reports District when reporting the local stff number; reports State when reporting the staff state ID.

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.

N/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:

Report the Local Staff Number if populated.
Reports the Staff State ID if populated.

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.

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.

N/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.

N/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.

N/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:

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:

Contact.homephone

Contact.workphone

Contact.cellphone

Contact.pager

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

telephoneNumberType

This element reports the short description mapped in the Telephone Number Type table listed in the section below.

N/A

orderOfPriority

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

N/A

textMessage
CapabilityIndicator

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

N/A

telephoneNumber

The 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.

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.

N/A

repRaceOrders

An unordered collection of staffREPRaceOrders. This element is an array which reports the following additional data:

N/A

raceOrderChoice Descriptor

Always reports a value of 1.

N/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.

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 Code	Ed-Fi Short Description	Ed-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.

Action	Trigger
Post	When a District Assignment record is created or changed and saved for a staff member.
Post	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.
Put	N/A, a delete and insert occurs when any field is edited and saved.
Delete/Insert	When the person’s employment assignment record is changed.
Delete	When 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 Element	Description		Campus Database Field	Campus GUI Location
id	The 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	M	N/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	M	N/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.	M	N/A	N/A
schoolYear	The reporting school year.	O	N/A	N/A
academicSubjects	An unordered collection of staffSchoolAssociationAcademicSubjects. This association indicates the school(s) to which a teacher provides instructional services.	O	N/A	N/A
gradeLevels	An unordered collection of staffSchoolAssociationGradeLevels. This association indicates the school(s) to which a teacher provides instructional services.	O	N/A	N/A
_etag	A unique system-generated value that identifies the version of the resource	O	N/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 Code	Ed-Fi Short Description	Ed-Fi Description
01	Bilingual/English as a Second Language	Bilingual/English as a Second Language
02	Other	Other
03	Regular Education	Regular Education
04	Special Education	Special Education
05	Title I-Academic	Title I-Academic
06	Title I-Non-Academic	Title 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.

Action	Trigger
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.
Post	When 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.
Delete	When 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 Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
section Reference	A reference to the related Section resource. Reports: Class Period Course Offering Location School Unique Section Code Sequence of Course	M	N/A	N/A
staffReference	A reference to the related Staff resource. Reports the Staff Unique ID.	M	N/A	N/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’.	M	sectionStaffhistory.role	Scheduling > 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.	O	N/A	N/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.	O	N/A	N/A
percentageContribution	The percentage of time the teacher is responsible for the student. This is optional and does not report.	O	N/A	N/A
_etag	A unique system-generated value that identifies the version of the resource. This is optional and does not report.	O	N/A	N/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 Value	Ed-Fi Short Description	Ed-Fi Description
01	Teacher of Record	Teacher of Record
02	Assistant Teacher	Assistant Teacher
03	Support Teacher	Support Teacher
04	Substitute Teacher	Substitute Teacher
05	Mentor	Mentor

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.

Action	Trigger
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
Delete	If 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 Element	Description			Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.		M	N/A	N/A
educationOrganization Reference	A reference to the related EducationOrganization resource. Reports the District Number		M	N/A	N/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		M	N/A	N/A
studentReference	Reports the fields that are part of the Natural Key for the Student resource studentUniqueId		M	N/A	N/A
termDescriptor	The term for the session during the school year. See the Term Descriptor table in the Type/Descriptor section below. Report the Ed-Fi code for the value selected in "Ed-Fi Transcript Term Override" field on the transcript. If NULL, report the Term Descriptor based on the Course Term Type Override, else Section Term Type Override. 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. Else, report the Ed-Fi Code from the Ed-Fi Transcript Term Descriptor Override in the SAR preferences. If an Term cannot be determined, provide error. 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. 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 If the Diploma Date is aligned to more than 1 Term Descriptor, report the value from the highest TermId		M	N/A	N/A
cumulativeEarnedCreditType	Key for Credit. This is optional and does not report.		O	N/A	N/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.		O	N/A	N/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. 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. Report '0' if the student does not have any Credits Earned This value will be the same for all Student Academic Records that are being updated, regardless of Term Type or Year. If the student does not have any Course Transcript records and is only reporting from Graduation, this field will be NULL		O	Calculated value from the earned credit field in the transcriptcredit table	Student Information > General > Transcripts
cumulativeAttemptedCreditType	Key for Credit This is optional and does not report.		O	N/A	N/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.		O	N/A	N/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. 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. Report '0' if the student does not have any Attempted Credits Earned This value will be the same for all Student Academic Records that are being updated, regardless of Term Type or Year. If the student does not have any Course Transcript records and is only reporting from Graduation, this field will be NULL		O	N/A	N/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.		O	N/A	N/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.		O	N/A	N/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.		O	N/A	N/A
projectedGraduationDate	The month and year the student is projected to graduate. This is optional and does not report.		O	N/A	N/A
sessionEarnedCreditType	Key for Credit This is optional and does not report.		O	N/A	N/A
sessionEarnedCreditConversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units. This is optional and does not report.		O	N/A	N/A
sessionEarnedCredit	The number of an credits an individual earned in this session. This is optional and does not report.		O	N/A	N/A
sessionAttemptedCreditType	Key for Credit. This is optional and does not report.		O	N/A	N/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.		O	N/A	N/A
sessionAttemptedCredit	The number of an credits an individual attempted to earn in this session This is optional and does not report.		O	N/A	N/A
sessionGradePointsEarned	The number of grade points an individual earned for this session This is optional and does not report.		O	N/A	N/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.		O	N/A	N/A
classRanking	This educational entity represents the cumulative record of academic achievement for a student This is optional and does not report.		O	N/A	N/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.		O	N/A	N/A
diplomas	An unordered collection of studentAcademicRecordDiplomas. This educational entity represents the cumulative record of academic achievement for a student.		O	N/A	N/A
	Diploma Type	The type of diploma/credential that is awarded to a student in recognition of his/her completion of the curricular requirements.	M	N/A	N/A
	Diploma Date	The month, day, and year on which the student met graduation requirements and was awarded a diploma. Reports the Diploma Date	M	N/A	N/A
	achievementCategory Descriptor	This descriptor defines the category of achievement attributed to the learner. Report '6' for Diploma Earned when Diploma Type is = 01: Grad from gen ed, diploma 02: Grad from gen ed, diploma, applied to college 03: Grad from alternate program 04: Grad from gen ed, diploma, applied to non-degree Report '5' for Certificate Earned when Diploma Type is = 05: Completed gen ed, equivalency certificate 06: Completed gen ed, other certificate 20: Received Special Ed certificate, exited	M	Student Information > General > Graduation > Diploma Type	Graduation. 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.		O	N/A	N/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.		O	N/A	N/A
_etag	A unique system-generated value that identifies the version of the resource. This is optional and does not report.		O	N/A	N/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 Value	Ed-Fi Short Description	Ed-Fi Description
Fall Semester	Fall Semester	Fall Semester
Spring Semester	Spring Semester	Spring Semester
Summer Semester	Summer Semester	Summer Semester
First Quarter	First Quarter	First Quarter
Second Quarter	Second Quarter	Second Quarter
Third Quarter	Third Quarter	Third Quarter
Fourth Quarter	Fourth Quarter	Fourth Quarter
First Trimester	First Trimester	First Trimester
Second Trimester	Second Trimester	Second Trimester
Third Trimester	Third Trimester	Third Trimester
MiniTerm	MiniTerm	MiniTerm
Other	Other	Other
Full Year	Full Year	Full Year
Continuous	Continuous	Continuous

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.

Action	Trigger
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: P: Primary S: Partial 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.
Post	When 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: P: Primary S: Partial 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.
Post	When 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
Delete	OMP is deleted for a student
Delete	A test Date is changed for the assessment.
Delete	All overlapping enrollments are deleted for a school
Delete	When 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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource.

N/A

assessmentReference

Reports data from the fields that are part of the natural key for the Assessment resource.

N/A

studentReference

The title or name of the assessment. NEDM: Assessment Title. Reports data from the fields that are part of the natural key for the Studentresource.

N/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.

SEPOutcomeMeasures. referredDate

Student 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.

N/A

serialNumber

The unique number for the assessment form or answer document.

This field is optional and does not report.

N/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.

N/A

administrationEnvironmentType

The environment in which the test was administered. For example: Electronic Classroom Testing Center.

This field is optional and does not report.

N/A

retestIndicatorType

Indicator if the test was retaken. For example: Primary administration First retest Second retest.

This field is optional and does not report.

N/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.

N/A

whenAssessedGrade LevelDescriptor

The grade level of a student when assessed.

This field is optional and does not report.

N/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.

N/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.

N/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.

SEPOutcomeMeasures. outcomeType

Student 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.

N/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.

SEPlan.parentInput

Student 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.

N/A

barcode

Student's barcode number providing detailed information regarding the student and the assessment.

This field is optional and does not report.

N/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.

N/A

nonstandard Accommodation

Identifies whether a student received accommodations that do not qualify as standard accommodations.

This field is optional and does not report.

N/A

online

Identifies whether the assessment was administered in an online testing environment.

This field is optional and does not report.

N/A

outOfLevel

Identifies whether student tested in an incorrect grade.

This field is optional and does not report.

N/A

parentConferenceDate

Date the parent conference occurred.

Early Childhood Special Education Assessment - does not report.
Part C Assessment - Reports Parent Input Date.

SEPlan.parent Inputdate

Student 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.

N/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.

N/A

valid

Identifies whether the student received a valid test score for the assessment.

This field is optional and does not report.

N/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.

N/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.

SEPOutcomeMeasures.behaviorScore

Student 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.

SEPOutcomeMeasures.behaviorCheck

Student 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.

N/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.

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.

SEPOutcomeMeasures.skillsCheck

Student 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.

N/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.

SEPOutcomeMeasures.socialScore

Student 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

SEPOutcomeMeasures.socialCheck

Student 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.

N/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.

N/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.

N/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.

N/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.

N/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.

N/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 Value	Ed-Fi Short Description	Ed-Fi Description
1	Entrance	Entrance assessment taken when the child enters Part C services
2	Annual	Annual assessment taken while the child is receiving services
3	Exit	Exit 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 Value	Ed-Fi Short Description	Ed-Fi Description
1	Not Yet	Child 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.
2	Between Not Yet and Emerging	Some of the foundational skills are there, though not all the immediate foundational skills.
3	Emerging	Child 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.
4	Between Emerging and Somewhat	Immediate foundational skills are in place, and child has demonstrated age appropriate skills once or twice, perhaps not deliberately.
5	Somewhat	Child's functioning is a mix of age appropriate and not appropriate functioning. Functioning might be described as that of a slightly younger child.
6	Between Somewhat and Completely	Child's functioning generally is considered appropriate for his/her age but there are some concerns about his/her functioning in this outcome area.
7	Completely	Child 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 Value	Ed-Fi Short Description	Ed-Fi Description
A	Meeting(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.
B	Collected separately	The 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.
C	Incorporated in assessment	The 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.
D	Not included	No parent input was included in determining the child outcomes rating.

Student Discipline Incident Association

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.

Action	Trigger
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
Deete	When 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 Element	Description			Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.		M	N/A	N/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		M	N/A	N/A
studentReference	Reports data from the fields that are part of the natural key for the Student resource. The following elements are reported: studentUniqueId		M	N/A	N/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		M	BehaviorEvent.role	Behavior > 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.		O	N/A	N/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.	O	N/A	N/A
followUps	An unordered collection of studentDisciplineIncidentAssociationFollowUps. The follow-up and/or educational services provided to the student after the discipline incident.		O	N/A	N/A
followUps	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.	O	N/A	N/A
swisBehaviors	An unordered collection of studentDisciplineIncidentAssociationSwisBehaviors. Describes SWIS behavior by category and provides a detailed description.		O	N/A	N/A
	behaviorDescriptor	The ID of the Behavior Descriptor. Report all behavior events that are associated with the student Report the Ed-Fi code value from the mapped behavior event. If the event is not mapped to a state code or the Ed-Fi Code is blank, report '02'.	M	N/A	Behavior> Behavior Management> Event Type
	orderOfBehavior	Report based on earliest eventID found on incident. 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
_etag	A unique system-generated value that identifies the version of the resource.		O	N/A	N/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 Role

Ed-Fi Short Description

Ed-Fi Description

Victim

Offender

Perpetrator

Witness

Reporter

Witness

Reporter

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

Ed-Fi Code Value	Ed-Fi Short Description	Ed-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:

The first Resident District value saved for a student will populate the resident district field on the enrollment table.
A record is reported regardless if the Resident District value does not equal the enrolled district.
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.

Action	Trigger
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
Put	When the start date for an enrollment is changed.
Delete	When 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.
Delete	When 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.
Delete	When 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 Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/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	M	N/A	N/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'.	M	N/A	N/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.	M	Enrollment.startdate	Student Information > General > Enrollments > Start Date
etag	A unique system-generated value that identifies the version of the resource.	O	N/A	N/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 Value	Ed-Fi Short Description	Ed-Fi Description
01	Accountability	Accountability
02	Attendance	Attendance
03	Funding	Funding
04	Graduation	Graduation
05	Individualized Education Program	Individualized Education Program
06	Transportation	Transportation

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.

Action

Trigger

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.

Put

When the relationship type is changed.

Put

When 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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource

N/A

parentReference

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

parentUniqueId

N/A

studentReference

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

studentUniqueId

N/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.

Report the Ed-Fi Code from the Ed-Fi Relation Type field that is mapped.
If no mapping, do not report.

See the Relationship Type table in the section below for the Ed-Fi value that is reported.

RelatedPair.name

Census > 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.

N/A

Census > 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.

N/A

Census > 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.

N/A

Census > 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.

N/A

contactRestrictions

Restrictions for student and/or teacher contact with the individual.

This data is not collected in Campus is not reported.

N/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%'

N/A

Student 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%'

N/A

Student 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.

N/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%'

N/A

Student Information > Special Education > Documents > IFSP > Transition Plan > Part C Exit Reason, Parent/Guardian Demographics, Start Date, End Date

etag

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

N/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 Description	Ed-Fi Description
Aunt	Aunt
Brother	Brother
BrotherInLaw	BrotherInLaw
CourtAppointedGuardian	CourtAppointedGuardian
Cousin	Cousin
Daughter	Daughter
DaughterInLaw	DaughterInLaw
Employer	Employer
Father	Father
Father, step	Father, step
FathersSignificantOther	FathersSignificantOther
FathersCivilPartner	FathersCivilPartner
FatherInLaw	FatherInLaw
Fiance	Fiance
Fiancee	Fiancee
Foster parent	Foster parent
Friend	Friend
Grandfather	Grandfather
Grandmother	Grandmother
Great aunt	Great aunt
Great uncle	Great uncle
Great Grandparent	Great Grandparent
Husband	Husband
MothersSignificantOther	MothersSignificantOther
Mother	Mother
Mother, step	Mother, step
MothersCivilPartner	MothersCivilPartner
Nephew	Nephew
Niece	Niece
Other	Other
SignificantOther	SignificantOther
Sister	Sister
Son	Son
Unknown	Unknown
Uncle	Uncle
Ward	Ward
Wife	Wife

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.

Action	Trigger
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).
Put	When 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.
Delete	When 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.

Action	Trigger
Post	When a student is associated with one or more programs that have: State Reported = selected 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.
Delete	When Location is changed from NULL to a school, delete any school records not associated with the selected school.
Delete	When 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.
Delete	All overlapping enrollments are deleted for a school.

Special Education Programs Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a student in the year and calendar reporting has the following: A locked IEP. IEP has a Special Ed Program(s) mapped to a state code with an Ed-Fi Code. Print Format: ‘miIEP%’ A locked NPSP. NPSP has a Special Ed Program(s) mapped to a state code with an Ed-Fi Code. Print Format: 'miNPSP%' A locked IFSP. IFSP has an Early Intervention Service(s) mapped to a state code with an Ed-Fi Code. 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: P: Primary S: Partial 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: Enrollment start date must be after IEP/IFSP start date. 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
Delete	A Sped Start Date is changed for a student.
Delete	All 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 Element

Description

Campus Database Field

Campus GUI Interface

The unique identifier of the resource.

N/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.

School.number

System Administration > Resources > School > State School Number

programReference

A reference to the related Program resource. Reports Program reference (EL, Title 1, Special Educaiton).

N/A

studentReference

A reference to the related Student resource.

Reports the studentUniqueId from the Student Resource.

N/A

beginDate

The month, day, and year on which the Student first received services. Reports the EL Identified Date.

Lep.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.

Lep.exitDate

Student 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.

N/A

servedOutsideOf regularSession

Indicates whether the student received services during the summer session or between sessions.

This field is optional and does not report.

N/A

enrollmentStatus

This field is optional and does not report.

N/A

services

An 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.

N/A

serviceDescriptor

The ID of the Service Descriptor.

English Learners (EL)

Report the Code from the State Defined Service Type.
1. IIf the service is not mapped to a state code, do not report.
Service must be active at least one day in the Scope Year to report.

Title I Programs

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

Report the Ed-Fi Code associated with the assigned Special Education Program service.
Service must be active at least one day in the Scope Year to report.

Lepservicetype.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.

N/A

serviceBeginDate

The month, day, and year on which the Student first received service.

English Learners (EL)

Report Start Date of Service.

Title I Programs

Report Program Start Date.

Special Education Programs

Report Start Date of IEP/NPSP/IFSP.

lepservice.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)

Report Program Exit Date.

Title I Programs

Report Program End Date.

Special Education Programs

Report End Date of IEP.

lep.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 Value	Ed-Fi Short Description	Ed-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.

Action	Trigger
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: P: Primary Enrollment S: Partial/Ancillary 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
Put	When a change is made to the Graduation > NCLB Cohort End Year field.
Put	When 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.
Delete	When 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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource.

N/A

graduationPlan
Reference

A reference to the related GraduationPlan resource.

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.
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.
If the student has both a CTE and Graduation Plan, report the Graduation Plan.
If the student has more than one Graduation Plan, report the plan with the most recent start date.

N/A

Student Information > Academic Planning > Programs

schoolReference

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

schoolReference
studentReference
entryDate

N/A

classOfSchool
YearTypeReference

The year the student is expected to graduate.

Report only for students with an enrollment in grade 9-12:

Populate the year selected in Student Info > General > Graduation > NCLB Cohort End Year.
When NCLB Cohort End Year = Null, do not report.

Graduation.gradYear

Student 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.

N/A

studentReference

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

studentUniqueId

N/A

entryDate

The month, day, and year on which an individual enters and begins to receive instructional services in a campus.

Enrollment.startDate

Student 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.

Report the Ed-Fi Code from the Grade Level mapping for the grade selected on the student's enrollment.
If a mapping is not available, the record will error.

Enrollment.grade

Student 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.

N/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.

Enrollment.
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.

N/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.

N/A

exitWithdrawDate

The 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.

Enrollment.endDate

Student 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.

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.

N/A

primarySchool

Indicates 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.

Enrollment.type

Student 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.

N/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.

Array

N/A

enrollmentPercent

The full-time equivalency (FTE) that the participant spends in the program, service, or education organization reported. Range 0.00 - 1.00

Enrollment. percentEnrolled

Student Information > General > Enrollments > State Reporting > FTE in General Education

districtResidency StatusAsOfDate

Reports the enrollment start date ONLY when the districtResidencyStatusDescriptor reports.

Enrollment.startDate

Student 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.

EnrollmentMI. studentResidency

Student Information > General > Enrollments > State Reporting > Student Residency

exitWithdrawDateAsofDate

To support state reporting: captures when ExitWithdrawDate changed.

This is optional and does not report.

N/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.

Student Information > General > Enrollments > Early Reading Deficiency

etag

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

N/A

Arrays

Student School Association Early Reading Intervention

Data Element

Description

Campus Database Field

Campus GUI Location

readingDeficiencyIdentified

A reading deficiency was identified during the current school year.

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.

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.

If any checkboxes are selected under the question, 'What additional instructional time grant related activities were delivered to the student?', report array.

Student Information > General > Enrollments > Early Reading Deficiency

Student School Association Early Reading Intervention Reading Deficiency Activity

Data Element

Description

Campus Database Field

Campus GUI Location

readingDeficiencyActivityDescriptor

Indicates the type of additional instructional time related activities delivered to the student.

If Before School = selected, report 01.
If During School = selected, report 02.
If After School = selected, report 03.
If Summer Program = selected, report 04.
If Other Allowable Grant Activities = selected, report 05.
If Read At Home = selected, report 06.

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 Value	Ed-Fi Short Description	Ed-Fi Description
01	Transfer	Transfer
02	Re-entry	Re-entry
03	Next year school	Next year school
04	New to education system	New to education system
05	Other	Other

This table describes the mapping for the Start Status/Entry Type Descriptor:

Code	Name	Ed-Fi Code
	From public school, same district	05
02	From public school, different state district	01
03	From public school, different state	01
04	From private non-religious school, same district	01
05	From private non-religious school, different state district	01
06	From private, non-religious school, different state	01
07	From private religious school, same district	01
08	From private religious school, different state district	01
09	From private religious school, different state	01
10	From a school outside of the US	01
11	From an institution	01
12	From a charter school	01
13	From home schooling	01
14	Matriculation from another school	01
15	Continuous within same school	05
16	Re-entry after voluntary withdrawal	02
17	Re-entry after involuntary withdrawal	02
18	First entry into a US school	04
19	First entry into a US school, previously in school	04
20	First entry into a US school, not previously in school	04
21	Placement in district by another district IEP	05
99	Other	05
TIN	Transferred In	NULL
SOY	Start of Year	NULL
ESC	Enrollment Status Change	NULL

This table describes the Ed-Fi Value mapped and reported for Exit Withdrawal Type Descriptor:

Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
00	Not enrolled	Use 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
01	Graduated from general education with a high school diploma	Use 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.
02	Graduated from general education with a high school diploma;college	Use 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
03	Graduated from an alternative program with a high school diploma	Use for a graduate receiving a diploma from an alternative program in a regular high school or a separate building.
04	Graduated from general education with a high school diploma;non-degree grade	Use 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).
05	Completed 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.
06	Completed general education with other certificate	Use for a student who completed school with some other type of certificate, such as a certificate of attendance/completion or a district competency test.
07	Dropped out of school	Use 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.
08	Enrolled in another public school district in Michigan	Use 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.
09	Moved out of state	Use 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.
10	Expelled 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

Action	Trigger
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.
Delete	Delete 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.
Delete	When 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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource

N/A

schoolReference

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

entityID

N/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.

N/A

studentReference

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

studentUniqueId

N/A

eventDate

Date for this attendance event.

N/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:

Report '02' when the majority of absence for the day is Absent/Excused.
Report '03' when the majority of absence for the day is Absent/Unexcused and/or Absent/Unknown.
If absence times are equal, report '03'.
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:
Status Excuse
Absent Excused
Absent Unexcused
Absent Unknown
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.

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.

N/A

educational
EnvironmentType

The educational environment.

This element is optional and does not report.

N/A

absenceAmountDescriptor

N/A

instructionalMinutes

N/A

etag

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

N/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 Value	Ed-Fi Short Description	Ed-Fi Description
03	Unexcused Absence	Unexcused Absence
02	Excused Absence	Excused Absence
04	Tardy	Tardy

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.

Action	Trigger
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.
Post	Send 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.
Delete	When 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.
Delete	Delete 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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource.

N/A

sectionReference

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

id
classPeriodReference
courseOfferingReference
locationReference
schoolReference
sessionReference

N/A

studentReference

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

studentUniqueId

N/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.

Enrollment.startDate

Terms.startDate

Student Information > General > Enrollments > Start Date

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:

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
If NULL, report the latest term start date associated with the term descriptor selected for this section based on section schedule placement.

Roster.endDate

Terms.endDate

Student Information > General > Schedule > Roster End Date

System Administration > Calendar > Calendar > Terms

homeroomIndicator

Indicator 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.

Course.homeroom

Section.homeroom

Scheduling > Course > Homeroom

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.

N/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.

N/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.

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.

Student Information > Program Participation > Programs

etag

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

N/A

Type/Descriptors

Code Value	Short Description	Description
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.

Action	Trigger
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
Delete	Delete attendance record if all attendance is removed for the day
Delete	When an enrollment is deleted or the No Show or State Exclude checkboxes are checked
Delete	If 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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource

N/A

sectionReference

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

N/A

studentReference

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

N/A

eventDate

Date for this attendance event.

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

N/A

attendanceEventReason

The reported reason for a student's absence

This element is optional and does not report.

N/A

educationalEnvironmentType

Key for EducationalEnvironment

This element is optional and does not report.

N/A

etag

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

This element is optional and does not report.

N/A

Type/Descriptors

Code Value	Short Description	Description
02	Excused Absence	Excused Absence
03	Unexcused Absence	Unexcused Absence
04	Tardy	Tardy

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.

Action

Trigger

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).

Delete

Student 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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource.

N/A

studentUniqueId

A unique alpha-numeric code assigned to a student. This element reports the Ed-Fi ID of the student.

Person.edFiId

Census >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.

N/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.

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.

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.

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.

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.

N/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)

Identity.legalGender

Identity.gender

Census > People > Identity > Protected Identity Fields > Gender

Census > People > Identity > Gender

birthDate

The month, day, and year on which an individual was born. The Birth Date from the student's currently Identity record is reported.

Identity.birthDate

Census > 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.

N/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.

Identity.birthState

Census > 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.

Identity.birthCountry

Census > People > Identities > Birth Country

dateEnteredUS

For 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.

Identity.
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.

EnrollmentMI. multipleBirth

Census > People > Demographics > Multiple Birth Order

profileThumbnail

File name for the ProfileThumbnail photograph.

This element is currently not reported or collected.

N/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:

If droplist is = Yes, report "true"
If droplist is = No, report "false"

Identity.
hispanicEthnicity

Census > People > Identities > Is the individual Hispanic/Latino?

oldEthnicityType

No longer reports data.

N/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.

PosEligibility.eligibility

FRAM > 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.

PosEligibility.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

N/A

Student 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.

N/A

loginId

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

This element is currently not reported or collected.

N/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.

N/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.

N/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:

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.

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

Address.postOfficeBox

Address.number

Address.street

Address.tag

Address.prefix

Address.dir

Households > Address Info

apartmentRoomSuiteNumber

The apartment, room, or suite number of an address.

Address.apt

Households > 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.

N/A

city

The name of the city in which an address is located.

Address.city

Households > Address Info > City

stateAbbreviationType

The abbreviation for the state (within the United States) or outlying area in which an address is located.

Address.state

Households > Address Info > State

postalCode

The five or nine digit zip code portion of an address.

SAddress.zip

Households > 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.

N/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.

N/A

latitude

The geographic latitude of the physical address.

This field is optional and does not report.

N/A

longitude

The geographic longitude of the physical address.

This field is optional and does not report.

N/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.

N/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.

N/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.

Homeless
UnaccompaniedYouth

Student Information > Program Participation > Homeless

descriptor

If Homeless = NOT NULL, report codeValue = ‘Homeless’
If Unaccompanied Youth = selected, report codeValue = “Unaccompanied Youth”

beginDate

The organization code or name assigning the assessment identification code.

This element is optional and does not report.

N/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.

N/A

designatedBy

The person, organization, or department that designated the characteristic.

This element is optional and does not report.

N/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.

N/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.

Reports the Ed-Fi Code from the disabilities entered for the student on a locked IEP or IFSP
If blank, does not report

Enrollment.disability1

Enrollment.disability2

Enrollment.disability3

Student Information > General > Enrollments > Special Ed Fields

disabilityDescriptor

This descriptor defines a student's impairment.

Report the mapped Ed-Fi code for the disability.

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.

N/A

orderOfDisability

The order by severity of student's disabilities: 1- Primary, 2 - Secondary, 3 - Tertiary, etc.

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'

N/A

disabilityDetermination SourceType

Key for Disability Determination Source Type

This element is optional and does not report.

N/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.

Reports the email address entered for that person
1. Do not report if Email is marked as "Private"
If blank, does not report

N/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:

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.

Reports ‘State’ if Student State ID = NOT NULL.
Reports ‘District’ if Local Student Number = NOT NULL.

N/A

Assigning Organization Identification Code

The organization code or name assigning the assessment identification code.

Reports ‘84000’ if Student State ID = NOT NULL.
Reports State District Number if Local Student Number = NOT NULL.

N/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.

Report the Student State ID if populated.
Report the Local Student Number if populated

Person.
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.

N/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.

N/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.

N/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.

If blank, do not report this field
If the code does not match an Ed-Fi code, do not report a record
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:

Identity.
homePrimaryLanguage

Census > People > Demographics > Home Primary Language

languageDescriptor

An unordered collection of studentLanguageUses. Language(s) the individual uses to communicate.

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).

Identity.
homePrimaryLanguage

Census > People > Identities > Home Primary Language, Native Language

uses

An unordered collection of studentLanguageUses. Language(s) the individual uses to communicate.

N/A

languageUseType

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

If Home Primary Language = NOT NULL, report ‘Home language’.
If Native Language = NOT NULL, report ‘Native language’.

identity.homePrimaryLanguage

Census > 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:

N/A

Census > People > Identities

otherNameType

This reports the Other Name Type Ed-Fi value mapped in the Other Name Type table in the section below.

N/A

personalTitlePrefix

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

This element is not collected or reported.

N/A

firstName

A name given to an individual at birth, baptism, or during another naming ceremony, or through legal change.

Identity.firstName

Census > People > Identities > First Name

middleName

A secondary name given to an individual at birth, baptism, or during another naming ceremony.

Identity.middleName

Census > People > Identities > Middle Name

lastSurname

The name borne in common by members of a family.

Identity.lastName

Census > People > Identities > Last Name

generationCodeSuffix

An appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III).

Identity.suffix

Census > 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.

N/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

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.

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.

Report Start Date of program.

Student Information > Program Participation > Programs

endDate

The date the Program Participation ended. Reports the end date of the programs.

Report End Date of program

Student Information > Program Participation > Programs

designatedBy

The person, organization, or department that made a student designation.

This field is optional and does not report.

N/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.

N/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.

N/A

statuses

An unordered collection of studentProgramParticipationStatuses. (MI EXT) To indicate the status of the students participation in the program (i. g. eligible, started, completed, not eligible)

N/A

programParticipation StatusDescriptor

The program the student is associated with or receiving services from.

Program Reporting

If Code = 6011, 6012, 6013, 6014, 6015, 6016, 6017, 6021, 6022, 6023, 6024, 6025, 6026, or 6027, report 6010.
Else report Code from program reported.

Military Connections Reporting

Report 9140.

programCode

Program 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:

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'.

identity.homePrimaryLanguage

Census> 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.

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.

Reports the Phone numbers entered in the Personal Contact Information for that person
1. do not report Phone Number is marked as "Private"
If blank, does not report
See Business Rule S3 in Scope Year logic to determine the eligibility of records
See Array section for data logic for each field

N/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.

N/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.

Identity.dateEntered USSchool

Census > 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.

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.

PosEligibility.eligibility

FRAM > 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.

Census > 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.

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.

N/A

medicalNotes

Reports medical notes such as Allergic to Bee Stings for transportation records.

This field is optional and does not report.

N/A

msdsRaceOrders

An unordered collection of studentMSDSRaceOrders. (MI EXT) Captures the racial group and order choice for MSDS. Reports the student's race(s).

N/A

etag

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

N/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 Campus	Ed-Fi Short Description	Ed-Fi Description
1	Eligible Free	Student is eligible for free meal/milk program for current school year.
2	Eligible Reduced	Student 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 Value	Ed-Fi Short Description	Ed-Fi Description
01	Limited	Limited
02	Limited Monitored 1	Limited Monitored 1
03	Limited Monitored 2	Limited Monitored 2
04	Not Limited	Not Limited

This table describes the Ed-Fi Value mapped and reported for Student Characteristic Descriptors: Only Homeless and Unaccompanied Youth report.

Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
Asylee	Asylee	Asylee
Displaced Homemaker	Displaced Homemaker	Displaced Homemaker
Foster Care	Foster Care	Foster Care
Homeless	Homeless	Homeless
Immigrant	Immigrant	Immigrant
Migrant	Migrant	Migrant
Neglected or Delinquent	Neglected or Delinquent	Neglected or Delinquent
Parent in Military	Parent in Military	Parent in Military
Pregnant	Pregnant	Pregnant
Refugee	Refugee	Refugee
Runaway	Runaway	Runaway
Section 504 Handicapped	Section 504 Handicapped	Section 504 Handicapped
Single Parent	Single Parent	Single Parent
Unaccompanied Youth	Unaccompanied Youth	Unaccompanied Youth

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

Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
05	Cognitive Impairment	MARSE R340.1705
06	Emotional Impairment	MARSE R340.17069
07	Hearing Impairment	MARSE R340.1707
08	Visual Impairment	MARSE R340.1708
09	Physical Impairment	MARSE R340.1709
10	Speech and Language Impairment	MARSE R340.1710
11	Early Childhood Developmental Delay	MARSE R340.1711
13	Specific Learning Disability	MARSE 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 Value	Ed-Fi Short Description	Ed-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 Value	Ed-Fi Short Description	Ed-Fi Description
1	First	First
2	Second	Second
3	Third	Third
4	Fourth	Fourth
5	Fifth	Fifth
6	Sixth	Sixth

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

Ed-Fi Code Value	Ed-Fi Short Description	Ed-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
3060	Section 31a At Risk	Section 31a At Risk
3500	Early/Middle College Participant	Early/Middle College Participant
6010	Title I Targeted Assistance Program	Title I Targeted Assistance Program
7760	21st Century Community Learning Center Program (21st CCLC)	21st Century Community Learning Center Program (21st CCLC)
9110	Out-of-State Resident	Out-of-State Resident
9120	International Student	International Student
9130	Immigrant	Immigrant
9210	Section 504	Section 504
9220	Alternative Education	Alternative Education
9222	Sec. 6(4)(l)(ii) Pupil Count Exception	Sec. 6(4)(l)(ii) Pupil Count Exception
9229	Seat-Time Waiver Participant	Seat-Time Waiver Participant
9230	Developmental Kindergarten	Developmental Kindergarten

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

Ed-Fi Code Value	description	shortDescription
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

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

Action	Trigger
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
Delete	When an IEP/IFSP is deleted for a student.
Delete	When a SPEd entry date is changed for a student.
Delete	When all overlapping enrollments are deleted for a school.
Delete	When 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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource.

N/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

School.stateSchool Number

System Administration > Resources > School Information > State School Number

programReference

A reference to the related Program resource. Reports the Special Education Program reference.

N/A

studentReference

A reference to the related Student resource.Reports the data that is part of the natural key for the student resource.

N/A

beginDate

The month, day, and year on which the Student first received services. Reports the start date of the IEP/IFSP.

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.

Enrollment.sped ExitDate

Student 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.

Enrollment.sped ExitReason

Student 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.

N/A

enrollmentStatus

This field is optional and does not report.

N/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.

Evaluation. timeliness

Student 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.

Evaluation. evalResult

Student 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.

PlanState. 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.

Evaluation. evalCompliance

Student 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%'

PlanType.printedFormat

Student 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.

N/A

specialEducationHoursPerWeek

The number of hours per week for special education instruction and therapy.

This field is optional and does not report.

N/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.

N/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.

N/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.

N/A

lastEvaluationDate

The date of the last special education evaluation.

This field is optional and does not report.

N/A

iepReviewDate

The date of the last IEP review.

This field is optional and does not report.

N/A

iepBeginDate

Reports the start date of the IEP/IFSP.

Plan.startDate

Student Information > Special Education > General > Documents > IEP/IFSP > Start Date

iepEndDate

Reports the end date of the IEP/IFSP.

Plan.endDate

Student 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

SEPlan.fapeOfferDate

SEPlan. evaluationDate

Student Information > Special Education > General > Documents > IEP/IFSP > Offer of a FAPE, Initial Date

section52FTE

The 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.

Enrollment.fteSection52

Student Information > General > Enrollments > Special Ed Fields > FTE Section 52

section53FTE

The 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.

Enrollment.fteSection53

Student Information > General > Enrollments > Special Ed Fields > FTE Section 53

dateOfParentalConsent

The 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.

Evaluation.consentDate

Student 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.

Evaluation.extensionDays

Student 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.

Evaluation.fapeOfferDate

Student Information > General > Special Ed > Documents > Evaluation > Offer of a FAPE

additionalPlanDate

If 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/A

services

An unordered collection of studentProgramAssociationServices. Indicates the services being provided to the student by the program. This field is an array.

N/A

serviceDescriptor

Reports the ID of the Service Descriptor.

Report the Ed-Fi Code associated with the assigned Special Education Program service.
Service must be active at least one day in the Scope Year to report.

PlanService. 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.

N/A

serviceBeginDate

Reports the first date the student was in this option for the school year.

PlanServiceProvided .startDate

Student Information > Special Education > Documents > IEP > Start Date

serviceEndDate

Reports the last date the student was in this option for the current school year.

PlanServiceProvided. endDate

Student 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.

N/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.

Plan.relatedServices

Student 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.

PlanService. stateCode

N/A

Type/Descriptors

The highlighted column indicates the reported valued.

Service Descriptors

Ed-Fi Code Value	Ed-Fi Short Description	Ed-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 Value	Ed-Fi Short Description	Ed-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 Value	Ed-Fi Short Description	Ed-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

Action	Trigger
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.
Delete	When Location is changed from NULL to a school, delete any school records not associated with the selected school.
Delete	When Location is changed from one school to another school, delete any school records not associated with the selected school.
Post	When 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
Delete	When all Title 1 programs are deselected for a student
Delete	When a Start Date is changed for a student
Delete	When 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 Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource.

N/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

School.stateSchoolNumber

System Administration > Resources > School Information > State School Number

programReference

A reference to the related Program resource. Reports the Special Education Program reference.

N/A

studentReference

A reference to the related Student resource.Reports the data that is part of the natural key for the student resource.

N/A

beginDate

The month, day, and year on which the Student first received services. Reports the start date of the program.

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.

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.

Enrollment.spedExitReason

Student 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.

N/A

enrollmentStatus

This field is optional and does not report.

N/A

services

An unordered collection of studentProgramAssociationServices. Indicates the services being provided to the student by the program. This field is an array.

N/A

serviceDescriptor

The ID of the Service Descriptor.

Reports the Code from the program:

State Reported must be selected
Code must be 6011, 6012, 6013, 6014, 6015, 6016, or 6017

Student Information > Program Participation > Programs

primaryIndicator

Reports true if the service is primary.

This field is optional and does not report.

N/A

serviceBeginDate

The first date the student was in this option for the school year.

Reports the program Start Date.

N/A

Student 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.

N/A

Student Information > Program Participation > Programs > End Date

programSupports

An unordered collection of studentTitleITASPRogramAssociationProgramSupports. This field is an array.

N/A

programSupportDescriptor

The ID of the Service Descriptor. State Reported must be marked.

Reports the mapped code for the Program Support Descriptor.

EnrolmentMI.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 Value	Ed-Fi Short Description	Ed-Fi Description
6011	Reading/Language Arts	Supplemental instruction provided to the student in reading or language arts and funded by Title I.
6012	English (ESL) for LEP Students	Supplemental instruction provided to an English-language learner (ESL, EL) to improve his/her English-language skills and funded by Title I.
6013	Mathematics	Supplemental instruction provided to the student in mathematics and funded by Title I.
6014	Science	Supplemental instruction provided to the student in science and funded by Title I.
6015	Social Studies	Supplemental instruction provided to the student in social studies and funded by Title I.
6016	Vocational/Career	Supplemental instruction provided to the student in vocational or career development and funded by Title I.
6017	Other	Supplemental 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 Value	Ed-Fi Short Description	Ed-Fi Description
6021	Supporting Guidance/Counseling	A certified school counselor providing additional supplementary guidance and counseling to eligible students.
6022	Social Work, Outreach/Advocacy	A certified school social worker hired to provide one-on-one or small group supplementary support.
6023	Prevention Education	A supplementary support program approved in the Consolidated Application.
6024	Health	A school nurse hired to provide supplemental health services; does not include immunization, medication or health checks.
6025	Dental	Only as all other resources are exhausted.
6026	Eye Care	Only as all other resources are exhausted.
6027	Pupil Transportation	Only for Title I program and services.
6028	Other	TAS 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.

Was this helpful?