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 |