Wisconsin Ed-Fi Data v3.1 - 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.

Action	Trigger
Post	When an enrollment is created and saved for a person and the enrollment overlaps a configured year. Only one record is posted per student. Do not send a student record for an enrollment that is marked as State Exclude, No Show, or WISE Exclude. Do not send a record if enrollment is in a calendar marked as State Exclude, Summer School, or in a School marked Exclude. If Ed-Fi Configuration Profile = Choice + Opt in report a record for all eligible students if Choice = Yes or No on the student's enrollment. If Ed-Fi Configuration Profile = Choice AND Choice = No on Student enrollment, do not report a record. Send only one record per unique School/Student combination based on primacy if there are overlapping records: State Enrollment Type = Primary Enrollment Type = Primary Enrollment Type = Special Ed other enrollment types or state enrollment types
Post	If the School Override field is populated on a student's enrollment, report the record with the associated Ed-Fi School Number.
Post	When a student's FRAM record is ended.
Put	When the Immigrant indicator on the enrollment driving the Student Education Organization Association record is updated and saved.
Put	When the Resident District field on the enrollment driving the Student Education Organization Association record is updated and saved.
Put	When a Migrant record is created that has dates falling within the enrollment dates driving the Student Education Organization Association record.
Delete	This record will delete if the student no longer has an eligible enrollment in the District.
Delete	When the State Exclude, WISE Exclude, or No Show check boxes are checked.

Resource Toggle and Resync Logic

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

Action	Business Rule
None	If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
Resync	If 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.
Resync	If 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.
Resync	If 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/Delete	Natural 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.
Delete	Cascading 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.

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.

Identity Mapping Object Key

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

campusObjectType	Object Key Data Source
Person	personID - schoolID

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
identity	Put	Reports Hispanic or Latino, Gender, Home Primary Language, US Entry Type.
person	Put	Reports the Ed-FI ID.
contact	Put	Reports the Telephone and Email information.
raceethnicity	Put	Reports Races.
plantype	Put	Reports Indicators.
plan	Put	Reports Disabilities, Indicators.
planstate	Put	Reports Disabilities.
programs	Put	Reports any Characteristic created in Programs.
programparticipation	Put	Reports any Characteristic created in Programs.
ImpactAidEmployment	Put	Reports Parent in Military.
relatedpair	Put	Guardian checkbox for contact information and Parent in Military.
section504	Put	Reports Section 504 Handicapped.
homeless	Put	Reports Homeless, Unaccompanied Youth, Runaway.

Object Data Elements

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

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
id	The unique identifier of the resource.		M
education OrganizationId	The identifier assigned to an education organization.	Report the Ed-Fi school number for the student's enrollment record from the School Override field on the enrollment record if it is populated. If the school override is the same as the school for the enrollment record, only report 1 record. Otherwise, report the Ed-Fi school Number (System Administration > Resources > School) associated with the student's enrollment record.	M
studentReference	A unique alphanumeric code assigned to a student.	Reports the natural key of the Students resource.	M
addresses	The set of elements that describes an address, including the street address, city, state, and ZIP code.	This is optional, does not report.	O
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, does 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.	If the enrollment determining the record is in a School with Ed-Fi Configuration Profile = Public, do not report this array. Otherwise, report the Ed-Fi Code Value from the Disability Descriptor list in the Type/Descriptors section based on the Ed-Fi code value for each disability the student meets. See the Array section above for Disabilities for full reporting requirements	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.	electronicMailType has a specific url path = WI_URI_PATH('uri://dpi.wi.gov/ElectronicMailTypeDescriptor#Org')	O	Census> 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."	Report "Is the individual Hispanic/Latino?" from the student's current identity: If droplist is = Yes, report "true". If droplist is = No, report "false".	O	Census>People>Identities> Is the Individual Hispanic or Latino?	identity.hispanic Ethnicity
international Addresses	The set of elements that describes an international address.	This is optional, does 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.	If the Enrollment determining the record is in a calendar in a school where Ed-Fi School Population is marked Choice or Choice + Private Opt in, report blank. If Enrollment is in a school where Ed-Fi School Population is marked Public and Native Language is not NULL, add to the languages. Otherwise, do not add to the array. See the Languages Array elements for logic.	C	Census > People > Identity > Native Language	Identity.language Alt
limitedEnglish Proficiency Descriptor	An indication that the student has been identified as limited English proficient by the Language Proficiency Assessment Committee (LPAC), or English proficient.	See Appendix A :Additional Logic for calculation.	O	Student Information> Program Participation> English Learners (EL)	lep.programStatus lep.identifieddate lep.exitDate lep.parent Declined
loginId	The login ID for the user; used for security access control interface.	Reports the app username	O		app.username
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.	O	N/A	N/A
profileThumbnail	File name for the ProfileThumbnail photograph.	This is optional, does not report.	O	N/A	N/A
program Participations	Key programs the student is participating in or receives services from.	This is optional, does not report.	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.	O	Census > People > Identities > Race/Ethnicity	IdentityRace Ethnicity and racethnicity.raceid
sexDescriptor	A person's gender.	Report the Legal Gender from the student's current identity record. If null, report the student's Gender from the current Identity record. Report the following based on the value selected in the droplist Female report 'Female'. Male report 'Male'. If Blank, do not report.	M	Census>People>Identities> Legal Gender OR Census>People>Identities> Gender	identity.Legal Gender or 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.	This is optional, does not report.	O
telephones	The 10-digit telephone number, including the area code, for the person.	This is optional, does not report.	O
languages	An unordered collection of studentLanguages. Language(s) the individual uses to communicate.	If the Enrollment determining the record is in a calendar in a school where Ed-Fi School Population is marked Choice or Choice + Private Opt in, report blank If Enrollment is in a school where Ed-Fi School Population is marked Public and Native Language is not NULL, add to the languages. Otherwise, do not add to the array. See the Languages Array elements for logic.	C	Census > People > Identity > Native Language	Identity.language Alt
tribalAffiliations	An American Indian tribe with which the student is affiliated.	This is optional, does not report.	O
_etag	A unique system-generated value that identifies the version of the resource.		O

