Michigan Ed-Fi Data v3.1 - Student Education Organization Association

Classic View: System Administration > Ed-Fi

Search Terms: Ed-Fi

This association represents student information that is specific to a student’s relationship with an Education Organization.

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 and the enrollment overlaps a configured year. 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. Do not send a record if the No Show checkbox ix checked on the enrollment.
Put	When any student data is edited for the person in the Data Elements fields below: When the person’s identity record is changed: Race/Ethnicity, Gender, Home Primary Language, US Entry Type. When one of the person’s household locations is updated/changed: Mailing, Private. When one of the person’s household memberships is added/deleted/changed: Start Date, End Date, Private. When any data in the address the student is associated with change:PO Box, Number, Prefix, Street, Tag, Direction, Apt, City, State, Zip When a student's contact information is changed: email, phone number: Email, Other Phone, Work Phone, Cell Phone, Pager, Private. When any of the Student Characteristics change: Unaccompanied Youth: A student has a Homeless record that overlaps the configure year, Start/End Dates are changed so record no longer overlaps configured year, the record is deleted, the Unaccompanied Youth field is changed, the Runaway checkbox is checked or unchecked. When a change is made to a program. When a change is made to Date Entered US School.
Delete	This record will delete if the student no longer has an eligible enrollment in the District.
Delete	If the enrollment is marked as a No Show.

Resource Toggle and Resync Logic

This table describes the Resource Toggle and Trigger logic of this object.

Action	Business Rule
None	If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
Resync	If a record is in the Ed-Fi Identity Mapping table and not in the ODS, it will be deleted from the Ed-Fi Identity Mapping table.
Resync	If a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it will be deleted from the ODS.
Resync	If a mapping is changed in Resource Preferences, a resync will need to be done to reflect the changes.

Natural Key Changes, Cascading Updates, and Deletes Logic

This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.

Action	Business Rule
Post/Delete	Natural Key Change: If the District Number/Ed-Fi District Number changes, a delete/post will occur with the cascading deletes from the LEA ID Change triggers. If an Ed-Fi ID changes, this will happen with the cascading deletes from the Ed-Fi ID Change trigger.
Delete	Cascading Deletes: N/A - no dependent resources

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

Logic

The record will send to the scope year for the school year the enrollment is associated with.

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

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label	Mapping Needed
Race Descriptor	Race/Ethnicity
Primary Nighttime Residence	Homeless Primary Nighttime Residence

Identity Mapping Object Key

This table describes the Identity Mapping Object Key of this object.

campusObjectType	Object Key Data Source
Person	personID

