Organization Setup
This category captures organization demographics, course catalog, programs, class periods, locations, and graduation plans. The Organization Setup category includes the following data views and resources:
Local Education Agencies
This view captures a list of 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 | Published Value = 'Active' | O |
| categoryType | The category of local education agency/district. | String | Published Value = 'Independent' If subdistricts are configured (Prefs.Value = '1' where name = 'PSSR_SubDistrict'), then: Published Value = '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 | Published Value = '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 | Published Value = '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 | Published Value = '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, School ID, 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
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 | 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. Published Value = 'Active' Otherwise: Published Value = 'Inactive' | O |
type | The type of education institution as classified by primary focus, for example, Regular, Alternative, Special Ed, CTE. | String | Published Value = '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 | Published Value = '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 | Published Value = '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
| Published Value = 'LEA' Published Value = '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 | Schools.School_Number Schools.Alternate_School_Number or | 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 | Published Value = 'Main' Published Value = '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, Subject Area, 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: CST_SubDistricts.Subdistrict_Number | 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 |
academicSubjectDescriptor | The intended major subject area of the course. | String | Derived from: Courses.Course_Number | O |
numberOfParts | The number of parts identified for a course. | Integer | Published Value = '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 | Published Value = 'LEA course code' Published Value = '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 |
courseLevelCharacteristics An unordered collection of courseLevelCharacteristics. | O | |||
/type | The type of specific program or designation with which the course is associated (e.g., AP, IB, Dual Credit, CTE). | String | Derived from Courses.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: CST_SubDistricts.Subdistrict_Number | R |
type | The type of program, for example, Adult Ed, CTE, Bilingual. | String | Gen.Type | R |
name | The formal name of the program of instruction, training, services, or benefits available. | String | Gen.Name | R |
| programId | A unique number or alphanumeric code assigned to a program by a school, school system, a state, or other agency or entity. | String | Gen.Id | O |
Graduation Plans
This data view represents a detailed list of graduationPlans successfully published to the ODS. This represents a plan outlining the required credits, credits by subject, credits by course, and other criteria required for graduation. A graduation plan may be one or more standard plans defined by an education organization and/or individual plans for some or all students. The published view layout provides the School Name, Graduation School Year, Graduation Plan Type, Last Publish Date, Publishing ID, and Resource ID.
graduationPlans
This entity is a plan outlining the required credits, credits by subject, credits by course, and other criteria required for graduation. A graduation plan may be one or more standard plans defined by an education organization and/or individual plans for some or all students.
Primary PowerSchool Source Data
- GradPlan
- GPVersion
- GPNode
- GPStudentPlan
- Students
Selection Criteria
Records are published if the following criteria are met:
- The school must not be excluded from state reporting.
- The school must have at least one student in grades 9 - 13 who is linked to the graduation plan.
- The graduation year must be between the graduation plan's start and end years. (GPVersion.StartYear and GPVersion.EndYear)
Resource Output
- A graduationPlans record is published for each school and school year where at least one student is linked to the plan via GPStudentPlan table for that graduation year.
- The graduationPlans 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 |
|---|---|---|---|---|
educationOrganizationReference A reference to the related educationOrganization resource. | R | |||
/educationOrganizationID | The school associated with the graduation plan. | Integer | Derived from: Schools.School_Number | R |
graduationSchoolYearTypeReference A reference to the related schoolYearType resource. | R | |||
/schoolYear | The school year for the graduation plan. | Integer | Students.Graduation_Year, if populated Otherwise: Students.ClassOf | R |
| typeDescriptor | The type of academic plan the student is following for graduation, for example, Minimum, Recommended, Distinguished, or Standard. | String | if GradPlan.PlanType =
| R |
| individualPlan | An indicator of whether the graduation plan is tailored for an individual. | Boolean | False | O |
| totalRequiredCredits | The total number of credits required for graduation under this plan | Number | Calculated from GPNode.CreditCapacity where GPNode.GPVersionId = GPVersion.ID, excluding redundant credits from parent node records | R |