Student Cohort Data

The Student Cohort and Student Cohort Association resources have been added to the Ed-Fi implementation. These elements derive their values from the Student CTSO Page. If no value is present on the Student CTSO Page, these resources will not be published for the student. These resources are published at the district level.

Cohort

Primary PowerSchool Source Data

[ClubMembership]

Resource Output

The cohort records with the cohort ID, district ID, and cohort type descriptor are published.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Data Element

Description

Data Type

Stored in [Table]Field

Required

/cohortIdentifier

The Club ID from the Student CTSO Page. For example, “DECA” (Distributive Education Clubs of America).

String

[ClubMembership]TN_ClubID

Yes

/educationOrganizationReference/
educationOrganizationId

The Education Organization associated with the Cohort. This is the district ID.

Integer

Derived from:

[Prefs]Name=districtnumber
[Prefs]Value

Yes

/cohortTypeDescriptor

Currently defaults to the value “Other”.

String(Descriptor)

Yes

studentCohortAssociation

This resource represents the cohort(s) associated with a student.

Primary PowerSchool Source Data

[Students]
[ClubMembership]

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 student has a club membership record during the year for the term selected in the PowerSchool UI.

Resource Output

A studentCohortAssociation record is published for each period of enrollment in each club at each school.
The studentCohortAssociation resource is dependent on the prior publishing of the following resources: student and studentSchoolAssociation.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Data Element	Description	Data Type	Stored in [Table]Field	Required
studentReference/studentUniqueID	The unique ID of the student associated with the cohort.	Integer	StudentUniqueId downloaded from State Derived from: [ClubMembership]StudentId	Yes
cohortReference/cohortIdentity Reference to the cohort associated with the student.
/cohortIdentifier	The Club ID from the Student CTSO Page. For example, “DECA” (Distributive Education Clubs of America).	String	[ClubMembership]TN_ClubID	Yes
educationOrganizationId	The Education Organization associated with the Cohort. This is the district ID.	Integer	Derived from: [Prefs]Name=districtnumber [Prefs]Value	Yes
beginDate	The month, day, and year on which the student was first identified as part of the cohort.	String(Date)	[ClubMembership]TN_Club_MembBeginDate	Yes
endDate	The month, day, and year on which the student was removed as part of the cohort.	String(Date)	[ClubMembership]TN_Club_MembEndDate	Optional