Grading Periods

Resource Overview

Ed-Fi endpoint: /data/v3/gradingPeriods
Published view/entity: Grading Period
Purpose: Describes grading periods related to terms
Source query: GradingPeriod
Dependencies: No resource dependency is declared.

gradingPeriod

This resource represents the time span for which grades are reported.

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 associated with the grading period exists 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
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: GradingPeriods p_yearid + 1991	Required by the production resource definition when the resource is published.	JSON type: `number`. Query alias: `SchoolYear`.
gradingPeriodName	GradingPeriodName	Y	[Terms]Abbreviation; [Terms]Name; Transformation: COALESCE(CST_PUBWORKFLOW.formatLEADistrictIDBase(p_profileid, p_schoolid, 0, 'districtnumber', 1), CST_PUBWORKFLOW.formatLEADistrictIDBase(p_profileid, 0, 0, 'districtnumber', 1), TO_CHAR(p_schoolid)) \\|\\| '-' \\|\\| NVL(NULLIF(trim(t.abbreviation), ''), REGEXP_REPLACE(NVL(trim(t.name), 'GradingPeriod'), '\s+', ' '))	Required by the production resource definition when the resource is published.	JSON type: `string`. Query alias: `GradingPeriodName`.
gradingPeriodDescriptor	GradingPeriod_DX	Y	[Terms]GradingPeriodDescriptor	Required by the production resource definition when the resource is published.	JSON type: `string`. Query alias: `GradingPeriod_DX`.
periodSequence	PeriodSequence	Y	[Terms]Portion; [Terms]Abbreviation; transformation: case when t.portion = 1 then '1' else substr(t.abbreviation, length(t.abbreviation), 1) end	Required by the production resource definition when the resource is published.	JSON type: `number`. Query alias: `PeriodSequence`.
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`.