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.

ActionTrigger
PostPost 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.
PutWhen 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.

ActionBusiness Rule
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS and no new data will send..
ResyncIf 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.

ActionBusiness Rule
Delete/PostNatural Key change:
DeleteIf 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.
DeleteStudent 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 RequirementBusiness RulesM, C or O

Data Source GUI Path

Database Field

id  

The unique identifier of the resource


M


addressesAn unordered collection of educationOrganizationAddresses. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups
  1. Reports the Physical Address.
    • If blank, do not report.
  2. See Array information below for field logic.
O

CategoriesAn 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 ColumnReport the District Number entered on the Connection Credentials screen.
  1. If NULL, Report the Ed-Fi District Number.
    • If NULL, report the State District Number.
MSystem 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

accountabilitiesAn 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

federalFundsAn 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

identificationCodesAn 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


institutionTelephonesAn unordered collection of educationOrganizationInstitutionTelephones. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups
  1. Reports the Phone Number for the District.
    • If blank, do not report.
  2. See Array information below for field logic.
O

internationalAddressesAn 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

nameOfInstitutionThe full, legally accepted name of the institution. 

Report the Name.

MSystem 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

shortNameOfInstitutionA short name for the institution

 This is optional, does not report.

O

webSiteThe 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, 

or 

O

Data Source 

GUI Path

Database 

Field

addressTypeDescriptor

Key for Address

All addresses will report as 'Physical'.

M



localeDescriptorA 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

buildingSiteNumberThe number of the building on the site, if more than one building shares the same address

This is optional, do not report.

O

cityThe 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

countyFIPSCode5 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

latitudeThe geographic latitude of the physical address

This is optional, do not report.

O

longitudeThe geographic longitude of the physical address

This is optional, do not report.

O

nameOfCountyThe 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

postalCodeThe five or nine digit zip code portion of an address

Reports the Zip Code for the address being reported.

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

MSystem Administration> Resources> District Informationdistrict.physicaladdress
PeriodsThe 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

beginDateThe first date the address is valid. For physical addresses, the date the person moved to that address

This is optional, do not report.

O

endDateThe 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 LabelBusiness RequirementBusiness RulesM,
C,
O
Data Source GUI PathDatabase Field
institutionTelephone
NumberTypeDescriptor
Type of Phone Number.

Always report 'Main'.




telephoneNumberThe telephone number including the area code, and extension, if applicable.Report the Phone Number entered.
  1. If blank, do not report.

System Administration> Resources> District Informationdistrict.phone


Identification Codes

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



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.M
District.number