Field Set: State ON Virtual ON_Educator_Assign
This field set was included with Provincial Reporting Installer 17.9.0 released on September 29, 2017.
Source Table (Virtual Table) | Source Field | Destination Table (Extended Schema) | Destination Field |
|---|---|---|---|
| ON_Educator_Assign | unique_ID | S_ON_SSF_Educator_Assign_C | unique_ID |
| ON_Educator_Assign | schoolID | S_ON_SSF_Educator_Assign_C | schoolID |
| ON_Educator_Assign | foreignKey | S_ON_SSF_Educator_Assign_C | foreignKey |
| ON_Educator_Assign | foreignKey_alpha | S_ON_SSF_Educator_Assign_C | foreignKey_alpha |
| ON_Educator_Assign | user_defined_date | S_ON_SSF_Educator_Assign_C | Assignment_Start |
| ON_Educator_Assign | user_defined_date2 | S_ON_SSF_Educator_Assign_C | Assignment_End |
| ON_Educator_Assign | user_defined_integer | S_ON_SSF_Educator_Assign_C | AssignmentID |
| ON_Educator_Assign | user_defined_numeric | S_ON_SSF_Educator_Assign_C | FTE |
| ON_Educator_Assign | user_defined_text | S_ON_SSF_Educator_Assign_C | Position_Type |
| ON_Educator_Assign | user_defined_text2 | S_ON_SSF_Educator_Assign_C | Leave_Type |
| ON_Educator_Assign | ON_Assign_Withdrawal_Type | S_ON_SSF_Educator_Assign_C | Assign_Withdrawal_Type |
| ON_Educator_Assign | ON_Department_Type | S_ON_SSF_Educator_Assign_C | Department_Type |
| ON_Educator_Assign | ON_Letter_Permission | S_ON_SSF_Educator_Assign_C | Letter_Permission |
| ON_Educator_Assign | ON_Teaching_Type | S_ON_SSF_Educator_Assign_C | Teaching_Type |
| ON_Educator_Assign | ON_Core_Flag | S_ON_SSF_Educator_Assign_C | Core_Flag |
| ON_Educator_Assign | ON_NTIP_Status | S_ON_SSF_Educator_Assign_C | NTIP_Status |
| ON_Educator_Assign | ON_Class_Assignment_Flag | S_ON_SSF_Educator_Assign_C | Class_Assignment_Flag |
| ON_Educator_Assign | ON_TLA | S_ON_SSF_Educator_Assign_C | TLA |
Source Table (Virtual Table) | Source Field | Destination Table (Extended Schema) | Destination Field |
|---|---|---|---|
| ON_Assign_Class | unique_ID | S_ON_Assign_Class_C | unique_ID |
| ON_Assign_Class | schoolID | S_ON_Assign_Class_C | schoolID |
| ON_Assign_Class | foreignKey | S_ON_Assign_Class_C | foreignKey |
| ON_Assign_Class | foreignKey_alpha | S_ON_Assign_Class_C | foreignKey_alpha |
| ON_Assign_Class | user_defined_integer | S_ON_Assign_Class_C | ClassID |
Source Table (Virtual Table) | Source Field | Destination Table (Extended Schema) | Destination Field |
|---|---|---|---|
| ON_Educator_Role | unique_ID | S_ON_Educator_Role_C | unique_ID |
| ON_Educator_Role | schoolID | S_ON_Educator_Role_C | schoolID |
| ON_Educator_Role | foreignKey | S_ON_Educator_Role_C | foreignKey |
| ON_Educator_Role | foreignKey_alpha | S_ON_Educator_Role_C | foreignKey_alpha |
| ON_Educator_Role | user_defined_date | S_ON_Educator_Role_C | Start_Date |
| ON_Educator_Role | user_defined_date2 | S_ON_Educator_Role_C | End_Date |
| ON_Educator_Role | user_defined_numeric | S_ON_Educator_Role_C | FTE |
| ON_Educator_Role | user_defined_text | S_ON_Educator_Role_C | Role_Type |
Source Table (Virtual Table) | Source Field | Destination Table (Extended Schema) | Destination Field |
|---|---|---|---|
| ON_Instructional_TM | unique_ID | S_ON_Instructional_TM_C | unique_ID |
| ON_Instructional_TM | schoolID | S_ON_Instructional_TM_C | schoolID |
| ON_Instructional_TM | foreignKey | S_ON_Instructional_TM_C | foreignKey |
| ON_Instructional_TM | foreignKey_alpha | S_ON_Instructional_TM_C | foreignKey_alpha |
| ON_Instructional_TM | user_defined_text | S_ON_Instructional_TM_C | Time_Type |
Source Table (Virtual Table) | Source Field | Destination Table (Extended Schema) | Destination Field |
|---|---|---|---|
| ON_TLA | unique_ID | S_ON_TLA_C | unique_ID |
| ON_TLA | schoolID | S_ON_TLA_C | schoolID |
| ON_TLA | foreignKey | S_ON_TLA_C | foreignKey |
| ON_TLA | foreignKey_alpha | S_ON_TLA_C | foreignKey_alpha |
| ON_TLA | user_defined_text | S_ON_TLA_C | Non_Teaching_Flag |
| ON_TLA | user_defined_text2 | S_ON_TLA_C | Subject_Type |