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. Do not send records if the Calendar Grade Level "Exclude from State Reporting" checkbox is selected for the grade level that the student's enrollment is tied to.
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 a student's IEP is locked or unlocked and/or a student's disability is changed on the IEP, Enrollment or State Special Education tab. When a student's contact information is changed: email, phone number: Email, Other Phone, Work Phone, Cell Phone, Pager, Private. When a student's LEP information is changed: Program Status, Identified Date, LEP Exit Date, Parent Refused. When a student's Response To Intervention Plan is locked/unlocked or the plan name changes. When any of the Student Characteristics change: Asylee, Refugee, Immigrant: If the student's US Entry Type is changed. Displaced Homemaker, Pregnant, Single Parent: If a student's Special Population is changed. Foster Care: A student has a Foster Care record that overlaps the configured year, Start/End Dates are changed so the record no longer overlaps the configured year, the record is deleted. Economic Disadvantaged: Astudent has an SES FRAM Eligibiltiy record that overlaps the configured year and meets the criteria selected in the Economic Disadvantaged resource preferences, Start/End Dates are changed so the record no longer overlaps the configured year, the record is deleted. Parent in Military: A Military Connections record exists for a Guardian of the student, Start/End Dates are changed so the record no longer overlaps the configured year, the Guardian checkbox is checked/unchecked, the record is deleted. Homeless, Unaccompanied Youth, Runaway: 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.
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
Student Characteristic Descriptor	Military Status
Race Descriptor	Race/Ethnicity
Language Descriptor	Home Primary Language
Ancestry Ethnic Origin Descriptor	Identity Race

Identity Mapping Object Key

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

