SPB_PROVDR_SRCH

(SQL View)
 Index Back

Provider Search by Supplier

/************************************************************************ ICE#561631002 PRJ117330 New Search view for component SPB_SERV_PROVIDER ************************************************************************/

SELECT A.PERSON_ID , C.OPRID , A.FIRST_NAME , A.LAST_NAME FROM PS_SPB_PERSON_TBL A , PS_SPB_SERVICE_PRV B , PSOPRALIAS C WHERE B.PERSON_ID = A.PERSON_ID AND C.PERSON_ID = B.PROVIDER_CONTACT AND (A.SPRO_PERSON_TYPE = 'SP' OR A.SPRO_PERSON_TYPE = 'PC') AND (B.SP_FUNCTION_TYPE = 'PROV' OR B.SP_FUNCTION_TYPE = 'INDP') AND A.SP_ELIGIBLE_STATUS = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Default Value: NEXT

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name