USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTMEMBERSHIP_BENEFIT

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@VALUE	money	INOUT
@BASECURRENCYID	uniqueidentifier	INOUT
@CATEGORY	nvarchar(100)	INOUT
@DESCRIPTION	nvarchar(255)	INOUT
@SENDWHEN	nvarchar(10)	INOUT
@SITE	nvarchar(250)	INOUT
@DETAILS	nvarchar(255)	INOUT

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTMEMBERSHIP_BENEFIT
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @VALUE money = null output,
                    @BASECURRENCYID uniqueidentifier = null output,
                    @CATEGORY nvarchar(100) = null output,
                    @DESCRIPTION nvarchar(255) = null output,
                    @SENDWHEN nvarchar(10) = null output,
                    @SITE nvarchar(250) = null output,
                    @DETAILS nvarchar(255) = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @VALUE = RB.TOTALVALUE,
                        @BASECURRENCYID = RB.BASECURRENCYID,
                        @CATEGORY = BCC.DESCRIPTION,
                        @DESCRIPTION = B.DESCRIPTION,
                        @SENDWHEN = B.SENDBENEFIT,
                        @SITE = S.NAME,
                        @DETAILS = RB.DETAILS
                    from dbo.REVENUEBENEFIT RB
                        inner join dbo.BENEFIT B on RB.BENEFITID = B.ID
                        left join dbo.BENEFITCATEGORYCODE BCC on B.BENEFITCATEGORYCODEID = BCC.ID
                        left join dbo.BENEFITSITE BS on BS.BENEFITID = B.ID
                        left join dbo.SITE S on BS.SITEID = S.ID
                    where RB.ID = @ID

                    return 0;