Skip to main content
Skip table of contents

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

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.