RSF_LE_WF_MGR_V (SQL View)	Index Back
Lead Sales Rep and Manager This view joins the Lead Table with the Worker table to bring back the Lead Sales Rep and the Manager.

RSF_LE_WF_MGR_V

(SQL View)

Lead Sales Rep and Manager

This view joins the Lead Table with the Worker table to bring back the Lead Sales Rep and the Manager.

SELECT DISTINCT B.LEAD_ID , A.PERSON_ID ,B.PERSON_ID FROM PS_RB_WORKER A , PS_RSF_LEAD B , PS_RB_WORKER B2 WHERE (A.PERSON_ID = B2.SUPERVISOR_ID AND B.PERSON_ID = B2.PERSON_ID) OR (A.PERSON_ID = B.PERSON_ID AND B.PERSON_ID = B2.PERSON_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.

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

3 PERSON_ID_OWNER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LEAD_ID	Character(15)	VARCHAR2(15) NOT NULL	Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
2	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
3	PERSON_ID_OWNER	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts