UFN_WEALTHPOINT_GETBUILTIN_POLITICALDONATION_SOURCES

Return

Return Type
table

Definition

Copy


            CREATE function dbo.UFN_WEALTHPOINT_GETBUILTIN_POLITICALDONATION_SOURCES(
            ) 
            returns table
            as return
            (
                select
                    null as ID,
                    WEALTHSOURCE.SOURCE
                from
                    dbo.WEALTHSOURCE
                left join dbo.WEALTHSOURCEMAPPING on 
                    WEALTHSOURCE.ID = WEALTHSOURCEMAPPING.WEALTHSOURCEID
                where
                    WEALTHSOURCEMAPPING.WEALTHTABLE='WPPOLITICALDONATION' and
                    WEALTHSOURCE.ISBUILTIN = 1 and
                    WEALTHSOURCE.SOURCE <> 'Federal Election Commission'
            )