campusObjectType	Object Key Data Source
Person	personID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
enrollment	Post/Put/Delete Put	The primary table used for sending data for this resource. Reports Disabilities
identity	Put	Reports Hispanic or Latino, Gender, Home Primary Language, US Entry Type.
person	Put	Reports the Ed-FI ID.
contact	Put	Reports the Telephone and Email information.
householdlocation	Put	Determines if address is marked as Mailing or Private.
householdmember	Put	Determines household membership with Start Date, End Date, Private.
address	Put	PO Box, Number, Prefix, Street, Tag, Direction, Apt, City, State, Zip
raceethnicity	Put	Reports Races.
plantype	Put	Reports Indicators.
plan	Put	Reports Disabilities, Indicators.
planstate	Put	Reports Disabilities.
programs	Put	Reports any Characteristic created in Flags.
programparticipation	Put	Reports any Characteristic created in Flags.
Title1	Put	Reports Neglected or Delinquent.
ImpactAidEmployment	Put	Reports Parent in Military.
relatedpair	Put	Guardian checkbox for contact information and Parent in Military.
section504	Put	Reports Section 504 Handicapped.
homeless	Put	Reports Homeless, Unaccompanied Youth, Runaway.

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 Organization Id	The identifier assigned to an education organization.	Report the Ed-Fi School ID. If Ed-Fi School ID is NULL, report: ttddddsssmmm where: tt = district type dddd = district number, left zero filled sss = school number, left zero filled mmm = 000 for all organizations reported in Ed-Fi	M	System Administration > Resources > School > school record > Ed-Fi School ID tt: System Administration > Resources > District Information > district record > Type dddd: System Administration > Resources > District Information > district record > State District Number SSS: System Administration > Resources > School > school record > State School Number	School.entity ID District.type District. number School. number
student Reference	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.	This is optional, does not report.	O
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
electronic Mails	The numbers, letters, and symbols used to identify an electronic mail (e-mail) user within the network to which the individual or organization belongs.	This is optional, does not report.	O
hispanic Latino 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. hispanic Ethnicity
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
limited English Proficiency Descriptor	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
profile Thumbnail	File name for the ProfileThumbnail photograph.	This is optional, does not report.	O
program Participations	Key programs the student is participating in or receives services from.	This is optional, does not report.	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	IdentityRace Ethnicity and racethnicity. raceid
sex Descriptor	A person's gender.	Report from the latest identity record overlapping the enrollment. Check the to see if the "Report Legal Identifies when provided" checkbox is selected. If yes, check to see if Legal Gender is populated. If yes, report the value. If no, report the Gender value. If no, report the Gender value.	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.	C
identification Codes	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.	C
student Indicators	An unordered collection of studentEducationOrganization AssociationStudentIndicators. 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.	C
telephones	The 10-digit telephone number, including the area code, for the person.	This is optional, does not report.	O
tribal Affiliations	An American Indian tribe with which the student is affiliated.	This is optional, does not report.	O
Ancestry Ethnic Origin	An unordered collection of studentEducationOrganization AssociationAncestryEthnicOrigins. The ancestry ethnic origins that pertain to the general racial categories with which the individual identifies.	Report the mapped Ed-Fi Code value associated with any "More Detailed Ancestry/Ethnicity Codes" records saved in the student's record. If no mappings exist for the code, or no value exists, do not report. If "Individual Hispanic/Latino?" is marked as "Yes", report the mapped Ed-Fi Code value associated with any "More Detailed Hispanic/Latino Codes" records saved in the student's record. If "Individual Hispanic/Latino?" is marked as "No", do not report any "More Detailed Hispanic/Latino Codes" records. If no mappings exist for the code, or no value exists, do not report.	C	Census > People > Identities > Race Subcategory' Census > People > Identities > Hispanic Subcategory	Identity.race Subcategory Identity. hispanic Subcategory
birthdate	The month, day, and year on which an individual was born.	Report the Birth Date value from the most recent Identity record.	M	Census > People > Identities > Birth Date	identity. birthdate
FirstName	A name given to an individual at birth, baptism, or during another naming ceremony, or through legal change.	Report from the latest identity record overlapping the enrollment. Check the to see if the "Report Legal Identities when provided" checkbox is selected. If yes, check to see if Legal First Name is populated. If yes, report the value. If no, report the First Name value. If no, report the First Name value.	M	Census > People > Identities > First Name Census > People > Identities > Legal First Name	identity. firstName
Generation Code Suffix	An appendage, if any, used to denote an individual’s generation in his family (e.g., Jr., Sr., III).	Report from the latest identity record overlapping the enrollment. Check the to see if the "Report Legal Identities when provided" checkbox is selected. If yes, check to see if Legal First Name is populated. If yes, report the value from Legal Suffix. If no, report the Suffix value. If no, report the Suffix value. If Null, do not report.	C	Census > People > Identities > Suffix Census > People > Identities > Legal Suffix	Identity.suffix Identity.legal Suffix
LastName	The name borne in common by members of a family.	Report from the latest identity record overlapping the enrollment. Check the to see if the "Report Legal Identities when provided" checkbox is selected. If yes, check to see if Legal First Name is populated. If yes, report the value from Legal Last Name. If no, report the Last Name value. If no, report the Last Name value.	M	Census > People > Identities > Last Name Census > People > Identities > Legal Last Name	identity. lastName
MiddleName	A secondary name given to an individual at birth, baptism, or during another naming ceremony.	Report from the latest identity record overlapping the enrollment. Check the to see if the "Report Legal Identities when provided" checkbox is selected. If yes, check to see if Legal First Name is populated. If yes, report the value from Legal Middle Name. If no, report the Middle Name value. If no, report the Middle Name value. If Null, do not report.	C	Census > People > Identities > Legal Middle Name Census > People > Identities > Middle Name	identity.middle Name
OptOut Indicators Descriptor	An unordered collection of studentEducation OrganizationAssociationOpt OutIndicators.	Report 'MNC' if there is any FRAM record that: Has Start Date on or after July 1st of the Scope Year; and Overlaps the enrollment; and "Opt Out SCHIP" is selected. Else do not report.	M	FRAM > Eligibility > Start Date FRAM > Eligibility > Opt Out SCHIP	POSEligibility. optOutSCHIP
_etag	A unique system-generated value that identifies the version of the resource.		O

Array Data Elements

Student Language

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
uses	A description of how the language is used (e.g. Home Language, Native Language, Spoken Language).	If Home Primary Language = NOT NULL, report ‘Home language’	O	Census> People> Identities> Home Primary Language	identity.homePrimary Language

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

languageDescriptor

The language(s) the individual uses to communicate. It is strongly recommended that entries use only ISO 639-3 language codes.

Report the Language from the Home Primary Language saved on the student's current identity record.
- Look for a mapping saved to the Language Descriptor Override section in preferences. If there is a mapped value, report that mapping.
- If an override is not there, look to see if the language standard code matches an Ed-Fi code, if yes report that value.
- Report default value if saved on the Attribute and the standard code matches an Ed-Fi code.
Else, report NULL.

Census> People> Identities> Home Primary Language

identity.homePrimary

Language

uses

A description of how the language is used (e.g. Home Language, Native Language, Spoken Language).

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

Census> People> Identities> Home Primary Language

identity.homePrimary

Language

