AVLEGACYDEGVWLN

(SQL View)
 Index Back

Legacy Degree View

View with Descriptive joins for reporting (BIOBIT)

SELECT A.INSTITUTION , A.EMPLID , A.SEQ_NO , B.LANGUAGE_CD , B.DESCR , C.DESCR , D.DESCR , E.DESCR FROM PS_AV_LEGACY_DEG A , PS_INSTITUTION_LNG B , PS_ACCOMP_TBL_LANG C , PS_CAMPUS_LANG D , PS_ACAD_ORG_TBL_LN E WHERE A.INSTITUTION = B.INSTITUTION AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_INSTITUTION_LNG B1 WHERE B1.INSTITUTION = B.INSTITUTION AND B1.EFFDT <= %CurrentDateIn) AND A.ACCOMPLISHMENT = C.ACCOMPLISHMENT AND A.INSTITUTION = D.INSTITUTION AND A.CAMPUS = D.CAMPUS AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_CAMPUS_LANG D1 WHERE D1.INSTITUTION = D.INSTITUTION AND D1.CAMPUS = D.CAMPUS AND D1.EFFDT <= %CurrentDateIn) AND A.INSTITUTION = E.INSTITUTION AND A.ACAD_ORG = E.ACAD_ORG AND E.EFFDT = ( SELECT MAX(E1.EFFDT) FROM PS_ACAD_ORG_TBL_LN E1 WHERE E1.INSTITUTION = E.INSTITUTION AND E1.ACAD_ORG = E.ACAD_ORG AND EFFDT <= %CurrentDateIn)

  • Related Language Record for AV_LEGACYDEG_VW

    • # 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 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    6 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    7 DESCR3 Character(30) VARCHAR2(30) NOT NULL Descr 3
    8 DESCR4 Character(30) VARCHAR2(30) NOT NULL Descr 4