SPB_PRV_SRCH_VW (SQL View)	Index Back
service provider search record view used as a search record for the service provider component

SPB_PRV_SRCH_VW

(SQL View)

service provider search record

view used as a search record for the service provider component

SELECT A.PERSON_ID , A.VENDOR_SETID , A.VENDOR_ID , B.FIRST_NAME , B.LAST_NAME , A.SP_FUNCTION_TYPE FROM PS_SPB_SERVICE_PRV A , PS_SPB_PERSON_TBL B WHERE B.PERSON_ID = A.PERSON_ID AND (A.SP_FUNCTION_TYPE = 'PROV' OR A.SP_FUNCTION_TYPE = 'INDP') 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)

# 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 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

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

4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

6 SP_FUNCTION_TYPE Character(4) VARCHAR2(4) NOT NULL Function Type
INDP=Independent Provider
PRCT=Provider Contact
PROV=Provider

#	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	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
3	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
4	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
5	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
6	SP_FUNCTION_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Function Type INDP=Independent Provider PRCT=Provider Contact PROV=Provider