UFN_FAFPARTICIPANT_DONORS

Return all donors associated with the current FAF event constituent

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_FAFPARTICIPANT_DONORS
(
     @EVENTID        as uniqueidentifier
    ,@CONSTITUENTID as uniqueidentifier
)
/*
    returns number of donors for a given FAF event participant
*/
returns table
as
return
    select    
         EVENTDONORS.DONORID
        ,EVENTDONORS.CONSTITUENTID AS RECEIVERID
        ,EVENTDONORS.ORIGINALAMOUNT
        ,EVENTDONORS.APPLIEDAMOUNT
        ,DONORS.FIRSTNAME + ' ' + DONORS.KEYNAME as [DONATED BY] 
        ,RECEIVERS.FIRSTNAME + ' ' + RECEIVERS.KEYNAME as [DONATED TO] 
    from    dbo.UFN_EVENT_DONORS(@EVENTID) EVENTDONORS
    inner    join CONSTITUENT (nolock) as DONORS
    on        DONORS.ID = EVENTDONORS.DONORID
    inner    join CONSTITUENT (nolock) as RECEIVERS
    on        RECEIVERS.ID = EVENTDONORS.CONSTITUENTID
    where    CONSTITUENTID = @CONSTITUENTID
    -- Excluding self donors.

    and        EVENTDONORS.DONORID <> EVENTDONORS.CONSTITUENTID;