Cohorts
This category captures student cohorts (groups), and includes any activities and students associated with those activities. The Student Cohort Groups category includes the following data views and resources:
Cohorts
This data view represents a detailed list of Cohorts successfully published. The published view layout provides the School Name, Cohort Identifier, Cohort Name, Last Publish Date, Publishing ID, and Resource ID.
cohorts
This resource represents any type of list of designated students for tracking, analysis, or intervention.
Primary PowerSchool Source Data
- Gen
Selection Criteria
Records are published if the following criteria are met:
- One or more students at the school are in the cohort and none of the students are marked as being excluded.
Resource Output
- The cohort resource is dependent on the prior publishing of the following entities: schools
- LEAs and Schools may upload (publish) data to the Ed-Fi 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 | Req’d |
|---|---|---|---|---|
educationOrganizationReference A reference to the related EducationOrganization resource. | R | |||
/educationOrganizationId | The school with which the cohort is associated. | Integer | Derived from: Gen.SchoolID | R |
| identifier | The name or ID for the cohort. | String | When Gen.Cat = Activity derived from Gen.DCID and Gen.Value Otherwise: Derived from Gen.DCID and Gen.Name | R |
| description | The description of the cohort and its purpose. | String | Gen.Name | O |
| type | The type of the cohort (academic intervention, attendance intervention, discipline intervention, breakout session, etc.). | String | When Gen.Cat = Activity Gen.Value Otherwise: Gen.ID | R |
| scopeType | The scope of cohort (e.g., campus, district, classroom). | String | When Gen.SchoolID = 0: 'District' Otherwise: 'School' | O |
Student Cohort Association
This data view represents a detailed list of Student Cohort Associations successfully published. The published view layout provides the School Name, Student Number, Student Name, State Identifier, Grade Level, Cohort Name, Begin Date, End Date, Last Publish Date, Publishing ID, and Resource ID.
studentCohortAssociation
This association represents the cohort(s) for which a student is designated.
Primary PowerSchool Source Data
- Gen
- Students
Selection Criteria
Records are published if the following criteria are met:
- The student must not be excluded from state reporting.
- The student’s school of enrollment must not be excluded from state reporting.
- StudentUniqueId must be populated in PowerSchool.
Resource Output
- The studentCohortAssociation resource is dependent on the prior publishing of the following entities: students, cohorts
- LEAs and Schools may upload (publish) data to the Ed-Fi 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 | Req’d |
|---|---|---|---|---|
cohortReference A reference to the related Cohort resource. | R | |||
/identifier | The name or ID for the cohort. | String | When Gen.Cat = Activity derived from Gen.DCID and Gen.Value Otherwise: Derived from Gen.DCID and Gen.Name | R |
/educationOrganizationId | The organization associated with the cohort. | Integer | Derived from: Gen.SchoolID | R |
studentReference A reference to the related Student resource. | R | |||
/studentUniqueId | The student associated with the cohort. | String | Students.State_StudentNumber | R |
| beginDate | The month, day, and year on which the Student was first identified as part of the Cohort. | Date | Students.EntryDate | R |
| endDate | The month, day, and year on which the Student was removed as part of the Cohort. | Date | Students.ExitDate | O |
Staff Cohort Association
This data view represents a detailed list of Staff Cohort Associations successfully published. The published view layout provides the School Name, Teacher Number, Staff Name, State Identifier, Cohort Name, Begin Date, End Date, Last Publish Date, Publishing ID, and Resource ID.
staffCohortAssociation
This association indicates the staff associated with a cohort of students.
Primary PowerSchool Source Data
- Gen
- S_USR_EdFi_CohortGroups_C
Selection Criteria
Records are published if the following criteria are met:
- The staff member must not be excluded from state reporting.
- The staff's school of enrollment must not be excluded from state reporting.
- StaffUniqueId must be populated in PowerSchool.
Resource Output
- The staffCohortAssociation resource is dependent on the prior publishing of the following entities: staffs, cohorts
- LEAs and Schools may upload (publish) data to the Ed-Fi 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 | Req’d |
|---|---|---|---|---|
cohortReference A reference to the related Cohort resource. | R | |||
/identifier | The name or ID for the cohort. | String | When Gen.Cat = Activity derived from Gen.DCID and Gen.Value Otherwise: Derived from Gen.DCID and Gen.Name | R |
/educationOrganizationId | The organization associated with the cohort. | Integer | Derived from: Gen.SchoolID | R |
staffReference A reference to the related Staff resource. | R | |||
/staffUniqueId | The staff associated with the cohort. | String | S_USR_EdFi_CohortGroups_C.DCID | R |
| beginDate | Start date for the association of staff to this cohort. | Date | Later date of: S_USR_EdFi_CohortGroups_C.Start_Date Terms.FirstDay | R |
| endDate | End date for the association of staff to this cohort. | Date | S_USR_EdFi_CohortGroups_C.EndDate if less than Terms.LastDay Otherwise: Terms.LastDay | O |
| studentRecordAccess | Indicator of whether the staff has access to the student records of the cohort per district interpretation of FERPA and other privacy laws, regulations, and policies. | Boolean | When S_USR_EdFi_CohortGroups_C.StudentAccess = 1: Published Value = '1' Otherwise: Published Value = '0' | O |