UFN_RE7INTEGRATION_GETCONTRIBUTIONS

This SQL function returns all confirmed Philanthropic Gifts and Campaign Contributions.
Return

Return Type
table
Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN
Definition

Copy


            CREATE function dbo.UFN_RE7INTEGRATION_GETCONTRIBUTIONS(@ID uniqueidentifier)
            returns table
            as
                return
                (
                    (    select
                            ORGANIZATION as ORGANIZATIONNAME,  
                            CVALUE as AMOUNT,
                            cast(GIFTYEAR as nvarchar) as DATEGIVEN,
                            'Philanthropic Gift' as DATASOURCE,
                            MC as MATCHCODE,
                            CNOTES as NOTES,
                            FULLHASH,
                            PARTIALHASH,
                            ID
                        from
                            dbo.WPPHILANTHROPICGIFT
                        where
                            WEALTHID = @ID and
                            CONFIRMED = 1             
                    )union( 
                        select
                            DN_ORGANIZATIONNAME as ORGANIZATIONNAME,  
                            CVALUE as AMOUNT,
                            convert(nvarchar, TRANSACTIONDATE,101) as DATEGIVEN,
                            'Federal Election Commission' as DATASOURCE,
                            MC as MATCHCODE,
                            CNOTES as NOTES,
                            FULLHASH,
                            PARTIALHASH, 
                            ID
                        from
                            dbo.WPPOLITICALDONATION
                        where
                            WEALTHID = @ID and
                            CONFIRMED = 1    
                        )
                );