Organization Setup
This category captures organization demographics, course catalog, programs, class periods, and locations. The Organization Setup category includes the following data views and resources:
Local Education Agencies
This view captures a list of Indiana districts defined on the PowerSchool server. The layout includes the School Name, District ID, District Name, Last Publish Date, Publishing ID, and Resource 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.
Primary PowerSchool Source Data
- [Prefs]
- [CST_SubDistricts]
Selection Criteria
Records are published if the following criteria are met:
- This resource has no specific selection criteria.
Resource Output
- The localEducationAgencies resource is not dependent on the prior publishing of other Ed-Fi resources.
- LEAs and Schools may upload (publish) data to the 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 |
|---|---|---|---|---|
| localEducationAgencyID | The identifier assigned to a local education agency by the State Education Agency (SEA). | Integer | Derived from: [Prefs]Name=DistrictNumber If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: [CST_SubDistricts]Subdistrict_Number | R |
| stateOrganizationID | The identifier assigned to an education agency by the State Education Agency (SEA). | String | Derived from: [Prefs]Name=DistrictNumber If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: [CST_SubDistricts]Subdistrict_Number | R |
| nameOfInstitution | The full, legally accepted name of the institution. | String | [Prefs]Name=DistrictName If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: [CST_SubDistricts]SubDistrict_Name | R |
| operationalStatusType | The current operational status of the education organization, for example, active, inactive. | String | 'Active' | O |
| categoryType | The category of local education agency/district. | String | 'Independent' If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: 'Charter' | R |
educationOrganizationAddress An unordered collection of educationOrganizationAddresses. The set of elements that describes an address, including the street address, city, state and zip code. | O | |||
/addressType | The type of address listed for an individual or organization, for example, Physical Address, Mailing Address, Home Address, etc. | String | 'Physical' | R |
/streetNumberName | The street number and street name or post office box number of an address. | String | [Prefs]Name=DistrictAddress If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: [CST_SubDistricts]SubDistrict_Address | R |
/city | The name of the city in which an address is located. | String | [Prefs]Name=DistrictCity If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: [CST_SubDistricts]SubDistrict_City | R |
/stateAbbreviationType | The abbreviation for the state (within the United States) or outlying area in which an address is located. | String | [Prefs]Name=DistrictState If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: [CST_SubDistricts]SubDistrict_State | R |
/postalCode | The five- or nine-digit zip code of an address. | String | [Prefs]Name=DistrictZip If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: [CST_SubDistricts]SubDistrict_Zip | R |
educationOrganizationCategories An unordered collection of 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. | R | |||
/type | 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. NEDM: Agency Type | String | 'Local Education Agency' | R |
educationOrganizationIdentificationCode An unordered collection of educationOrganizationIdentificationCodes. A unique number or alphanumeric code that is assigned to an education organization by a school, school system, state, or other agency or entity. | R | |||
/educationOrganization | The school system, state, or agency assigning the identification code, for example, SEA, NCES. | String | 'SEA' | R |
/identificationCode | A unique number or alphanumeric code assigned to a space, room, site, building, individual, organization, program, or institution by a school, school system, a state, or other agency or entity. | String | Derived from: [Prefs]Name=DistrictNumber If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: [CST_SubDistricts]SubDistrict_Number | R |
Schools
This view captures a detailed list of schools defined in PowerSchool. The layout includes the School Name, State Organization ID, State School Number, Last Publish Date, Publishing ID, and Resource ID.
schools
This resource represents an educational organization that includes staff and students who participate in classes and educational activity groups.
Primary PowerSchool Source Data
- [Schools]
- [S_IN_SCH_X]
Selection Criteria
Records are published if the following criteria are met:
- This resource has no specific selection criteria.
Resource Output
- The schools resource is dependent on the prior publishing of the following resources: localEducationAgencies.
- LEAs and Schools may upload (publish) data to the 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 |
|---|---|---|---|---|
localEducationAgencyReference A reference to the related localEducationAgency resource. | R | |||
/localEducationAgencyID | The LEA of which the school is an organizational component. | Integer | Derived from: [Prefs]Name=DistrictNumber If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: [CST_SubDistricts]Subdistrict_Number | R |
stateOrganizationID | The identifier assigned to an education agency by the State Education Agency. | String | Derived from:[S_IN_SCH_X]SchoolNumberPrefix if not empty Otherwise: [Schools]Alternate_School_Number or [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 | If a term exists for the school within the school year, or students are actively enrolled in the school for the school year. 'Active' Otherwise: 'Inactive' | O |
type | The type of education institution as classified by primary focus, for example, Regular, Alternative, Special Ed, CTE. | String | 'Regular' | O |
educationOrganizationAddress An unordered collection of educationOrganizationAddresses. The set of elements that describes an address, including the street address, city, state and ZIP code. | O | |||
/addressType | The type of address listed for an individual or organization. | String | 'Physical' | R |
/streetNumberName | The street number and street name or post office box number of an address. | String | [Schools]SchoolAddress | R |
/city | The name of the city in which an address is located. | String | [Schools]SchoolCity | R |
/stateAbbreviationType | The abbreviation for the state (within the United States) or outlying area in which an address is located. | String | [Schools]SchoolState | R |
/postalCode | The five- or nine-digit zip code portion of an address. | String | [Schools]SchoolZip | R |
| 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' | |
educationOrganizationIdentificationCode An unordered collection of educationOrganizationIdentificationCodes. A unique number or alphanumeric code that is assigned to an education organization by a school, school system, state, or other agency or entity., | ||||
/educationOrganization | The school system, state, or agency assigning the identification code, for example, SEA, NCES. | Descriptor | 'LEA' 'SEA' 'ACT' | 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 | [Schools]Alternate_School_Number or Derived from:[S_IN_SCH_X]SchoolNumberPrefix if not empty [S_IN_SCH_X]CEEB_ACT_Code | R |
educationOrganizationInstitutionTelephone An unordered collection of educationOrganizationInstitutionTelephones. The 10-digit telephone number, including the area code, for the person. | ||||
/institutionTelephoneNumberType | The type of telephone number listed for an individual or organization. | Type | 'Main' 'Fax' | R |
/telephoneNumber | The 10-digit telephone number, including the area code, for the education entity. | String | [Schools]Schoolphone [Schools]SchoolFax | R |
schoolCategoryType | The one or more categories of school. For example: High School, Middle School, and/or Elementary School. | Type | Derived from [Schools]Low_Grade and [Schools]High_Grade | R |
schoolGradeLevel The grade levels served at the school. | R | |||
/gradeLevelDescriptor | The grade levels served at the school. | Descriptor | List of all grade levels between [Schools]Low_Grade and [Schools]High_Grade | R |
Locations(Rooms)
This view captures the physical space where students gather for a particular class/section. The layout includes the School Name, Room Number, Last Publish Date, Publishing ID, and Resource ID.
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]
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.
- The locations resource is dependent on the prior publishing of Ed-Fi resources: schools
- 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 |
|---|---|---|---|---|
schoolReference A reference to the related schools resource. | R | |||
/schoolID | The school associated with this location. | Integer | Derived from: [Sections]SchoolID | 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 | R |
maximumNumberOfSeats | The maximum number of seats the class can maintain. | Integer | When [Room]Occupancy_Maximum is greater than 0:[Room]Occupancy_Maximum When [Sections]MaxEnrollment is greater than 0:[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, Last Publish Date, Publishing ID, and Resource ID.
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.
- The period number associated with the period name be equal or greater than 0.
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 classPeriods resource is dependent on the prior publishing of Ed-Fi resources: schools.
- 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 |
|---|---|---|---|---|
schoolReference A reference to the related schools resource. | R | |||
/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 | Derived from: [Period]Abbreviation | 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, Minimum Available Credits, Maximum Available Credits, Course Identifier, Last Publish Date, Publishing ID, and Resource ID.
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 courses resource is dependent on the prior publishing of Ed-Fi resources: localEducationAgencies.
- 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 |
|---|---|---|---|---|
educationOrganizationReference A reference to the related educationOrganization resource. | R | |||
/educationOrganizationID | The Education Organization that defines the curriculum and courses offered. | Integer | Derived from: If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: | 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 | '1' | R |
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 |
courseIdentificationCodes An unordered collection of courseIdentificationCodes. A standard code that identifies the organization of subject matter and related learning experiences provided for the instruction of students. | O | |||
/courseIdentification | A unique number or alphanumeric code that is reflects the entity authorizing the course. | Descriptor | 'LEA course code' 'State course code' | R |
/identificationCode | A unique number or alphanumeric code assigned to a space, room, site, building, individual, organization, program, or institution by a school, school system, a state, or other agency or entity. | String | [Courses]Course_Number [Courses]Alt_Course_Number | R |
Programs
This view captures the program(s) that the students participate in or are served by. The layout provides the School Name, Program Type, Program Name, Last Publish Date, Publishing ID, and Resource ID.
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.
Selection Criteria
Records are published if the following criteria are met:
- This resource has no specific selection criteria.
Resource Output
- The programs resource is dependent on the prior publishing of Ed-Fi resources: localEducationAgencies.
- The programs resource is published at the district level.
- LEAs 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 |
|---|---|---|---|---|
educationOrganizationReference A reference to the related educationOrganization resource. | R | |||
/educationOrganizationID | Relates the program to an Education Organization, typically the LEA. | Integer | Derived from: If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: | R |
type | The type of program, for example, Adult Ed, CTE, Bilingual. | String | [CST_PubProgram]Type Valid values:
| R |
name | The formal name of the program of instruction, training, services, or benefits available. | String | [CST_PubProgram]Name Valid values:
| R |