Array Data Elements

Disabilities

Data Element Label	Business Requirement	Business Rules	M,C or O	Data Source GUI Path	Database Field
disabilityDescriptor	This descriptor defines a student's impairment.	Report the Ed-Fi code from the Disabilities mapping for the student being reported. Only report the distinct disabilities from the first 5 disability fields. If the student has a locked IEP that overlaps the configured year, report the disabilities entered on the IEP if mapped to an Ed-Fi Code. If the student does not have an eligible IEP but has 1 or more disabilities on their enrollment, report the disabilities if mapped to an Ed-Fi Code. The enrollment must overlap the configured year. If the student has more than 1 enrollment, report all distinct disabilities. If the student does not have an eligible IEP or disabilities on enrollment, report disabilities from the Special Ed State Reporting tab. State Reporting record must overlap the configured year. if the student has more than 1 State Reporting record, report all distinct disabilities.	M	Special Ed> Documents> Plan> IEP> Primary Disability, Secondary Disability, Tertiary Disability, Fourth Disability, Fifth Disability OR Enrollments> Secondary Disability, Tertiary Disability, Fourth Disability, Fifth Disability OR Student Information> Special Ed> General> State Reporting> Primary Disability	planstate.disability1 planstate.disability2 planstate.disability3 planstate.disability4 planstate.disability5 or enrollment.disability1 enrollment.disability2 enrollment.disability3 enrollment.disability4 enrollment.disability5 or specialEdState.primaryDisability
disabilityDeterminationSourceTypeDescriptor	The source that provided the disability determination.	This is optional, does not report.	O
disabilityDiagnosis	A description of the disability diagnosis.	This is optional, does not report.	O
orderOfDisability	The order by severity of student's disabilities: 1- Primary, 2 - Secondary, 3 - Tertiary, etc.,	Report the order of disability based on the disability being reported from above. If Primary Disability, report '1'. if Secondary Disability, report '2'. if Tertiary Disability, report '3'. if Fourth Disability, report '4'. if Fifth Disability, report '5'. If the student has the same disability in multiple records from the same source (IEP, Enrollment, State Reporting) and the order is not the same, report the order from the record with the most recent start date. If the start dates are the same, the system will pick a record to send.	O
designations	Whether the disability is IDEA, Section 504, or other disability designation.	This is optional, do not report.

Electronic Mail

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
electronicMailTypeDescriptor	The type of email listed for an individual or organization. For example: Home/Personal, Work, etc.).	The Primary Email address will report as "Home/Personal" Do not report Secondary Email for students.	M
doNotPublishIndicator	An indication that the electronic email address should not be published.	This is optional, does not report.	O
electronicMailAddress	The electronic mail (e-mail) address listed for an individual or organization.	Reports the email address entered for that person.	M	Census> People> Demographics> Email	contact.email
primaryEmailAddressIndicator	An indication that the electronic mail address should be used as the principal electronic mail address for an individual or organization.	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 unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table	Report the Language from the Native 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 Code matches an Ed-Fi code, if yes report that value. Report default value if saved on the Attribute and the code matches an Ed-Fi code. Otherwise, report NULL.	M	Census > People > Identities > Native Language	Identity.languageAlt
uses	A description of how the language is used (e.g. Home Language, Native Language, Spoken Language).	If the array is being reported, report "Native language".	O	N/A	N/A

Races

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
raceDescriptor	The general racial category which most clearly reflects the individual's recognition of his or her community or with which the individual most identifies.	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 students current identity id. Report the Ed-Fi Code mapped to the corresponding Race Ethnicity. Report all races if the student has more than 1 selected. Do not report if the person does not have a Race/Ethnicity checked or there is not a corresponding mapping.	M	Census> People> Identities> Race/Ethnicity	IdentityRaceEthnicity and racethnicity.raceid

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

raceDescriptor

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

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 students current identity id.
Report the Ed-Fi Code mapped to the corresponding Race Ethnicity.
- Report all races if the student has more than 1 selected.
Do not report if the person does not have a Race/Ethnicity checked or there is not a corresponding mapping.

Census> People> Identities> Race/Ethnicity

IdentityRaceEthnicity

and

racethnicity.raceid

Student Characteristics

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
Student Characteristic Descriptor	This entity 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.	Report each characteristic based on the requirements below. Student must have a Student School Association in the configured year to report a characteristic.	M
		Parent in Military Do not report for students Enrolled in a School with Ed-Fi Reporting Option of Choice ONLY or Choice + Private Opt In. If students are enrolled in a school with Ed-Fi Reporting Option = Public: If the student has a Qualifying Relationship with a person with an Active Military Connections record, add Parent in Military to the array. A qualifying relationship is; active within the school year (not ended prior to the start of the config year). AND either marked Guardian OR the role is mapped to an Ed-Fi value of Parent/ Guardian. An Active Military Connections record is; has a start date in the school year associated with the Ed-Fi config year OR is not ended prior to the start of the config year. has a Status mapped to an Ed-Fi Value of Active. Otherwise do not report.		Calculated from: Census > People > Military Connections AND Census > People > Relationships	ImpactAidEmployment.militaryStatus ImpactAidEmployment.startDate ImpactAidEmployment.endDate RelatedPair.guardian
		Economic Disadvantaged If Disadvantaged - Alt Mechanism (Student Information > General > Enrollment) is checked, report 'ED' for the student characteristic descriptor. If Disadvantaged - Alt Mechanism (Student Information > General > Enrollment) is not checked, then do the following: Report 'ED' If an active FRAM eligibility record exists with a Type of Meal or SES for the current/reporting school year and the eligibility is Free or Reduced. If the active record is in the previous school year (carryover eligibility), do not report 'ED'. Report 'Not ED' if: Eligibility is Paid Eligibility is Non-reimbursable Eligibility is NULL No FRAM records exist All FRAM records are ended The active FRAM record is a "carryover" record from the previous school year.		Student Information > General > Enrollment > Disadvantaged - Alt Mechanism FRAM > Eligibility > Eligibility
		Not Economically Disadvantaged: If the student does not report Economically Disadvantaged, report Not Economically Disadvantaged.		Student Information > General > Enrollment > Disadvantaged - Alt Mechanism FRAM > Eligibility > Eligibility
		SATA Report when a student has an Enrollment marked State Assessment Type = Alternate. Otherwise, do not report.		Student Information> General> Enrollment > State Assessment Type
		Migrant Do not report for students Enrolled in a School with Ed-Fi Reporting Option of Choice ONLY or Choice + Private Opt In. If students are enrolled in a school with the Ed-Fi Reporting Option = Public Find any Migrant records for the student. Report the Migrant record if the student has a Migrant record at any point during the student's enrollment in the current school year and meets the following criteria: Enrollment State type = P : Primary. Enrollment is not excluded : State, Grade, Calendar, WISE. The Migrant record must overlap an enrollment record in the current year: The Migrant end date must be after enrollment start date or null. Changes in dates of the migrant record or enrollment trigger an event to send to the state. Otherwise do not report.		Student Information > General > Program Participation > Migrant
		Immigrant Do not report for students Enrolled in a School with Ed-Fi Reporting Option of Choice ONLY or Choice + Private Opt In. If students are enrolled in a school with Ed-Fi Reporting Option = Public: If student is marked Immigrant = Yes, add Immigrant to the array. Otherwise do not report.		Student Information > General > Enrollment > Immigrant
		Teen Single Parent Do not report for students Enrolled in a School with Ed-Fi Reporting Option of Choice ONLY or Choice + Private Opt In. If students are enrolled in a school with Ed-Fi Reporting Option = Public: AND If student is enrolled in grades 11 or 12, AND if the student has a State Reported CTE Participant (Student Information > Academic Planning > Academic Program > Career Tech Program - Participation Detail) record with Teen Single Parent checked OR the student is marked 12. Teen Single Parent in Student Information > General > CTE (CTEERS), report 'SP'. Otherwise do not report.
