SPA_PRV_PCT_VW (SQL View)	Index Back
Provider/Provider Contact view Provider/Provider Contact view

SPA_PRV_PCT_VW

(SQL View)

Provider/Provider Contact view

SELECT DISTINCT A.PERSON_ID , A.FIRST_NAME , A.LAST_NAME FROM PS_SPB_PERSON_TBL A WHERE A.SPRO_PERSON_TYPE <> 'SC' AND A.USER_ACC_STATUS = '1'

# 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 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

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

#	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	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
3	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name