Races

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
raceDescriptor	The general racial category which most clearly reflects the individual's recognition of his or her community or with which the individual most identifies.	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 check boxes checked for the students current identity id. Report the Ed-Fi Code mapped to the corresponding Race Ethnicity. Report all races if the student has more than 1 selected. Do not report if the person does not have a Race/Ethnicity checked or there is not a corresponding mapping.	M	Census> People> Identities> Race/Ethnicity	IdentityRaceEthnicity and racethnicity.raceid

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

raceDescriptor

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

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 check boxes checked for the students current identity id.
Report the Ed-Fi Code mapped to the corresponding Race Ethnicity.
- Report all races if the student has more than 1 selected.
Do not report if the person does not have a Race/Ethnicity checked or there is not a corresponding mapping.

Census> People> Identities> Race/Ethnicity

IdentityRaceEthnicity

and

racethnicity.raceid

Student Characteristics

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

Student Characteristic Descriptor

This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program.

Report each characteristic based on the requirements below. Student must have a Student School Association in the configured year to report a characteristic.

Active Duty Parent:
1. Branch is:
  Code Name
  4 Army
  11 Navy
  1 Air Force
  9 Marine Corp
  7 Coast Guard
2. Status is:
  Code Name
  1 Active Duty, Deployed
  2 Active Duty, Not Deployed
3. Start Date/End Date overlaps the configured year
...then report 'Active Duty Parent (ADP)'.

Census> People> Military Connections

militaryconnections.Status

militaryconnections.startDate

militaryconnections.endDate

Immigrant:

If Immigrant is checked, report 'Immigrant'.
- Otherwise, do not report.

Student Information > General > Enrollments > State Reporting > Immigrant

Enrollment.immigrant

Recently Arrived English Learner (RAEL):

Report 'Recently Arrived English Learner (RAEL)' if RAEL is checked.
- Otherwise, do not report.

Student Information > Program Participation > English Learners (EL) > "RAEL Identified Date"

lep.raelIdentifiedDate

SLIFE:

If SLIFE is checked, report 'SLIFE'.
- Otherwise, do not report.
- Report beginDate from the Identified Date on the EL editor.

Student Information > Program Participation > English Learners (EL) > "SLIFE"/"SLIFE Identified Date"

Lep.slife

Lep.slifeIdentifiedDate

Migrant:

If Migrant Indicator is marked "Yes", report 'Immigrant'
- Otherwise, do not report

Student Information > General > Enrollments > State Reporting > Migrant Indicator

Enrollment.migrant

Ancestry:

If Race Ethnicity is marked as either '01' or '03', report 'American Indian – Alaska Native (Minnesota)'.

Otherwise, do not report.

Census > People > Identities/Demographics > Race Ethnicity

Identity.raceEthnicity

designatedBy

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

This is optional, does not report.

periods

The time periods for which characteristic was effective.

This is optional, does not report.

beginDate

The date the characteristic was designated.

This is optional, does not report.

endDate

The date the characteristic was removed.

This is optional, does not report.

Student Identification Codes

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path
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.	Report "Local".	M
AssigningOrganizationIdentificationCode	The organization code or name assigning the assessment identification code.	Report "Assigning District ID".	M
IdentificationCode	A unique number or alphanumeric code assigned to a student by a school, school system, a state, or other agency or entity.	Report the personID.	M	Census > People > Demographics > personID

Indicators

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source
GUI Path

indicatorName

The name of the indicator or metric.

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 first record in the array.
- Report "InternetAccessTypeInResidence" for the 2nd record.
- Report "InternetPerformance" for the 3rd record.
- Report "DigitalDevice" for the 4th record.
- Report "PrimaryLearningDeviceProvider" for the 5th record.
- Report "PrimaryLearningDeviceAccess" for the 6th 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:

EdFi endpoint	Campus UI	Campus db
InternetAccess InResidence	Internet Access In Residence	DigitalEquity. internet AccessIn Residence
InternetAccessType InResidence	Primary Internet Access Type in Res	DigitalEquity. internet AccessType
InternetPerformance	Internet Performance	DigitalEquity. internet Performance
DigitalDevice	Primary Digital Device	DigitalEquity. digitalDevice
PrimaryLearning DeviceProvider	Primary Learning Device Provider	DigitalEquity.learning DeviceProvider
PrimaryLearning DeviceAccess	Primary Device Access	DigitalEquity. device Access

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> Response to Intervention> General> Documents > Plan

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 indicatorName

Student Information > Program Participation > State Programs > Digital Equity: see chart above

Minnesota 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

Event Queue Detail

Object Data Elements

Array Data Elements

Student Language

Races

Student Characteristics

Student Identification Codes

Indicators

Related Articles