USP_DATAFORMTEMPLATE_PLANNEDGIFTDATALISTVIEWDETAIL

The load procedure used by the view dataform template "Planned Gift 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_PLANNEDGIFTDATALISTVIEWDETAIL (
                    @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 = VEHICLECODE,
                        @GIFTAMOUNT = TRANSACTIONGIFTAMOUNT,
                        @ISREVOCABLE = ISREVOCABLE,
                        @ISANONYMOUS = ISANONYMOUS,
                        @EXPECTEDMATURITY = EXPECTEDMATURITY,
                        @GIFTDATE = GIFTDATE,
                        @STATUS = STATUS,
                        @SITES = dbo.UFN_PLANNEDGIFT_GETSITELIST(PG.ID),
                        @TRANSACTIONCURRENCYID = TRANSACTIONCURRENCYID,
                        @CAMPAIGNS = (
                            select dbo.UDA_BUILDLIST(distinct CAMPAIGN.NAME)
                            from dbo.PLANNEDGIFTDESIGNATION
                                inner join dbo.PLANNEDGIFTDESIGNATIONCAMPAIGN on PLANNEDGIFTDESIGNATION.ID = PLANNEDGIFTDESIGNATIONCAMPAIGN.PLANNEDGIFTDESIGNATIONID
                                inner join dbo.CAMPAIGN on CAMPAIGN.ID = PLANNEDGIFTDESIGNATIONCAMPAIGN.CAMPAIGNID
                            where PLANNEDGIFTDESIGNATION.PLANNEDGIFTID = PG.ID
                        )
                    from
                        dbo.PLANNEDGIFT PG    
                    where
                        PG.ID = @ID;

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

                    return 0;