Organization Setup
This category provides information about Michigan districts and schools as published within the Education Organization category. The Education Organization category includes the following data views and resources:
Local Education Agencies
This view captures a list of all Michigan districts defined on the PowerSchool server. The layout includes the School Name, State LEA Number, LEA Name, Last Publish Date, and Publishing ID.
localEducationAgencies
This resource 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.
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req’d |
localEducationAgencyId | Identifier assigned to the LEA by the State Education Agency. | Integer | [Prefs]Name=districtnumber [Prefs]Value [Gen]Value where cat=’districts’ | R |
stateOrganizationId | The identifier assigned to an education agency by the SEA. | String | [Prefs]Name=districtnumber [Prefs]Value [Gen]Value where cat=’districts’ | R |
nameOfInstitution | The full, legally accepted name of the institution. | String | [Prefs]Name=districtname [Prefs]Value [Gen]Name where cat=’districts’ | R |
operationalStatusType | The current operational status of the education organization, for example, active, inactive. | Type | ‘Active’ | O |
categoryType | The category of local education agency/district.
| Type | ‘Independent’ | R |
Address Note: The district address is not published for districts that are only identified as District of Residence. | O | |||
/addressType | The type of address listed for an individual or organization, for example, Physical Address, Mailing Address, Home Address, etc. | Type | ‘Physical’ |
|
/streetNumberName | The street number and street name or post office box number of an address. | String | Stored in PowerSchool in: [Prefs]Name=DistrictAddress [Prefs]Value |
|
/city | The name of the city in which an address is located. | String | Also stored in PowerSchool in: [Prefs]Name=DistrictCity [Prefs]Value |
|
/stateAbbreviationType | The abbreviation for the state (within the United States) or outlying area in which an address is located. | Type | Also stored in PowerSchool in: [Prefs]Name=districtstate [Prefs]Value |
|
/postalCode | The five- or nine-digit zip code portion of an address. | String | Also stored in PowerSchool in: [Prefs]Name=DistrictZip [Prefs]Value |
|
educationOrganizationCategory | The classification of the education agency within the geographic boundaries of a state according to the level of administrative and operational control granted by the state, for example, State Education Agency, Local Education Agency, or School. | String | ‘Local Education Agency’
| O |
educationOrganizationIdentificationSystemDescriptor | The school system, state, or agency assigning the identification code, for example, SEA, NCES. | Descriptor | ‘SEA’ | O |
identificationCode | A unique number or alphanumeric code that is assigned to an education organization by a school, school system, a state, or other agency or entity. | String | LEAId Stored in PowerSchool in: [Prefs]Name=districtnumber [Prefs]Value [Gen] cat=districts, Value | O |
Schools
This view captures a list of schools defined in PowerSchool. The layout includes the School Name and the State School Number.
schools
This resource represents an educational organization that includes staff and students who participate in classes and educational activity groups.
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req’d |
localEducationAgencyId | The LEA of which the school is an organizational component. | Integer | [Prefs]Name=districtnumber [Prefs]Value | O |
schoolId | The identifier assigned to a school by the State Education Agency.
| Integer | [Schools]School_Number Note: [Schools]School_Number is automatically converted to the state SchoolId during Ed-Fi publishing. | R |
stateOrganizationId | The identifier assigned to the school by the State Education Agency. | String | [S_MI_SCH_TSDL_X]adminunit [Schools]Alternate_School_Number (if set); else, [Schools]School_Number | R |
nameOfInstitution | The full, legally accepted name of the institution.
| String | [Schools]Name | R |
shortNameOfInstitution | A short name for the institution. | String | [Schools]Abbreviation | O |
operationalStatusType | The current operational status of the education organization, for example, active, inactive. | Type | ‘Active’ | O |
type | Type of education institution as classified by primary focus, for example, Regular, Alternative, Special Ed, CTE. | String | ‘Regular’ | O |
Address | O | |||
/addressType | The type of address listed for an individual or organization. | Type | ‘Physical’ |
|
/streetNumberName | The street number and street name or post office box number of an address. | String | [Schools]SchoolAddress |
|
/city | The name of the city in which an address is located. | String | [Schools]SchoolCity |
|
/stateAbbreviationType | The abbreviation for the state (within the United States) or outlying area in which an address is located. | String | [Schools]SchoolState |
|
/postalCode | The five- or nine-digit zip code portion of an address. | String | [Schools]SchoolZip |
|
educationOrganizationCategories | The classification of the education agency within the geographic boundaries of a state according to the level of administrative and operational control granted by the state, for example, State Education Agency, Local Education Agency, or School. | String | ‘School’ | O |
IdentificationCodes | O | |||
/identificationCode | A unique number or alphanumeric code that is assigned to an education organization by a school, school system, a state, or other agency or entity. | String | LEA: [S_MI_SCH_TSDL_X]adminunit SEA: [Schools]School_Number |
|
/educationOrganizationIdentificationSystemDescriptor | The school system, state, or agency assigning the identification code, for example, SEA, NCES.
| Descriptor | ‘LEA’ ‘SEA’ |
|
InstitutionTelephone | O | |||
/institutionTeleponeNumberType | The type of communication number listed for an individual or organization. | Type | ‘Main’ or ‘Fax’ |
|
/telephoneNumber | The 10-digit telephone number, including the area code, for the education entity. | String | Main: [Schools]SchoolPhone Fax: [Schools]SchoolFax |
|
schoolCategoryType | One or more categories of school, for example, High School, Middle School, Elementary School. | Type | [S_MI_SCH_TSDL_X]schoolType If blank, then derived from: [Schools]Low_Grade and [Schools]High_Grade | O |
gradeLevelDescriptor | Grade levels served at the school. | Descriptor | List of all grade levels between [Schools]Low_Grade and [Schools]High_Grade, inclusive | O |
Location (Rooms)
This view captures the physical space where students gather for a particular class/section. The layout includes the School Name, and Room Number.
locations
This resource represents the physical space where students gather for a particular class/section. The location may be an indoor or outdoor area designated for the purpose of meeting the educational needs of students.
Primary PowerSchool Source Data
- [Sections]Room
- [Room]
Selection Criteria
Records are published if the following criteria are met:
- The school must not be excluded from state reporting.
- The room is assigned to at least one course section based on [Sections]Room.
Resource Output
- A single record is published for each room or classroom at each school if the room has been assigned to at least one course section.
- A default value of “OPEN” will be published as the ClassroomIdentificationCode for any course sections where [Sections]Room is blank.
- The Location resource is not dependent on the prior publishing of other Ed-Fi resources.
- LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real-time or on-demand (“Run Now” button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req’d |
schoolID | The school associated with this location. | Integer | Derived from: [Sections]SchoolID Note: [Sections]WhereTaught is not currently implemented in Ed-Fi; [Sections]SchoolID is currently used in all cases. | R |
classroomIdentificationCode | A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or entity. | String | [Sections]Room If null: ‘Open’ | R |
maximumNumberOfSeats | The maximum number of seats the class can maintain. | Integer | [Room]Occupancy_Maximum If less than 0, then [Sections]MaxEnrollment | O |
Class Periods
This view captures the available class period meeting times reflected in the scheduling configurations for each school as published in the ClassPeriod resource within the Education Organization category. The layout provides the School Name, Period Name, and Period Number.
classPeriods
This resource represents the designation of a regularly scheduled series of class meetings at designated times and days of the week.
Primary PowerSchool Source Data
- [Period]
Selection Criteria
Records are published if the following criteria are met:
- The school must not be excluded from state reporting.
Resource Output
- A single record is published for each unique class period at each school based on the year for the Term selected in the PowerSchool UI.
- The courses resource is not dependent on the prior publishing of other Ed-Fi resources.
- LEAs and Schools may upload (publish) data to the Ed- Fi ODS in real-time or on-demand (“Run Now” button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req’d |
schoolId | The school associated with this period. | Integer | Derived from: [Period]SchoolID | R |
name | A unique number or alphanumeric code assigned to a classroom period. | String | [Period]Name [Section_Meeting]Period_Number or [Sections]Expression are used for linking a section to a period. | R |
Courses
This view captures the entries into the course catalog for the courses offered by the LEA/District during a session. The layout provides the School Name, Course Number, Course Name, Subject Area, Course Identifier, and Course Type.
courses
This educational resource represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.
Primary PowerSchool Source Data
- [Courses]
Selection Criteria
Records are published if the following criteria are met:
- The school must not be excluded from state reporting.
Resource Output
- A single record is published for each course defined in the school course catalog for the selected school year.
- The ClassPeriod resource is not dependent on the prior publishing of other Ed-Fi resources.
- LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real-time or on-demand (“Run Now” button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req’d |
educationOrganizationID | The Education Organization that defines the curriculum and courses offered; the SEA ID for Michigan in which the courses are offered. | Integer | [Prefs]Name=districtnumber [Prefs]Value [Gen]Value where cat=’districts’ | R |
code | The code that identifies the organization of subject matter and related learning experiences provided for the instruction of students. | String | [Courses]Course_Number | R |
title | The descriptive name given to a course of study offered in a school or other institution or organization. | String | [Courses]Course_Name | R |
numberOfParts | The number of parts identified for a course. | Integer | Default = ‘1’ | R |
academicSubjectDescriptor | The intended major subject area of the course. | Descriptor | [S_MI_CRS_TSDL_X]NCESsubjectArea | O |
minimumAvailableCredits | The minimum amount of credit available to a student who successfully completes the course. | Number | [Courses]Credit_Hours | O |
maximumAvailableCredits | The maximum amount of credit available to a student who successfully completes the course. | Number | [Courses]Maxcredit | O |
IdentificationCodes | O | |||
/courseIdentificationSystemDescriptor | A unique number or alphanumeric code that is reflects the entity authorizing the course. | Descriptor | ‘LEA course code’ ‘State course code’ |
|
/assigningOrganizationIdentificationCode | The organization code or name assigning the Identification code. | String | [Prefs]Name=districtnumber [Prefs]Value [Gen]Value where cat=’districts’ ‘84000’ |
|
/identificationCode | A unique alphanumeric code assigned to the course by the State | String | Derived from: [Course]Course_Number [S_MI_CRS_TSDL_X]NCEScourseID |
|
| courseTypeLevelRigor | courseTypeLevelAndRigorDescriptors - The level and rigor of the instruction provided throughout the reported course. Code 07 is to be used for college instructed courses for which the student will receive high school credit. The student may be participating in an Early/Middle College program or a dual enrollment program. | Descriptor | [S_MI_CRS_TSDL_X]CourseType
| |
Programs
This view captures the program(s) that the students participate in or are served by. The layout provides the School Name, Program Type, and Program Name.
programs
This resource represents any program designed to work in conjunction with, or as a supplement to, the main academic program. Programs may provide instruction, training, services, or benefits through federal, state, or local agencies. Programs may also include organized extracurricular activities for students.
Primary PowerSchool Source Data
- [Prefs]
Selection Criteria
Records are published if the following criteria are met:
- The school must not be excluded from state reporting.
Resource Output
- LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real-time or on-demand (“Run Now” button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req’d |
educationOrganizationId | Relates the program to an Education Organization, typically the LEA. | Integer | [Prefs]Name=districtnumber [Prefs]Value [Gen]Value where cat=’districts’ | R |
type | The type of program, for example, Adult Ed, CTE, Bilingual. | String | See the appendix for values. | R |
name | The formal name of the program of instruction, training, services, or benefits available. | String | See the appendix for values. | R |