Calendar Date

Resource Overview

Ed-Fi endpoint: /data/v3/calendarDates
Published view/entity: Calendar Date
Purpose: Describes calendar days in the school calendar
Source query: CalendarDate
Dependencies: calendars

calendarDate

This resource represents a day in the school calendar.

Primary PowerSchool Source Data

[Calendar_Day]
[GEN]
[S_TN_SCH_InstrProgram_C]

Selection Criteria

Records are published if the following criteria are met:

The school must not be excluded from state reporting.
The calendar date for the school falls within the year for the Term selected in the PowerSchool UI.

Resource Output

Data Element (Ed-Fi target)	Data View Column Name	Submission	[Table]Field (PowerSchool Source)	Business Rules	Comments
calendarReference.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`.
calendarReference.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`.
calendarReference.schoolYear	SchoolYear	Y	Staging rule: CalendarDates p_yearid + 1991	Required by the production resource definition when the resource is published.	JSON type: `number`. Query alias: `SchoolYear`.
Date	DateValue	Y	Calendar_Day]Date_value; Transformation: to_char(cd.date_value, 'YYYY-MM-DD')	Required by the production resource definition when the resource is published.	JSON type: `datetime`. Query alias: `DateValue`.
calendarEvents[].calendarEventDescriptor	CalendarEvent_DX	Y	[gen]value; Transformation: case when t.value is not null then t.value end	Required by the production resource definition when the resource is published.	JSON type: `string`. Query alias: `CalendarEvent_DX`.