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

Last Modified on 11/18/2024 10:42 am CST

Tool Search: Ed-Fi

This association represents student information 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 enrollment is marked as No Show or State Exclude.
Put

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

  • When the person’s identity record is changed: 
    • Race/Ethnicity
    • Gender
    • Home Primary Language
    • US Entry Type.
  • When one of the person’s household locations is updated/changed: 
    • Mailing, Private.
  • When one of the person’s household memberships is added/deleted/changed: 
    • Start Date
    • End Date
    • Private.
  • When any data in the address the student is associated with change:
    • PO Box
    • Number
    • Prefix
    • Street
    • Tag
    • Direction
    • Apt
    • City 
    • State
    • Zip
  • When a student's contact information is changed: 
    • email
    • phone number
    • Email
    • Other Phone
    • Work Phone
    • Cell Phone
    • Pager
    • Private.
  • When any of the Student Characteristics change.
  • When a change is made to a program.
  • When a change is made to Date Entered US School.
DeleteThis record is deleted if the student no longer has an eligible enrollment in the District.
If the enrollment is marked as a No Show or State Exclude.

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

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label

Mapping Needed

Race DescriptorRace/Ethnicity

Identity Mapping Object Key

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

campusObjectType

Object Key Data Source

PersonpersonID

Object Data Elements

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

Data Element
Label		Business Requirement and Business RulesM, C or O

Data Source 

GUI Path

Database
Field
idThe unique identifier of the resource.M

education
OrganizationId

The assigned identifier to an education organization.

  1. Report reference to the Local Education Agency
M

studentReference

A unique alphanumeric code assigned to a student.

  1. Reports the natural key of the Student's resource
M

addresses

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

  1. Reports the most current Primary address marked as "Mailing".
    1. If more than 1 Primary Address marked as Mailing, report address with most recent Household Membership Start Date
      1. Else, report the address with most recent Address Start Date
    2. Do not report if the Address Location Detail or Household Membership is marked as "Private"
  2. See Business Rule S3 in Scope Year logic to determine the eligibility of records
  3. See Array section below for data logic for each field
O

Household Addresses > Mailing


Household Membership > Start Date


Household Addresses > Start Date


HouseholdLocation.mailing


HouseholdMember.startDate


Householdlocation.StartDate

cohortYears

The type and year of a cohort (e.g., 9th grade) the student belongs to as determined by the year that student entered a specific grade.

This is optional, do 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, do not report. 

O

electronicMails 

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

  1. Reports the email address entered for that person
    1. Do not report if Email is marked "Private".
  2. If blank, do not report.
  3. See Array section for data logic for each field.
OCensus > People >
Demographics > Email		contact.email
hispanicLatino
Ethnicity

An indication that the individual traces his/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 "Is the individual Hispanic/Latino?" from the student's current identity:
    1. If droplist = Yes, report True.
    2. If droplist = No, report False.
OCensus > People >
Identities > Is the
Individual Hispanic
or Latino?		identity.hispanicEthnicity
internationalAddresses

The set of elements that describes an international address.

This is optional, do 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.

  1. Reports Home Primary Language and Native Language
  2. See array for field specific logic.
O

limitedEnglish
ProficiencyDescriptor

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

Do not report this field.		O




loginId

The login ID for the user; used for security access control interface.

This is optional, do 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

ON/AN/A
profileThumbnail

File name for the ProfileThumbnail photograph

  1. This is optional, does not report
ON/AN/A
programParticipations

Key programs the student is participating in or receives services from.

See array for field specific logic.


O

races

The general racial category which most clearly reflects the individual’s recognition of his or her community or with which the individual most identifies. The data model allows for multiple entries so that each individual can specify all appropriate races.

See Array section below for data logic for each field.		OCensus> People>
Identities> Race/
Ethnicity

IdentityRaceEthnicity

and

racethnicity.raceid

sexDescriptor

A person's gender.

  1. Report the Gender from the student's current identity record
    1. This is NOT legal gender
  2. Report the following based on the value selected in the droplist.
    1. Female report Female.
    2. Male report Male.
    3. If blank or Non-binary, report 'Not Selected.
MCensus > People >
Identities > Gender		identity.Gender
characteristics

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

