UFN_REVENUE_GETPARTICIPANTRAISEDTOTAL
Provide participant raised total in a given FAF event
Return
| Return Type |
|---|
| money |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REGISTRANTID | uniqueidentifier | IN | |
| @EVENTID | uniqueidentifier | IN |
Definition
Copy
CREATE function [dbo].[UFN_REVENUE_GETPARTICIPANTRAISEDTOTAL]
(
@REGISTRANTID uniqueidentifier
,@EVENTID uniqueidentifier
)
returns money
with execute as caller
as begin
declare @CONSTITUENTID as uniqueidentifier;
select @CONSTITUENTID = CONSTITUENTID from [REGISTRANT] where ID = @REGISTRANTID
return dbo.UFN_FAFEVENT_GETPARTICIPANTDONATIONSTOTAL(@EVENTID, @CONSTITUENTID)
end