Minnesota Ed-Fi Data - v2.0

Classic View: System Administration > Ed-Fi 

Search Terms: Ed-Fi

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

 
    • Future data is suppressed when syncing data from Campus to Ed-Fi. Only past and present data is synced.
    • Data in 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.
 

See the following articles for more information about setting up Ed-Fi within Campus: 

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

Understand Object Triggering Tables

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

Image 1: Example of an Object Triggering Logic Table

The following table lists the definition of each potential Action:

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

Understand Object Data Element Tables

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

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

Image 2: Example of a Object Data Elements Table

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

Image 3: Example of a Type/Descriptor Table

Entities and Elements

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



Local Education Agencies

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.

Reports the District Information for a school.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

Post all Districts populated in the District table.

  • A resync must be completed for all Districts to post but a UI change will trigger the reporting District to post.
Put

When fields not part of the natural key are changed: District Name, Phone or Physical Address is changed.

DeleteRecords are never deleted once they are sent.

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

Data Element Labels in bold are part of the Natural Key and are required data elements for data to send to Ed-Fi.

Data ElementDescritpionM, C or O

Data Source GUI Path

Database Field

localEducationAgencyId

Report ttddddsssmmm

where:

  • tt = district type
  • dddd = district number, left zero filled
  • sss = school number, left zero filled, 000 for districts
  • mmm = 000 for all organizations reported in Ed-Fi
M

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

mmm: '000'

District.type

District.number

School.number

stateOrganizationId

The identifier assigned to an education agency by the State Education Agency (SEA). Also known as the State LEP ID. NEDM: IdentificationCode, LEA Identifie.

Report ttddddsssmmm

where:

  • tt = district type
  • dddd = district number, left zero filled
  • sss = school number, left zero filled, 000 for districts
  • mmm = 000 for all organizations reported in Ed-Fi
M

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

mmm: '000'

District.type

District.number

School.number

nameOfInstitution


MSystem Administration > Resources > District Information > district record > Name

educationOrganization Category

Report 'Local Education Agency'.Mn/an/a

localEducationAgency Category

Report 'Independent'.Mn/an/a
districtTypeReport Type If number is not 2-digits long, add leading zero(s).MSystem Administration > Resources > District Info > Typedistrict.type
identificationCodes

IdentificationCode - A unique number or alphanumeric code that is assigned to an education organization by a school, school system, state, or other agency or entity. The value loaded for LocalEducationAgencyId / StateOrganizationId should also be loaded into this structure to provide additional context to users.

EducationOrganizationIdentificationSystem -The school system, state, or agency assigning the identification code. For the LocalEducationAgencyId / State OrganizationId, the value should be “SEA”.

For educationOrganizationIdentificationSystem, report 'SEA'

for identificationCode, report:

ttddddsss

where

  • tt = district type
  • dddd = district number, left zero filled
  • sss = school number, left zero filled, 000 for districts
M

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

District.type

District.number

School.number

addresses


  • addressType
  • streetNumberName
  • city
  • stateAbbreviation
  • postalCode
M
  • addressType - n/a
  • streetNumberName - System Administration > Resources > District Information > district record > Address
  • city - System Administration > Resources > District Information > district record > City
  • stateAbbreviation - System Administration > Resources > District Information > district record > State
  • postalCode - System Administration > Resources > District Information > district record > Zip

district.address

district.city

district.state

district.zip

Array

Education Organization Address

Data Element

Business Requirement

M, C or O

Data Source GUI Path

Database Field

addressType

Key for Address.

  1. All addresses will report as 'Physical'.

M



streetNumberName

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

  1. Reports the Physical Address
MSystem Administration> Resources> District Informationdistrict.physicaladdress
apartmentRoomSuiteNumber

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

 

This element is currently not reported or collected.

O

buildingSiteNumber

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

 

This element is currently not reported or collected.

O

city

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

  1. Reports the Physical City for the address being reported.
M System Administration> Resources> District Information district.physicalcity
stateAbbreviationType

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

  1. Reports the State for the address being reported.
M System Administration> Resources> District Information district.physicalstate
postalCode

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

  1. Reports the Zip Code for the address being reported.
M System Administration> Resources> District Information district.physicalzip
nameOfCounty

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

 

