S_USR_COHORTGROUPS_C (ver 19.11.1.0)
This table is a child of the [Users] table and defines one or more staff cohort group assignments Users record. This information is used in conjunction with Ed-Fi related functionality. The table is available for all states and provinces and may or may not be utilized for your state or province.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 19.11.1.0 | Number(11,0) | Primary Key |
UsersDCID | 19.11.1.0 | Number(11,0) | The unique DCID in the Users table. |
BeginDate | 19.11.1.0 | Date | The first day of the assignment. |
EndDate | 19.11.1.0 | Date | The last day of the assignment. |
ExcludeFromEdFi | 19.11.1.0 | Number(1,0) | This indicates that this cohort group assignment should not be reported via Ed-Fi. |
GroupID | 19.11.1.0 | Number(11,0) | ID from GEN table (cat=activity or specprog) that is associated with this record. |
SchoolID | 19.11.1.0 | Number(11,0) | The internal number for the school where the staff is assigned. |
StudentAccess | 19.11.1.0 | Number(1,0) | Indicates whether the staff has access to student records of the cohort. |