AV_ACAD_SUMM_VW

(SQL View)
 Index Back

Academic Degree Summary

This view summarizes the academic degrees that a person has earned. It contains one row for any 'type' (Internal, Internal Legacy and External) of degree earned.

SELECT A.EMPLID , A.AV_DEGREE_TYPE , A.AV_INST_ORG_ID , A.AV_YEAR , A.ACCOMPLISHMENT , A.AV_MAJOR1_CD , A.AV_MAJOR2_CD , A.AV_MINOR1_CD , A.AV_MINOR2_CD , A.INSTITUTION_NAME , A.AV_DEGREE_DESCR , A.AV_MAJOR1_NAME , A.AV_MAJOR2_NAME , A.AV_MINOR1_NAME , A.AV_MINOR2_NAME FROM PS_AV_INT_DEG_VW A UNION SELECT B.EMPLID , B.AV_DEGREE_TYPE , B.AV_INST_ORG_ID , B.AV_YEAR , B.ACCOMPLISHMENT , B.AV_MAJOR1_CD , B.AV_MAJOR2_CD , B.AV_MINOR1_CD , B.AV_MINOR2_CD , B.INSTITUTION_NAME , B.AV_DEGREE_DESCR , B.AV_MAJOR1_NAME , B.AV_MAJOR2_NAME , B.AV_MINOR1_NAME , B.AV_MINOR2_NAME FROM PS_AV_LEG_DEG_VW B UNION SELECT C.EMPLID , C.AV_DEGREE_TYPE , C.AV_INST_ORG_ID , C.AV_YEAR , C.ACCOMPLISHMENT , C.AV_MAJOR1_CD , C.AV_MAJOR2_CD , C.AV_MINOR1_CD , C.AV_MINOR2_CD , C.INSTITUTION_NAME , C.AV_DEGREE_DESCR , C.AV_MAJOR1_NAME , C.AV_MAJOR2_NAME , C.AV_MINOR1_NAME , C.AV_MINOR2_NAME FROM PS_AV_EXT_DEG_VW C

  • Related Language Record: AV_ACAD_SUMM_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 AV_DEGREE_TYPE Character(1) VARCHAR2(1) NOT NULL The degree type. Internal, External or legacy.
    E=External Degree
    I=Internal Degree
    L=Legacy Degree
    3 AV_INST_ORG_ID Character(11) VARCHAR2(11) NOT NULL Institution or EXT_ORG_ID container
    4 AV_YEAR Character(6) VARCHAR2(6) NOT NULL Year
    5 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment
    6 AV_MAJOR1_CD Character(10) VARCHAR2(10) NOT NULL Major
    7 AV_MAJOR2_CD Character(10) VARCHAR2(10) NOT NULL Major 2
    8 AV_MINOR1_CD Character(10) VARCHAR2(10) NOT NULL Minor
    9 AV_MINOR2_CD Character(10) VARCHAR2(10) NOT NULL Minor 2
    10 INSTITUTION_NAME Character(40) VARCHAR2(40) NOT NULL Institution Name
    11 AV_DEGREE_DESCR Character(30) VARCHAR2(30) NOT NULL Description of a degree that was conferred to a person.
    12 AV_MAJOR1_NAME Character(50) VARCHAR2(50) NOT NULL Major1 description of a person
    13 AV_MAJOR2_NAME Character(50) VARCHAR2(50) NOT NULL Major2 description
    14 AV_MINOR1_NAME Character(50) VARCHAR2(50) NOT NULL Minor1 description
    15 AV_MINOR2_NAME Character(50) VARCHAR2(50) NOT NULL Minor2 description