Arizona Ed-Fi Data v3.3 - Student Education Organization Association

Classic View: System Administration > Ed-Fi 

Search Terms: Ed-Fi

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

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When an enrollment is created and saved for a person and the enrollment overlaps a configured year.

  • Do not send a record if enrollment is in a calendar marked as State Exclude.
  • Do not send a record if enrollment is in a School marked as State Exclude.
  • Do not send a record if the No Show checkbox is checked on the enrollment.
  • 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.
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 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 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:
    •  Displaced Homemaker, Pregnant, 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 the record no longer overlaps the 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 the record no longer overlaps the configured year, the Guardian checkbox is checked/unchecked, the record is deleted.
DeleteThis record will delete if the student no longer has an eligible enrollment in the District.
DeleteIf 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

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

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 DescriptorRace/Ethnicity
Student Language OverrideHome Primary Language
State Abbreviation OverrideDefinition 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

PersonpersonID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table

Ed-Fi Action

Fields

enrollment

Post/Put/Delete

Put

The primary table used for sending data for this resource

Reports Disabilities

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

Object Data Elements

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

Data Element
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.

Report the School Entity ID tied to the school record tied to each enrollment.

MSystem Administration > Resources > School > school record > Entity IDSchool.entityID
studentReferenceA unique alphanumeric code assigned to
a student.

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".
    • If more than 1 Primary Address marked as Mailing, report address with most recent Household Membership Start Date.
      • Else, report the address with most recent Address Start Date.
    • 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

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.

 This is optional, does not report.

O N/A N/A
disabilitiesThe disability condition(s) that best describes an individual’s impairment, as determined by evaluation(s) conducted by the education organization.

 This is optional, does not report.

ON/AN/A
electronicMailsThe 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.

ON/AN/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.""
  1. Report "Is the individual Hispanic/Latino?" from the student's current identity:
    • If droplist is = Yes, report "true".
    • If droplist is = No, report "false".
OCensus>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

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

See Array section below for data logic for each field.

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.

ON/AN/A


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

ON/AN/A
profileThumbnailFile name for the ProfileThumbnail photograph.

 This is optional, does not report.

ON/AN/A
program
Participations

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

 This is optional, does not report.

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.

See Array section below for data logic for each field.

OCensus> People> Identities> Race/Ethnicity

IdentityRace

Ethnicity


and


racethnicity.

raceid

sexDescriptorA person's gender.
  1. Report the Gender from the student's current identity record.
    • This is NOT legal gender.
  2. 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'.
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.

See Array below for 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.

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

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

This is optional, does not report.

O

tribalAffiliationsAn unordered collection of studentEducationOrganization
Association TribalAffiliations. An American Indian
tribe with which the student is affiliated.
  1. 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.
  2. If no values are saved, or if values are saved but no Config mapping exists for any of them, BUT an azTribalAffiliations value has been sent, send 'Other'.
  3. Otherwise, do not report.
CCensus > People > Tribal AffiliationRaceSubcategory.
subcategory
azTribal
Affiliations
An unordered collection of studentEducationOrganization
AssociationAZTribalAffiliations.
An American Indian tribe with
which an individual is affiliated.
Report if no value is reported for tribalAffiliations.CCensus > People >
Tribal Name
Identity.
tribalName
_etagA unique system-generated
value that identifies the version of the resource.

O

Array Data Elements

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

stateAbbreviation
Descriptor
The abbreviation for the state (within the United States) or outlying area in which an address is located.
  1. 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.
  2. Else, report NULL.
MHouseholds> Address Info> Stateaddress.state
apartmentRoom
SuiteNumber
The 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

doNotPublish
Indicator

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

Box

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

Student Language

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.

  1. 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.
  2. Otherwise, report NULL.

M

Census > People> Identities > Home Primary Language


Census > People> Identities > Most Spoken Language


Census > People> Identities > First Acquired Language

identity.homePrimaryLanguage

Identity.languageAlt2

Identity.languageAlt

languageUseDescriptorA description of how the language is used (e.g. Home Language, Native Language, Spoken Language).
  1. For a reportable language value saved in "Home Primary Language", report 'Home Language'.
  2. For a reportable language value saved in "Most Spoken Language", report ‘Spoken language’.
  3. For a reportable language value saved in "First Acquired Language", report 'First Acquired Language'.
O

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.

  1. Determine the Race/Ethnicity(s) that are checked on the student's current identity record.
    • Use the Identity Race Ethnicity table to determine all of the check boxes checked for the students current identity id.
  2. Report the Ed-Fi Code mapped to the corresponding Race Ethnicity
    • Report all races if the student has more than 1 selected
  3. Do not report if the person does not have a Race/Ethnicity checked or there is not a corresponding mapping
MCensus> People> Identities> Race/Ethnicity

IdentityRaceEthnicity

and

racethnicity.raceid

Student Characteristics

Data Element LabelBusiness RequirementBusiness RulesM, 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
  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


US Entry Type
  1. Does not report.

N/AN/A
Career Tech Special Populations
  1. Does not report.

N/AN/A
Parent in Military
  1. 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
  2. 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
  1. Does not report.

N/AN/A
Foster Care
  1.  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
  1. Does not report.

N/AN/A
1/4 or more degree Indian bloodReport if "1/4 more degree Indian blood" is checked.
Census > People > Identities > Protected Identity Information > 1/4 more degree Indian Blood
Flags
  1. 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:

  1. Parent in Military: report the Military Connection Start Date
  2. Foster Care: report the Foster Care Start Date



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
M

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

Student Identification Codes

Data Element LabelBusiness RequirementBusiness RulesM, C or O

Data Source GUI Path