This element is currently not reported or collected.

O

countyFIPSCode

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

 

This element is currently not reported or collected.

O

latitude

The geographic latitude of the physical address.

 

This element is currently not reported or collected.

O

longitude

The geographic longitude of the physical address.

 

This element is currently not reported or collected.

O

beginDate

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

 

This element is currently not reported or collected.

O

endDate

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

 

This element is currently not reported or collected.

O

Education Organization Institution Telephone

Data Element LabelBusiness RequirementBusiness RulesM,C,OData Source GUI PathDatabase Field
institutionTelephoneNumberTypeType of Phone Number
  1. Always report 'Main'



telephoneNumber The telephone number including the area code, and extension, if applicable.
  1. Report the Phone Number entered
    • If blank, do not report

System Administration> Resources> District Informationdistrict.phone

Type/Descriptor

  Click here to expand...

Institution Telephone Number Type

Ed-Fi Code ValueShort DescriptionDescription

Main

MainMain
AdministrativeAdministrativeAdministrative
Health ClinicHealth ClinicHealth Clinic
AttendanceAttendanceAttendance
OtherOtherOther
FaxFaxFax
Food ServiceFood ServiceFood Service

Local Education Agency Category Type

Ed-Fi Code ValueShort DescriptionDescription
IndependentIndependentIndependent
CharterCharterCharter

Institution Telephone Number Type

Ed-Fi Code ValueShort DescriptionDescription

Main

MainMain
AdministrativeAdministrativeAdministrative
Health ClinicHealth ClinicHealth Clinic
AttendanceAttendanceAttendance
OtherOtherOther
FaxFaxFax
Food ServiceFood ServiceFood Service

Local Education Agency Category Type

Ed-Fi Code ValueShort DescriptionDescription
IndependentIndependentIndependent
CharterCharterCharter




Schools

This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups. This field only accepts numeric values for the School ID so some states may implement a different State School Number for Ed-Fi. See state specific logic for more information.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a new School is created and saved OR the Ed-Fi School Number or State School Number Changes.

  • Do not send if the Exclude checkbox is checked.
  • If the Exclude checkbox is checked after the school is sent, the school will remain.
  • 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 Deletes are not sent for Schools.

**Data will not send for any of the Resources if they reference a school that is marked as 'Exclude' on the School Editor.

Scope Year Logic

This table describes scope year logic of this object.

Logic

Schools are not aligned to a year so all Schools 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

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 LabelDescritpionM, C or O

Data Source GUI Path

Database Field
schoolId

MN State Organization ID with last 3 digits removed.

Report ttddddsss

where:

  • tt = district type
  • dddd = district number, left zero filled
  • sss = school number, left zero filled, 000 for districts
M

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

District.type

District.number

School.number

stateOrganizationId

districtType + districtNumber + schoolNumber + Unit Minor

Report ttddddsssmmm

where:

  • tt = district type
  • dddd = district number, left zero filled
  • sss = school number, left zero filled, 000 for districts
  • mmm = 000 for all organizations reported in Ed-Fi
M

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

mmm: '000'

District.type

District.number

School.number

educationOrganization Category

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

Report 'School'.

Mn/an/a

schoolClassification

The numeric code representing the MARSS school classification.

Report the Code value from the selected value.

MSystem Administration > Resources > School > school record > School.type
 

Student

Provide a summary of what the report/function will cover and the logistics around the data collection or reporting.

**NOTE:  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 "wins".  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 except the Identification Code in which the array reports for each district.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When an enrollment is created and saved for a person.

  • Do not send a student record for an enrollment that is marked as State Exclude.
  • Do not send a record if enrollment is in a calendar marked as State Exclude.
  • Do not send a record if enrollment grade is a value that is marked as grade level exclude in the calendar grade level editor.

  • Do not send a record if enrollment is marked as No Show.

Put

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

  • When the person’s identity record is changed.
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 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.

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 ElementBusiness RequirementM, C or O

Data Source GUI Path

Database Field
id 

The unique identifier of the resource.

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

Ononenone
birthCountryDescriptor 

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.

Ononenone
birthDate 

The month, day, and year on which an individual was born.

Report the value from the most recent identities record.