Object Data Elements

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

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
id	The unique identifier of the resource.		M
education OrganizationId	The identifier assigned to an education organization.	Report reference to the Local Education Agency.	M
studentReference	A unique alphanumeric code assigned to a student.	Reports the natural key of the Students resource.	M
addresses	The set of elements that describes an address, including the street address, city, state, and ZIP code.	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. Do not report if the Address Location Detail or Household Membership is marked as "Private". Determine the eligibility of records by looking at the Scope Year section. See Array section below for data logic for each field.	O	Household Addresses> Mailing Household Membership> Start Date Household Addresses> Start Date	HouseholdLocation.mailing HouseholdMember.startDate Householdlocation.StartDate
cohortYears	The type and year of a cohort (e.g., 9th grade) the student belongs to as determined by the year that student entered a specific grade.	This is optional, does not report.	O
disabilities	The disability condition(s) that best describes an individual’s impairment, as determined by evaluation(s) conducted by the education organization.	This is optional, does not report.	O
electronicMails	The numbers, letters, and symbols used to identify an electronic mail (e-mail) user within the network to which the individual or organization belongs.	Reports the email address entered for that person. Do not report if Email is marked as "Private". If blank, does not report. See Array section for data logic for each field.	O	Census> People> Demographics> Email	contact.email
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. The term, "Spanish origin," can be used in addition to "Hispanic or Latino."	Report "Is the individual Hispanic/Latino?" from the student's current identity: If droplist is = Yes, report "true". If droplist is = No, report "false".	O	Census>People> Identities> Is the Individual Hispanic or Latino?	identity.hispanicEthnicity
international Addresses	The set of elements that describes an international address.	This is optional, does not report.	O
languages	The language(s) the individual uses to communicate. It is strongly recommended that entries use only ISO 639-3 language codes.	See Array section below for data logic for each field.	O
limitedEnglish ProficiencyDescriptor	An indication that the student has been identified as limited English proficient by the Language Proficiency Assessment Committee (LPAC), or English proficient.	This is optional, does not report.	O
loginId	The login ID for the user; used for security access control interface.	This is optional, does not report.	O
oldEthnicity Descriptor	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 is optional, does not report.	O	N/A	N/A
profileThumbnail	File name for the ProfileThumbnail photograph.	This is optional, does not report.	O	N/A	N/A
programParticipations	An unordered collection of studentEducationOrganizationAssociation ProgramParticipations. Key programs the student is participating in or receives services from.	See array for field specific logic.	O
races	The general racial category which most clearly reflects the individual’s recognition of his or her community or with which the individual most identifies. The data model allows for multiple entries so that each individual can specify all appropriate races.	See Array section below for data logic for each field.	O	Census> People> Identities> Race/ Ethnicity	IdentityRaceEthnicity and racethnicity.raceid
sexDescriptor	A person's gender.	Report the Gender from the student's current identity record. This is NOT legal gender. Report the following based on the value selected in the droplist. Female report 'Female' Male report 'Male' If blank or Non-binary, report 'Not Selected'.	M	Census>People> Identities>Gender	identity.Gender
characteristics	Reflects important characteristics of the student’s home situation: Displaced Homemaker, Immigrant, Migratory, Military Parent, Pregnant Teen, Single Parent, and Unaccompanied Youth.	See Array below for logic.	O
homelessDescriptor	This characteristic is used to identify students who lack fixed, regular and adequate residence and to indicate the student’s primary nighttime residence. Students who become homeless for any period of time within the school year are eligible for all homeless services for the entire school year.	Report Ed-Fi Code of Primary Nighttime Residence. If NULL, do not report this field. Homeless status needs to active within the Scope Year to report. If more than one status is found, report the most recent.	O	Student Information > Programs > Homeless > Primary Nighttime Residence	Homeless.primaryNight TimeResidence
raceAsOfDate	The date of the most recent change in Race.	Reports the Effective Date of Identity record if a change in federal race checkboxes or the hispanic/latino droplist is found on or before the active date/today's date.	O	Census > People > Identity > Effective Date
schoolFoodServices EligibilityAsOfDate	The date of the most recent change in SchoolFoodServicesEligibility.	Do not report.	O
yearOfEntry	The four-digit calendar year in which the student first attended school in the United States.	Report year from Date Entered US School.	O	Census > People > Demographics > Date Entered US School
msdsRaceOrders	Captures the racial group and order choice for MSDS.	Reports student race(s). See array for field specific logic.	O
identificationCodes	A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to a student.	See Array section for reporting logic.	O
indicators	Indicator(s) or metric(s) computed for the student (e.g., at risk) to influence more effective education or direct specific interventions.	This is optional, does not report.	O
telephones	The 10-digit telephone number, including the area code, for the person.	See Array section for reporting logic.	O
tribalAffiliations	An American Indian tribe with which the student is affiliated.	This is optional, does not report.	O
indicators	Indicator(s) or metric(s) computed for the student (e.g., at risk) to influence more effective education or direct specific interventions.	See Array section for reporting logic.	O
_etag	A unique system-generated value that identifies the version of the resource.		O

Array Data Elements

Indicators/Digital Equity

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Format
indicatorName	The name of the indicator or metric: InternetAccessInResidence InternetBarrierInResidence InternetAccessTypeInResidence InternetPerformance DigitalDevice PrimaryLearningDeviceAccess PrimaryLearningDeviceProvider	If a Digital Equity record exists for the student that falls within the config year, report the following: "InternetAccessInResidence" as the Indicator Name for the 1st record in the array Report "InternetBarrierInResidence" for the 2nd record Report "InternetAccessTypeInResidence" for the 3rd record Report "InternetPerformance" for the 4th record Report "DigitalDevice" for the 5th record Report "PrimaryLearningDeviceAccess" for the 6th record Report "PrimaryLearningDeviceProvider" for the 7th record If multiple Digital Equity records exist for the student, report the most recent record. If no record exists, do not report.	M	Student Information > Program Participation > State Programs > Digital Equity	string (max length 200)
indicator	The value of the indicator or metric.	If a Digital Equity record exists for the student that falls within the config year, report the name for the value selected for each indicatorName.	M	Student Information > Program Participation > State Programs > Digital Equity	string (max length 35)
indicatorGroup	The name for a group of indicators.	If a Digital Equity record exists for the student that falls within the config year, report "DigitalEquity" for each indicatorGroup.	M		string (max length 200)

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

Format

indicatorName

The name of the indicator or metric:

InternetAccessInResidence

InternetBarrierInResidence
InternetAccessTypeInResidence
InternetPerformance
DigitalDevice

PrimaryLearningDeviceAccess

PrimaryLearningDeviceProvider

