AV_LEG_DEG_LANG

(SQL View)
Index Back

Legacy Degrees Language View

Related Language View of AV_LEG_DEG_VW

SELECT A.EMPLID , E.LANGUAGE_CD , D.DESCR , C.DESCR , E.DESCR , F.DESCR , G.DESCR , H.DESCR FROM PS_AV_LEGACY_DEG A LEFT OUTER JOIN PS_MAJOR_TBL_LANG E ON A.AV_MAJOR1_CD = E.MAJOR_CODE LEFT OUTER JOIN PS_MAJOR_TBL_LANG F ON A.AV_MAJOR2_CD = F.MAJOR_CODE LEFT OUTER JOIN PS_MAJOR_TBL_LANG G ON A.AV_MINOR1_CD = G.MAJOR_CODE LEFT OUTER JOIN PS_MAJOR_TBL_LANG H ON A.AV_MINOR2_CD = H.MAJOR_CODE , PS_INSTITUTION_TBL B , PS_ACCOMP_TBL_LANG C , PS_INSTITUTION_LNG D WHERE B.INSTITUTION = A.INSTITUTION AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_INSTITUTION_LNG B1 WHERE B.INSTITUTION = B1.INSTITUTION AND B1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND A.ACCOMPLISHMENT = C.ACCOMPLISHMENT AND B.INSTITUTION = D.INSTITUTION AND B.EFFDT = D.EFFDT

  • Related Language Record for AV_LEG_DEG_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 INSTITUTION_NAME Character(40) VARCHAR2(40) NOT NULL Institution Name
    4 AV_DEGREE_DESCR Character(30) VARCHAR2(30) NOT NULL Description of a degree that was conferred to a person.
    5 AV_MAJOR1_NAME Character(50) VARCHAR2(50) NOT NULL Major1 description of a person
    6 AV_MAJOR2_NAME Character(50) VARCHAR2(50) NOT NULL Major2 description
    7 AV_MINOR1_NAME Character(50) VARCHAR2(50) NOT NULL Minor1 description
    8 AV_MINOR2_NAME Character(50) VARCHAR2(50) NOT NULL Minor2 description