STDNT_WHPCAR_VW

(SQL View)
Index Back

Student What-if Car/Prog View

This view is used internal to the AA COBOL engine to correctly retrieve what-if career and academic programs for a student.

SELECT DISTINCT A.EMPLID ,A.STDNT_CAR_NBR ,A.ACAD_PROG FROM PS_ACAD_PROG_WHIF A WHERE A.ADVIS_STATUS <> 'NINC' AND A.STDNT_CAR_NBR = ( SELECT MIN(D.STDNT_CAR_NBR) FROM PS_ACAD_PROG_WHIF D ) AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_ACAD_PROG_WHIF B WHERE B.EMPLID = A.EMPLID AND B.ACAD_PROG = A.ACAD_PROG AND B.STDNT_CAR_NBR = A.STDNT_CAR_NBR ) AND A.EFFSEQ = ( SELECT MAX(C.EFFSEQ) FROM PS_ACAD_PROG_WHIF C WHERE C.EMPLID = A.EMPLID AND C.ACAD_PROG = A.ACAD_PROG AND C.STDNT_CAR_NBR = A.STDNT_CAR_NBR AND C.EFFDT = A.EFFDT )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
3 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program