PowerSchool SIS Tennessee

Class Period

Resource Overview

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

  • Published view/entity: Class Period

  • Purpose: Information describing established class periods within a school

  • Source query: ClassPeriod

  • Dependencies: No resource dependency is declared.

This resource represents the designation of a regularly scheduled series of class meetings at designated times and days of the week.

Primary PowerSchool Source Data

  • [Period]

  • [Meetingtime]

Selection Criteria

Records are published if the following criteria are met:

  • The school must not be 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.

classPeriodName

Name

Y

[Period]DCID; [Period]Abbreviation; [Period]Period_Number; Transformation: EDFI_TN_LIB.formaPeriodName(p_profileid, per.dcid, per.abbreviation, per.period_number)

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

JSON type: string. Query alias: Name.

officialAttendancePeriodD

AttendancePeriod


Conditional

Publishing framework or supporting query

Query alias: AttendancePeriod

Submit when the source alias is populated and the parent structure is applicable.

JSON type: boolean. Query alias: AttendancePeriod.

meetingTimes[].startTime

StartTime


Y

Staging rule: classPeriodMeetingTimes

[Meetingtime]Start_Time


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

JSON type: string. Query alias: StartTime.

meetingTimes[].endTime

EndTime

Y

Staging rule: classPeriodMeetingTimes

[Meetingtime].End_Time

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

JSON type: string. Query alias: EndTime.