Field Set: State ON Virtual ON_SHSM_Cert
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_SHSM_Cert | unique_ID | S_ON_STU_SHSM_Cert_C | unique_ID |
| ON_SHSM_Cert | schoolID | S_ON_STU_SHSM_Cert_C | schoolID |
| ON_SHSM_Cert | foreignKey | S_ON_STU_SHSM_Cert_C | foreignKey |
| ON_SHSM_Cert | foreignKey_alpha | S_ON_STU_SHSM_Cert_C | foreignKey_alpha |
| ON_SHSM_Cert | user_defined_date | S_ON_STU_SHSM_Cert_C | Date_Completed |
| ON_SHSM_Cert | user_defined_date2 | S_ON_STU_SHSM_Cert_C | Expiration_Date |
| ON_SHSM_Cert | user_defined_numeric | S_ON_STU_SHSM_Cert_C | Certification_Hours |
| ON_SHSM_Cert | user_defined_text | S_ON_STU_SHSM_Cert_C | certType |