AV_INT_DEG_LANG

(SQL View)
 Index Back

Internal Degrees Language View

Related Language View of AV_INT_DEG_VW

SELECT A.EMPLID , B.LANGUAGE_CD , I.DESCR , H.DESCR , B.AV_MAJOR1_NAME , C.AV_MAJOR2_NAME , D.AV_MINOR1_NAME , E.AV_MINOR2_NAME FROM PS_ACAD_PROG A LEFT OUTER JOIN PS_AV_PLAN_MAJ1_LN B ON A.EMPLID = B.EMPLID AND A.ACAD_CAREER = B.ACAD_CAREER AND A.STDNT_CAR_NBR = B.STDNT_CAR_NBR AND A.EFFDT = B.EFFDT AND A.EFFSEQ = B.EFFSEQ LEFT OUTER JOIN PS_AV_PLAN_MAJ2_LN C ON A.EMPLID = C.EMPLID AND A.ACAD_CAREER = C.ACAD_CAREER AND A.STDNT_CAR_NBR = C.STDNT_CAR_NBR AND A.EFFDT = C.EFFDT AND A.EFFSEQ = C.EFFSEQ LEFT OUTER JOIN PS_AV_PLAN_MIN1_LN D ON A.EMPLID = D.EMPLID AND A.ACAD_CAREER = D.ACAD_CAREER AND A.STDNT_CAR_NBR = D.STDNT_CAR_NBR AND A.EFFDT = D.EFFDT AND A.EFFSEQ = D.EFFSEQ LEFT OUTER JOIN PS_AV_PLAN_MIN2_LN E ON A.EMPLID = E.EMPLID AND A.ACAD_CAREER = E.ACAD_CAREER AND A.STDNT_CAR_NBR = E.STDNT_CAR_NBR AND A.EFFDT = E.EFFDT AND A.EFFSEQ = E.EFFSEQ LEFT OUTER JOIN PS_ACAD_DEGR F ON (A.EMPLID = F.EMPLID AND B.STDNT_DEGR = F.STDNT_DEGR) LEFT OUTER JOIN PS_AV_DEGDESCRLANG H ON (F.DEGREE = H.DEGREE) , PS_INSTITUTION_TBL G , PS_INSTITUTION_LNG I WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_ACAD_PROG A1 WHERE A.EMPLID = A1.EMPLID AND A.ACAD_CAREER = A1.ACAD_CAREER AND A.STDNT_CAR_NBR = A1.STDNT_CAR_NBR) AND A.EMPLID = F.EMPLID AND B.STDNT_DEGR = F.STDNT_DEGR AND G.INSTITUTION = A.INSTITUTION AND G.EFFDT = ( SELECT MAX(G1.EFFDT) FROM PS_INSTITUTION_TBL G1 WHERE G.INSTITUTION = G1.INSTITUTION AND G1.EFFDT <= A.EFFDT) AND G.EFF_STATUS = 'A' AND G.INSTITUTION = I.INSTITUTION AND G.EFFDT = I.EFFDT

  • Related Language Record for AV_INT_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