Michigan Ed-Fi Data v3.1 - Local Education Agencies

Tool Search: Ed-Fi

This entity represents an administrative unit at the local level, which exists primarily to operate schools or to contract for educational services. It includes school districts, charter schools, charter management organizations or other local administrative organizations.

Reports the District Information for a school.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	Post all Districts populated in the District table. A resync must be completed for all Districts to post but a UI change will trigger the reporting District to post.
Put	When fields not part of the natural key are changed: District Name, Phone or Physical Address is changed.
Delete	Records are never deleted once they are sent.

Resource Preferences & Toggle/Resync Logic

This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync 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 and no new data will send..
Resync	If an Ed-Fi Code mapping is changed to a new code or made NULL, a resync must be performed for the data to be updated in the ODS.

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
Delete/Post	Natural Key change:
Delete	If the LEA ID changes all dependent resources will be deleted and only reposted if the new LEA ID has claim to the district to send data.
Post
	Cascading Deletes: If the Ed-Fi District Number or State District Number changes, all dependent resources will be deleted.
Delete	Student Education Organization Associations, Graduation Plans, Programs, Student Program Associations, Student CTE Program Associations, Student Special Education Program Associations, Student Title 1 Part A Program Associations, Student Homeless Program Associations, Student Language Instruction Program Associations, Student Migrant Program Associations, Student Neglected or Delinquent Program Associations, Student School Food Service Program Associations, Cohorts, Student Cohort Associations, Staff Cohort Associations

Scope Year Logic

This table describes scope year logic of this object.

Business Rules
Districts are not aligned to a year so all Districts will send to each scoped year. Data will only send for the years that have valid configuration. A resync must be completed on the resource when a new scope year is connected in order for this data to send.

Object Data Elements

This table describes data elements sent within the Local Education Agencies 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
addresses	An unordered collection of educationOrganizationAddresses. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups	Reports the Physical Address. If blank, do not report. See Array information below for field logic.	O
Categories	An unordered collection of educationOrganizationCategories. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups.	Always report 'Local Education Agency'.	M
localEducation AgencyId	EducationOrganization Identity Column	Report the District Number entered on the Connection Credentials screen. If NULL, Report the Ed-Fi District Number. If NULL, report the State District Number.	M	System Administration> Resources> District Information	district.entityID OR district.number
educationService CenterReference	A reference to the related EducationServiceCenter resource	This is optional, does not report.	O
parentLocalEducation AgencyReference	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.,	This is optional, does not report.	O
stateEducation AgencyReference	A reference to the related StateEducationAgency resource	This is optional, does not report.	O
accountabilities	An unordered collection of localEducationAgencyAccountabilities. This entity represents an administrative unit at the local level, which exists primarily to operate schools or to contract for educational services. It includes school districts, charter schools, charter management organizations or other local administrative organizations	This is optional, does not report.	O
charterStatus Descriptor	A school or agency providing free public elementary or secondary education to eligible students under a specific charter granted by the state legislature or other appropriate authority and designated by such authority to be a charter school.	This is optional, does not report.	O
federalFunds	An unordered collection of localEducationAgencyFederalFunds. Contains the information about the reception and use of federal funds for reporting purposes.	This is optional, does not report.	O
identificationCodes	An unordered collection of educationOrganizationIdentificationCodes. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups	See array for details.	M
institutionTelephones	An unordered collection of educationOrganizationInstitutionTelephones. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups	Reports the Phone Number for the District. If blank, do not report. See Array information below for field logic.	O
internationalAddresses	An unordered collection of educationOrganizationInternationalAddresses. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups	This is optional, does not report.	O
localEducationAgency CategoryDescriptor	The category of LEA/District (e.g., Independent or Charter).	Always report 'Independent'.	M
nameOfInstitution	The full, legally accepted name of the institution.	Report the Name.	M	System Administration> Resources> District Information	district.name
operationalStatus Descriptor	The current operational status of the education organization (e.g., active, inactive)	This is optional, does not report.	O
shortNameOfInstitution	A short name for the institution	This is optional, does not report.	O
webSite	The public web site address (URL) for the educational organization	This is optional, does not report.	O
etag			O

Array Data Elements

Click here to expand...

Education Organization 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 report as 'Physical'.	M
localeDescriptor	A general geographic indicator that categorizes U.S. territory (e.g., City, Suburban).	This is optional, do not report.	O
stateAbbreviation Descriptor	The abbreviation for the state (within the United States) or outlying area in which an address is located	Reports the State for the address being reported.	M	System Administration> Resources> District Information	district.physicalstate
apartmentRoom SuiteNumber	The apartment, room, or suite number of an address	This is optional, do not report.	O
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 Physical City for the address being reported.	M	System Administration> Resources> District Information	district.physicalcity
congressional District	The congressional district in which an address is located.	This is optional, do not report.	O
countyFIPSCode	5 digit code consisting of the two digit state code followed by the three digit FIPS code for the county	This is optional, do not report.	O
doNotPublish Indicator	An indication that the address should not be published.	This is optional, do not report.	O
latitude	The geographic latitude of the physical address	This is optional, do not report.	O
longitude	The geographic longitude of the physical address	This is optional, do 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, do 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	System Administration> Resources> District Information	district.physicalzip
streetNumber Name	The street number and street name or post office box number of an address	Reports the Physical Address.	M	System Administration> Resources> District Information	district.physicaladdress
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, do 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, do not report.	O
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, do not report.	O

Education Organization Institution Telephone

Data Element Label	Business Requirement	Business Rules	M, C, O	Data Source GUI Path	Database Field
institutionTelephone NumberTypeDescriptor	Type of Phone Number.	Always report 'Main'.
telephoneNumber	The telephone number including the area code, and extension, if applicable.	Report the Phone Number entered. If blank, do not report.		System Administration> Resources> District Information	district.phone

Identification Codes

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

educationOrganization

IdentificationSystem

Descriptor

The school system, state, or agency assigning the identification code.

Always report 'SEA'.

identificationCode

A unique number or alphanumeric code that is assigned to an education organization by a school, school system, state, or other agency or entity.

Report State District Number.

District.number