This table pulls from the STDNT_CAR_TERM - Student Career Term Table, ADM_APPL_PROG - Admission Applicant Program table and the ACAD_PROG - Student Academic Program table to determine the first and the most recent admit terms, both with and without credits.
Join this table to another table containing information about the student such as the UM_STUD_EXTRACT - Student Reporting Extract to find out when a student first enrolled. This could be useful, for instance, to determine whether or not someone is a First-Time student.
| Key | Record.Fieldname | Format | XLAT | Heading Text |
|---|---|---|---|---|
| → | ACAD_CAREER - Academic Career | Char4 | N | Career |
| ADMIT_TERM - First Admit Term | Char4 | First Admit Ter | ||
| → | EMPLID - Empl ID | Char11 | ID | |
| → | INSTITUTION - Academic Institution | Char5 | Institution | |
| STRM - First Term | Char4 | First Term | ||
| UM_MAX_ADMIT_TERM - Maximim Admit Term | Char4 | Max Admit_term | ||
| UM_MAX_TERM - Maximum Term | Char4 | Max Term | ||
| UM_MAX_TERM_NOCRED - MAX STRM no credit hour check | Char4 | MAX TERM NOCRED | ||
| UM_MIN_STRM_NOCRED - Min STRM no credit hour check | Char4 | Min STRM no chk |
SQL Code for UM_D_MIN_TERMS
SELECT x.emplid , x.acad_career , x.institution , CASE WHEN MIN(x.strm) = '9999' THEN NULL ELSE MIN(x.strm) END AS STRM , CASE WHEN MIN(x.admit_term) = '9999' THEN NULL ELSE MIN(x.admit_term) END AS ADMIT_TERM , CASE WHEN MIN(x.strm_nocred) = '9999' THEN NULL ELSE MIN(x.strm_nocred) END AS UM_STRM_NOCRED , CASE WHEN MAX(x.max_term) = '0000' THEN NULL ELSE MAX(x.max_term) END AS UM_MAX_TERM , CASE WHEN MAX(x.max_admit_term) = '0000' THEN NULL ELSE MAX(x.max_admit_term) END AS UM_MAX_ADMIT_TERM , CASE WHEN MAX(x.max_term_nocred) = '0000' THEN NULL ELSE MAX(x.max_term_nocred) END AS UM_MAX_TERM_NOCRED FROM ( SELECT a.emplid , a.acad_career , a.institution , a.strm , '9999' AS admit_term , '9999' AS strm_nocred , a.strm AS max_term , '0000' AS max_admit_term , '0000' AS max_term_nocred FROM ps_stdnt_car_term a WHERE a.unt_taken_prgrss > 0 UNION SELECT b.emplid , b.acad_career , b.institution ,'9999' ,b.admit_term ,'9999' ,'0000' ,b.admit_term ,'0000' FROM ps_adm_appl_prog b UNION SELECT c.emplid , c.acad_career , c.institution ,'9999' ,c.admit_term ,'9999' , '0000' ,c.admit_term , '0000' FROM ps_acad_prog c UNION SELECT a2.emplid , a2.acad_career , a2.institution , '9999' , '9999' , a2.strm , '0000' , '0000' , a2.strm FROM ps_stdnt_car_term a2 ) x GROUP BY x.emplid , x.acad_career , x.institution