MN v3.3 - Student Education Organization Association

Classic View: System Administration > Ed-Fi 

Search Terms: Ed-Fi

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

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
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 is checked on the enrollment.
  • For all Enrollment-related data, if multiple Enrollments exist that overlap the SEOA record, report the data elements from the Enrollment record with the most recent start date.
  • For all Identity-related data, if multiple Identity records exist that overlap the SEOA record, report the data elements from the Identity record with the most recent start date.
Put

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

  1. Identity Record 
    • Race / Ethnicity
    • Home Primary Language
  2. LEP Information 
    • Program Status
    • Identified Date
    • LEP Exit Date
    • Parent Refused
  3. Response To Intervention (RTI) Plan
    • Locked /Unlocked 
    • Plan name changes
  4. Student Characteristics
    • Refugee
    • Immigrant
    • US Entry Type 
  5. Economic Disadvantaged
    • SES FRAM Eligibility record overlaps the configured year and meets the criteria selected in the Economic Disadvantaged resource preferences
    • Start / End Dates are changed so record no longer overlaps configured year, the record is deleted
  6. Parent in Military
    • A Military Connections record exists for a Guardian of the student, Start/End Dates are changed so record no longer overlaps configured year, the Guardian checkbox is checked/unchecked, the record is deleted.
DeleteThis record will delete if:
  • Student no longer has an eligible enrollment in the District
  • 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

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 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.
ResyncIf 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.
ResyncIf 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/DeleteNatural Key Changes
  • 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.
DeleteCascading Deletes:  N/A - no dependent resources

Scope Year Logic

This table describes scope year logic of this object.

Logic

A 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 DescriptorCareer Tech Special Populations
Economic Disadvantaged
Foster Care
Homeless
Parents in Military
US Entry Type
Flags
Race DescriptorRace/Ethnicity
Language DescriptorHome Primary Language
Disability DescriptorDisability
Limited English Proficiency DescriptorEL Program Status

Identity Mapping Object Key

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

campusObjectType

Object Key Data Source

PersonpersonID

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

identityPutReports Hispanic or Latino, Gender, Home Primary Language, US Entry Type.
personPutReports the Ed-FI ID.
contactPutReports the Telephone and Email information.
householdlocationPutDetermines if address is marked as Mailing or Private.
householdmemberPutDetermines household membership with Start Date, End Date, Private.
addressPutPO Box, Number, Prefix, Street, Tag, Direction, Apt, City, State, Zip
raceethnicityPutReports Races.
plantypePutReports Indicators.
planPutReports Disabilities, Indicators.
planstatePutReports Disabilities.
programsPutReports any Characteristic created in Flags.
programparticipationPutReports any Characteristic created in Flags.
Title1PutReports Neglected or Delinquent.
ImpactAidEmploymentPutReports Parent in Military.
relatedpairPutGuardian checkbox for contact information and Parent in Military.
section504PutReports Section 504 Handicapped.
homelessPutReports Homeless, Unaccompanied Youth, Runaway.

Object Data Elements

This table describes data elements sent within the Student Education Organization Association resource. Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi.

Click here to expand...

Data Element LabelBusiness RequirementBusiness RulesM, C or O

Location

education
Organization
Id

The identifier assigned to an 

education organization.

  1. Report the Ed-Fi School ID.
  2. 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.entityID

District.type

District.number

School.number

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



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

This is optional, does not report.



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



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



sexDescriptorA person's gender.Report from the latest identity record overlapping the enrollment.
  • Check 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.
MCensus > People >
Identities > Gender

identity.Gender
characteristicsReflects important characteristics of the student’s home situation: 
  • Displaced Homemaker 
  • Immigrant 
  • Migratory 
  • Military Parent
  • Pregnant Teen
  • Single Parent
  • Unaccompanied Youth

See Array section for reporting logic.

C
identificationCodesA 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
studentIndicators

An unordered collection of studentEducation OrganizationAssociationStudent Indicators. Indicator(s) or metric(s) computed for the student (e.g., at risk) to influence more effective education or direct specific interventions.

See Array section for reporting logic.

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

This is optional, does not report.

O
AncestryEthnicOriginAn unordered collection of studentEducation OrganizationAssociationAncestryEthnicOrigins.
The ancestry ethnic origins that pertain to the general racial categories with which the individual identifies.
  1. 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.
  2. 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 > More Detailed Ancestry/Ethnicity Codes


Census > People > Identities > More Detailed Hispanic/Latino Codes



Identity.raceSubcategory

Identity.hispanicSubcategory

birthdateThe month, day, and year on
which an individual was born.
Report the Birth Date value from the most recent Identity record.MCensus > People > Identities > Birth Date

identity.birthdate
FirstNameA name given to an individual at birth, baptism, or during another naming ceremony, or through legal change.
  1. Report from the latest identity record overlapping the enrollment.
  2. Check 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 the family (e.g., Jr., Sr., III).
  1. Report from the latest identity record overlapping the enrollment.
  2. Check 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.legalSuffix

