S_TX_COHORT_STAFF_C (ver 14.5.0)
This table is a child table of the S_TX_COHORT_S table that stores information about staff associated with each cohort group.
Column Name | Version | Data Type | Description |
---|---|---|---|
ID | 14.5.0 | Number(11,0) | Primary Key. |
S_TX_COHORT_SID | 14.5.0 | Number(11,0) | A foreign key link to S_TX_COHORT_S. |
TEACHERSDCID | 14.5.0 | Number(11,0) | A foreign key that relates the extended table to the [Teachers] table. |
Access_Student_Records | 14.5.0 | Number(1,0) | Denotes whether or not the staff member will have access to the student records from the associated cohort grop in the Dashboard application. |
End_Date | 14.5.0 | Date | Denotes the date the staff member ended their association with the cohort group. |
Start_Date | 14.5.0 | Date | Denotes the date the staff member started their association with the cohort group. |