USP_DATAFORMTEMPLATE_VIEW_FUNDRAISING_GROUP_DETAILS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@NAME	nvarchar(200)	INOUT
@ORGANIZATIONNAME	nvarchar(200)	INOUT
@TYPEOFGROUP	nvarchar(200)	INOUT
@ORGANIZATIONCONTACT	nvarchar(308)	INOUT
@ALLOWOTHERSJOINFROMGROUPPAGE	bit	INOUT
@ALLOWCOMPANIESJOINFROMGROUPPAGE	bit	INOUT
@ALLOWGROUPSCHOOSEHIERARCHYLEVEL	bit	INOUT
@TOTALREVENUEGOAL	money	INOUT
@TOTALDONORSGOAL	int	INOUT
@PARTICIPANTSRECRECRUITMENTGOAL	int	INOUT
@PARTICIPANTSRETAINEDGOAL	decimal(18, 0)	INOUT
@FAFGROUPSRECRUITMENTGOAL	int	INOUT
@FAFGROUPSRETAINEDGOAL	decimal(18, 0)	INOUT
@COMMUNICATIONSTOSEND	int	INOUT
@RESULTTOTALREVENUEGOAL	money	INOUT
@RESULTTOTALDONORSGOAL	int	INOUT
@RESULTPARTICIPANTSRECRECRUITMENTGOAL	int	INOUT
@RESULTPARTICIPANTSRETAINEDGOAL	decimal(18, 0)	INOUT
@RESULTFAFGROUPSRECRUITMENTGOAL	int	INOUT
@RESULTFAFGROUPSRETAINEDGOAL	decimal(18, 0)	INOUT
@RESULTCOMMUNICATIONSTOSEND	int	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_FUNDRAISING_GROUP_DETAILS
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,


    @NAME nvarchar(200) = null output,
    @ORGANIZATIONNAME nvarchar(200) = null output,
    @TYPEOFGROUP nvarchar(200) = null output,
    @ORGANIZATIONCONTACT nvarchar(308) = null output,
    @ALLOWOTHERSJOINFROMGROUPPAGE bit = null output,
--    @ALLOWOTHERSJOINFROMLOCALWEBSITE bit = NULL output,
    @ALLOWCOMPANIESJOINFROMGROUPPAGE bit = null output,
--    @ALLOWCOMPANIESJOINFROMLOCALWEBSITE bit = null output ,
    @ALLOWGROUPSCHOOSEHIERARCHYLEVEL bit = null output ,
    @TOTALREVENUEGOAL money = null output,
    @TOTALDONORSGOAL int = null output,
    @PARTICIPANTSRECRECRUITMENTGOAL int = null output,
    @PARTICIPANTSRETAINEDGOAL decimal = null output,
    @FAFGROUPSRECRUITMENTGOAL int = null output,
    @FAFGROUPSRETAINEDGOAL decimal = null output,
    @COMMUNICATIONSTOSEND int = null output,
    @RESULTTOTALREVENUEGOAL money = null output,
    @RESULTTOTALDONORSGOAL int = null output,
    @RESULTPARTICIPANTSRECRECRUITMENTGOAL int = null output,
    @RESULTPARTICIPANTSRETAINEDGOAL decimal = null output,
    @RESULTFAFGROUPSRECRUITMENTGOAL int = null output,
    @RESULTFAFGROUPSRETAINEDGOAL decimal = null output,
    @RESULTCOMMUNICATIONSTOSEND  int = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows
    set @DATALOADED = 0;

    -- populate the output parameters, which correspond to fields on the form.  Note that
    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system
    -- will display a "no data loaded" message.
    select @DATALOADED = 1,
           @NAME = a.NAME,
           @ORGANIZATIONNAME = b.KeyName,
           @TYPEOFGROUP = c.DESCRIPTION,
           @ORGANIZATIONCONTACT = d.NAME,
           @ALLOWOTHERSJOINFROMGROUPPAGE = a.ALLOWOTHERSJOINFROMGROUPPAGE,
    --       @ALLOWOTHERSJOINFROMLOCALWEBSITE = a.ALLOWOTHERSJOINFROMLOCALWEBSITE,
           @ALLOWCOMPANIESJOINFROMGROUPPAGE = a.ALLOWCOMPANIESJOINFROMGROUPPAGE,
    --       @ALLOWCOMPANIESJOINFROMLOCALWEBSITE = a.ALLOWCOMPANIESJOINFROMLOCALWEBSITE,
           @ALLOWGROUPSCHOOSEHIERARCHYLEVEL = a.ALLOWGROUPSCHOOSEHIERARCHYLEVEL,
           @TOTALDONORSGOAL = a.TOTALDONORSGOAL,
           @PARTICIPANTSRECRECRUITMENTGOAL = a.PARTICIPANTSRECRECRUITMENTGOAL,
           @PARTICIPANTSRETAINEDGOAL = a.PARTICIPANTSRETAINEDGOAL,
           @TOTALREVENUEGOAL = a.TOTALREVENUEGOAL,
           @RESULTTOTALDONORSGOAL = NFGS.DONORCNT, 
           @RESULTPARTICIPANTSRECRECRUITMENTGOAL = NFGS.TOTALPARTICIPANTS, 
           @RESULTPARTICIPANTSRETAINEDGOAL = 0, 
           @RESULTTOTALREVENUEGOAL = NFGS.TOTALRAISED, 
       @RESULTFAFGROUPSRECRUITMENTGOAL = NFGS.TOTALGROUP,
       @RESULTCOMMUNICATIONSTOSEND = NFGS.COMMSENT,
           @FAFGROUPSRECRUITMENTGOAL = a.FAFGROUPSRECRUITMENTGOAL,
           @FAFGROUPSRETAINEDGOAL = a.FAFGROUPSRETAINEDGOAL,
           @COMMUNICATIONSTOSEND = a.COMMUNICATIONSTOSEND,
       @RESULTFAFGROUPSRETAINEDGOAL = NFGS.GROUPRETENTIONRATE,
       @RESULTPARTICIPANTSRETAINEDGOAL = NFGS.PARTICIPANTRETENTIONRATE
    from dbo.FAFNFGCampaign a (NOLOCK)
  left join dbo.V_NFG_SUMMARYINFO NFGS on NFGS.ID = a.ID
    left join dbo.CONSTITUENT b (NOLOCK)
        ON a.ORGANIZATIONCONSTITUENTID = b.ID
    left join dbo.FAFNFGTYPECODE c
        ON a.NFGTYPECODEID = c.ID
    left join dbo.CONSTITUENT d (NOLOCK)
        on a.CONTACTID = d.ID
    where a.ID = @ID

    return 0;