MCensus > People > Identities > identities record > Birth DateIdentity.birthdate
birthInternationalProvince 

For students born outside of the US, the Province or jurisdiction in which an individual is born.

 

This element is currently not reported or collected.


Ononenone
birthStateAbbreviationType 

The abbreviation for the name of the state (within the United States) or extra-state jurisdiction in which an individual was born.

 

This element is currently not reported or collected.

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


Ononenone
dateEnteredUS

For students born outside of the U.S., the date the student entered the U.S.

 

This element is currently not reported or collected.

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

Ononenone
economicDisadvantaged 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 policyO

firstName 

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

  1. Report Legal First Name if it exists.
  2. Otherwise report First Name.
M

Census > People > Identities > Protected Identity Information > Legal First Name


Census > People > Demographics > First Name

Identity.legalFirstName

Identity.firstName

generationCodeSuffix 

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

  1. Report Legal Suffix if it exists
    1. Remove any trailing periods
  2. Otherwise report Suffix
    1. Remove any trailing periods
C

Census > People > Identities > Protected Identity Information > Suffix


Census > People > Demographics > Suffix

Identity.legalSuffix

Identity.suffix

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. The term, "Spanish origin," can be used in addition to "Hispanic or Latino."

  1. If <> NULL, report the value saved in the DB
    • If 'Y', report 'true'
    • If 'N', report 'false'
  2. If NULL, report 'false'
MCensus > People > Demographics > Is the individual Hispanic/Latino?Identity.hispanicEthnicity
lastSurname 

The name borne in common by members of a family.

  1. Report Legal Last Name if it exists.
  2. Otherwise report Last Name.
M

Census > People > Identities > Protected Identity Information > Legal Last Name


Census > People > Demographics > Last Name

Identity.legalLastName

Identity.lastName

limitedEnglishProficiencyDescriptor 

An indication that the student has sufficient difficulty speaking, reading, writing, or understanding the English language, as to require special English Language services.

O

loginId The login ID for the user; used for security access control interfaceO

maidenName 

The person's maiden name.

O

middleName 

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

  1. Report Legal Middle Name if it exists.
  2. Otherwise report Middle Name.
C

Census > People > Identities > Protected Identity Information > Legal Middle Name


Census > People > Demographics > Middle Name

Identity.legalMiddleName

Identity.middleName

multipleBirthStatus 

Indicator of whether the student was born with other siblings (i.e., twins, triplets, etc.).

O

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

O

personalTitlePrefix 

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

 

This element is currently not reported or collected.

Onone
profileThumbnail 

ProfileThumbnail.

 

This element is currently not reported or collected.

Ononenone
schoolFoodServicesEligibilityDescriptor 

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.

Ononenone
sex 

A person's gender.

  1. Report Legal Gender if it exists.
  2. Otherwise report Gender.
M

Census > People > Identities > Protected Identity Information > Legal Gender


Census > People > Demographics > Gender

Identity.legalGender

Identity.gender

studentUniqueId 

A unique alphanumeric code assigned to a student.

Report the value.

MCensus > People > Demographics > State ID
learningStyle 
 

This element is currently not reported or collected.

Ononenone
addresses 

An unordered collection of studentAddresses. The set of elements that describes an address, including the street address, city, state, and ZIP code.

 

This element is currently not reported or collected.

Ononenone
characteristics 

An unordered collection of studentCharacteristics. Reflects important characteristics of the student's home situation: Displaced Homemaker, Homeless, Immigrant, Migratory, Military Parent, Pregnant Teen, Single Parent, Unaccompanied Youth.

O

cohortYears 

An unordered collection of studentCohortYears. 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 element is currently not reported or collected.

Ononenone
disabilities 

An unordered collection of studentDisabilities. This type represents an impairment of body structure or function, a limitation in activities or a restriction in participation, as ordered by severity of impairment.

 

This element is currently not reported or collected.

Ononenone
electronicMails

An unordered collection of studentElectronicMails.

 

This element is currently not reported or collected.

Ononenone
identificationCodes 

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

RSee Array BelowSee Array Below
identificationDocuments 

An unordered collection of studentIdentificationDocuments. Represents the valid document that a person uses for identification.

 

This element is currently not reported or collected.

Ononenone
indicators 

