S_MI_STU_VLMC_C (ver 20.9.1.0)
This table is an extension of the [Students] table.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 20.9.1.0 | Number(19,0) | Primary key. |
| StudentsDCID | 20.9.1.0 | Number(19,0) | Foreign key linking records to parent students record. |
| SectionsDCID | 20.9.1.0 | Number(11,0) | Section DCID. |
| Contact_Person | 20.11.2.0 | VarChar2(200) | Contact Person if not a Teacher or Mentor |
| ContactDate | 20.9.1.0 | Date | Indicates the contact date of the two-way communication. |
| ResponseDate | 20.9.3.0 | Date | Indicates the response date for the two-way communication. |
| ContactTypeEmail_YN | 20.9.1.0 | Number(1,0) | Indicates contact type as email. |
| ContactTypePhone_YN | 20.9.1.0 | Number(1,0) | Indicates contact type as phone. |
| ContactTypeF2F_YN | 20.9.1.0 | Number(1,0) | Indicates contact type as face-to-face. |
| ContactTypeHomework_YN | 20.10.1.0 | Number(1,0) | Indicates contact type as homework assignment. |
| ContactTypeOther_YN | 20.9.1.0 | Number(1,0) | Indicates contact type as other. |
| TeacherComments | 20.9.1.0 | VarChar2(250) | Teacher comments regarding two-way interaction. |
| StudentComments | 20.9.1.0 | VarChar2(250) | Student response regarding two-way interaction. |
| MentorTeacherUserDCID | 20.9.1.0 | Number(11,0) | User DCID. |