Although there is an Academic Plan Type of CER for Certificates, it is not used consistently, which makes it difficult to determine which programs are Certificates and which are not. Additionally, not all Academic Plan codes use the -CER suffix, and not all descriptions contain the word "Certificate."
Certificate "Career" - Career is sometimes null in MaineStreet, making it difficult to determine (for those not familiar with a given set of programs or plans) whether a certificate is an undergraduate or graduate program based solely on the ACAD_CAREER field. Of the 253 certificate programs in the UMS, 150 have a null ACAD_CAREER field in the ACAD_PLAN_TBL. This might be one of the reasons that certificates are sometimes picked up in the Baccalaureate level of the UM_NEASC_LEVEL field.
Example of coding needed to inventory certificates:
When A.ACAD_PLAN like '%-CER%' then 'Certificate (Undergraduate)'
When A.ACAD_PLAN = 'CERT-INFO' then 'Certificate (Undergraduate)'
When A.ACAD_PLAN like '%CER%' and A.ACAD_CAREER = 'UGRD' then 'Certificate (Undergraduate)'
When A.ACAD_PLAN_TYPE = 'CER' and A.ACAD_CAREER = 'UGRD' then 'Certificate (Undergraduate)'
When A.ACAD_PLAN in('C-CSC','CCY1-CER','CCY2-CER','EED-CER') then 'Certificate (Undergraduate)'
When A.ACAD_PLAN like '%-CGS%' then 'Certificate of Graduate Study'
When A.ACAD_PLAN like '%-CAS%' then 'Certificate of Advanced Study (Post-Masters)'
Certificate has been identified as a Data Governance issue.
As of summer 2021, certificate students can be identified as below:
| Institution | Undergraduate certificate | Post-Bacc / Graduate | Post-Masters | Notes |
|---|---|---|---|---|
| UMS01 | A.Degree = 'CERT' A.ACAD_PLAN like '%-CER' | A.Degree = 'CGS' A.ACAD_PLAN like '%-CGS' | ||
UMS02 | A.Degree = 'CERT' | A.Degree = 'CGS' A.ACAD_PROG_PRIMARY = 'GRCRT' | ||
| UMS03 | A.ACAD_PROG = 'CERTS' | |||
| UMS04 | A.ACAD_PROG = 'CERT' | Not all A.Degree = 'CERT' are degree-seeking. | ||
| UMS05 | A.ACAD_PROG = 'CERT' (A.Degree = 'CERT') | A.Degree = 'CGS' | A.Degree = 'EDS' A.Degree = 'CAS' | |
| UMS06 | A.ACAD_PLAN like '%-CERT' | A.ACAD_PLAN like '%-CGS' | ||
| UMS07 | A.ACAD_PROG = 'CERT' |
(Alias A. is UM_STUD_EXTRACT on the table above)