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 Vermont 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 [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 (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
nameOfInstitution	The 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
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 [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	'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	'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

Back to top

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_VT_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 [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	Derived from:[S_VT_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 IdentificationSystemDescriptor	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 [Schools]School_Number Derived from:[S_VT_SCH_X]SchoolNumberPrefix if not empty Otherwise: [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	'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

Back to top

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

Back to top

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_Name

R

Back to top

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: [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
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 SystemDescriptor	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

Back to top

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	[CST_PubProgram]Type Valid values: English as a Second Language (ESL) Gifted and Talented Special Education Title I Part A	R
name	The formal name of the program of instruction, training, services, or benefits available.	String	[CST_PubProgram]Name Valid values: Type = English as a Second Language (ESL) Content-based ESL ESL Program ESOL Heritage Language Pull-out ESL Regular education program Sheltered English Structured Immersion Transitional Bilingual Education (TBE) Type = Gifted and Talented 1 General Intellectual (G/T) 2 Math (M-HA) 3 Language Arts (L-HA) 4 Other Type = Special Education Special Education Type = Title I Part A Instruction Support	R

Back to top