DATAFORMTEMPLATE_VIEW_FUNDINGREQUEST

The load procedure used by the view dataform template "Funding Request 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.
@GRANTID	uniqueidentifier	INOUT	Grant ID
@GRANT	nvarchar(150)	INOUT	Grant program
@GRANTORID	uniqueidentifier	INOUT	Grantor ID
@GRANTOR	nvarchar(150)	INOUT	Grantor
@AMOUNTREQUESTED	money	INOUT	Amount requested
@AMOUNTAWARDED	money	INOUT	Amount awarded
@PRIMARYMANAGER	nvarchar(700)	INOUT	Primary manager
@PRIMARYMANAGERID	uniqueidentifier	INOUT	PRIMARYMANAGERID
@SECONDARYMANAGER	nvarchar(700)	INOUT	Secondary manager
@SECONDARYMANAGERID	uniqueidentifier	INOUT	SECONDARYMANAGERID
@COMMENT	nvarchar(500)	INOUT	Comment
@STATUS	nvarchar(250)	INOUT	Status
@DATESUBMITTED	datetime	INOUT	Date submitted
@STAGE	nvarchar(100)	INOUT	Stage
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	Transaction currency

Definition

Copy



                CREATE procedure dbo.DATAFORMTEMPLATE_VIEW_FUNDINGREQUEST
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @GRANTID uniqueidentifier = null output,
                    @GRANT nvarchar(150) = null output,
                    @GRANTORID uniqueidentifier = null output,
                    @GRANTOR nvarchar(150) = null output,
                    @AMOUNTREQUESTED money = null output,
                    @AMOUNTAWARDED money = null output,
                    @PRIMARYMANAGER nvarchar(700) = null output,
                    @PRIMARYMANAGERID uniqueidentifier = null output,
                    @SECONDARYMANAGER nvarchar(700) = null output,
                    @SECONDARYMANAGERID uniqueidentifier = null output,
                    @COMMENT nvarchar(500) = null output,
                    @STATUS nvarchar(250) = null output,
                    @DATESUBMITTED datetime = null output,
                    @STAGE nvarchar(100) = null output,
                    @TRANSACTIONCURRENCYID uniqueidentifier = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @GRANTID = GRANTS.ID,
                        @GRANT = GRANTS.TITLE,
                        @GRANTORID = GRANTS.GRANTORID,
                        @GRANTOR = dbo.UFN_CONSTITUENT_BUILDNAME(GRANTS.GRANTORID),
                        @AMOUNTREQUESTED = FUNDINGREQUEST.TRANSACTIONAMOUNTREQUESTED,
                        @AMOUNTAWARDED = FUNDINGREQUEST.TRANSACTIONAMOUNTAWARDED,
                        @PRIMARYMANAGER = PRIMARYMANAGER_NF.NAME,
                        @PRIMARYMANAGERID = FUNDINGREQUEST.PRIMARYMANAGERID,
                        @SECONDARYMANAGER = SECONDARYMANAGER_NF.NAME,
                        @SECONDARYMANAGERID = FUNDINGREQUEST.SECONDARYMANAGERID,
                        @COMMENT = COMMENT,
                        @STATUS = dbo.UFN_FUNDINGREQUESTSTATUSCODE_GETDESCRIPTION(FUNDINGREQUEST.FUNDINGREQUESTSTATUSCODEID),
                        @DATESUBMITTED = FUNDINGREQUEST.DATESUBMITTED,
                        @STAGE = dbo.UFN_FUNDINGREQUESTSTAGECODE_GETDESCRIPTION(FUNDINGREQUESTSTAGECODEID),
                        @TRANSACTIONCURRENCYID = FUNDINGREQUEST.TRANSACTIONCURRENCYID
                    from 
                        dbo.FUNDINGREQUEST
                        inner join dbo.GRANTS on FUNDINGREQUEST.GRANTSID = GRANTS.ID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(FUNDINGREQUEST.PRIMARYMANAGERID) PRIMARYMANAGER_NF
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(FUNDINGREQUEST.SECONDARYMANAGERID) SECONDARYMANAGER_NF
                    where
                        FUNDINGREQUEST.ID = @ID;

                    return 0;