USP_DATALIST_PROSPECT_PEOPLELINKCONTACTS
Displays a list of a prospect's PeopleLink contacts.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @WEALTHID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
create procedure dbo.USP_DATALIST_PROSPECT_PEOPLELINKCONTACTS(@WEALTHID uniqueidentifier)
as begin
select
PFC.ID,
PFO.ORGNAME,
PFO.SOURCE,
PFC.FULLNAME,
PFC.RELATIONSHIP,
PFO.LINE1,
PFO.CITY,
PFO.STATE,
PFO.ZIP,
PFO.TICKER
from
dbo.PEOPLELINKCONTACT PFC
inner join dbo.PEOPLELINKORGANIZATION PFO on PFO.ID=PFC.PEOPLELINKORGANIZATIONID
where
PFO.WEALTHID=@WEALTHID
order by
PFO.ORGNAME,
PFC.FULLNAME
end