Location | PowerSchool SIS Tennessee | PowerSchool SIS Compliance

Resource Overview

Ed-Fi endpoint: /data/v3/locations
Published view/entity: Location
Purpose: Information related to classrooms within schools
Source query: Location
Dependencies: No resource dependency is declared.

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

[CST_PUBPUBLISHED_TMP]

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.
The room is scheduled for at least one section that is not excluded from state reporting.

Resource Output

Data Element (Ed-Fi target)	Data View Column Name	Submission	[Table]Field (PowerSchool Source)	Business Rules	Comments
schoolReference.schoolId	SchoolOrgID	Y	Publishing framework or supporting query Query alias: SchoolOrgID	Required by the production resource definition when the resource is published.	JSON type: `string`. Query alias: `SchoolOrgID`.
classroomIdentificationCode	ClassroomIdentificationCode	Y	[CST_PUBPUBLISHED_TMP]CompositeKeys	Required by the production resource definition when the resource is published.	JSON type: `string`. Query alias: `ClassroomIdentificationCode`.
maximumNumberOfSeats	MaximumNumberOfSeats	Conditional	[CST_PUBPUBLISHED_TMP]Supportingkeys; Transformation: case when to_number(pt.supportingkeys) between 4 and 6 then '30' when to_number(pt.supportingkeys) between 7 and 13 then '35' else '25' end	Submit when the source alias is populated and the parent structure is applicable.	JSON type: `number`. Query alias: `MaximumNumberOfSeats`.
optimalNumberOfSeats	OptimalNumberOfSeats	Conditional	[CST_PUBPUBLISHED_TMP]Supportingkeys; Transformation: case when to_number(pt.supportingkeys) between 4 and 6 then '25' when to_number(pt.supportingkeys) between 7 and 13 then '30' else '20' end	Submit when the source alias is populated and the parent structure is applicable.	JSON type: `number`. Query alias: `OptimalNumberOfSeats`.