See Array below for logic.		O

identificationCodes

A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to a student.

See Array section for reporting logic.		O

indicators

Indicator(s) or metric(s) computed for the student (e.g., at risk) to influence more effective education or direct specific interventions.

See Array section below for reporting logic.		O

telephones

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

See Array section for data logic for each field.		O

tribalAffiliations

An American Indian tribe with which the student is affiliated.

This is optional, do not report.		O

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

raceAsOfDate

(MI EXT) The date of the most recent change in Race.

  1. Reports the Effective Date of Identity record if a change in federal race checkboxes or the hispanic/latino droplist is found on or before the active date/today's date.
OCensus > People > Identity > Effective Date
schoolFoodServiceEligibilityAsOfDate

(MI EXT) The date of the most recent change in SchoolFoodServicesEligibility.

Do not report. 		O

yearOfEntry

(MI EXT) The four-digit calendar year in which the student first attended school in the United States.

Report year from Date Entered US School.		O

msdsRaceOrders

(MI EXT) Captures the racial group and order choice for MSDS.

  1. Reports student race(s).
  2. See array for field specific logic.
O

Array Data Elements

Click here to expand...

Indicators/Digital Equity

Data Element Label

Business Requirement and Business Rules

M, C or O

Data Source GUI Path

Database Field

Format

indicatorName

The name of the indicator or metric:

InternetAccessInResidence

InternetBarrierInResidence
InternetAccessTypeInResidence
InternetPerformance
DigitalDevice

PrimaryLearningDeviceAccess

PrimaryLearningDeviceProvider


  1. If a Digital Equity record exists for the student that falls within the config year, report the following:
    1.  "InternetAccessInResidence" as the Indicator Name for the 1st record in the array
    2. Report "InternetBarrierInResidence" for the 2nd record
    3. Report "InternetAccessTypeInResidence" for the 3rd record
    4. Report "InternetPerformance" for the 4th record
    5. Report "DigitalDevice" for the 5th record
    6. Report "PrimaryLearningDeviceAccess" for the 6th record
    7. Report "PrimaryLearningDeviceProvider" for the 7th record
  2. If multiple Digital Equity records exist for the student, report the most recent record.
  3. If no record exists, do not report.
MStudent Information > Program Participation > State Programs > Digital Equity
string (max length 200)
indicatorThe 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.		MStudent Information > Program Participation > State Programs > Digital Equity
string (max length 35)
indicatorGroupThe name for a group of indicators.

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

string (max length 200)

Identification Codes

Data Element LabelBusiness Requirement and Business RulesM, C or OData Source GUI PathDatabase Field
studentIdentificationSystemDescriptor

A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to a student.


  • If reporting Student State ID, report 'State'.
  • If reporting Local Student Number, report 'District'.



assigningOrganizationIdentificationCode

The organization code or name assigning the StudentIdentificationCode.


  • If reporting Student State ID, report 'State'.
  • If reporting Local Student Number, report State District Number.



identificationCode

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


  • Report Student State ID
  • Report Local District Number.



Student Address

Data Element Label

Business Requirement and Business Rules

M, C or O

Data Source GUI Path

Database Field

addressTypeDescriptorKey for Address

All addresses report as 'Home'.		M

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

Reports the State for the address being reported.		MHouseholds> Address Info> Stateaddress.state
apartmentRoomSuiteNumberThe apartment, room, or suite number of an address.

Reports the value entered in Apt field if populated.		OHouseholds> Address Info> Aptaddress.apt
buildingSiteNumberThe number of the building on the site, if more than one building shares the same address.

This is optional, do not report. 		O

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

Reports the City for the address being reported.		MHouseholds> Address Info> Cityaddress.city
countyFIPSCode5 digit code consisting of the two digit state code followed by the three digit FIPS code for the county.

This is optional, do not report. 		O

doNotPublishIndicator

An indication that the address should not be published.


This is optional, do not report. 




latitudeThe geographic latitude of the physical address.

This is optional, do not report. 		O

longitudeThe geographic longitude of the physical address.

This is optional, do not report. 		O

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

This is optional, do not report. 		O

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

Reports the Zip Code of the reported address.		MHouseholds> Address Info> Zip Codeaddress.zip
streetNumberNameThe street number and street name or post office box number of an address.

