Field Set: State ON Virtual ON_Community_Hours
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_Community_Hours | unique_ID | S_ON_STU_Community_Hours_C | unique_ID |
| ON_Community_Hours | schoolID | S_ON_STU_Community_Hours_C | schoolID |
| ON_Community_Hours | foreignKey | S_ON_STU_Community_Hours_C | foreignKey |
| ON_Community_Hours | foreignKey_alpha | S_ON_STU_Community_Hours_C | foreignKey_alpha |
| ON_Community_Hours | user_defined_date | S_ON_STU_Community_Hours_C | Date_Completed |
| ON_Community_Hours | user_defined_numeric | S_ON_STU_Community_Hours_C | Number_Of_Hours |
| ON_Community_Hours | user_defined_text | S_ON_STU_Community_Hours_C | Activity_Description |
| ON_Community_Hours | user_defined_text2 | S_ON_STU_Community_Hours_C | Location |
| ON_Community_Hours | Phone_Number | S_ON_STU_Community_Hours_C | Phone_Number |
| ON_Community_Hours | Supervisor | S_ON_STU_Community_Hours_C | Supervisor |