LastNameThe name borne in common by members of a family.
  1. Report from the latest identity record overlapping the enrollment.
  2. Check 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

MiddleNameA secondary name given to an individual at birth, baptism, or during another naming ceremony.
  1. Report from the latest identity record overlapping the enrollment.
  2. Check 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.middleName

OptOutIndicatorsDescriptor

An unordered collection of studentEducation

OrganizationAssociationOptOutIndicators. 

  1. Report 'MNC' if there is any FRAM record that:
    • Has Start Date on or after July 1st of the Scope Year; and
    • 'Opt Out SCHIP' is selected.
  2. Otherwise, do not report.
M

FRAM > Eligibility > Start Date


FRAM > Eligibility > OptOut SCHIP



POSEligibility.optOutSCHIP

Array Data Elements

Click here to expand...

Student Characteristics

Data Element LabelBusiness RulesM, C or O

Location

Active Duty ParentReport values where
  1. Branch is:

    CodeName
    1Air Force
    2Air Force Reserve
    3Air National Guard
    4Army
    5Army Reserve
    6Army National Guard
    7Coast Guard
    8Coast Guard Reserve
    9Marine Corps
    10Marine Corps Reserve
    11Navy
    12Navy Reserve
  2. Status is:

    CodeName
    1Active Duty, Deployed
    2Active Duty, Not Deployed
  3. Start Date / End Date overlaps the configured year...then report 'StudentCharacteristicDescriptor#1'.
CCensus > People > Military Connections

ImpactAidEmployment.militaryBranch

ImpactAidEmployment.militaryStatus

ImpactAidEmployment.startDate

ImpactAidEmployment.endDate

RelatedPair.guardian


ImmigrantIf Immigrant is checked, report 'StudentCharacteristicDescriptor2'.
  • Otherwise, do not report.

Calendar Override Mapping logic:   
If a student has an enrollment that is tied to a state-excluded grade level, but is mapped to a non-excluded grade level via the calendar override mapping tool, report the immigrant characteristics based on that enrollment.

CStudent Information > General > Enrollments > State Reporting > Immigrant

Enrollment.immigrant
Recently Arrived English Learner (RAEL)Report 'StudentCharacteristicDescriptor#5' if RAEL has an Identified Date on the EL editor.
  • Otherwise, do not report.
CStudent Information > Program Participation > English Learners (EL) > "RAEL Identified Date"

lep.raelIdentifiedDate
SLIFEIf SLIFE is checked, report 'StudentCharacteristicDescriptor#6'
  • Otherwise, do not report.
  • Report beginDate from the EL Identified Date on the EL editor.
CStudent Information > Program Participation > English Learners (EL) > "SLIFE"/"SLIFE Identified Date"

Lep.slife

Lep.slifeIdentifiedDate


Migrant

Do not report.

O
Ancestry

If Race Ethnicity is marked as either '01' or '03', report 'StudentCharacteristic Descriptor#2'.

  • Otherwise, do not report.
CCensus > People > Identities/Demographics > Race Ethnicity

Identity.raceEthnicity

Student Identification Codes

Data Element LabelBusiness RequirementBusiness RulesM, C or O

Location

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".MN/A
assigningOrganizationIdentificationCode The organization code or name assigning the StudentIdentificationCode.Report "Assigning District ID". MN/A
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.

 MCensus > People > Demographics > personID

Person.personID

Student Indicators

Data Element LabelBusiness RequirementBusiness RulesM, C or OLocation
indicatorName 

The name of the indicator or metric.

  1. 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 "InternetAccessTypeIn Residence" for the 2nd record.
    • Report "InternetPerformance" for the 3rd record.
    • Report "DigitalDevice" for the 4th record.
    • Report "PrimaryLearningDevice Provider" for the 5th record.
    • Report "PrimaryLearningDeviceAccess" for the 6th record.
  2. If multiple Digital Equity records exist for the student, report the most recent record.
  3. If no record exists, do not report.
C

Student Information > Program Participation > State Programs > Digital Equity: 

EdFi endpointCampus UICampus db
InternetAccess
InResidence
Internet Access In ResidenceDigitalEquity.internetAccessInResidence
InternetAccessType
InResidence
Primary Internet Access Type in ResDigitalEquity.internetAccessType
InternetPerformanceInternet PerformanceDigitalEquity.internetPerformance
DigitalDevicePrimary Digital DeviceDigitalEquity.digitalDevice
PrimaryLearning
DeviceProvider
Primary Learning Device ProviderTBD
PrimaryLearning
DeviceAccess
Primary Device AccessDigitalEquity.deviceAccess

indicator The value of the indicator or metric.

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

