S_ON_STU_SHSM_Cert_C ver 17.9.0
This table is a child table of Students and stores SHSM Certifications information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
unique_ID | 17.9.0 | Number(11,0) | Record ID. Migrated from [ON_SHSM_Cert.unique_ID]. |
| SchoolID | 17.9.0 | Number(11,0) | School ID. Migrated from [ON_SHSM_Cert.schoolID]. |
| foreignKey | 17.9.0 | Number(11,0) | Reserved for future use. Migrated from [ON_SHSM_Cert.foreignKey]. |
| foreignKey_alpha | 17.9.0 | Varchar2(31) | Reserved for future use. Migrated from [ON_SHSM_Cert.foreignKey_alpha]. |
| Date_Completed | 17.9.0 | Date | Date Completed. Migrated from [ON_SHSM_Cert.user_defined_date]. |
| Expiration_Date | 17.9.0 | Date | Expiration Date. Migrated from [ON_SHSM_Cert.user_defined_date2]. |
| Certification_Hours | 17.9.0 | Number(25,10) | Certification Hours. Migrated from [ON_SHSM_Cert.user_defined_numeric]. |
| certType | 17.9.0 | Varchar2(3) | Certification Type. Migrated from [ON_SHSM_Cert.user_defined_text]. |