USP_DATAFORMTEMPLATE_VIEW_APPLICATIONNEWINFO

The load procedure used by the view dataform template "Payment: Application View New Information Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	nvarchar(40)	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.
@APPLIEDTODATE	datetime	INOUT	APPLIEDTODATE
@APPLIEDTOTRANSACTIONTYPECODE	tinyint	INOUT	APPLIEDTOTRANSACTIONTYPECODE
@APPLIEDTOCONSTITUENTID	uniqueidentifier	INOUT	Constituent
@DESIGNATIONS	nvarchar(max)	INOUT	Designations
@CAMPAIGNS	nvarchar(max)	INOUT	Campaigns
@CATEGORYCODEID	uniqueidentifier	INOUT	Revenue category

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_APPLICATIONNEWINFO
                (
                    @ID nvarchar(40),
                    @DATALOADED bit = 0 output,
                    @APPLIEDTODATE datetime = null output,
                    @APPLIEDTOTRANSACTIONTYPECODE tinyint = null output,
                    @APPLIEDTOCONSTITUENTID uniqueidentifier = null output,
                    @DESIGNATIONS nvarchar(max) = null output,
                    @CAMPAIGNS nvarchar(max) = null output,
                    @CATEGORYCODEID uniqueidentifier = null output
                )
                as
                set nocount on;

                declare @APPLICATIONCODE tinyint;
                declare @APPLICATIONID uniqueidentifier;


                set @DATALOADED = 0;
                set @APPLICATIONID = cast(left(@ID, 36) as uniqueidentifier);
                set @APPLICATIONCODE = cast(substring(@ID, 37, 5) as tinyint);

                if @APPLICATIONCODE = 1 --Event

                begin
                    select 
                        @DATALOADED = 1,
                        @APPLIEDTODATE = EVENT.STARTDATE,
                        @APPLIEDTOCONSTITUENTID = REGISTRANT.CONSTITUENTID
                    from dbo.REGISTRANT
                        inner join dbo.EVENT on EVENT.ID = REGISTRANT.EVENTID
                    where REGISTRANT.ID = @APPLICATIONID
                end

                if @APPLICATIONCODE in (2, 3, 6, 7, 8) --Pledge,RG,MGPledge,PlannedGift,Grant award

                begin
                    select 
                        @DATALOADED = 1,
                        @APPLIEDTODATE = REVENUE.DATE,
                        @APPLIEDTOTRANSACTIONTYPECODE = REVENUE.TRANSACTIONTYPECODE,
                        @APPLIEDTOCONSTITUENTID = REVENUE.CONSTITUENTID
                    from dbo.REVENUE
                    where REVENUE.ID = @APPLICATIONID
                end

                select @DESIGNATIONS = dbo.UFN_DESIGNATION_BUILDNAME(DESIGNATIONID)
                from dbo.REVENUESPLIT
                where REVENUEID = @APPLICATIONID and DESIGNATIONID is not null;

                select top 1 @CATEGORYCODEID = GLREVENUECATEGORYMAPPINGID
                from dbo.REVENUECATEGORY
                inner join dbo.REVENUESPLIT on REVENUESPLIT.ID = REVENUECATEGORY.ID
                where REVENUESPLIT.REVENUEID = @APPLICATIONID;

                --select @CAMPAIGNS = dbo.UDA_BUILDLIST(


                if @APPLICATIONCODE = 5 --Membership

                begin
                    select
                        @DATALOADED = 1,
                        @APPLIEDTODATE = REVENUE.DATE,
                        @APPLIEDTOTRANSACTIONTYPECODE = REVENUE.TRANSACTIONTYPECODE,
                        @APPLIEDTOCONSTITUENTID = REVENUE.CONSTITUENTID
                    from dbo.MEMBERSHIP
                    inner join dbo.MEMBERSHIPTRANSACTION on MEMBERSHIP.ID = MEMBERSHIPTRANSACTION.MEMBERSHIPID
                    inner join dbo.REVENUESPLIT on MEMBERSHIPTRANSACTION.REVENUESPLITID = REVENUESPLIT.ID
                    inner join dbo.REVENUE on REVENUESPLIT.REVENUEID = REVENUE.ID
                    where MEMBERSHIP.ID = @APPLICATIONID

                end

                return 0;