Sessions (Terms) | PowerSchool SIS Tennessee

Resource Overview

Ed-Fi endpoint: /data/v3/sessions
Published view/entity: Session
Purpose: Information describing school terms
Source query: Session
Dependencies: No resource dependency is declared.

session

This resource represents the prescribed span of time when an education institution is open, instruction is provided, and students are under the direction and guidance of teachers and/or education institution administration. A session may be interrupted by one or more vacations.

Primary PowerSchool Source Data

[Terms]

Selection Criteria

Records are published if the following criteria are met:

The school must not be excluded from state reporting.
The term or term portion exists within the year for the Term selected in the PowerSchool UI.

Note: Terms (e.g., exam periods) that do not contain any in-session dates are no longer published. This prevents publishing errors that appeared on the dashboard for sessions without instructional days.

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`.
schoolYearTypeReference.schoolYear	SchoolYear	Y	Staging rule: Sessions p_yearid + 1991	Required by the production resource definition when the resource is published.	JSON type: `number`. Query alias: `SchoolYear`.
sessionName	SessionName	Y	[Terms]Name	Required by the production resource definition when the resource is published.	JSON type: `string`. Query alias: `SessionName`.
`termDescriptor`	Term_DX	Y	[Terms]Portion; [Terms]Abbreviation; Transformation: EDFI_TN_LIB.getTermType_3(p_profileid, t.portion, t.abbreviation)	Required by the production resource definition when the resource is published.	JSON type: `string`. Query alias: `Term_DX`.
beginDate	BeginDate	Y	[Terms]Firstday; Transformation: to_char(t.firstday, 'YYYY-MM-DD')	Required by the production resource definition when the resource is published.	JSON type: `datetime`. Query alias: `BeginDate`.
endDate	EndDate	Y	[Terms]Lastday; Transformation: to_char(t.lastday, 'YYYY-MM-DD')	Required by the production resource definition when the resource is published.	JSON type: `datetime`. Query alias: `EndDate`.
totalInstructionalDays	TotalInstructionalDays	Y	[Terms]Firstday; [Terms]Lastday; Transformation: (select count(distinct cd.date_value) from calendar_day cd where cd.date_value between t.firstday and t.lastday and cd.insession = 1 and EDFI_TN_LIB.formatLEASchoolID(p_profileid, cd.schoolid) = p_orgid )	Required by the production resource definition when the resource is published.	JSON type: `number`. Query alias: `TotalInstructionalDays`.
gradingPeriods[].gradingPeriodReference.gradingPeriodDescriptor	GradingPeriod_DX	Y	Publishing framework or supporting query Query alias: GradingPeriod_DX	Required by the production resource definition when the resource is published.	JSON type: `string`. Query alias: `GradingPeriod_DX`.
gradingPeriods[].gradingPeriodReference.periodSequence	PeriodSequence	Y	Publishing framework or supporting query Query alias: PeriodSequence	Required by the production resource definition when the resource is published.	JSON type: `string`. Query alias: `PeriodSequence`.
gradingPeriods[].gradingPeriodReference.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`.
gradingPeriods[].gradingPeriodReference.schoolYear	SchoolYear	Y	Staging rule: Sessions p_yearid + 1991	Required by the production resource definition when the resource is published.	JSON type: `string`. Query alias: `SchoolYear`.