Arizona Ed-Fi Data v3.5 - Student Education Organization Associations

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. 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. Report one Student Education Organization Association record for every unique school enrollment; if there are multiple enrollment records tied to the same school in a configured year, report out a single Student Education Organization Association record for each unique school.
Delete/Post	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 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 changes: PO Box, Number, Prefix, Street, Tag, Direction, Apt, City, State, Zip When a student's IEP is locked or unlocked and/or a student's disability is changed on the IEP, Enrollment or State Special Education tab. When any of the Student Characteristics change: Single Parent: If a student's Special Population is changed. Foster Care: A student has a Foster Care record that overlaps the configured year, Start/End Dates are changed so record no longer overlaps configured year, the record is deleted. 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.
Delete	This record will delete if the student no longer has an eligible enrollment in the District.
Delete	If a student had multiple unique school enrollments, and all of the enrollments tied to a single school are deleted, then only the Student Education Organization Association record tied to that school would be removed.

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 LEA number changes, all data will remain under the old number and a resync will need to be completed to populate data under the new number. The delete tool would need to be used to remove all data from the old LEA number. If an Ed-Fi ID changes, this will happen with the cascading deletes from the Ed-Fi ID Change trigger.
Delete	Cascading Deletes: The logic for an Ed-FI ID change will update all resources impacted by this change.

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.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label	Mapping Needed
Student Characteristic Descriptors - Flags	Flag
Student Characteristic Descriptors - Foster Care	Foster Care
Student Characteristic Descriptors - Military Status	Military Status
Race Descriptor	Race/Ethnicity
Student Language Override	Home Primary Language
State Abbreviation Override	Definition US state list
Tribal Affiliation Descriptors	Identity Tribal Affiliation

Identity Mapping Object Key

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

campusObjectType	Object Key Data Source
Person	personID

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
householdlocation	Put	Determines if address is marked as Mailing or Private
householdmember	Put	Determines household membership with Start Date, End Date, Private
address	Put	PO Box, Number, Prefix, Street, Tag, Direction, Apt, City, State, Zip
raceethnicity	Put	Reports Races
plantype	Put	Reports Indicators
plan	Put	Reports Disabilities, Indicators
planstate	Put	Reports Disabilities
programs	Put	Reports any Characteristic created in Flags
programparticipation	Put	Reports any Characteristic created in Flags
Title1	Put	Reports Neglected or Delinquent
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 School Entity ID tied to the school record tied to each enrollment.	M	System Administration > Resources > School > school record > Entity ID	School.entityID
studentReference	A unique alphanumeric code assigned to a student.	Reports the natural key of the Students resource. Note: The Ed-Fi ID reports from the Student State ID field.	M
addresses	The set of elements that describes an address, including the street address, city, state, and ZIP code.	Reports the most current Primary address that is marked as "Mailing". If more than 1 Primary Address marked as Mailing, report address with most recent Household Membership Start Date. Otherwise, report the address with most recent Address Start Date. Else, report the address with the highest address. See Scope Year logic to determine the eligibility of records. See Array section below for data logic for each field. Send a second address in the array, but set that address as an address type as 'Mailing'. The second address should be the same exact address that was sent as 'Home'.	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, does not report.	O	N/A	N/A
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, does not report.	O	N/A	N/A
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.	O	N/A	N/A
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 Hispanicor Latino?	identity. hispanicEthnicity
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 tocommunicate. It is strongly recommended that entries use only ISO 639-3 language codes.	See Array section below for data logic for each field.	O
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.	This is optional, does not report.	O	N/A	N/A
loginId	The login ID for the user; used for security access control interface.	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.	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 Gender from the student's current identity record. This is not legal gender. Report the following based on the value selected in the droplist. Female report 'Female' Male report 'Male' If blank or Non-binary, report 'Not Selected'.	M	Census>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.	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
tribalAffiliations	An unordered collection of student Education Organization Association Tribal Affiliations. An American Indian tribe with which the student is affiliated.	Report the EdFi code(s) mapped in the config mapping tool if it exists, for any and all values saved in the multi-select tool. Otherwise, do not report.	C	Census > People > Tribal Affiliation	RaceSubcategory. subcategory
azTribal Affiliations	An unordered collection of student Education Organization Association AZ Tribal Affiliations. An American Indian tribe with which an individual is affiliated.	Do not report.	C	Census > People > Tribal Name	Identity. tribalName
_etag	A unique system-generated value that identifies the version of the resource.		O

Array Data Elements

Click here to expand...

