S_IL_SEC_Teacher_Tracking_C (ver 17.5.0)
This is a child table (section is the parent table) for migration from IL_Section_Teacher_Tracking virtual table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 17.5.0 | Number(11,0) | Primary Key |
| SchoolID | 17.5.0 | Number(11,0) | ID of the school associated with this Store code list. Migrated from [IL_Section_Teacher_Tracking.SchoolID]. |
| Teacher_id | 17.5.0 | Varchar2(10) | The teacher ID. Migrated from [IL_Section_Teacher_Tracking.Teacher_id]. |
| StartDate | 17.5.0 | Date | Start Date. Migrated from [IL_Section_Teacher_Tracking.StartDate]. |
| EndDate | 17.5.0 | Date | End Date. Migrated from [IL_Section_Teacher_Tracking.EndDate]. |
| Role_of_professional | 18.8.0 | Varchar2(3) | Role of Professional. Migrated from [IL_Section_Teacher_Tracking.Role_of_professional]. |
| Teacher_commitment | 17.5.0 | Number(25,10) | Teacher to Course Commitment. Migrated from [IL_Section_Teacher_Tracking.Teacher_commitment]. |
| Actual_attendance | 17.5.0 | Varchar2(10) | No longer used. Migrated from [IL_Section_Teacher_Tracking.Actual_attendance]. |
| Total_attendance | 17.5.0 | Varchar2(10) | No longer used. Migrated from [IL_Section_Teacher_Tracking.Total_attendance]. |
| Reason_for_exit | 17.5.0 | Varchar2(2) | Reason for Exit. Migrated from [IL_Section_Teacher_Tracking.Reason_for_exit]. |
| Sort_by | 17.5.0 | Varchar2(50) | Internal use. Migrated from [IL_Section_Teacher_Tracking.Sort_by]. |
| foreignkey | 17.5.0 | Number(11,0) | Stores the section id, connecting with the section parent table. |
| foreignKey_alpha | 17.5.0 | Number(11,0) | No longer used. |