If a Digital Equity record exists for the student that falls within the config year, report the following:
1. "InternetAccessInResidence" as the Indicator Name for the 1st record in the array
2. Report "InternetBarrierInResidence" for the 2nd record
3. Report "InternetAccessTypeInResidence" for the 3rd record
4. Report "InternetPerformance" for the 4th record
5. Report "DigitalDevice" for the 5th record
6. Report "PrimaryLearningDeviceAccess" for the 6th record
7. Report "PrimaryLearningDeviceProvider" for the 7th record
If multiple Digital Equity records exist for the student, report the most recent record.
If no record exists, do not report.

Student Information > Program Participation > State Programs > Digital Equity

string (max length 200)

indicator

The value of the indicator or metric.

If a Digital Equity record exists for the student that falls within the config year, report the name for the value selected for each indicatorName.

Student Information > Program Participation > State Programs > Digital Equity

string (max length 35)

indicatorGroup

The name for a group of indicators.

If a Digital Equity record exists for the student that falls within the config year, report "DigitalEquity" for each indicatorGroup.

string (max length 200)

Identification Codes

Data Element Label	Business Requirement	Business Rules
studentIdentificationSystemDescriptor	A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to a student.	If reporting Student State ID, report 'State'. If reporting Local Student Number, report 'District'.
assigningOrganizationIdentificationCode	The organization code or name assigning the StudentIdentificationCode.	If reporting Student State ID, report 'State'. If reporting Local Student Number, report State District Number.
identificationCode	A unique number or alphanumeric code assigned to a student by a school, school system, a state, or other agency or entity.	Report Student State ID Report Local District Number.

Student Address

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
addressTypeDescriptor	Key for Address	All addresses will report as 'Home'.	M
stateAbbreviationDescriptor	The abbreviation for the state (within the United States) or outlying area in which an address is located.	Reports the State for the address being reported.	M	Households> Address Info> State	address.state
apartmentRoomSuiteNumber	The apartment, room, or suite number of an address.	Reports the value entered in Apt field if populated.	O	Households> Address Info> Apt	address.apt
buildingSiteNumber	The number of the building on the site, if more than one building shares the same address.	This is optional, do not report.	O
city	The name of the city in which an address is located.	Reports the City for the address being reported.	M	Households> Address Info> City	address.city
countyFIPSCode	5 digit code consisting of the two digit state code followed by the three digit FIPS code for the county.	This is optional, does not report.	O
doNotPublishIndicator	An indication that the address should not be published.	This is optional, does not report.
latitude	The geographic latitude of the physical address.	This is optional, does not report.	O
longitude	The geographic longitude of the physical address.	This is optional, does not report.	O
nameOfCounty	The name of the county, parish, borough, or comparable unit (within a state) in which an address is located.	This is optional, does not report.	O
postalCode	The five or nine digit zip code portion of an address.	Reports the Zip Code for the address being reported	M	Households> Address Info> Zip Code	address.zip
streetNumberName	The street number and street name or post office box number of an address.	Reports Address PO Box + Number + Street + Tag + Prefix + Dir.	M	Households>Address Info	address.postOfficeBox address.number address.street address.tag address.prefix address.dir
periods	The time periods for which the address is valid. For physical addresses, the periods in which the person lived at that address.	This is optional, does not report.	O
beginDate	The first date the address is valid. For physical addresses, the date the person moved to that address.	This is optional, does not report.	M
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, does not report.	O

Electronic Mail

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
electronicMailTypeDescriptor	The type of email listed for an individual or organization. For example: Home/Personal, Work, etc.).	The Primary Email address will report as "Home/Personal" Do not report Secondary Email for students.	M
doNotPublishIndicator	An indication that the electronic email address should not be published.	This is optional, does not report.	O
electronicMailAddress	The electronic mail (e-mail) address listed for an individual or organization.	Reports the email address entered for that person.	M	Census> People> Demographics> Email	contact.email
primaryEmailAddressIndicator	An indication that the electronic mail address should be used as the principal electronic mail address for an individual or organization.	This is optional, does not report.	O

Student Language

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
languageDescriptor	A specification of which written or spoken communication is being used.	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 Report the Code from the Native 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 If Home Primary Language and Native Language match, report a single languageDescriptor associated with both uses (Home Language, Native Language).	M	Census> People> Identities> Race/Ethnicity
uses	A description of how the language is used (e.g. Home Language, Native Language, Spoken Language).	See uses Array section.	O

Uses

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
languageUseDescriptor	A specification of which written or spoken communication is being used.	If Home Primary Language = NOT NULL, report ‘Home Language’ If Native Language = NOT NULL, report ‘Spoken Language’	M	Census> People> Identities> Race/Ethnicity