designatedBy	The person, organization, or department that designated the characteristic.	This is optional, does not report.	O
periods	The time periods for which characteristic was effective.	This is optional, does not report.	O
beginDate	The date the characteristic was designated.	This is optional, does not report.	O
endDate	The date the characteristic was removed.	This is optional, does not report.	O

Student Identification Codes

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
studentIdentification SystemDescriptor	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 'L'.	M	Census> People> Demographics> Local Student Number and/or Student State ID	person.studentnumber person.stateID
AssigningOrganization IdentificationCode	The organization code or name assigning the StudentIdentificationCode.	Report 'Local'.	M	Student Information > General> Resource > District Information> Number	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 the Local Student Number.	M	Census>People>Demographics> Local Student Number	person.studentNumber

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

studentIdentification

SystemDescriptor

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

Census> People> Demographics> Local Student Number and/or Student State ID

person.studentnumber

person.stateID

AssigningOrganization
IdentificationCode

The organization code or name assigning the StudentIdentificationCode.

Report 'Local'.

Student Information > General> Resource > District Information> Number

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 the Local Student Number.

Census>People>Demographics> Local Student Number

person.studentNumber

Appendix A: Additional Logic

Field	Logic
limitedEnglishProficiencyDescriptor	For the current scope year (current date is within the start and end date of the year dates): Find the EL record to be used as of today's date: Find all EL records where the ELIdentified Date is before today's date, this may include EL records with an identified date in a prior year. EL records with an Identified Date after today's are disregarded. EL records with an Identified Date after the Enrollment End Date are disregarded. Use the record if one of the following are true: Today's date falls between the EL Identified Date and EL Exit Date. Today's date falls after Identified Date and No exit date exists. Program Status must be "EL" or "Exited EL". If today's date does not fall between the Identified Date and the Exit Date of any LEP record, and no record exists without an Identified Date, use the most recent LEP record with an Exit Date as the Valid EL Record. For any previous year's data (scope year set to a year with an end date prior to the current date) - Use this when configuration is set up with a prior year: Find the latest EL record within the scope year or before (on or before the last date of the year). Program Status must be "EL" or "Exited EL". From the identified EL record, calculate the reported value. First, If there is an 'English Proficiency Override' value on the EL record used (see above for logic on which record to use), report that value. If no English proficiency override exists AND the student has exited EL Status and the Exit date is prior to the current date/ end of year date, report '6'. Else find an EL Assessment of Assessment Type 'LPF' or 'LID' If the student's EL Identified date is prior to the start date of the school year use the most recent assessment score in the prior year. Score must be on the parent assessment. This score must report through the end date on index>system admin> calendar>school years> end date. If Null report this through 6/30/current year. Next, if the student has exited and the Exit date is prior to the current date/ end of year date, report '6'. Otherwise, find an EL Assessment of Assessment Type 'LPF' or 'LID'. If the student is not a new EL student to this year, use the prior year's assessment score. The student's EL identified date must be prior to the start of the scope year. If the student is a new EL student, use this year's assessment score. The student's EL identified date must be on or after the start of the scope year and on or before today's date. For previous year's data, do not use any assessments after the end of the year. From the identified assessment, pull the result value (1.0-6.0) and display the result truncated to the whole number. For example; the Result on the EL Assessment being considered = 2.8, a '2' is reported. Any test with a value outside this range (6.1 or above, or 0-.9) is disregarded and does not report. If Home Primary Language is equal to eng (English), report 7. If the Student is not EL, report 7.

Field