Skip to main content
Skip table of contents

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

localEducationAgencyIDThe identifier assigned to a local education agency by the State Education Agency (SEA).Integer

Derived from:

Prefs.Name=DistrictNumber
Prefs.Value

If subdistricts are configured (Prefs.Value = '1' where name = 'PSSR_SubDistrict'), then: CST_SubDistricts.Subdistrict_Number

R
stateOrganizationIDThe identifier assigned to an education agency by the State Education Agency (SEA).String

Derived from:

Prefs.Name=DistrictNumber
Prefs.Value

If subdistricts are configured (Prefs.Value = '1' where name = 'PSSR_SubDistrict'), then: CST_SubDistricts.Subdistrict_Number

 R
nameOfInstitutionThe full, legally accepted name of the institution.String

Prefs.Name=DistrictName
Prefs.Value

If subdistricts are configured (Prefs.Value = '1' where name = 'PSSR_SubDistrict'), then: CST_SubDistricts.SubDistrict_Name

R
operationalStatusTypeThe current operational status of the education organization, for example, active, inactive.String

Published Value = 'Active'

O
categoryTypeThe 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
Prefs.Value

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
Prefs.Value

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
Prefs.Value

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
Prefs.Value

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
IdentificationSystemDescriptor

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
Prefs.Value

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
Prefs.Value

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

educationOrganizationCategoriesThe 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.StringPublished 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
IdentificationSystemDescriptor

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
Schools.School_Number

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
Period.Period_Number

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:
Prefs.Name=DistrictNumber 
Prefs.Value

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
SystemDescriptor

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:
Prefs.Name=DistrictNumber
Prefs.Value

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.StringGen.IdO

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 =

  • 0: Published Value = 'Standard'
  • 1: Published Value = 'Career and Technical Education'
R
individualPlanAn indicator of whether the graduation plan is tailored for an individual.BooleanFalseO
totalRequiredCreditsThe total number of credits required for graduation under this planNumber

Calculated from GPNode.CreditCapacity where GPNode.GPVersionId = GPVersion.ID, excluding redundant credits from parent node records

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.