Student Cohort Groups
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 to TRIG. The published view layout provides the School Name, Cohort Identifier, and Cohort Name.
cohort
This resource represents any type of list of designated students for tracking, analysis, or intervention.
Primary PowerSchool Source Data
- [Gen]
- [S_MI_Stu_Assess_X]
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.
- One or more students at the school are in the cohort.
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 | [Table]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 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 |
| otherResearchCode1 | Field for use in researching or tracking student assessment information. | String | [S_MI_Stu_Assess_X] OtherResearchCode1 | O |
| otherResearchCode2 | Field for use in researching or tracking student assessment information. | String | [S_MI_Stu_Assess_X] OtherResearchCode2 | O |
assessments A reference to the related Assessment resource. | O | |||
/title | The title or name of the assessment. | String | [S_MI_Stu_Assess_X]OtherTestType | R |
/assessedGradeLevelDescriptor | The typical grade level for which an assessment is designed. If the test assessment spans a range of grades, then this attribute holds the highest grade assessed. If only one grade level is assessed, then only this attribute is used. | String | When [S_MI_Stu_Assess_X]OtherTestType
| R |
/academicSubjectDescriptor | The description of the content or subject area (e.g., arts, mathematics, reading, stenography, or a foreign language) of an assessment. | String | '73' | R |
/version | The version identifier for the assessment. | Integer | '1' | R |
Student Cohort Association
This data view represents a detailed list of Student Cohort Associations successfully published to TRIG. The published view layout provides the School Name, Student Number, Student Name, UIC, Grade Level, Cohort Name, Begin Date, and End Date.
studentCohortAssociation
This association represents the cohort(s) for which a student is designated.
Primary PowerSchool Source Data
- [enter table name]
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 | [Table]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 | 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 | R | |
| beginDate | The month, day, and year on which the Student was first identified as part of the Cohort. | Date | R | |
| endDate | The month, day, and year on which the Student was removed as part of the Cohort. | Date | O | |
Staff Cohort Association
This data view represents a detailed list of Staff Cohort Associations successfully published to TRIG. The published view layout provides the School Name, Teacher Number, Staff Name, PIC, Cohort Name, Begin Date, and End Date.
staffCohortAssociation
This association indicates the staff associated with a cohort of students.
Primary PowerSchool Source Data
- [enter table name]
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 | [Table]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 | R | |
/educationOrganizationId | The organization associated with the cohort. | Integer | R | |
staffReference A reference to the related Staff resource. | R | |||
/staffUniqueId | The student associated with the cohort. | String | R | |
| beginDate | Start date for the association of staff to this cohort. | Date | R | |
| endDate | End date for the association of staff to this cohort. | Date | 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 | O | |