UFN_REVENUE_GETSPLITS

            CREATE function dbo.UFN_REVENUE_GETSPLITS
            (
                @REVENUEID uniqueidentifier
            )
            returns table            
            AS            
            return 
                (
                    select 
                        REVENUESPLIT.ID,
                        REVENUESPLIT.APPLICATIONCODE,
                        REVENUESPLIT.TYPECODE,
                        REVENUESPLIT.AMOUNT,
                        REVENUESPLIT.DESIGNATIONID,
                        REVENUECATEGORY.GLREVENUECATEGORYMAPPINGID CATEGORYCODEID,
                        coalesce(REVENUESPLITGIFTAID.DECLINESGIFTAID, cast(0 as bit)) as DECLINESGIFTAID,
            coalesce(REVENUESPLITGIFTAID.ISSPONSORSHIP, cast(0 as bit)) as ISGIFTAIDSPONSORSHIP
                    from 
                        dbo.REVENUESPLIT 
                    left outer join dbo.REVENUECATEGORY 
                        on REVENUECATEGORY.ID = REVENUESPLIT.ID
                    left outer join dbo.REVENUESPLITGIFTAID
                        on REVENUESPLITGIFTAID.ID = REVENUESPLIT.ID
                    where 
                        REVENUEID = @REVENUEID
                );