USP_DATALIST_PARTICIPANTCONTACTMERGEDATA

Returns participant contact merge data by a given registrant

Parameters

Parameter	Parameter Type	Mode	Description
@FAFADDRESSBOOKID	uniqueidentifier	IN	AddressbookID
@EVENTID	uniqueidentifier	IN	EventID

Definition

Copy



CREATE procedure dbo.USP_DATALIST_PARTICIPANTCONTACTMERGEDATA
  (
    @FAFADDRESSBOOKID uniqueidentifier,
    @EVENTID uniqueidentifier
  )
  as
      set nocount on;

declare @PRIORYEAREVENTID uniqueidentifier
select @PRIORYEAREVENTID=PRIORYEAREVENTID from dbo.EVENTEXTENSION WHERE EVENTID = @EVENTID

select 
  ParticipantContactName = CONTACTS.FirstName + ' ' + CONTACTS.LastName
, ParticipantContactFirstName = CONTACTS.FirstName
, ParticipantContactLastName = CONTACTS.LastName
, ParticipantContactDonationAmount = ISNULL(dbo.UFN_REVENUE_GETPARTICIPANTGIVENTOTAL(CONTACTS.CONSTITUENTID,@EVENTID),0)
, ParticipantConatctLastYearDonationAmount = (CASE when @PRIORYEAREVENTID is not null 
                                                        then ISNULL(dbo.UFN_REVENUE_GETPARTICIPANTGIVENTOTAL(CONTACTS.CONSTITUENTID,@PRIORYEAREVENTID),0)
                                                  else 0 end)

, ParticipantContactSuggestedDonationAmount = null
from dbo.ADDRESSBOOKFAF CONTACTS (NOLOCK)
where CONTACTS.ID = @FAFADDRESSBOOKID