An unordered collection of studentIndicators. An indicator or metric computed for the student (e.g., at risk) to influence more effective education or direct specific interventions.

 

This element is currently not reported or collected.

Ononenone
internationalAddresses 

An unordered collection of studentInternationalAddresses. The set of elements that describes an address, including the street address and country for international students.

 

This element is currently not reported or collected.

Ononenone
languages 

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

 

This element is currently not reported or collected.

Ononenone
otherNames 

An unordered collection of studentOtherNames. Other names (e.g., alias, nickname, previous legal name) associated with a person.

 

This element is currently not reported or collected.

Ononenone
programParticipations 

An unordered collection of studentProgramParticipations. Key programs the student is participating in or receives services from.

 

This element is currently not reported or collected.

Ononenone
races 

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

 

This element is currently not reported or collected.

Ononenone
telephones 

An unordered collection of studentTelephones. The 10-digit telephone number, including the area code, for the person.

 

This element is currently not reported or collected.

Ononenone
visas 

An unordered collection of studentVisas. Describe the types of Visa that a non-U.S. citizen student holds.

 

This element is currently not reported or collected.

Ononenone
_etag

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

 

This element is currently not reported or collected.

Ononenone

Array

studentIdentificationCodes

Data ElementBusiness RulesM, C or O

Data Source GUI Path

Database Field
IdentificationCodeReport the value.MCensus > People > Demographics > State ID
studentIdentificationSystemReport 'State'.MN/AN/A
assigningOrganizationIdentificationCodeReport 'MARSS'.MN/AN/A

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.

Resident District on Enrollment

This value uses the enrollment table.  See information below on how to determine what values to report from:

  1. The first Resident District value saved for a student will populate the resident district field on the enrollment table
  2. Any additional resident district values saved for a student, will populate the custom student table in the Resident District Campus Attribute

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When an enrollment is saved in a school.

  • Do not send a 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.
  • Report data from the Identities record with the latest "Effective Date" that is on or before the Student School Association end date
PutWhen the student's Identity record is edited.
Delete/PostWhen a new Identities record is created and saved (or deleted) for a student that overlaps a reportable Enrollment record - report data from the Identities record with the latest "Effective Date" that is on or before the Student School Association end date.
DeleteWhen the enrollment is deleted

Scope Year Logic

This table describes scope year logic of this object.

Logic

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

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

Object Data Elements

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

M, C or O

Data Source GUI Path

Database Field

id

The unique identifier of the resource.

MN/AN/A
educationOrganizationReference 

A reference to the related EducationOrganization resource.

Report the reference from the educationOrganization resource; report the schoolID

Report ttddddsss

where:

  • tt = district type
  • dddd = district number, left zero filled
  • sss = school number, left zero filled, 000 for districts
M

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

District.type

District.number

School.number

studentReference

A reference to the related Student resource.

Report the reference from the Student record for the student being reported.

M

birthCity 

The city the student was born in.

 

This element is currently not reported or collected.

ON/AN/A
birthCountryDescriptor 

The country in which an individual is born.

 

This element is currently not reported or collected.

ON/AN/A
birthDate 

The month, day, and year on which an individual was born.

Report the value from the most recent identities record.

MCensus > People > Identities > identities record > Birth DateN/A
birthInternationalProvince 

For students born outside of the U.S., the Province or jurisdiction in which an individual is born.

 

This element is currently not reported or collected.

ON/AN/A
birthStateAbbreviationType 

The abbreviation for the name of the state (within the United States) or extra-state jurisdiction in which an individual was born.

 

This element is currently not reported or collected.

ON/AN/A
dateEnteredUS

For students born outside of the U.S., the date the student entered the U.S.

 

This element is currently not reported or collected.

ON/AN/A
firstName 

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

  1. Report Legal First Name if it exists.
  2. Otherwise report First Name.
M

Census > People > Identities > Protected Identity Information > Legal First Name


Census > People > Identities > First Name

N/A
generationCodeSuffix 

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

  1. Report Legal Suffix if it exists.
    • Remove any trailing periods.
  2. Otherwise report Suffix.
    • Remove any trailing periods.
C

Census > People > Identities > Protected Identity Information > Suffix


