Minnesota Ed-Fi Data v3.1 - Students

Classic View: System Administration > Ed-Fi 

Search Terms: Ed-Fi

This resource represents an individual for whom instruction, services, and/or care are provided in an early childhood, elementary, or secondary educational program under the jurisdiction of a school, education agency, or other institution or program. A student is a person who has been enrolled in a school or other educational institution. 

 

At least one Student School Association record is required to be sent to Ed-Fi before a Student record can be seen in the ODS. The Student School Association is what gives a district a claim to a Student resource in the ODS.

The Student Resource is a shared record among all districts. If two districts have the same student in the same year,  the last district to trigger data to Ed-Fi is the data stored in Ed-Fi. 

For example, if one district put in a first name of "Robert" and the second district put in a first name of "Rob", the last district to update the student record is what will appear in Ed-Fi and on both District's reports. This is true for all field logic in the Student Resource.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When an enrollment is created and saved for a person and the enrollment overlaps a configured year.

  • Do not send it an enrollment is marked as No Show.
  • Do not send a record if enrollment is in a Calendar marked as State Exclude.
  • Do not send a record if enrollment is in a School marked as State Exclude.
  • Do not send records if the Calendar Grade Level "Exclude from State Reporting" checkbox is selected for the grade level in which the student is enrolled.
Put

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

  • First Name
  • Middle Name
  • Middle Name
  • Suffix
  • Birth City
  • Birth Country
  • Birth Date
  • Gender
  • Birth State
  • Date Entered US
Delete

Student records are never deleted because Student records are a shared resource among all districts.

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.

ActionBusiness Rule
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncIf an Ed-Fi Code mapping is changed to a new code or made NULL, a resync must be performed for the data to be updated in the ODS.

Natural Key Changes, Cascading Updates, and Deletes Logic

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

ActionBusiness Rule
Post

Natural Key change:  Ed-Fi ID

  • If an Ed-Fi ID is changed for a student, all data for the previous number will be deleted and resent under the new number.
Delete

Cascading Deletes:  The following resources will be deleted and resent if the Ed-Fi ID is changed.

  • Student Parent Associations, Student Education Organization Associations, Student School Associations, Student Section Associations, Graduation Plans, Student Program Associations, Student CTE Program Associations, Student Special Education Program Associations, Student Title 1 Part A Program Associations, Student Academic Records, Course Transcripts, Grades, Student Discipline Incident Associations, Discipline Actions, Student Cohort Associations, Student School Attendance Events, Student Section Attendance Events

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

  • The enrollment must overlap with the configured year to report.
  • Data only sends 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) in which to report data:

  • Current Year: The record must overlap the current year.
  • 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) iin which to report data:

  • Current Year: The record must overlap the current year.
  • 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

Data Element Label

Mapping Needed

Database Field

birthCountryDescriptorBirth Country Overrideidentity.birthcountry
birthStateDescriptorBirth State Overrideidentity.birthstate

Identity Mapping Object Key

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

campusObjectType

Object Key Data Source

PersonpersonID


  1. If a Student and Student School Association record has been sent for a student, a Student and Student School Association record will be logged in the Ed-Fi Identity Mapping table. If the student's enrollment is deleted or their Ed-Fi ID is changed while the Student and/or Student School Association Resource Preference is turned off, the old record and resource id will remain in the table until the resource is turned back on and a resync is performed on either Students or Student School Associations.
  2. The Students and Student School Associations records will be deleted from the identity mapping table if all enrollments that were sent to Ed-Fi are deleted.


Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table

Ed-Fi Action

Fields

enrollmentPost/Put/DeleteThe primary table used for sending data for this resource.
identityPutbirthDate, firstName, lastSurname,  generationCodeSuffix, middleName
personPost/DeletestudentUniqueID

Object Data Elements

This table describes data elements sent within the Student resource.

Data Element LabelBusiness RequirementBusiness RulesMandatory (M) or Optional (O)

Location


idThe unique identifier of the resource.
M
birthCityThe city where the student was born.

This is optional, does not report.

O
birthCountry
Descriptor
The country in which an individual is born. It is strongly recommended that entries use only ISO 3166 2-letter country codes.

This is optional, does not report.

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

Report the date of birth from the student's current identity record.

MCensus > People >
Identities > Birth Date

identity.birthdate
birthSex
Descriptor
A person's gender at birth.
  1. Report from the current identity record.
  2. Check the to see if the "Report Legal Identities 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 > Legal Gender


OR


Census > People > Identities > Gender


identity.Legal

Gender


or


identity.gender

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

Do not report.

O
dateEntered
US
For students born outside of the US, the date the student entered the US.

Do not report.

O
firstNameA name given to an individual at birth, baptism, or during another naming ceremony, or through legal change.
  1. Report from the current identity record.
  2. 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 of Legal First Name.
      • If no, report the First Name value.
    • If no, report the First Name value.
M

Census > People > Identities > Legal First Name


OR


Census > People > Identities > First Name


dentity.legal

FirstName


OR


identity.firstName

generationCode
Suffix
An appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III).
  1. Report from the current identity record.
  2. 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 of Legal Suffix.
      • If no, report the Suffix value.
    • If no, report the Suffix value.
    • If Null, do not report.
M

Census > People > Identities > Legal Suffix


OR


Census > People > Identities > Suffix


identity.legalSuffix

OR

identity.suffix

lastSurnameThe name borne in common by members of a family.
  1. Report from the current identity record.
  2. 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 of Legal Last Name.
      • If no, report the Last Name value.
    • If no, report the Last Name value.
M

Census > People > Identities > Legal Last Name


OR


Census > People > Identities > Last Name


identity.legal

LastName

OR


identity.lastName

middleNameA secondary name given to an individual at birth, baptism, or during another naming ceremony.
  1. Report from the current identity record.
  2. 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 of Legal Middle Name.
      • If no, report the Middle Name value.
    • If no, report the Middle Name value.
    • If Null, do not report.
M

Census > People > Identities > Legal Middle Name


OR


Census > People > Identities > Middle Name


identity.legal

MiddleName


OR


identity.middle

Name

otherNamesOther names (e.g., alias, nickname, previous legal name) associated with a person.

Does not report.



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


Array Data Elements

This table describes the array data elements for the Student Other Name element:

Data Element Label

Business Requirement

Business Rules

M, C or O

Location

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

Report the first name from the student's current identity record.

MCensus > People > Identities > First Name

identity.firstName
generationCodeSuffixAn appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III).
  1. Report the suffix from the student's current identity record.
  2. If blank, do not report.
CCensus > People> Identities > Suffix

identity.suffix
lastSurnameThe name borne in common by members of a family. 

Report the last name from the student's current identity record.

MCensus > People > Identities > Last Name

identity.lastName
middleNameA secondary name given to an individual at birth, baptism, or during another naming ceremony. 
  1. Report the middle name from the student's current identity record.
  2. If blank, do not report.
CCensus > People > Identities > Middle Name

identity.middleName
personalTitlePrefixA prefix used to denote the title, degree, position or seniority of the person.

This is optional, does not report.

CN/A