PowerSchool SIS Tennessee

Cohort (Group)

Resource Overview

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

  • Published view/entity: Cohort (Group)

  • Purpose: Any type of list of designated students for tracking, analysis or intervention

  • Source query: Cohort

  • Dependencies: No resource dependency is declared.

Primary PowerSchool Source Data

  • [Sections]

Selection Criteria

Records are published if the following criteria are met:

  • The student was published in the Student category.

  • StudentUniqueId must be populated in PowerSchool.

  • The student must not be excluded from state reporting.

  • 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

educationOrganizationReference.educationOrganizationId

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.

cohortIdentifier

CohortIdentifier

Y

[Sections]DCID

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

JSON type: string. Query alias: CohortIdentifier.

cohortTypeDescriptor

CohortType_DX

Y

Staging rule: cohorts

'Other'

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

JSON type: string. Query alias: CohortType_DX.

cohortDescription

Description

Conditional

Staging rule: cohortPullouts

'Cohort class'

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

JSON type: string. Query alias: Description.

cohortScopeDescriptor

CohortScope_DX

Conditional

Publishing framework or supporting query

Query alias: CohortScope_DX

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

JSON type: string. Query alias: CohortScope_DX.