AVSTFPRPSVWLNG

(SQL View)
 Index Back

AV Staff Purpose View

This view contains all current purpose codes for the selected staff member

SELECT a.institution , a.staff_id , a.purpose_cd , b.effdt , b.LANGUAGE_CD , b.descr , b.descrshort FROM PS_AV_STF_PRPS_TBL a , ps_AV_PRPS_LNG b ,PS_av_prps_tbl c WHERE a.purpose_cd=b.purpose_cd AND c.purpose_type='ASG' AND B.purpose_cd =c.purpose_cd AND B.EFFDT=c.EFFDT

  • Related Language Record for AV_STF_PRPS_VW AV_VOL_PRPS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 STAFF_ID Character(11) VARCHAR2(11) NOT NULL Staff ID
    3 PURPOSE_CD Character(3) VARCHAR2(3) NOT NULL Role
    4 EFFDT Date(10) DATE Effective Date
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description