Reports Address PO Box + Number + Street + Tag + Prefix + Dir.		MHouseholds>Address Info

address.postOfficeBox

address.number

address.street

address.tag

address.prefix

address.dir

periodsThe time periods for which the address is valid. For physical addresses, the periods in which the person lived at that address.

This is optional, do not report. 		O

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

This is optional, do not report. 		M

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

This is optional, do not report. 		O

Electronic Mail

Data Element LabelBusiness Requirement and Business RulesM, C or O

Data Source GUI Path

Database Field
electronicMailTypeDescriptorThe type of email listed for an individual or organization. For example: Home/Personal, Work, etc.).
  1. The Primary Email address will report as "Home/Personal"
  2. Do not report Secondary Email for students.
M

doNotPublishIndicatorAn indication that the electronic email address should not be published.

This is optional, do not report. 		O

electronicMailAddressThe electronic mail (e-mail) address listed for an individual or organization.

Reports the email address entered for that person.		MCensus> People> Demographics> Emailcontact.email
primaryEmailAddressIndicatorAn indication that the electronic mail address should be used as the principal electronic mail address for an individual or organization.

This is optional, do not report. 		O

Student Language

Data Element Label

Business Requirement and 

Business Rules

M, C, or O

Data Source GUI Path

Database Field

languageDescriptor

A specification of which written or spoken communication is being used.


  1. Report the Code from the Home Primary Language saved on the student's current identity record.
    • If blank, do not report this field
    • If the code does not match an Ed-Fi code, do not report a record
    • Report default value if saved on the Attribute and the code matches an Ed-Fi code
  2. Report the Code from the Native Language saved on the student's current identity record.
    • If blank, do not report this field
    • If the code does not match an Ed-Fi code, do not report a record
    • Report default value if saved on the Attribute and the code matches an Ed-Fi code
  3. If Home Primary Language and Native Language match, report a single languageDescriptor associated with both uses (Home Language, Native Language).

M

Census> People> Identities> Race/Ethnicity


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

See uses Array section.		O

Uses

Data Element Label

Business Requirement and 

Business Rules

M, C, or O

Data Source GUI Path

Database Field

languageUseDescriptor

A specification of which written or spoken communication is being used.


  1. If Home Primary Language = NOT NULL, report ‘Home Language’
  2. If Native Language = NOT NULL, report ‘Spoken Language’

M

Census> People> Identities> Race/Ethnicity


Races

Data Element Label

Business Requirement and 

Business Rules

M, C or O

Data Source GUI Path

Database Field

raceDescriptor 

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


  1. If American Indian - Alaska Native = selected, report "American Indian - Alaska Native".
  2. If Asian = selected, report 'Asian'.
  3. If Black or African American = selected, report 'Black - African American'.
  4. If Native Hawaiian or Other Pacific Islander = selected, report 'Native Hawaiian - Pacific Islander'.
  5. If White = selected, report 'White'.
MCensus> People> Identities> Race/Ethnicity

IdentityRaceEthnicity

and

racethnicity.raceid

raceOrderChoiceDescriptorThe order choice of the racial category.

Always report 1. 		M

Student Characteristics

Data Element LabelBusiness Requirement and
Business Rules		M, C, or O

Data Source GUI Path

Database Field

Student Characteristic Descriptor

This descriptor captures important characteristics of the student’s environment or situation. Generally used for non-program-based student characteristics.

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



US Entry Type
  • This is optional, do not report.
O


Career Tech Special Populations
  • This is optional, do not report.




Parent in Military
  • This is optional, do not report.






Foster Care
  • This is optional, do not report.


f



Economic Disadvantaged
  • This is optional, do not report.




Flags
  • This is optional, do not report.



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

This is optional, do not report. 		O

periods The time periods for which characteristic was effective.

This is optional, do not report.		O

beginDateThe date the characteristic was designated.

This is optional, do not report. 		O

endDateThe date the characteristic was removed.

This is optional, do not report. 		O

Program Participations

Data Element Label

Business Requirement and 

Business Rules

M, C, or O

Data Source GUI Path

Database Field

programTypeDescriptor

The type of program.


