Certificate Eligibility

This does not work with certificates that have optional courses unless you run the options separately as a person will only show up with completion/current enrollment in all courses selected.

This report calls a procedure called CALL PROD_DB.ACADEMIC.P_GET_CERT_CANDIDATES

Which takes in the following parameters:

txt_main_courses - The courses to evaluate if they are taken or currently enrolled in. (selected in the “Select Course Number(s)” selection box and it is sent as a comma delimited list.)
txt_main_certs - the certificate that you are evaluating for. (Selected in the “Certificate To Exclude” Dropdown.)
main_dd_term.TERM_CODE - The Term Code to check for current enorllment in. ( Who is in a course this term that is part of the certificate you are looking for. Selected in the “TERM” Dropdown.)
btn_main_qry - This is set when the “Query” button is pressed. It stops the query from running automatically when you don’t want it to.

This procedure splits the courses in an array and stores them. It then checks to see if a student is enrolled in one of the courses during the term selected. If the student is enrolled in one of the courses then it checks for enrollment or completion of the other courses. If a student has completed or is enrolled in all the courses then it checks to see if they have been awarded the certificate, as defined by the certificate chosen.

The “All Subjects” checkbox/select box is meant to narrow down what courses show up in the list of courses to select.