Ontario Educator Assignment: ON_Educator_Assign
One record is present for each assignment for an educator at a school. These records can be maintained manually on the Edit Information Staff page.
Data Element | Field Name | DDE: [Table]Field | Required for Import |
---|---|---|---|
Unique identifier for this record. | AssignmentID | [VirtualTablesData]Unique_ID | System generated |
Teacher ID (foreign key reference to Teachers view, based on the SchoolStaff.ID value associated with this educator). | TeacherID | [VirtualTablesData]ForeignKey | Yes |
School ID (foreign key reference to SchoolStaff.SchoolID or the corresponding value in the Teachers view). | SchoolID | [VirtualTablesData]SchoolID | Yes |
Position Type | Position_Type | [VirtualTablesData]User_Defined_Text | Yes |
Leave Type | Leave_Type | [VirtualTablesData]User_Defined_Text2 |
|
Assignment Withdrawal Type | ON_Assign_Withdrawal_Type | [VirtualTablesData]Custom |
|
Assignment Start Date | Assignment_Start | [VirtualTablesData]User_Defined_Date |
|
Assignment End Date | Assignment_End | [VirtualTablesData]User_Defined_Date2 |
|
Full Time Equivalent | FTE | [VirtualTablesData]User_Defined_Numeric |
|
Department Type | ON_Department_Type | [VirtualTablesData]Custom |
|
Letter Of Permission Number | ON_Letter_Permission | [VirtualTablesData]Custom |
|
Teacher Type | ON_Teaching_Type | [VirtualTablesData]Custom |
|
Core Teacher Flag | ON_Core_Flag | [VirtualTablesData]Custom |
|
NTIP Status Type | ON_NTIP_Status | [VirtualTablesData]Custom |
|
Class Assignment Flag | ON_Class_Assignment_Flag | [VirtualTablesData]Custom |
|
Temporary Letter Assignment | Temporary_Letter_Assignment | [VirtualTablesData]Custom |
|