S_RI_STU_ContributingTeacher_C (ver 17.7.0)
This is a child table of the [STUDENTS] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 17.7.0 | Number(10,0) | Primary Key. |
| ForeignKey | 17.7.0 | Number(11,0) | Student ID that relates the child table back to the STUDENTS table. |
| StudentsDCID | 17.7.0 | Number(10,0) | Foreign key that relates the child table back to the STUDENTS table. |
| Unique_ID | 17.7.0 | Number(11,0) | Primary key from the virtual table. |
| ELA | 17.7.0 | Number(1,0) | Indicates if the educator provides English language arts development through this course. |
| EntryDate | 17.7.0 | Date | Start date for the teacher associated with the course section. |
| ExitDate | 17.7.0 | Date | End date for the teacher associated with the course section. |
| Math | 17.7.0 | Number(1,0) | Indicates if the educator provides mathematics development through this course. |
| SchoolID | 17.7.0 | Number(11,0) | ID of the school associated with the course section. |
| SectionID | 17.7.0 | Number(11,0) | ID of the course section. |
| SchoolStaffID | 17.7.0 | Number(11,0) | Teacher ID associated with the course section. |
| StaffRoleID | 17.7.0 | Varchar2(10) | Finance classification of the educator associated with course section. |
| ForeignKey_Alpha | 17.7.0 | Varchar2(31) | Default field. No longer used. |