RS_WRK_HON_VW

(SQL View)
 Index Back

Honors View


SELECT A.EMPLID , A.ACCOMPLISHMENT , A.DT_ISSUED , A.MAJOR_CODE ,B.DESCR , A.GRANTOR FROM PS_ACCOMPLISHMENTS A , PS_ACCOMP_TBL B WHERE A.ACCOMPLISHMENT = B.ACCOMPLISHMENT AND B.ACCOMP_CATEGORY = 'HON'

  • Related Language Record: RS_WRK_HON_VWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA

    2 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

    Prompt Table: %RECNAME_EDIT

    3 DT_ISSUED Date(10) DATE Issue Date
    4 MAJOR_CODE Character(10) VARCHAR2(10) NOT NULL Major Code

    Prompt Table: MAJOR_TBL

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 GRANTOR Character(20) VARCHAR2(20) NOT NULL Grantor