DATAFORMTEMPLATE_VIEW_FUNDINGPLAN

The load procedure used by the view dataform template "Funding Plan 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.
@FUNDINGNEED	money	INOUT	Funding need
@TOTALREQUESTED	money	INOUT	Total requested
@TOTALAWARDED	money	INOUT	Total awarded
@SITE	nvarchar(150)	INOUT	Site
@DEPARTMENT	nvarchar(150)	INOUT	Department
@PROGRAM	nvarchar(150)	INOUT	Program
@FUNDINGPLANMANAGERID	uniqueidentifier	INOUT	Funding plan manager ID
@FUNDINGPLANMANAGER	nvarchar(700)	INOUT	Funding plan manager
@DATENEEDED	datetime	INOUT	Date needed
@DESCRIPTION	nvarchar(500)	INOUT	Description
@INACTIVE	bit	INOUT	Inactive
@BASECURRENCYNAME	nvarchar(110)	INOUT	Currency
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency

Definition

Copy



                CREATE procedure dbo.DATAFORMTEMPLATE_VIEW_FUNDINGPLAN
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @FUNDINGNEED money = null output,
                    @TOTALREQUESTED money = null output,
                    @TOTALAWARDED money = null output,
                    @SITE nvarchar(150) = null output,
                    @DEPARTMENT nvarchar(150) = null output,
                    @PROGRAM nvarchar(150) = null output,
                    @FUNDINGPLANMANAGERID uniqueidentifier = null output,
                    @FUNDINGPLANMANAGER nvarchar(700) = null output,
                    @DATENEEDED datetime = null output,
                    @DESCRIPTION nvarchar(500) = null output,
                    @INACTIVE bit = null output,
                    @BASECURRENCYNAME nvarchar(110) = null output,
                    @BASECURRENCYID uniqueidentifier = null output
                )
                as
                    set nocount on;
                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @FUNDINGNEED = FUNDINGPLAN.FUNDINGNEED,
                        @TOTALREQUESTED = sum(FUNDINGREQUEST.AMOUNTREQUESTED),
                        @TOTALAWARDED = sum(FUNDINGREQUEST.AMOUNTAWARDED),
                        @SITE = SITE.NAME,
                        @DEPARTMENT = dbo.UFN_FUNDINGPLANDEPARTMENTCODE_GETDESCRIPTION(FUNDINGPLAN.FUNDINGPLANDEPARTMENTCODEID),
                        @PROGRAM = dbo.UFN_FUNDINGPLANPROGRAMCODE_GETDESCRIPTION(FUNDINGPLAN.FUNDINGPLANPROGRAMCODEID),
                        @FUNDINGPLANMANAGERID = FUNDINGPLAN.FUNDINGPLANMANAGERID,
                        @FUNDINGPLANMANAGER = NF.NAME,
                        @DATENEEDED = FUNDINGPLAN.DATENEEDED,
                        @DESCRIPTION = FUNDINGPLAN.DESCRIPTION,
                        @INACTIVE = FUNDINGPLAN.INACTIVE,
                        @BASECURRENCYNAME = dbo.UFN_CURRENCY_GETDESCRIPTION(FUNDINGPLAN.BASECURRENCYID), 
                        @BASECURRENCYID = FUNDINGPLAN.BASECURRENCYID
                    from 
                        dbo.FUNDINGPLAN
                        left join dbo.FUNDINGREQUEST on FUNDINGPLAN.ID = FUNDINGREQUEST.FUNDINGPLANID
                        left join dbo.SITE on FUNDINGPLAN.SITEID = SITE.ID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(FUNDINGPLAN.FUNDINGPLANMANAGERID) NF
                    where
                        FUNDINGPLAN.ID = @ID
                    group by
                        FUNDINGPLAN.FUNDINGNEED,
                        SITE.NAME, 
                        FUNDINGPLAN.FUNDINGPLANDEPARTMENTCODEID, 
                        FUNDINGPLAN.FUNDINGPLANPROGRAMCODEID,
                        FUNDINGPLAN.FUNDINGPLANMANAGERID,
                        FUNDINGPLAN.DATENEEDED,
                        FUNDINGPLAN.DESCRIPTION,
                        FUNDINGPLAN.INACTIVE,
                        FUNDINGPLAN.BASECURRENCYID,
                        NF.NAME

                    return 0;