Database Field
StudentCharacteristicDescriptor
Report 'District'.MN/AN/A
AssigningOrganizationIdentificationCode The organization code or name assigning the assessment identification code.
  1. Reports the District Number where the student is enrolled.
 OStudent Information > General> Resource > District Information> Entity IDdistrict.entityID
IdentificationCode A unique number or alphanumeric code assigned to a student by a school, school system, a state, or other agency or entity.
  1. Report the Local Student Number.
 MCensus>People>Demographics> Local Student Number person.studentNumber

Type/Descriptor

Address Type Descriptor

Code ValueDescriptionNamespaceShort Description
BillingBillinguri://ed-fi.org/AddressTypeDescriptorBilling
Doubled - up (i.e., living with another family)Doubled - up (i.e., living with another family)uri://ed-fi.org/AddressTypeDescriptorDoubled - up (i.e., living with another family)
Father AddressFather Addressuri://ed-fi.org/AddressTypeDescriptorFather Address
Guardian AddressGuardian Addressuri://ed-fi.org/AddressTypeDescriptorGuardian Address
HomeHomeuri://ed-fi.org/AddressTypeDescriptorHome
Hotels/MotelsHotels/Motelsuri://ed-fi.org/AddressTypeDescriptorHotels/Motels
MailingMailinguri://ed-fi.org/AddressTypeDescriptorMailing
Mother AddressMother Addressuri://ed-fi.org/AddressTypeDescriptorMother Address
OtherOtheruri://ed-fi.org/AddressTypeDescriptorOther
PhysicalPhysicaluri://ed-fi.org/AddressTypeDescriptorPhysical
Shelter, Transitional housing, Awaiting FosterShelters, Transitional housing, Awaiting Foster Careuri://ed-fi.org/AddressTypeDescriptorShelters, Transitional housing, Awaiting Foster Care
ShippingShippinguri://ed-fi.org/AddressTypeDescriptorShipping
TemporaryTemporaryuri://ed-fi.org/AddressTypeDescriptorTemporary
UnshelteredUnsheltered (e.g. cars, parks, campgrounds, temporary trailers including FEMA trailers, or abandoned buildings)uri://ed-fi.org/AddressTypeDescriptorUnsheltered (cars, parks, temporary trailers, or abandoned buildings)
WorkWorkuri://ed-fi.org/AddressTypeDescriptorWork

Race Descriptors

Code ValueDescriptionNamespaceShort Description
American Indian - Alaska NativeAmerican Indian - Alaska Nativeuri://ed-fi.org/RaceDescriptorAmerican Indian - Alaska Native
AsianAsianuri://ed-fi.org/RaceDescriptorAsian
Black - African AmericanBlack - African Americanuri://ed-fi.org/RaceDescriptorBlack - African American
Native Hawaiian - Pacific IslanderNative Hawaiian - Pacific Islanderuri://ed-fi.org/RaceDescriptorNative Hawaiian - Pacific Islander
WhiteWhiteuri://ed-fi.org/RaceDescriptorWhite

Student Characteristic Descriptors

Code ValueDescriptionNamespaceShort Description
AsyleeAsyleeuri://ed-fi.org/StudentCharacteristicDescriptorAsylee
DisplacedDisplaceduri://ed-fi.org/StudentCharacteristicDescriptorDisplaced
Displaced HomemakerDisplaced Homemakeruri://ed-fi.org/StudentCharacteristicDescriptorDisplaced Homemaker
Economic DisadvantagedEconomic Disadvantageduri://ed-fi.org/StudentCharacteristicDescriptorEconomic Disadvantaged
Foster CareFoster Careuri://ed-fi.org/StudentCharacteristicDescriptorFoster Care
HomelessHomelessuri://ed-fi.org/StudentCharacteristicDescriptorHomeless
ImmigrantImmigranturi://ed-fi.org/StudentCharacteristicDescriptorImmigrant
OtherOtheruri://ed-fi.org/StudentCharacteristicDescriptorOther
Parent in MilitaryParent in Militaryuri://ed-fi.org/StudentCharacteristicDescriptorParent in Military
PregnantPregnanturi://ed-fi.org/StudentCharacteristicDescriptorPregnant
RefugeeRefugeeuri://ed-fi.org/StudentCharacteristicDescriptorRefugee
RunawayRunawayuri://ed-fi.org/StudentCharacteristicDescriptorRunaway
Single ParentSingle Parenturi://ed-fi.org/StudentCharacteristicDescriptorSingle Parent
Unaccompanied YouthUnaccompanied Youthuri://ed-fi.org/StudentCharacteristicDescriptorUnaccompanied Youth

Student Identification System Descriptors

Code ValueDescriptionNamespaceShort Description
Canadian SINCanadian SINuri://ed-fi.org/StudentIdentificationSystemDescriptorCanadian SIN
DistrictDistricturi://ed-fi.org/StudentIdentificationSystemDescriptorDistrict
FamilyFamilyuri://ed-fi.org/StudentIdentificationSystemDescriptorFamily
FederalFederaluri://ed-fi.org/StudentIdentificationSystemDescriptorFederal
LocalLocaluri://ed-fi.org/StudentIdentificationSystemDescriptorLocal
National MigrantNational Migranturi://ed-fi.org/StudentIdentificationSystemDescriptorNational Migrant
OtherOtheruri://ed-fi.org/StudentIdentificationSystemDescriptorOther
SchoolSchooluri://ed-fi.org/StudentIdentificationSystemDescriptorSchool
SSNSSNuri://ed-fi.org/StudentIdentificationSystemDescriptorSSN
StateStateuri://ed-fi.org/StudentIdentificationSystemDescriptorState
State MigrantState Migranturi://ed-fi.org/StudentIdentificationSystemDescriptorState Migrant