AVSTAFFST2VWLNG

(SQL View)
 Index Back

Staff members in AV_STAFF

010901 JM Brings back only staff members found in av_staff with effdt and eff_status check. This view replaces the av_staff_stf_vw on the av_account_tbl.staff_id prompt.

SELECT A.INSTITUTION , A.STAFF_ID , A.LANGUAGE_CD , A.DESCR FROM PS_AV_STAFFLNG A ,PS_AV_STAFF D , PS_HCR_PERSON_NM_I B WHERE A.STAFF_ID = B.EMPLID AND A.STAFF_TYPE = 'STF' AND A.EFFDT<=%CurrentDateIn AND D.EFF_STATUS = 'A' AND A. STAFF_ID =D.STAFF_ID AND A.STAFF_TYPE =D.STAFF_TYPE AND A.EFFDT=D.EFFDT

  • Related Language Record for AV_STAFF_ST2_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description