Census > People > Identitites > Suffix
N/A
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. The term, "Spanish origin," can be used in addition to "Hispanic or Latino."

  1. Report "true" if Hispanic/Latino field is Y.
  2. If N or NULL, report "false".
MCensus > People > Identities > Race/EthnicityIdentity.hispanicEthnicity
lastSurname 

The name borne in common by members of a family.

  1. Report Legal Last Name if it exists
  2. Otherwise report Last Name
M

Census > People > Identities > Protected Identity Information > Legal Last Name


Census > People > Identities > Last Name

N/A
limitedEnglishProficiencyDescriptor 

An indication that the student has been identified as limited English proficient by the Language Proficiency Assessment Committee (LPAC), or English proficient.

  1. If the student has an "English Learners (EL)" record with a Program Status of 'EL' or 'Exited EL', and the student's enrollment overlaps the timespan between the Identified Date and the Program Exit Date, then report 'Yes'
    1. Otherwise report 'No'
MStudent Information > Program Participation > LEP > LEP > Program Status, Identified Date, Program Exit Date

Lep.identifiedDate

Lep.exitDate

middleName 

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

  1. Report Legal Middle Name if it exists
  2. Otherwise report Middle Name
M

Census > People > Identities > Protected Identity Information > Legal Middle Name


Census > People > Identities > Middle Name

N/A
multipleBirthStatus 

Indicator of whether the student was born with other siblings (i.e., twins, triplets, etc.).

 

This element is currently not reported or collected.

ON/AN/A
responsibilityDescriptor 

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

Report 'Demographic'.

MN/AN/A
sexType 

A person's gender.

  1. Report Legal Gender if it exists.
  2. Otherwise report Gender.
M

Census > People > Identities > Protected Identity Information > Legal Gender


Census > People > Identities > Gender
N/A
ancestryEthnicOrigins 

An unordered collection of studentEducationOrganizationAssociationAncestryEthnicOrigins. The ancestry ethnic origins that pertain to the general racial categories with which the individual identifies.

  1. Report the Ed-Fi Code value associated with any Race Subcategory records saved in the student's record.
  2. If "Individual Hispanic/Latino?" is marked as "Yes", report the Ed-Fi Code value associated with any Hispanic Subcategory records saved in the student's record.
    • If "Individual Hispanic/Latino?" is marked as "No", do not report any Hispanic Subcategory records.
M

Census > People > Identities > Race Subcategory


Census > People > Identities > Hispanic Subcategory


Identity.raceSubcategory

Identity.hispanicSubcategory

languages 

An unordered collection of studentEducationOrganizationAssociationLanguages. The language(s) the individual uses to communicate.

M

races 

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

RaceReporting Logic
American Indian or Alaska Native
  1. f American Indian race checkbox is selected, report "American Indian - Alaskan Native".
  2. Else do not report.
Asian
  1. If Asian race checkbox is selected, report "Asian".
  2. Else do not report.
Black or African American
  1. If Black race checkbox is selected, report "Black - African American".
  2. Else do not report.
Native Hawaiian or Other Pacific Islander
  1. If Native Hawaiian Pacific Islander race checkbox is selected, report "Native Hawaiian - Pacific Islander".
  2. Else do not report.
White
  1. If White race checkbox is selected, report "White".
  2. Else do not report.
MCensus > People > Identities > RaceIdentity.federalRaces
studentCharacteristics 

An unordered collection of studentEducationOrganizationAssociationStudentCharacteristics. Reflects important characteristics of the student's home situation: Displaced Homemaker, Immigrant, Migratory, Military Parent, Pregnant Teen, Single Parent, and Unaccompanied Youth.

Also includes:

  • beginDate
  • endDate
MN/AN/A
studentIdentificationCodes 

An unordered collection of studentEducationOrganizationAssociationStudentIdentificationCodes. 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 the value - see Array logic below.

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

Array

studentCharacteristics

Data Element Label

Description

M, C or OData Source GUI Path

Database Field

Race/Ethnicity (ethnicCode)
  1. Report Race Ethnicity from state droplist.
    • If '01' or '03', report 'American Indian - Alaskan Native (Minnesota)'.

    • If '0', do not report.
CCensus > People > Demographics > State Race/EthnicityIdentity.raceEthnicity
(Homeless Student Flag)