CStudent Information > Program Participation > State Programs > Digital Equity (see chart above)
indicatorGroup 

The name for a group of indicators.

If a Digital Equity record exists for the student that falls within the configuration year, report "DigitalEquity" for each indicatorName

CN/A

Languages

Data Element LabelBusiness RequirementBusiness RuleM, C, or OLocation
languageDescriptorThe language(s) the individual uses to communicate. It is strongly recommended that entries use only ISO 639-3 language codesReport 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.
  • Otherwise, report blank.
MCensus > People > Identities > Home Primary Language

identity.homePrimaryLanguage


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

Races

Data Element LabelBusiness RequirementBusiness RuleM, C, or OLocation
raceDescriptorThe general racial category which most clearly reflects the individual's recognition of his or her community or with which the individual most identifies.
  1. 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 student's current identity id.
  2. Report the Ed-Fi Code mapped to the corresponding Race Ethnicity.
    • Report all races if the student has more than 1 selected.
  3. Do not report if the person does not have a Race/Ethnicity checked or there is not a corresponding mapping.
MCensus > People > Identities > Race/Ethnicity

IdentityRaceEthnicity

and

racethnicity.raceid




Type / Descriptors

Student Characteristics

Code ValueDescriptionNamespace
1Active Duty Parent (ADP)uri://education.mn.gov/StudentCharacteristicDescriptor
2American Indian - Alaskan Native (Minnesota)uri://education.mn.gov/StudentCharacteristicDescriptor
3Migranturi://education.mn.gov/StudentCharacteristicDescriptor
4Immigranturi://education.mn.gov/StudentCharacteristicDescriptor
5Recently Arrived English Learner (RAEL)uri://education.mn.gov/StudentCharacteristicDescriptor
6Student with Limited or Interrupted Formal Education (SLIFE)uri://education.mn.gov/StudentCharacteristicDescriptor

Resource Preferences Continued

The Ed-Fi Configuration tool is used to establish Ed-Fi data resources.

The following describes how to set the resource preferences for the Student Education Organization Association resource. If the Configure or Edit buttons do not display, then the resource does not need to be mapped and the toggle button can be used to turn the resource on or off.

 If a mapping is changed, a resync must be performed on the resource in order for the new mappings to send correctly. Any item not mapped will not report to Ed-Fi. 

1. Indicate if the resource should report Legal Identities.

2. Set the Student Education Organization Association Descriptors:

Primary Learning Device Access Descriptors: Indicates whether the student shares the device with anyone else in the household.

Digital Equity Primary Device Access
Attribute DictionarySystem Administration > Custom > Attribute/Dictionary > Digital Equity
UI LocationStudent Information > Program Participation > State Programs > Digital Equity

Primary Learning Device Provider Descriptors: Indicates if the primary learning device is a personal device or a school provided device. 

Digital Equity Primary Learning Device Provider
Attribute DictionarySystem Administration > Custom > Attribute/Dictionary > Digital Equity
UI LocationStudent Information > Program Participation > State Programs > Digital Equity


Digital Device Descriptors: Indicates the type of device the student most often uses to complete school work at home.

Digital Equity Primary Digital Device
Attribute DictionarySystem Administration > Custom > Attribute/Dictionary > Digital Equity
UI LocationStudent Information > Program Participation > State Programs > Digital Equity


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

Race Descriptors
Attribute DictionarySystem Administration > Custom > Attribute/Dictionary > Identity > Race/Ethnicity
UI LocationCensus > People > Identities


Student Language Override: The language the individual uses to communicate.

The Student Language Override mapping only needs to be populated if the code does not match a code that is in the Ed-Fi Code list.
Student Language Overrides
UI LocationCensus > People > Identities


Ancestry Ethnic Origin Descriptors: The general category which most clearly reflects the individual’s recognition of his or her ethnic ancestry.

Identity Race Subcategory
Attribute DictionarySystem Administration > Custom > Attribute/Dictionary > Identity > Race Subcategory
UI LocationCensus > People > Identities


Internet Access In Residence Descriptors: Indicates if the student can access the internet on their primary learning device at home.

Digital Equity Primary Internet Access in Residence
Attribute DictionarySystem Administration > Custom > Attribute/Dictionary > Digital Equity
UI LocationStudent Information > Program Participation > State Programs > Digital Equity


Internet Access Type In Residence Descriptors: Indicates the type of internet access the student has at home.

Digital Equity Primary Internet Access Type in Res
Attribute DictionarySystem Administration > Custom > Attribute/Dictionary > Digital Equity
UI LocationStudent Information > Program Participation > State Programs > Digital Equity

Internet Performance Descriptors: Indicates the performance of the student's internet service.

Digital Equity Internet Performance
Attribute DictionarySystem Administration > Custom > Attribute/Dictionary > Digital Equity
UI LocationStudent Information > Program Participation > State Programs > Digital Equity


3. Click Save.