SPA_EXP_ROS_LVW

(SQL View)
 Index Back

Provider Contact Search

Search View for Expense roster

SELECT A.PERSON_ID ,V.LANGUAGE_CD , A.NAME , V.NAME1 FROM PS_SPB_PERSON_TBL A , PS_SPB_SERVICE_PRV B , PSOPRALIAS C , PS_VENDOR_LANG V WHERE B.PERSON_ID = A.PERSON_ID AND C.PERSON_ID = B.PERSON_ID AND A.SPRO_PERSON_TYPE IN ('SP','PC','BH') AND (B.SP_FUNCTION_TYPE = 'PRCT' OR B.SP_FUNCTION_TYPE = 'PROV' OR B.SP_FUNCTION_TYPE = 'INDP') AND B.VENDOR_SETID = V.SETID AND B.VENDOR_ID = V.VENDOR_ID AND A.USER_ACC_STATUS = '1'

  • Related Language Record for SPA_EXP_ROST_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 NAME Character(50) VARCHAR2(50) NOT NULL Name
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1