USP_DATALIST_CONSTITUENTPROFILEACTIVEPROSPECTTEAM
Displays 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_CONSTITUENTPROFILEACTIVEPROSPECTTEAM
(
@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, 0)
return 1