StudentCounselor (ver22.5.0.0)
This table contains the relationships between a counselor and their assigned students.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
ID | 22.5.0.0 | Number(19.0) | System generated unique key for this relationship between a student and a counselor. Required. Indexed. |
IsPrimary | 22.5.0.0 | Number(1,0) | Flag indicating if this is the primary counselor for the student. Required. Valid values are 1=Yes, this is the primary counselor, and 0=No, this is not the primary counselor. |
StudentDCID | 22.5.0.0 | Number(10,0) | The DCID from the Students table referencing the student. Required. Foreign Key; Indexed. |
UserDCID | 22.5.0.0 | Number(10,0) | The DCID from the Users table referencing the counselor. Required. Foreign Key. |
WhenCreated | 22.5.0.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
WhenModified | 22.5.0.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |
WhoCreated | 22.5.0.0 | Varchar2(100) | The user login that created the record. Defaults to the database user. Required. |
WhoModified | 22.5.0.0 | Varchar2(100) | The user login that modified the record. Defaults to the database user. Required. |