| Key | Record.Fieldname | Format | XLAT | Heading Text |
|---|---|---|---|---|
| → | ACAD_CAREER - Academic Career | Char4 | Career | |
| ACAD_PROG - Academic Program | Char5 | Acad Prog | ||
| ACTION_DT - Action Date | Date | Action Date | ||
| ADMIT_TERM - Admit Term | Char4 | Admit Term | ||
| ADMIT_TYPE - Admit Type | Char3 | Admit Type | ||
| ADM_APPL_CMPLT_DT - Completed Date | Date | Date | ||
| ADM_APPL_COMPLETE - Application Complete | Char1 | Complete | ||
| → | ADM_APPL_NBR - Application Nbr | Char8 | Appl Nbr | |
| → | EMPLID - Empl ID | Char11 | ID | |
| EVALUATION_DT - Evaluation Date | Date | Eval Dt | ||
| EVALUATN_STATUS - Evaluation Status | Char2 | Eval Stat | ||
| INSTITUTION - Academic Institution | Char5 | Institution | ||
| → | OPRID - User ID | Char30 | User | |
| PROG_ACTION - Program Action | Char4 | Prog Actn | ||
| PROG_REASON - Action Reason | Char4 | Action Rsn | ||
| PROG_STATUS - Academic Program Status | Char4 | N | Status |
SQL Code for ADM_APPL_VW
-- ADM_APPL_VW IN CS90PRD
SELECT DISTINCT a.emplid,
a.acad_career,
a.adm_appl_nbr,
d.oprid,
a.institution,
a.admit_type,
a.adm_appl_complete,
a.adm_appl_cmplt_dt,
b.acad_prog,
b.prog_status,
b.prog_action,
b.prog_reason,
b.action_dt,
b.admit_term,
c.evaluatn_status,
c.evaluation_dt
FROM ps_adm_appl_data a,
ps_adm_appl_prog b,
ps_adm_app_car_seq c,
ps_scrty_appl_ctr d
WHERE d.access_cd = 'Y'
AND a.institution = d.institution
AND ( d.adm_appl_ctr = a.adm_appl_ctr
OR d.adm_appl_ctr = 'ALL' )
AND b.effdt = (SELECT MAX(effdt)
FROM ps_adm_appl_prog
WHERE b.emplid = emplid
AND b.acad_career = acad_career
AND b.stdnt_car_nbr = stdnt_car_nbr
AND b.adm_appl_nbr = adm_appl_nbr
AND b.appl_prog_nbr = appl_prog_nbr
AND effdt <= To_date(To_char(sysdate, 'YYYY-MM-DD')
,
'YYYY-MM-DD'))
AND b.effseq = (SELECT MAX(effseq)
FROM ps_adm_appl_prog
WHERE b.emplid = emplid
AND b.acad_career = acad_career
AND b.stdnt_car_nbr = stdnt_car_nbr
AND b.adm_appl_nbr = adm_appl_nbr
AND b.appl_prog_nbr = appl_prog_nbr
AND b.effdt = effdt)
AND a.emplid = b.emplid
AND a.acad_career = b.acad_career
AND a.stdnt_car_nbr = b.stdnt_car_nbr
AND a.adm_appl_nbr = b.adm_appl_nbr
AND b.emplid = c.emplid
AND b.acad_career = c.acad_career
AND b.stdnt_car_nbr = c.stdnt_car_nbr
AND b.adm_appl_nbr = c.adm_appl_nbr
AND b.appl_prog_nbr = c.appl_prog_nbr;
-- ADM_APPL_VW IN CSPRD
SELECT DISTINCT a.emplid,
a.acad_career,
a.adm_appl_nbr,
a.institution,
a.admit_type,
a.adm_appl_complete,
a.adm_appl_cmplt_dt,
b.acad_prog,
b.prog_status,
b.prog_action,
b.prog_reason,
b.action_dt,
b.admit_term,
c.evaluatn_status,
c.evaluation_dt
FROM ps_adm_appl_data a,
ps_adm_appl_prog b,
ps_adm_app_car_seq c
WHERE b.effdt = (SELECT MAX(effdt)
FROM ps_adm_appl_prog
WHERE b.emplid = emplid
AND b.acad_career = acad_career
AND b.stdnt_car_nbr = stdnt_car_nbr
AND b.adm_appl_nbr = adm_appl_nbr
AND b.appl_prog_nbr = appl_prog_nbr
AND effdt <= To_date(To_char(sysdate, 'YYYY-MM-DD'),
'YYYY-MM-DD'))
AND b.effseq = (SELECT MAX(effseq)
FROM ps_adm_appl_prog
WHERE b.emplid = emplid
AND b.acad_career = acad_career
AND b.stdnt_car_nbr = stdnt_car_nbr
AND b.adm_appl_nbr = adm_appl_nbr
AND b.appl_prog_nbr = appl_prog_nbr
AND b.effdt = effdt)
AND a.emplid = b.emplid
AND a.acad_career = b.acad_career
AND a.stdnt_car_nbr = b.stdnt_car_nbr
AND a.adm_appl_nbr = b.adm_appl_nbr
AND b.emplid = c.emplid
AND b.acad_career = c.acad_career
AND b.stdnt_car_nbr = c.stdnt_car_nbr
AND b.adm_appl_nbr = c.adm_appl_nbr
AND b.appl_prog_nbr = c.appl_prog_nbr;