Student Cohort Group Data
This category captures student cohort information based on scheduled pull-out classes and student club memberships, along with the associated staff members, as published in the Student Cohort category.
Student Pull-out Classes
This view captures information about student cohort groups based on scheduled pull-out classes. The layout includes the School Name, Student Number, Student Name, Course Number, Course Name, Section Number, StartDate, End Date, Ed-Fi Unique ID, Last Publish Date, and the Publishing ID.
Student Club Memberships
This view captures information about student cohort groups based on club memberships. The layout includes the School Name, Student Number, Student Name, Club ID, Begin Date, End Date, Ed-Fi Unique ID, Last Publish Date, and the Publishing ID.
studentCohortAssociation
This association represents the cohort(s) for which a student is designated based on pull-out classes and club memberships. Both types of cohort groups are published in this association.
Primary PowerSchool Source Data
[Students]
[CC]
[ClubMembership] / [VirtualTablesData]
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.
For cohort groups based on pull-out classes: the student is scheduled into the class during the year for the term selected in the PowerSchool UI.
For cohort groups based on student club memberships: the student has a club membership record during the year for the term selected in the PowerSchool UI.
Resource Output
For pull-out classes: A studentCohortAssociation record is published for each period of enrollment in each pull-out section at each school.
For club memberships: 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, studentSchoolAssociation, section (for pull-out classes), and studentSectionAssocation.
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 | The student associated with the cohort. | Integer | StudentUniqueId downloaded from State Derived from: Classes: [CC]StudentId Clubs: [ClubMembership]StudentId [VirtualTablesData]ForeignKey | M |
cohortReference/cohortIdentity Reference to the cohort associated with the student. | M | |||
/cohortIdentifier | The name or ID for the cohort. | Varchar(20) | Classes: [Sections]DCID Clubs: [ClubMembership]TN_ClubID [VirtualTablesData]custom | M |
/educationOrganizationReference/ | The Education Organization associated with the Cohort. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
beginDate | The month, day, and year on which the student was first identified as part of the cohort. | Date | Classes: [CC]DateEnrolled Clubs: [ClubMembership]TN_Club_MembBeginDate [VirtualTablesData]custom | M |
endDate | The month, day, and year on which the student was removed as part of the cohort. | Date | Classes: [CC]DateLeft (-1) Clubs: [ClubMembership]TN_Club_MembEndDate [VirtualTablesData]custom | O |
CTSOChapterID | Chapter ID (name or number) assigned by the National CTSO. | Varchar(20) | [S_TN_STU_ClubMembership_C]TN_Club_ChapterID | M |
CTSOMembershipId | Student membership ID assigned by the National CTSO | Integer(9) | [S_TN_STU_ClubMembership_C]TN_Club_MembershipID | M |
sectionReference/sectionIdentity The cohort representing the subdivision of students within one or more sections. For example, a group of students may be given additional instruction and tracked as a cohort. | O | |||
/locationReference/locationIdentity The location, typically a classroom, where the section meets. | M | |||
//classroomIdentificationCode | A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or resource. | Varchar(20) | [Sections]Room Default: 'OPEN' | M |
//schoolReference/schoolIdentity | The school for the section's classroom. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
/classPeriodReference/classPeriodIdentity The class period during which the section meets. | M | |||
//classPeriodName | An indication of the portion of a typical daily session in which students receive instruction in a specified subject, for example, morning, sixth period, block period, or AB schedules. | Varchar(20) | [Period]Period_Number Derived from: [Section_Meeting]Period_Number | M |
//schoolReference/schoolIdentity | The school for the class period. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
/courseOfferingReference/courseOfferingIdentity The course offering taught in the section. | M | |||
//localCourseCode | The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students; must match LocalCourseCode in corresponding CourseOffering. | Varchar(60) | If Report Course.Section setting is set to Yes, then Local Course Number + Section_Number '_' Section DCID Otherwise, [Sections]ID | M |
//term | The name of the term in which the section is offered, for example, First semester, Second semester, Year long, Summer school. This must match Term in corresponding CourseOffering. | Enumerated List | [Sections]TermID [Terms]Portion [Terms]Abbreviation | M |
//schoolYear | The identifier for the school year, for example, 2010-2011. This must match SchoolYear in corresponding CourseOffering. | Enumerated List | [Terms]YearID | M |
//schoolReference/schoolIdentity | The school offering the course; must match SchoolID in corresponding CourseOffering. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
Staff Pull-out Classes
This view captures the staff members scheduled for cohort pull-out classes. The layout includes the School Name, Teacher Number, Staff Name, along with Course Name, Course Number, Section Number, Start Date, End Date, Last Publish Date, and the Publishing ID.
staffCohortAssociation
This association indicates the staff associated with a cohort of students.
Primary PowerSchool Source Data
[Staff]
[Sections]
Selection Criteria
Records are published if the following criteria are met:
The cohort pull-out class or the cohort club was published in the cohort resource.
The staff member was published in the Staff category.
StaffUniqueId must be populated in PowerSchool.
The staff member must not be excluded from state reporting.
The staff member must not be designated as Lunch Staff or Substitute.
Resource Output
A staffCohortMembership record is published for each pull-out class section for which the staff member was scheduled, and for each student club with which the staff member is associated, assuming the other selection criteria are met.
The staffCohortMembership resource is dependent on the prior publishing of the following resources: staff and staffSectionAssociation.
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/staffIdentity | A unique alphanumeric code assigned to a staff. | Integer | [CST_PubUniqueIdStaff]UniqueId Derived from: [Sections]Teacher [SchoolStaff]Users_DCID | M |
cohortReference/cohortIdentity The cohort associated with the student. | M | |||
/cohortIdentifier | The name or ID for the cohort. | Varchar(20) | [Sections]DCID | M |
/educationOrganizationReference/ | The Education Organization associated with the Cohort. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
beginDate | Start date for the association of staff to this cohort. | Date | [Terms]FirstDay Linked from [Sections]TermID | M |
endDate | End date for the association of staff to this cohort. | Date | [Terms]LastDay Linked from [Sections]TermID | O |