USP_DATAFORMTEMPLATE_VIEW_PAYMENTGRANTAWARD

The load procedure used by the view dataform template "Payment: Grant Award 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.
@TRANSACTIONTYPE	nvarchar(20)	INOUT	Type
@CONSTITUENTNAME	nvarchar(700)	INOUT	Constituent
@DESCRIPTION	nvarchar(700)	INOUT	Description
@GRANTAWARDDATE	datetime	INOUT	Date
@NEXTINSTALLMENTDATE	datetime	INOUT	Amount due
@NEXTINSTALLMENTDUE	money	INOUT	Next installment amount
@AMOUNT	money	INOUT	Grant award amount
@BALANCE	money	INOUT	Grant award balance
@MAXAMOUNT	money	INOUT	MAXAMOUNT
@DESIGNATIONS	nvarchar(3000)	INOUT	Designations
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	Transaction currency ID

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PAYMENTGRANTAWARD
                (
                    @ID uniqueidentifier,    
                    @DATALOADED bit = 0 output,
                    @TRANSACTIONTYPE nvarchar(20) = null output,
                    @CONSTITUENTNAME nvarchar(700) = null output,
                    @DESCRIPTION nvarchar(700) = null output,
                    @GRANTAWARDDATE datetime = null output,
                    @NEXTINSTALLMENTDATE datetime = null output,
                    @NEXTINSTALLMENTDUE money = null output,
                    @AMOUNT money = null output,
                    @BALANCE money = null output,
                    @MAXAMOUNT money = null output,
                    @DESIGNATIONS nvarchar(3000) = null output,
                    @TRANSACTIONCURRENCYID uniqueidentifier = null output
                )
                as
                set nocount on;

                set @DATALOADED = 0;

                select
                    @DATALOADED = 1,
                    @TRANSACTIONTYPE = REVENUE.TRANSACTIONTYPE,
                    @CONSTITUENTNAME = NF.NAME,
                    @GRANTAWARDDATE = REVENUE.DATE,
                    @NEXTINSTALLMENTDATE = NEXTINSTALLMENT.DATE,
                    @NEXTINSTALLMENTDUE = dbo.UFN_INSTALLMENT_GETINSTALLMENTBALANCE(NEXTINSTALLMENT.ID),
                    @AMOUNT = REVENUE.TRANSACTIONAMOUNT,
                    @BALANCE = dbo.UFN_PLEDGE_GETBALANCE(REVENUE.ID),
                    @DESIGNATIONS = dbo.UFN_REVENUE_DESIGNATIONLIST(REVENUE.ID),
                    @TRANSACTIONCURRENCYID = REVENUE.TRANSACTIONCURRENCYID
                from 
                    dbo.REVENUE
                    cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(REVENUE.CONSTITUENTID) NF
                    left join dbo.INSTALLMENT NEXTINSTALLMENT on NEXTINSTALLMENT.ID = dbo.UFN_REVENUE_GETNEXTINSTALLMENT(REVENUE.ID)
                where 
                    REVENUE.ID = @ID;

                set @DESCRIPTION = @CONSTITUENTNAME;

                return 0;