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

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 ix checked on the enrollment.
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:
    • Unaccompanied Youth:  A student has a Homeless record that overlaps the configure year, Start/End Dates are changed so record no longer overlaps configured year,  the record is deleted, the Unaccompanied Youth field is changed, the Runaway checkbox is checked or unchecked.
  • When a change is made to a program.
  • When a change is made to Date Entered US School.
DeleteThis record will delete if the student no longer has an eligible enrollment in the District.
DeleteIf the enrollment is marked as a No Show.

Resource Toggle and Resync Logic

This table describes the Resource Toggle and Trigger logic of this object.

Action

Business Rule

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
Primary Nighttime ResidenceHomeless Primary Nighttime Residence

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

Data Source 

GUI Path

Database
Field
idThe unique identifier of the resource.
M

education
OrganizationId

The identifier assigned to an education organization.

  1. Report reference to the Local Education Agency.
M

studentReferenceA unique alphanumeric code assigned to a student.
  1. Reports the natural key of the Students resource.
M

addressesThe set of elements that describes an address, including the street address, city, state, and ZIP code.
  1. Reports the most current Primary address that is 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. Determine the eligibility of records by looking at the Scope Year section.
  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

cohortYearsThe 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.
  1.  This is optional, does not report.
O

disabilitiesThe disability condition(s) that best describes an individual’s impairment, as determined by evaluation(s) conducted by the education organization.
  1.  This is optional, does 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 as "Private".
  2. If blank, does 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 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 "Is the individual Hispanic/Latino?" from the student's current identity:
    1. If droplist is = Yes, report "true".
    2. If droplist is = No, report "false".
OCensus>People>
Identities> Is the
Individual Hispanic
or Latino?
identity.hispanicEthnicity
international
Addresses
The set of elements that describes an international address.
  1.  This is optional, does not report.
O

languagesThe language(s) the individual uses to communicate. It is strongly recommended that entries use only ISO 639-3 language codes.
  1. See Array section below for data logic for each field.
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.
  1.  This is optional, does not report.
O




loginIdThe login ID for the user; used for security access control interface.
  1.  This is optional, does not report.
O

oldEthnicity
Descriptor
Previous definition of Ethnicity combining Hispanic/latino and race 1 - American Indian or Alaskan Native 2 - Asian or Pacific Islander 3 - Black, not of Hispanic origin 4 - Hispanic 5 - White, not of Hispanic origin.
  1.  This is optional, does not report.
ON/AN/A
profileThumbnailFile name for the ProfileThumbnail photograph.
  1.  This is optional, does not report.
ON/AN/A
programParticipations

An unordered collection of studentEducationOrganizationAssociation

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

  1.  See array for field specific logic.
O

racesThe 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.
  1. See Array section below for data logic for each field.
OCensus> People>
Identities> Race/
Ethnicity

IdentityRaceEthnicity

and

racethnicity.raceid

sexDescriptorA 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
characteristicsReflects important characteristics of the student’s home situation: Displaced Homemaker, Immigrant, Migratory, Military Parent, Pregnant Teen, Single Parent, and Unaccompanied Youth.
  1. See Array below for logic.
O

homelessDescriptorThis characteristic is used to identify students who lack fixed, regular and adequate residence and to indicate the student’s primary nighttime residence. Students who become homeless for any period of time within the school year are eligible for all homeless services for the entire school year.
  1. Report Ed-Fi Code of Primary Nighttime Residence. If NULL, do not report this field.
  2. Homeless status needs to active within the Scope Year to report.
  3. If more than one status is found, report the most recent.
OStudent Information > Programs > Homeless > Primary Nighttime Residence
Homeless.primaryNight TimeResidence
raceAsOfDateThe date of the most recent change in Race.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
schoolFoodServices
EligibilityAsOfDate
The date of the most recent change in SchoolFoodServicesEligibility.Do not report.O

yearOfEntryThe four-digit calendar year in which the student first attended school in the United States.Report year from Date Entered US School.OCensus > People > Demographics > Date Entered US School
msdsRaceOrdersCaptures the racial group and order choice for MSDS.
  1. Reports student race(s).
  2. See array for field specific logic.
O

identificationCodesA coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to a student.
  1. 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.

  1.  This is optional, does not report.
O

