Student Education Organization Associations (Arizona 7.1)

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.

  • Does not send a record when enrollment is in a calendar marked as State Exclude.
  • Does not send a record when enrollment is in a School marked as State Exclude.
  • Does not send a record when the No Show checkbox is checked on the enrollment.
  • Reports one Student Education Organization Association record for every unique school enrollment; when there are multiple enrollment records tied to the same school in a configured year, reports 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 tool.
  • When any of the Student Characteristics change:
    • Single Parent: when 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.
DeleteThis record deletes when the student no longer has an eligible enrollment in the District.
DeleteWhen 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

NoneWhen a resource is toggled to 'OFF' after data has sent, all sent data remains in the ODS but no new data is sent.
ResyncWhen a record is in the Ed-Fi Identity Mapping table and not in the ODS, it is deleted from the Ed-Fi Identity Mapping table
ResyncWhen a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it is deleted from the ODS.
ResyncWhen a mapping is changed in Resource Preferences, a resync needs 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: When the LEA number changes, all data remains under the old number and a resync needs 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. When an Ed-Fi ID changes, this happens with the cascading deletes from the Ed-Fi ID Change trigger.
DeleteCascading Deletes: The logic for an Ed-FI ID change updates all resources impacted by this change.

Scope Year Logic

This table describes scope year logic of this object.

Logic

The record sends to the scope year for the school year the enrollment is associated with.

  • The enrollment must overlap with the scope year to report.
  • Data only sends for the years that have valid configuration.

When using data in Campus that has a single date, the following logic applies to determine the scope year(s) to report the data to.

  • Current Year: Records are compared to today's date to determine when 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. When 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. When blank, the default date of 7/01/xxxx is used.

When using data in Campus that have start and end dates, the following logic is 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. When 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. When 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 - FlagsFlag
Student Characteristic Descriptors - Foster CareFoster Care
Student Characteristic Descriptors - Military StatusMilitary Status
Race DescriptorRace/Ethnicity
Student Language OverrideHome Primary Language
State Abbreviation OverrideDefinition US state list
Tribal Affiliation DescriptorsIdentity 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 whether 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 Requirements and Rules
Mandatory, Conditiona or OptionsLocation
idThe unique identifier of the resource.M
education
OrganizationId

The identifier assigned to an education organization.


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

MSchool Information > 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.


  1. Reports the most current Primary address that is marked as "Mailing".
    • When more than 1 Primary Address marked as Mailing, report address with most recent Household Membership Start Date.
      1. Otherwise, report the address with most recent Address Start Date.
      2. Else, report the address with the highest address.
  2. See Scope Year logic to determine the eligibility of records.
  3. See Array section below for data logic for each field.
  4. 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
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.

ON/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.

ON/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:
    • When Yes, reports True.
    • When No, report False.
OIdentities > Is the Individual Hispanic or 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 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/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.

ON/A
profileThumbnail

File name for the Profile Thumbnail photograph.


This is optional, does not report.

ON/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.

M

Identities > Race/Ethnicity


Identity.raceEthnicity


Racethnicity.raceid

sexDescriptor

A 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'
    • When blank or Non-binary, report 'Not Selected'.
MIdentities > 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.


Reports the EdFi code(s) mapped in the configuration mapping tool when it exists, for any and all values saved in the multi-select tool. Otherwise, do not report.


The person MUST have the"American Indian or Alaska Native race checkbox checked to be able to populate the Tribal Affiliation field.

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


When the Tribal Enrollment field is populated, reports based on array details below.

The person MUST have the "American Indian or Alaska Native" race checkbox checked to be able to populate the Tribal Enrollment field.

CIdentities > Tribal Name

Identity.tribalName
_etagA 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 Requirements and Rules

Mandatory, Conditional or Optional

Location

addressTypeDescriptor

Key for Addresses.


All addresses are sent twice. One reports as 'Home' and the second reports as 'Mailing'.

M
stateAbbreviation
Descriptor

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


Reports 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. When there is a mapped value, report that mapping.
  • When an override is not there, look to see when the Code matches an Ed-Fi code. When Yes, that value reports.
  • Reports default value when saved on the Attribute and the code matches an Ed-Fi code.

Else, reports NULL.

MHouseholds > Address Info > State

address.state
apartmentRoom
SuiteNumber

The apartment, room, or suite number of an address.


Reports the value entered in Apt field when populated.

OHouseholds > Address Info > Apt

address.apt
buildingSiteNumber

The number of the building on the site, when 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.

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

MHouseholds > 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

MHouseholds > Address Info

address.postOfficeBox

address.number

address.street

address.tag

address.prefix

address.dir

periods

 This is optional, does not report.

O
beginDate

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.

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 Requirements and Rules

M, C or O

Location

languageDescriptor

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


Reports 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. When there is a mapped value, report that mapping.
  • When an override is not there, look to see whether the language standard code matches an Ed-Fi code. When yes, that value reports.
  • Reports the default value when saved on the Attribute and the standard code matches an Ed-Fi code.

Otherwise, report NULL.

M

Identities > Home Primary Language


Identities > Most Spoken Language


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

O

Races

Data Element Label

Business Requirements and  Rules

Mandatory, Conditional or Optional

Location

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 when the student has more than 1 selected.
  3. Does not report when the person does not have a Race/Ethnicity checked or there is not a corresponding mapping.
MIdentities > Race/Ethnicity

identityRaceEthnicity


racethnicity.raceid


Student Characteristics

Data Element LabelBusiness Requirements and  RulesMandatory, Conditional or Optional

Location

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.


Reports 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

Career Tech Special Populations


Does not report.


N/A

Parent in Military

  1. Reports when 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 tool must be checked in the Military Connections Resource Preferences to report.
  2. Removes characteristic when the Guardian checkbox is removed from the student/guardian relationship.

Military Connections > Status, Start Date, End Date

ImpactAidEmployment.militaryStatus

ImpactAidEmployment.startDate

ImpactAidEmployment.endDate

RelatedPair.guardian


Homeless


Does not report.


N/A

Foster Care


Reports when the student has a Foster Care record that overlaps the configured year and is mapped in the Foster Care Resource Preferences.


Foster Care > Start Date, End Date

fostercare.startdate

fostercare.enddate


Economic Disadvantaged


Does not report.


N/A
1/4 or more degree Indian blood

Reports when "1/4 more degree Indian blood" is checked.

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.


Flags > Name

programparticipation. name

Periods Array -  Begin Date


Report a beginDate value:

  1. Parent in Military: report the Military Connection Start Date:
    • When 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 when both parents are in the military.
  2. 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 LabelBusiness Requirements and RulesMandatory, Conditional or Optional

Location

StudentCharacteristicDescriptorReport 'District'.MN/A
AssigningOrganization
IdentificationCode 

The organization code or name assigning the assessment identification code.


Reports the District Number where the student is enrolled.

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

 MDemographics > Local Student Number

person.studentNumber

AZ Tribal Affiliations

Data Element LabelBusiness Requirements and RulesMandatory, Conditional or Optional

Location

tribalAffiliationDescriptorAn American Indian tribe with which an individual is affiliated.

Reports the EdFi code mapped in the config mapping tool when it exists.
M

Tribal Enrollment



isEnrolled

Flag indicting for which tribal affiliation the student is an enrolled member. A student may have multiple tribal affiliations, but only one tribe may be flagged as IsEnrolled.


Reports True.


 O

Type/Descriptor

Click here to expand...

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