PowerSchool SIS Tennessee
PowerSchool SIS Tennessee
Breadcrumbs

Calendar

Resource Overview

  • Ed-Fi endpoint: /data/v3/calendars

  • Published view/entity: School Calendar

  • Purpose: A set of dates associated with a school organization

  • Source query: Calendar

  • Dependencies: No resource dependency is declared.

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: Calendars

p_yearid + 1991

Required by the production resource definition when the resource is published.

JSON type: number. Query alias: SchoolYear.

calendarCode

CalendarCode

Y

[S_TN_SCH_InstrProgram_C]InstructionalProgramNbr

Required by the production resource definition when the resource is published.

JSON type: string. Query alias: CalendarCode.

calendarTypeDescriptor

CalendarType_DX

Y

Staging rule: Calendars

'School'

Required by the production resource definition when the resource is published.

JSON type: string. Query alias: CalendarType_DX.