DATAFORMTEMPLATE_VIEW_GRANT

The load procedure used by the view dataform template "Grant 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.
@MINAWARD	money	INOUT	Min award
@MAXAWARD	money	INOUT	Max award
@TITLE	nvarchar(150)	INOUT	Title
@REQUESTED	money	INOUT	Total requested
@AWARDED	money	INOUT	Total awarded
@DESCRIPTION	nvarchar(500)	INOUT	Description
@BASEMINAWARD	money	INOUT	Base Min award
@BASEMAXAWARD	money	INOUT	Base Max award
@BASEREQUESTED	money	INOUT	Base total requested
@BASEAWARDED	money	INOUT	Base total awarded
@BASECURRENCYID	uniqueidentifier	INOUT	Currency
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	Transaction currency
@CURRENCYNAME	nvarchar(110)	INOUT	Currency

Definition

Copy



                CREATE procedure dbo.DATAFORMTEMPLATE_VIEW_GRANT
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @MINAWARD money = null output,
                    @MAXAWARD money = null output,
                    @TITLE nvarchar(150) = null output,
                    @REQUESTED money = null output,
                    @AWARDED money = null output,
                    @DESCRIPTION nvarchar(500) = null output,
                    @BASEMINAWARD money = null output,
                    @BASEMAXAWARD money = null output,
                    @BASEREQUESTED money = null output,
                    @BASEAWARDED money = null output,
                    @BASECURRENCYID uniqueidentifier = null output,
                    @TRANSACTIONCURRENCYID uniqueidentifier = null output,
                    @CURRENCYNAME nvarchar(110) = null output

                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @TITLE = GRANTS.TITLE,
                        @MINAWARD = GRANTS.TRANSACTIONMINAWARD,
                        @MAXAWARD = GRANTS.TRANSACTIONMAXAWARD,
                        @BASEMINAWARD = GRANTS.MINAWARD,
                        @BASEMAXAWARD = GRANTS.MAXAWARD,
                        @BASECURRENCYID = GRANTS.BASECURRENCYID,
                        @TRANSACTIONCURRENCYID = GRANTS.TRANSACTIONCURRENCYID,
                        @BASEREQUESTED = isnull(sum(FUNDINGREQUEST.AMOUNTREQUESTED),0),
                        @BASEAWARDED = isnull(sum(FUNDINGREQUEST.AMOUNTAWARDED), 0),
                        @REQUESTED = isnull(sum(FUNDINGREQUEST.TRANSACTIONAMOUNTREQUESTED), 0),
                        @AWARDED = isnull(sum(FUNDINGREQUEST.TRANSACTIONAMOUNTAWARDED), 0),
                        @DESCRIPTION = GRANTS.DESCRIPTION,
                        @CURRENCYNAME = dbo.UFN_CURRENCY_GETDESCRIPTION(GRANTS.TRANSACTIONCURRENCYID)
                    from 
                        dbo.GRANTS
                        left join dbo.FUNDINGREQUEST on GRANTS.ID = FUNDINGREQUEST.GRANTSID
                    where
                        GRANTS.ID = @ID
                    group by
                        GRANTS.TITLE, GRANTS.TRANSACTIONMINAWARD, GRANTS.TRANSACTIONMAXAWARD, GRANTS.MINAWARD, GRANTS.MAXAWARD, GRANTS.DESCRIPTION, GRANTS.BASECURRENCYID, GRANTS.TRANSACTIONCURRENCYID;

                    return 0;