SPB_SPCNT_LOC_V

(SQL View)
 Index Back

Provider & Prov Contact detail

Stores additional information for Providers and Provider Contacts

SELECT A.VENDOR_SETID ,A.VENDOR_ID ,A.LOCATION ,A.PERSON_ID ,B.NAME FROM PS_SPB_SERVICE_PRV A , PS_SPB_PERSON_TBL B WHERE (SP_FUNCTION_TYPE = 'PRCT' OR SP_FUNCTION_TYPE = 'INDP') AND A.PERSON_ID=B.PERSON_ID AND A.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_SPB_SERVICE_PRV D WHERE D.PERSON_ID = A.PERSON_ID AND D.SP_FUNCTION_TYPE = A.SP_FUNCTION_TYPE AND D.EFFDT <= %CurrentDateIn) AND B.USER_ACC_STATUS = '1'

  • Parent record: SPB_PERSON_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

    Prompt Table: SP_SETID_NONVW

    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR_SP_VW3
    Set Control Field: VENDOR_SETID

    3 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: SPB_LOCATION_VW
    Set Control Field: VENDOR_SETID

    4 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

    Prompt Table: SPB_PERSON_TBL

    5 NAME Character(50) VARCHAR2(50) NOT NULL Name