Student Address

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
addressTypeDescriptor	Key for Address	All addresses will be sent twice. One will report as 'Home' and the second will report as 'Mailing'.	M
stateAbbreviation Descriptor	The abbreviation for the state (within the United States) or outlying area in which an address is located.	Report the State from the Birth State saved on the student's current identity record. Look for a mapping saved to the State Abbreviation Type Override section in preferences. If there is a mapped value, report that mapping. If an override is not there, look to see if the 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. Else, report NULL.	M	Households> Address Info> State	address.state
apartmentRoom SuiteNumber	The apartment, room, or suite number of an address.	Reports the value entered in Apt field if populated.	O	Households> Address Info> Apt	address.apt
buildingSiteNumber	The number of the building on the site, if more than one building shares the same address.	This is optional, do not report.	O
city	The name of the city in which an address is located.	Reports the City for the address being reported.	M	Households> Address Info> City	address.city
countyFIPSCode	5 digit code consisting of the two digit state code followed by the three digit FIPS code for the county.	This is optional, does not report.	O
doNotPublish Indicator	An indication that the address should not be published.	This is optional, does not report.
latitude	The geographic latitude of the physical address.	This is optional, does not report.	O
longitude	The geographic longitude of the physical address.	This is optional, does not report.	O
nameOfCounty	The name of the county, parish, borough, or comparable unit (within a state) in which an address is located.	This is optional, does not report.	O
postalCode	The five or nine digit zip code portion of an address.	Reports the Zip Code for the address being reported.	M	Households> Address Info> Zip Code	address.zip
streetNumberName	The street number and street name or post office box number of an address.	Reports Address PO Box + Number + Street + Tag + Prefix + Dir	M	Households>Address Info	address.postOffice Box address.number address.street address.tag address.prefix address.dir
periods	The time periods for which the address is valid. For physical addresses, the periods in which the person lived at that address.	This is optional, does not report.	O
beginDate	The first date the address is valid. For physical addresses, the date the person moved to that address.	This is optional, does not report.	M
endDate	The last date the address is valid. For physical addresses, this would be the date the person moved from that address.	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
languageUseDescriptor	A description of how the language is used (e.g. Home Language, Native Language, Spoken Language).	For a reportable language value saved in "Home Primary Language", report 'Home Language'. For a reportable language value saved in "Most Spoken Language", report ‘Spoken language’. For a reportable language value saved in "First Acquired Language", report 'First Acquired Language'.	O

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

languageDescriptor

The language(s) the individual uses to communicate. It is strongly recommended that entries use only ISO 639-3 language codes.

Report the Languages from the Home Primary Language, Most Spoken Language, and/or First Acquired Language fields 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 NULL.

Census > People> Identities > Home Primary Language

Census > People> Identities > Most Spoken Language

Census > People> Identities > First Acquired Language

identity.homePrimaryLanguage

Identity.languageAlt2

Identity.languageAlt

languageUseDescriptor

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

For a reportable language value saved in "Home Primary Language", report 'Home Language'.
For a reportable language value saved in "Most Spoken Language", report ‘Spoken language’.
For a reportable language value saved in "First Acquired Language", report 'First Acquired Language'.

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
	US Entry Type	Does not report.		N/A	N/A
	Career Tech Special Populations	Does not report.		N/A	N/A
	Parent in Military	Report if the student has a relationship with a Guardian that has an active Military Connections record within the configured year. The Status on the Military Connections tab must be checked in the Military Connections Resource Preferences to report. Remove characteristic if the Guardian checkbox is removed from the student/guardian relationship.		Census> People> Military Connections	ImpactAidEmployment.militaryStatus ImpactAidEmployment.startDate ImpactAidEmployment.endDate RelatedPair.guardian
	Homeless	Does not report.		N/A	N/A
	Foster Care	Report if the student has a Foster Care record that overlaps the configured year and is mapped in the Foster Care Resource Preferences.		Student Information> Program Participation> Foster Care	fostercare.startdate fostercare.enddate
	Economic Disadvantaged	Does not report.		N/A	N/A
	1/4 or more degree Indian blood	Report if "1/4 more degree Indian blood" is checked.		Census > People > Identities > Protected Identity Information > 1/4 more degree Indian Blood
	Flags	Report when a student has a Flag in the configured year and the the Flag is mapped to an Ed-Fi Code in the Flags Resource Preferences.		Student Information> General> Flags	programparticipation. name
	Periods Array - Begin Date	Report a beginDate value: Parent in Military: report the Military Connection Start Date: If more than one Military Connection record exists, report the oldest start date of all the records. Note: Only one date should ever report for this, even if both parents are in the military. Foster Care: Report the Foster Care Start Date
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.	M
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
StudentCharacteristicDescriptor		Report 'District'.	M	N/A	N/A
AssigningOrganizationIdentificationCode	The organization code or name assigning the assessment identification code.	Reports the District Number where the student is enrolled.	O	Student Information > General> Resource > District Information> Entity ID	district.entityID
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

Type/Descriptor