USP_DATALIST_CONSTITUENTPROFILEPROSPECTTEAMHISTORY
Displays history of prospect manager and prospect team assignments for a prospect/constituent
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONSTITUENTID | uniqueidentifier | IN | |
| @ISVISIBLE | bit | IN |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_CONSTITUENTPROFILEPROSPECTTEAMHISTORY
(
@CONSTITUENTID uniqueidentifier,
@ISVISIBLE bit = 1
)
as
set nocount on;
if @ISVISIBLE = 0
return 0;
select NAME, ROLEDESCRIPTION, DATEFROM, DATETO, ORGANIZATIONALSITE POSITIONSITE
from dbo.UFN_PROSPECTTEAM_SELECT(@CONSTITUENTID, 1) PROSPECT_TEAM
where PROSPECT_TEAM.TIMEFRAME = 'Prior'
return 1