AVSTFVOLVWLNG

(SQL View)
 Index Back

Volunteers in AV_STAFF

Brings back only volunteers found in the av_staff table.

SELECT A.INSTITUTION , A.STAFF_ID , A.STAFF_TYPE , A.EFFDT , A.LANGUAGE_CD , A.DESCR FROM PS_AV_STAFFLNG A , PS_HCR_PERSON_NM_I B WHERE A.STAFF_ID = B.EMPLID AND A.STAFF_TYPE = 'VOL'

  • Related Language Record for AV_STF_VOL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: AV_OPR_DEF_TBL.INSTITUTION

    Prompt Table: INSTITUTN_SCRTY

    2 STAFF_ID Character(11) VARCHAR2(11) NOT NULL Staff ID
    3 STAFF_TYPE Character(3) VARCHAR2(3) NOT NULL Staff Type
    STF=Staff
    UNT=Unit
    VOL=Volunteer
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description