USP_DATAFORMTEMPLATE_PLANNEDGIFTADDITIONDATALISTVIEWDETAIL

The load procedure used by the view dataform template "Planned Gift Addition Datalist View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@VEHICLECODE	tinyint	INOUT	Planned gift vehicle
@GIFTAMOUNT	money	INOUT	Gift amount
@ISREVOCABLE	bit	INOUT	Revocable
@ISANONYMOUS	bit	INOUT	Anonymous gift
@EXPECTEDMATURITY	UDT_YEAR	INOUT	Expected maturity year
@GIFTDATE	datetime	INOUT	Date
@STATUS	nvarchar(16)	INOUT	Status
@SITES	nvarchar(1024)	INOUT	Site
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	Transaction currency ID
@DESIGNATIONS	xml	INOUT	Designations
@CAMPAIGNS	nvarchar(max)	INOUT	Campaigns

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_PLANNEDGIFTADDITIONDATALISTVIEWDETAIL (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @VEHICLECODE tinyint = null output,
                    @GIFTAMOUNT money = null output,
                    @ISREVOCABLE bit = null output,
                    @ISANONYMOUS bit = null output,
                    @EXPECTEDMATURITY dbo.UDT_YEAR = null output,
                    @GIFTDATE datetime = null output,
                    @STATUS nvarchar(16) = null output,
                    @SITES nvarchar(1024) = null output,
                    @TRANSACTIONCURRENCYID uniqueidentifier = null output,
                    @DESIGNATIONS xml = null output,
                    @CAMPAIGNS nvarchar(max) = null output
                ) as

                    set nocount on;

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @VEHICLECODE = PG.VEHICLECODE,
                        @GIFTAMOUNT = PGA.TRANSACTIONGIFTAMOUNT,
                        @ISREVOCABLE = PG.ISREVOCABLE,
                        @ISANONYMOUS = PG.ISANONYMOUS,
                        @EXPECTEDMATURITY = PG.EXPECTEDMATURITY,
                        @GIFTDATE = PGA.GIFTDATE,
                        @STATUS = PG.STATUS,
                        @SITES = dbo.UFN_PLANNEDGIFT_GETSITELIST(PG.ID),
                        @TRANSACTIONCURRENCYID = PGA.TRANSACTIONCURRENCYID,
                        @CAMPAIGNS = (
                            select dbo.UDA_BUILDLIST(distinct CAMPAIGN.NAME)
                            from dbo.PLANNEDGIFTADDITIONDESIGNATION
                                inner join dbo.PLANNEDGIFTADDITIONDESIGNATIONCAMPAIGN on PLANNEDGIFTADDITIONDESIGNATION.ID = PLANNEDGIFTADDITIONDESIGNATIONCAMPAIGN.PLANNEDGIFTADDITIONDESIGNATIONID
                                inner join dbo.CAMPAIGN on CAMPAIGN.ID = PLANNEDGIFTADDITIONDESIGNATIONCAMPAIGN.CAMPAIGNID
                            where PLANNEDGIFTADDITIONDESIGNATION.PLANNEDGIFTADDITIONID = PGA.ID
                        )
                    from
                        dbo.PLANNEDGIFT PG
                    inner join 
                        dbo.PLANNEDGIFTADDITION PGA on PG.ID = PGA.PLANNEDGIFTID
                    where
                        PGA.ID = @ID;

                    set @DESIGNATIONS = 
                      (select 
                        PLANNEDGIFTADDITIONDESIGNATION.ID,
                        coalesce(DESIGNATION.VANITYNAME, DESIGNATION.NAME) NAME
                        from dbo.PLANNEDGIFTADDITIONDESIGNATION
                      inner join dbo.DESIGNATION on DESIGNATION.ID = PLANNEDGIFTADDITIONDESIGNATION.DESIGNATIONID
                      where PLANNEDGIFTADDITIONDESIGNATION.PLANNEDGIFTADDITIONID = @ID
                      for xml raw('ITEM'),type,elements,root('DESIGNATIONS'),BINARY BASE64)

                    return 0;