Report 'Homeless'

CStudent Information > Enrollments > State Reporting Fields > HomelessEnrollment.homeless
(Active Duty Parent (ADP) Indicator)

Report values where

  1. Branch is:
    1. CodeName
      4Army
      11Navy
      1Air Force
      9Marine Corp
      7Coast Guard
  2. Status is:
    1. CodeName
      1Active Duty, Deployed
      2Active Duty, Not Deployed
  3. Start Date/End Date overlaps the configured year.

...then report 'Active Duty Parent (ADP)'.

C

Census > Person > Military Connection

ImpactAidEmployment.militaryBranch

ImpactAidEmployment.militaryStatus

ImpactAidEmployment.startDate

(Immigrant Indicator)
  1. If Immigrant is checked, report 'Immigrant'.
    1. Otherwise, do not report.
CStudent Information > General > Enrollments > Immigrant
Enrollment.immigrant
(Recently Arrived English Learner (RAEL))
  1. Report 'Recently Arrived English Learner (RAEL)' if RAEL is checked.
    1. Otherwise, do not report.
C

Student Information > Program Participation > EL > RAEL (date & checkbox)

(Still need to get approval from Ann/Jon on this)

Unsure
(Student with Limited or Interrupted Formal Education (SLIFE))
  1. If SLIFE is checked, report 'SLIFE'.
    1. Otherwise, do not report.
    2. Report beginDate from the Identified Date on the EL editor.
C

Student Information > Program Participation > EL > SLIFE (date & checkbox)

Lep.slife

studentIdentificationCodes

Data Element Label

Business Requirement

M, C or OData Source GUI Path

Database Field

Format

identificationCode

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

  1. Report the value if it exists.
  2. If it does not, do not report.
CCensus > People > Demographics > Local Student Number
string

studentIdentificationSystem

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

Mn/an/astring

assigningOrganizationIdentificationCode

The organization code or name assigning the StudentIdentificationCode.

  1. Report the value if it exists.
  2. If it does not, do not report.
CCensus > People > Demographics > Student State ID


string


Student School Association

This association represents the school in which a student is enrolled.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a new enrollment is saved for a student or the No Show or State Exclude check box is unchecked.

  • Do not post a record when the No Show or State Exclude check box is checked before initial save.
  • When a student has two enrollments in the same school for the same start date report from the enrollment service type in the following order:

    1. P: Primary Enrollment
    2. S: Partial/Ancillary
    3. N: Special Ed Services
  • When an enrollment with a higher priority is deleted, the enrollment with lower priority will post a new record.
  • Do not send records if the Calendar Exclude check box is checked in the calendar the student is enrolled.
  • Do not send records if the School Exclude check box is checked in the calendar the student is enrolled.
  • Do not send records if the Grade Level Exclude check box is checked in the grade level record tied to the calendar the student is enrolled in.
Post

When the start date for an enrollment is changed.

  • When an enrollment with a lower priority is changed, data will not send.
  • If the No Show check box is checked, the record will remain and update the exit date and exit withdraw type descriptor if populated on the enrollment.
PostIf a Transportation record is saved, and the Start Date overlaps the enrollment record, post a unique record based on the start date of the transportation record.
PutWhen an enrollment is updated for a student.
PutWhen a change is made to Graduation > Grad Year.
Delete

When an enrollment is deleted or the State Exclude check boxes are checked.

  • When a student has two enrollments in the same school for the same start date, records will lower priority will not trigger a delete.
DeleteWhen the start date of an enrollment is changed.
DeleteWhen a Transportation record, which previously had a start date that took place during an enrollment and thus created a unique SSA record, is updated so that the Transportation start date no longer takes place during an enrollment.
DeleteWhen a Transportation record, which previously had a start date that took place during an enrollment and thus created a unique SSA record, 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

Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi.

Data ElementDescriptionM, C or O

Data Source GUI Path

Database Field
id 

The unique identifier of the resource.

M

graduationPlanReference

A reference to the related GraduationPlan resource.

 

This element is currently not reported or collected.

O

schoolReference 

A reference to the related School resource.

Report the School resource for the school tied to the enrollment

Should contain:

  • studentUniqueId
  • schoolId
MN/AN/A
classOfSchoolYearTypeReference

