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 |
|