telephonesThe 10-digit telephone number, including the area code, for the person.
  1. See Array section for reporting logic.
O

tribalAffiliationsAn American Indian tribe with which the student is affiliated.
  1.  This is optional, does not report.
O

indicatorsIndicator(s) or metric(s) computed for the student (e.g., at risk) to influence more effective education or direct specific interventions.
  1. See Array section for reporting logic.

O

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

Array Data Elements

Click here to expand...

Indicators/Digital Equity

Data Element Label

Business Requirement

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.
  1. 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.
  1. 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 RequirementBusiness 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

Business Rules

M, C or O

Data Source GUI Path

Database Field

addressTypeDescriptorKey for Address
  1. All addresses will report as 'Home'.
M

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


MHouseholds> Address Info> Stateaddress.state
apartmentRoomSuiteNumberThe apartment, room, or suite number of an address.
  1. 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.
  1. This is optional, do not report.
O

cityThe name of the city in which an address is located.
  1. 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.
  1.  This is optional, does not report.
O

doNotPublishIndicator

An indication that the address should not be published.

  1.  This is optional, does not report.



latitudeThe geographic latitude of the physical address.
  1.  This is optional, does not report.
O

longitudeThe geographic longitude of the physical address.
  1.  This is optional, does not report.
O

nameOfCountyThe name of the county, parish, borough, or comparable unit (within a state) in which an address is located.
  1.  This is optional, does not report.
O

postalCodeThe five or nine digit zip code portion of an address.
  1. Reports the Zip Code for the address being reported
MHouseholds> Address Info> Zip Codeaddress.zip
streetNumberNameThe street number and street name or post office box number of an address.
  1. 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.
  1.  This is optional, does not report.
O

beginDateThe first date the address is valid. For physical addresses, the date the person moved to that address.
  1.  This is optional, does not report.
M

endDateThe last date the address is valid. For physical addresses, this would be the date the person moved from that address.
  1.  This is optional, does not report.
O


Electronic Mail

Data Element LabelBusiness RequirementBusiness 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.
  1.  This is optional, does not report.
O

electronicMailAddressThe electronic mail (e-mail) address listed for an individual or organization.
  1. 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.
  1.  This is optional, does not report.
O

Student Language

Data Element Label

Business Requirement

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).
  1. See uses Array section.
O

Uses

Data Element Label

Business Requirement

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

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 RequirementBusiness RulesM, 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.
  1. Report each characteristic based on the requirements below.  Student must have a Student School Association in the configured year to report a characteristic.
M




  1. US Entry Type
    • Optional, does not report.
O



  1. Career Tech Special Populations
    • Optional, does not report.





  1. Parent in Military
    • Optional, does not report.







  1. Homeless
    • If the student has a Homeless record that overlaps the configured year and Unaccompanied Youth = Yes, report 'Unaccompanied Youth'.

Student Information> Program Participation> Homeless






  1. Foster Care
    • Optional, does not report.


f




  1. Economic Disadvantaged
    • Optional, does not report.





  1. Flags:
    • Optional, does not report.



designatedByThe person, organization, or department that designated the characteristic.
  1.  This is optional, does not report.
O

periods The time periods for which characteristic was effective.
  1.  This is optional, does not report.
O

beginDateThe date the characteristic was designated.
  1.  This is optional, does not report.
O


endDateThe date the characteristic was removed.
  1.  This is optional, does not report.
O


Program Participations

Data Element Label

Business Requirement

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.

  1. Does not report
O

designatedBy

The person, organization, or department 

that designated the program association.

  1. Does not report
O

endDate

The date the Program participation ended.

  1. Does not report
O

programCharacteristicsReflects important characteristics of the
Program, such as categories or particular
indications.
  1. Does not report
O

enrollmentPercent

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

that the participant spends in the program 

reported.

  1. Does 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)

  1. See programParticipationStatus
  2. Descriptor
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

Telephones

Data Element Label

Business Requirement

Business Rules

M, C, or O

Data Source GUI Path

Database Field

 telephoneNumberTypeDescriptor

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

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

  1.  This is optional, does not report.
O

orderOfPriorityThe order of priority assigned to telephone numbers to define which number to attempt first, second, etc.
  1.  This is optional, does not report.
O

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 is marked as "Private"
  3. If blank, does 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.
  1.  This is optional, does not report.
O