A reference to the related schoolYearType resource.

 

This element is currently not reported or collected.

O

schoolYearTypeReference

A reference to the related schoolYearType resource.

Report the end year associated with the calendar (i.e., 2019-2020 calendars would report out '2020')

MSystem Administration > Calendar > Calendar > End Date
studentReference

A reference to the related Student resource.

Report the Student resource for the related student.

MN/AN/A
residentLocalEducationAgencyReference

A reference to the related localAgency resource.

Report ttdddd

Where:

  • tt = district type
  • dddd = district number, left zero filled


  1. Look to see if the Resident District <> NULL
    • If so, report the Resident District number
  2. If not, report from the district.type + district.number values
M

Student Information > General > Enrollments > Resident District


System Administration > Resources > District Information > Type


System Administration > Resources > District Information > State District Number

Enrollment.residentDistrict

District.type

District.number

employedWhileEnrolled

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.

O

entryDate

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

  1. Report Start Date.
  2. If there is a Transportation record that begins during the enrollment, report the Start Date of transportation record as the start of a new unique SSA record.
M

Student Information > General > Enrollments > Start Date


or


Student Information > General > Transportation > Start Date

enrollment.startDate

transportation.startDate

entryGradeLevelDescriptor

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 value from the state grade level associated with the enrollment grade level selected.

MStudent Information > General > Enrollment > Grade Level
entryGradeLevelReasonTypeA unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.O

entryTypeDescriptor

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

  1. If State Aid Category on the enrollment record = '46', then report '0'.
  2. If there is a transportation record that overlaps the Student School Association record, report '24'.
  3. Otherwise reports EdFi Code from the State Start Status value saved in the enrollment record.
M

Student Information > General > Enrollments > Enrollments > Start Status

enrollment.startStatus
exitWithdrawDate

The month, day, and year of the first day after the date of an individual's last attendance at a school (if known), the day on which an individual graduated, or the date on which it becomes known officially that an individual left school.

  1. For a given StudentSchoolAssociation record, report the earlier of the following:
    • the Enrollment End Date
      • If no Enrollment End Date exists, use the last instructional date of the associated calendar.
    • the last instructional date prior to a Transportation Start Date.
M

Student Information > General > Enrollments > End Date


OR


Student Information > General > Transportation > Start Date

enrollment.endDate

transportation.startDate

exitWithdrawTypeDescriptor

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

  1. Report the Ed-Fi Code End Status.
  2. If value is NULL and calendar End Code Override has a value set, the override value will be reported.
  3. If NULL, report = 40.
M

Student Information > General > Enrollments > End Status


OR


sys admin > calendar > End Code Override


homeboundServiceIndicator

The Homebound Service Indicator is used to validate Membership Days for students who have no Attendance Days. It is an indication of whether students were medically confined to their home and received instruction in the home during the enrollment period.

  1. If Homebound = Yes, report 'true'.
  2. If Homebound = No, report 'false'.
  3. If Homebound = NULL, report 'false'.
MStudent Information > General > Enrollments > State Reporting Fields > Homebound
primarySchoolIndicates if a given enrollment record should be considered the primary record for a student. If omitted, the default is true.O

repeatGradeIndicatorAn indicator of whether the student is enrolling to repeat a grade level, either by failure or an agreement to hold the student back.O

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

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

schoolFoodServicesEligibilityDescriptor

An indication of a student's level of eligibility for breakfast, lunch, snack, supper, and milk programs.

  1. Report the State Eligibility Code from the FRAM record, if it exists, and overlaps the enrollment record.
  2. If multiple FRAM records exist that overlap the enrollment record, report the highest number from any eligibility status tied to the reported calendar year that falls before the End Date of the enrollment record
    • If Eligibility = Free, report 2.
    • If Eligibility = Reduced, report 1.
    • If Eligibility = Paid, report 0.
    • If Eligibility = Non-reimbursable, report 0.
  3. If there are no FRAM records, report 0.
  4. If the Certified Type of the most recent eligibility record for the selected calendar that falls before the End Date of the extract editor has a value of "Declined" (DE) or "Denied" (DN), report the State Code associated with the Eligibility value of the most recent record.
  5. If the Certified Type is something other than "Declined" (DE) or "Denied" (DN), continue reporting based on existing logic below. 
    1. Report highest number from any eligibility status tied to the reported calendar year that falls before the End Date of the extract editor
      • If Eligibility = Free, report 2.
      • If Eligibility = Reduced, report 1.
      • If Eligibility = Paid, report 0.
      • If Eligibility = Non-reimbursable, report 0.
      • If NULL, report 0.
