USP_RESEARCHGROUPREPORT_PROSPECTMODELINGANDPROPENSITY

Parameters

Parameter Parameter Type Mode Description
@CONSTITUENTID uniqueidentifier IN
@REPORTUSERID nvarchar(128) IN
@ALTREPORTUSERID nvarchar(128) IN
@ISVISIBLE bit IN
@CURRENTAPPUSERID uniqueidentifier IN

Definition

Copy


CREATE procedure dbo.USP_RESEARCHGROUPREPORT_PROSPECTMODELINGANDPROPENSITY
(
    @CONSTITUENTID uniqueidentifier = null,
    @REPORTUSERID nvarchar(128) = null,
    @ALTREPORTUSERID nvarchar(128) = null,
    @ISVISIBLE bit = 1,
  @CURRENTAPPUSERID uniqueidentifier = null
)
as
    set NOCOUNT on;

  if @CURRENTAPPUSERID is null
      set @CURRENTAPPUSERID = dbo.UFN_APPUSER_GETREPORTAPPUSERID(@REPORTUSERID, @ALTREPORTUSERID);

    exec dbo.USP_PROSPECTRESEARCHREPORT_MODELINGPROPENSITY @CONSTITUENTID, @CURRENTAPPUSERID, @ISVISIBLE;