Student Cohort Groups
This category captures student activities and related information. The Student Cohort Groups category includes the following data views and resources:
Cohorts are used to designate groups of students outside of class rosters, enrollment lists, or program participation. For Nebraska, the published records are based on Activities and on Sections flagged as Activities in PowerSchool.
Note: The district must configure Ed-Fi Code Set Mapping to map local activities in the [Gen] table to Ed-Fi CohortTypes.
Student Cohort Association
This view captures information about students and their activities and sections identified as activities as published in the studentCohortAssociation resource within the Cohort category. The layout includes School Name, Student Number, Student Name, State Student Number, Grade Level, Activity Name, Course Name, Course Number, Section Number, 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 based on PowerSchool student activities and scheduled sections flagged as activities.
Primary PowerSchool Source Data
- [Gen]
- [Students]
- [S_NE_SSF_ACTIVITIES_C]
- [Sections]
- [S_NE_SEC_X]
- [CC]
Selection Criteria
Records are published if the following criteria are met:
- The student was published in the student resource.
- The studentUniqueId must be populated in PowerSchool.
- The student must not be excluded from state reporting.
- The student must have an active school enrollment.
- The school associated with the activity must not be excluded from state reporting.
- If one or more staff is assigned to the activity in [S_NE_SSF_ACTIVITIES_C], at least one staff assignment for the activity at the school must not be excluded from state reporting
- The Section is flagged as activities in [S_NE_SEC_X] where Activity_YN = 1 and has enrolled students.
Resource Output
- A separate record is published for each student, for each cohort group (activity or section), and for each school associated with the student activity.
- The studentCohortAssociation resource is dependent on the prior publishing of the following resources: student, studentSchoolAssociation, and cohort.
- 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 | Req'd |
|---|---|---|---|---|
studentReference/studentIdentity | StudentUniqueId - The student associated with the cohort. | Integer | [Students]State_StudentNumber Derived from: Activities: [Students]Id if a custom field exists in [Students] where fieldname=gen.value Sections: [CC]StudentId | R |
cohortReference/cohortIdentity Reference to the cohort associated with the student. | R | |||
/cohortIdentifier | The name or ID for the cohort. | Varchar(20) | Activities: [Gen]Value where cat='activity' Sections: [Sections]DCID | R |
/educationOrganizationReference/educationOrganizationIdentity | EducationOrganizationId – The Education Organization associated with the Cohort. | Integer | SchoolId downloaded from the state Derived from: Activities: [Students]SchoolId Sections: [Sections]SchoolId | R |
beginDate | The month, day, and year on which the student was first identified as part of the cohort. | Date | Activities: [Students]EntryDate Sections: [CC]DateEnrolled] | R |
endDate | The month, day, and year on which the student was removed as part of the cohort. | Date | Activities: [Students]ExitDate Sections: [CC]DateLeft] | O |
Staff Cohort Association
This view captures information about staff and their activities and sections identified as activities. The layout includes the School Name, Teacher Number, Staff Name, NDE Staff ID, Activity Name, Course Name, Course Number, Section Number, Begin Date, End Date, Last Publish Date, Publishing ID, and Resource ID.
staffCohortAssociation
This association represents the cohort(s) for which a staff member is designated based on PowerSchool student activities and scheduled sections flagged as activities.
Primary PowerSchool Source Data
- [SchoolStaff]
- [Gen]
- [S_NE_SSF_ACTIVITIES_C]
- [Sections]
- [S_NE_SEC_X]
- [SectionTeacher]
Selection Criteria
Records are published if the following criteria are met:
- The staff member was published in the staff category.
- The staffUniqueId must be populated in PowerSchool.
- The staff member must not be excluded from Ed-Fi.
- The school associated with the staff member or the section must not be excluded from state reporting.
- A [S_NE_SSF_ACTIVITIES_C] record exists with a staff assignment for the activity, and is not excluded from reporting ([S_NE_SSF_ACTIVITIES_C].SchoolStaffDCID, Gen_DCID, State_ExcludeFromReporting).
- The teacher's section is flagged as activities in [S_NE_SEC_X]Activity_YN = 1 and has enrolled students.
Resource Output
- A separate record is published for each student, for each cohort group (activity or section), and for each school associated with the student activity.
- The staffCohortAssociation resource is dependent on the prior publishing of the following resources: staffSchoolAssociation and cohort.
- 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 | Req'd |
|---|---|---|---|---|
staffReference/studentIdentity | StaffUniqueId - The staff member associated with the cohort. | Integer | [Teachers]NE_StaffID Derived from: Activities: [S_NE_SSF_ACTIVITIES_C]SchoolStaffDCID Sections: [SectionTeacher]TeacherId | R |
cohortReference/cohortIdentity Reference to the cohort associated with the student. | R | |||
/cohortIdentifier | The name or ID for the cohort. | Varchar(20) | Activities: Derived from: [Gen]Value where cat='activity' [S_NE_SSF_ACTIVITIES_C]Gen_DCID Sections: [Sections]DCID | R |
/educationOrganizationReference/educationOrganizationIdentity | EducationOrganizationId – The Education Organization associated with the Cohort. | Integer | SchoolId downloaded from the state Derived from: Activities: [SchoolStaff]SchoolId Sections: [Sections]SchoolId | R |
beginDate | Start date for the association of staff to this cohort. | Date | Activities: Later date of: [S_NE_SSF_ACTIVITIES_C]Start_Date [Terms]FirstDay Sections: [SectionTeacher]Start_Date | R |
endDate | End date for the association of staff to this cohort. | Date | Activities: [S_NE_SSF_ACTIVITIES_C]End_Date Sections: [SectionTeacher]End_Date | O |