Program Reporting

  1. Student program must be active within the Scope Year.
  2. Program must have:
    1. State Reported = selected
    2. Report the following program types if any of the following programs are found:
      1. If Code = 3060, report 'Student Retention/Dropout Prevention'
      2. If Code = 3500, report 'Community/Junior College Education Program'
      3. If Code = 6011, 6012, 6013, 6014, 6015, 6016, 6017, 6021, 6022, 6023, 6024, 6025, 6026, or 6027, report 'Title I Part A'
      4. If Code = 7760, report 'Remedial Education'
      5. If Code = 9110, report 'Regular Education'
      6. If Code = 9120, report 'Foreign Exchange'
      7. If Code = 9130, report 'Immigrant Education'
      8. If Code = 9210, report 'Section 504 Placement'
      9. If Code = 9220, report 'Alternative Education'
      10. If Code = 9222, report 'Compensatory Services for Disadvantaged Students'
      11. If Code = 9229, report 'Other'
      12. If Code = 9230, report 'Prekindergarten - Full Day'

Military Connections Reporting

  1. If student has a relationship with a Guardian that has an active Military Connections record within the Scope Year, report Other. 
    1. Status must be = Active Duty, Deployed or Active Duty, Not Deployed
    2. Branch must be other than Air National Guard or Army National Guard.

M




beginDate

The date the Student was associated with

 the Program or service.


This is optional, do not report. 

O

designatedBy

The person, organization, or department 

that designated the program association.



This is optional, do not report.

O

endDate

The date the Program participation ended.



This is optional, do not report.

O

programCharacteristicsReflects important characteristics of the
Program, such as categories or particular
indications.


This is optional, do not report.

O

enrollmentPercent

(MI EXT) The full-time equivalency (FTE) 

that the participant spends in the program 

reported.



This is optional, do not report.

O

statuses

An unordered collection of studentEducationOrganizationAssociation

ProgramParticipationStatuses. (MI EXT) To indicate the status of the students participation in the program (i. g. eligible, started, completed, not eligible).


See programParticipationStatusDescriptor		O

programParticipation
StatusDescriptor

(MI EXT) To indicate the status of the students participation in the program (i. g. eligible, started, completed, not eligible).


Program Reporting

  1. If Code = 6011, 6012, 6013, 6014, 6015, 6016, 6017, 6021, 6022, 6023, 6024, 6025, 6026, or 6027, report 6010.
  2. Else report Code from program reported.

Military Connections Reporting

  1. Report 9140.
M

Addresses

Data Element LabelBusiness Requirement and
Business Rules		M, C, or OData Source GUI PathDatabase Field
countyCode

(MI EXT) A unique number or alphanumeric code assigned to a county by the state of Michigan.


Reports code associated with the County saved on the student's address.
  • Format: 00
    • Add zero padding if number is less than 2 characters.
OAddress > County

Telephones

Data Element Label

Business Requirement and

Business Rules

M, C, or O

Data Source GUI Path

Database Field

 telephoneNumberTypeDescriptor

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


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

Campus PhoneEd-Fi Code
Cell PhoneMobile
Other PhoneHome
Work PhoneWork
PagerOther
M Census> People> Demographics> Personal Contact Information> Other Phone, Work Phone, Cell Phone, Pager
doNotPublishIndicator

An indication that the telephone number should not be published.


This is optional, do not report.

O

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

Priority Reporting Order:
Campus PhoneEd-Fi Code
Cell PhoneMobile
Other PhoneHome
Work PhoneWork
PagerOther

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

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


  1. Reports the Phone numbers entered in the Personal Contact Information for that person.
  2. Do not report Phone Number  marked as "Private"
  3. If blank, do not report.
MCensus> People> Demographics> Personal Contact Information> Other Phone, Work Phone, Cell Phone, Pager

contact.otherPhone

contact.workPhone

contact.cellPhone

contact.pager

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

This is optional, do not report.		O

Previous Versions

Michigan Ed-Fi Data v3.1 - Student Education Organization Association [.2211 - .2307]

Related Articles

Was this helpful?
Thank you for your feedback!
User Icon

Thank you!

Copyright ©️ 2010-2023 Infinite Campus, Inc. All rights reserved. | Terms of Use | Privacy Policy | infinitecampus.com