Races

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
raceDescriptor	The racial category which most clearly reflects the individual’s recognition of his or her community or with which the individual most identifies.	If American Indian - Alaska Native = selected, report "American Indian - Alaska Native". If Asian = selected, report 'Asian'. If Black or African American = selected, report 'Black - African American'. If Native Hawaiian or Other Pacific Islander = selected, report 'Native Hawaiian - Pacific Islander'. If White = selected, report 'White'.	M	Census> People> Identities> Race/Ethnicity	IdentityRaceEthnicity and racethnicity.raceid
raceOrderChoiceDescriptor	The order choice of the racial category.	Always report '1'.	M

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

raceDescriptor

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

If American Indian - Alaska Native = selected, report "American Indian - Alaska Native".
If Asian = selected, report 'Asian'.
If Black or African American = selected, report 'Black - African American'.
If Native Hawaiian or Other Pacific Islander = selected, report 'Native Hawaiian - Pacific Islander'.
If White = selected, report 'White'.

Census> People> Identities> Race/Ethnicity

IdentityRaceEthnicity

and

racethnicity.raceid

raceOrderChoiceDescriptor

The order choice of the racial category.

Always report '1'.

Student Characteristics

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
Student Characteristic Descriptor	This descriptor captures important characteristics of the student’s environment or situation. Generally used for non-program-based student characteristics.	Report each characteristic based on the requirements below. Student must have a Student School Association in the configured year to report a characteristic.	M
		US Entry Type Optional, does not report.	O
		Career Tech Special Populations Optional, does not report.
		Parent in Military Optional, does not report.
		Homeless If the student has a Homeless record that overlaps the configured year and Unaccompanied Youth = Yes, report 'Unaccompanied Youth'.		Student Information> Program Participation> Homeless
		Foster Care Optional, does not report.			f
		Economic Disadvantaged Optional, does not report.
		Flags: Optional, does not report.
designatedBy	The person, organization, or department that designated the characteristic.	This is optional, does not report.	O
periods	The time periods for which characteristic was effective.	This is optional, does not report.	O
beginDate	The date the characteristic was designated.	This is optional, does not report.	O
endDate	The date the characteristic was removed.	This is optional, does not report.	O

Program Participations

Data Element Label	Business Requirement	Business Rules	M, C or O
programTypeDescriptor	The type of program.	Program Reporting Student program must be active within the Scope Year. Program must have: State Reported = selected Report the following program types 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 student has a relationship with a Guardian that has an active Military Connections record within the Scope Year, report Other. Status must be = Active Duty, Deployed or Active Duty, Not Deployed Branch must be other than Air National Guard or Army National Guard.	M
beginDate	The date the Student was associated with the Program or service.	Does not report	O
designatedBy	The person, organization, or department that designated the program association.	Does not report	O
endDate	The date the Program participation ended.	Does not report	O
programCharacteristics	Reflects important characteristics of the Program, such as categories or particular indications.	Does not report	O
enrollmentPercent	(MI EXT) The full-time equivalency (FTE) that the participant spends in the program reported.	Does not report	O
statuses	An unordered collection of studentEducationOrganizationAssociation ProgramParticipationStatuses. (MI EXT) To indicate the status of the students participation in the program (i. g. eligible, started, completed, not eligible)	See programParticipationStatus Descriptor	O
programParticipation StatusDescriptor	(MI EXT) To indicate the status of the students participation in the program (i. g. eligible, started, completed, not eligible)	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.	M

Telephones

Data Element Label

Business Requirement

Business Rules

M, C, or O

Data Source GUI Path

Database Field

telephoneNumberTypeDescriptor

The type of communication number listed for an individual or organization.

Reports based on the Phone Number type entered in Campus based on the chart below.

Campus Phone	Ed-FI Code
Cell Phone	Mobile
Other Phone	Home
Work Phone	Work
Pager	Other

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

doNotPublishIndicator

An indication that the telephone number should not be published.

This is optional, does not report.

orderOfPriority

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

This is optional, does not report.

telephoneNumber

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

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.

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

contact.otherPhone

contact.workPhone

contact.cellPhone

contact.pager

textMessageCapabilityIndicator

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

This is optional, does not report.

Michigan Ed-Fi Data v3.1 - Student Education Organization Association

Object Triggering Logic

Resource Toggle and Resync Logic

Natural Key Changes, Cascading Updates, and Deletes Logic

Scope Year Logic

Resource Preferences

Identity Mapping Object Key

Object Data Elements

Array Data Elements

Indicators/Digital Equity

Identification Codes

Student Address

Electronic Mail

Student Language

Uses

Races

Student Characteristics

Program Participations

Telephones

Related Articles