AV_ACAD_CHK_VW

(SQL View)
 Index Back

Academic View

Use the Academic view to determine if a constituent has been given a degree either internally, externally, or from legacy data.

SELECT B.INSTITUTION , A.EMPLID , 'Y' FROM PS_HCR_PERSON_I A , PS_INSTITUTION_TBL B WHERE (EMPLID IN ( SELECT A1.EMPLID FROM PS_ACAD_PROG A1 WHERE A1.EMPLID=A.EMPLID) OR EMPLID IN ( SELECT A1.EMPLID FROM PS_AV_LEGACY_DEG A1 WHERE A1.EMPLID=A.EMPLID) OR EMPLID IN ( SELECT A1.EMPLID FROM PS_ACCOMPLISHMENTS A1 WHERE A1.EMPLID=A.EMPLID))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 ACADEMIC_FLG Character(1) VARCHAR2(1) NOT NULL Academic

Y/N Table Edit

Default Value: N