SPB_VMS_SC_SPLR

(SQL View)

SELECT DISTINCT VENDOR_ID ,A.PERSON_ID ,A.NAME FROM PS_SPB_PERSON_TBL A ,PS_SPB_SERVICE_COD B WHERE A.PERSON_ID =B.PERSON_ID AND SPRO_PERSON_TYPE IN ('BH','SC', 'PC') AND B.SP_COOD_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 VMS_SUPPLIER_ID Character(10) VARCHAR2(10) NOT NULL VMS Supplier ID
Prompt Table: SPF_VMSBUSUP_VW
Set Control Field: BUSINESS_UNIT

2 RECRUITER Character(15) VARCHAR2(15) NOT NULL Service Coordinator
Prompt Table: SPF_SRVC_CRD_VW

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VMS_SUPPLIER_ID	Character(10)	VARCHAR2(10) NOT NULL	VMS Supplier ID Prompt Table: SPF_VMSBUSUP_VW Set Control Field: BUSINESS_UNIT
2	RECRUITER	Character(15)	VARCHAR2(15) NOT NULL	Service Coordinator Prompt Table: SPF_SRVC_CRD_VW
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name