PowerSchool SIS Ontario
Breadcrumbs

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