MFRAM > Eligibility > Eligibility, School Year

POSEligibility.eligibility

POSEligibility.endYear

specialEducationEvaluationStatusDescriptor

An indicator of the students' need for and participation in special education programs during this enrollment period.

  1. Report Special Ed Status code.
  2. If NULL, report 1.
MStudent Information > General > Enrollments > Special Ed Fields > Special Ed StatusEnrollment.specialEdStatus
educationPlans

An unordered collection of studentSchoolAssociationEducationPlans. Indicates the type of Education Plan(s) the student is following, if appropriate; for example: Special Education IEP or Vocational/CTE, etc.

See Array below.

O

studentProgramParticipations

An unordered collection of studentSchoolAssociationStudentProgramParticipations. Key programs the student is participating in or receives services from. , _etag (string, optional): A unique system-generated value that identifies the version of the resource.

See Array below.

C

Array

studentProgramParticipations

Data Element LabelDescriptionM, C or O

Data Source GUI Path

Database Field
StudentProgramParticipation (Independent Study)

An unordered collection of studentSchoolAssociationStudentProgramParticipations. Key programs the student is participating in or receives services from. , _etag (string, optional): A unique system-generated value that identifies the version of the resource.


  1. If Yes report "Independent Study".
  2. If No, do not report.

Report beginDate from the Enrollment Start Date.

MStudent Information > General > Enrollments > State Reporting Fields > Independent Study

CustomStudent.value (attribute: Enrollment.independentStudy)

Enrollment.startDate

StudentProgramParticipation (Section 504 Placement)
  1. If there is a Primary Disability status of '54: 504 Accommodation Plan', report "Section 504 Placement"
    • Otherwise, do not report

Report beginDate from the Enrollment Start Date.

MStudent Information > General > Enrollments > Special Ed > Primary Disability

Enrollment.disability1

Enrollment.startDate

StudentProgramParticipation (Title I Part A)
  1. Identify the school record tied to the enrollment.  If the School History area has a value in Title 1 that also overlaps the enrollment duration, then:
    • If SchoolAttribute.Title 1 = TGELGBNOPROG, SWELIGNOPROG, or NOTTITLE1ELIG, do not report.
    • If SchoolAttribute.Title 1 = SWELIGSWPROG, report 'Title I Part A'.
    • If SchoolAttribute.Title 1= Blank, TGELGBTGPROG or SWELIGTGPROG, and enrollment editor Title 1 = Y, report 'Title I Part A'.
    • if not, look at the student's enrollment record, at their Title 1 field:
      1. If Yes, report '"Title I Part A'.
      2. If No, do not report.

Report beginDate from the Enrollment Start Date (for both reporting locations).

M

Sys admin > resources > school > school history > Title 1 


OR


Student Information > General > Enrollments > State Reporting Fields > Title 1

SchoolAttribute.title1

Enrollment.startDate

StudentProgramParticipation (English Learner)
  1. If the student has an EL record or Exited EL record that overlaps the Student School Association record, report 'English Learner Served'.
    • If they do not, do not report.
  2. Report beginDate from the Start Date value of the EL Service Type record "StateReported: EL State Reported Service".
    • If there is no EL Service mapped to that value, do not report.

Note: in the MARSS B report,

  • the status data is pulled from columns 'LEP_PCP' and.
  • the date data is pulled from 'LEP_BEG_DAT'.
M

Student Information > Program Participation > English Learners (EL) > EL


AND


Student Information > Program Participation > English Learners (EL) > EL > EL Services

Lep.programStatus

Lep.identifiedDate

LepService.startDate



Additional Logic and Considerations

The following describes additional logic and considerations to be aware of when working with Ed-Fi.

No Show/Excludes

If the State Exclude or No Show buttons are marked or unmarked on an enrollment the record, they will be deleted/added from Ed-Fi.