USP_DATAFORMTEMPLATE_VIEW_APPEALPROFILE

The load procedure used by the view dataform template "Appeal 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.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(255)	INOUT	Description
@CATEGORY	nvarchar(100)	INOUT	Category
@BUSINESSUNIT	nvarchar(100)	INOUT	Business unit
@STATUS	nvarchar(8)	INOUT	Status
@GOAL	money	INOUT	Goal
@STARTDATE	datetime	INOUT	Start date
@ENDDATE	datetime	INOUT	End date
@ISACTIVE	bit	INOUT	Active
@APPEALREPORT1CODE	nvarchar(100)	INOUT	Report code
@SITE	nvarchar(1024)	INOUT	Site
@MEMBERSHIPPROGRAM	nvarchar(1024)	INOUT	Membership
@GIFTAIDQUALIFICATIONSTATUS	nvarchar(25)	INOUT	Gift Aid status
@BUSINESSUNITS	xml	INOUT	Business units
@BASECURRENCYNAME	nvarchar(110)	INOUT	Currency
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency ID

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_APPEALPROFILE
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @NAME nvarchar(100) = null output,
                @DESCRIPTION nvarchar(255) = null output,                
                @CATEGORY nvarchar(100) = null output,
                @BUSINESSUNIT nvarchar(100) = null output,
                @STATUS nvarchar(8) = null output,
                @GOAL money = null output,
                @STARTDATE datetime = null output,
                @ENDDATE datetime = null output,
                @ISACTIVE bit = null output,
                @APPEALREPORT1CODE nvarchar(100) = null output,
                @SITE nvarchar(1024) = null output,
                @MEMBERSHIPPROGRAM nvarchar(1024) = null output,
                @GIFTAIDQUALIFICATIONSTATUS nvarchar(25) = null output,
                @BUSINESSUNITS xml = null output,
                @BASECURRENCYNAME nvarchar(110) = null output,
                @BASECURRENCYID uniqueidentifier = null output
            )
            as
            begin
                set nocount on;

                set @DATALOADED = 0;

                select
                    @DATALOADED = 1,
                    @NAME = NAME,
                    @DESCRIPTION = DESCRIPTION,                
                    @CATEGORY = dbo.UFN_APPEALCATEGORYCODE_GETDESCRIPTION(APPEAL.APPEALCATEGORYCODEID),
                    @BUSINESSUNIT = dbo.UFN_BUSINESSUNITCODE_GETDESCRIPTION(APPEAL.BUSINESSUNITCODEID),
                    @STATUS = case ISACTIVE when 1 then 'Active' else 'Inactive' end,
                    @GOAL = GOAL,
                    @STARTDATE = STARTDATE,
                    @ENDDATE = ENDDATE,
                    @ISACTIVE = ISACTIVE,
                    @APPEALREPORT1CODE = dbo.UFN_APPEALREPORT1CODE_GETDESCRIPTION(APPEAL.APPEALREPORT1CODEID),
                    @SITE = COALESCE((select [NAME] from dbo.SITE where ID=APPEAL.SITEID), ''),
                    @MEMBERSHIPPROGRAM = COALESCE((select [NAME] from dbo.MEMBERSHIPPROGRAM where ID = APPEAL.MEMBERSHIPPROGRAMID), ''),
                    @BUSINESSUNITS = dbo.UFN_APPEALBUSINESSUNIT_GETBUSINESSUNITS_TOITEMLISTXML(APPEAL.ID),
                    @BASECURRENCYNAME = dbo.UFN_CURRENCY_GETDESCRIPTION(APPEAL.BASECURRENCYID), 
                    @BASECURRENCYID = APPEAL.BASECURRENCYID
                from 
                    dbo.APPEAL
                where
                    ID = @ID;

        --Gift Aid is for UK only

        if dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('9568A6C2-F7AA-45fd-8F54-21FE9654EE2D') = 1
        begin
          set @GIFTAIDQUALIFICATIONSTATUS = dbo.UFN_APPEALQUALIFICATIONSTATUS(@ID)
        end

                return 0
            end