UFN_QUERY_DESIGNATIONLEVEL_GETDONORS

                CREATE function dbo.UFN_QUERY_DESIGNATIONLEVEL_GETDONORS(@DESIGNATIONLEVELID uniqueidentifier)
                returns @DESIGNATIONLEVELDONORS table
                (
                    DESIGNATIONLEVELID uniqueidentifier NOT NULL,
                    CONSTITUENTID uniqueidentifier NOT NULL,
                    REVENUEID uniqueidentifier NOT NULL,
                    DATE datetime NOT NULL, 
                    AMOUNT datetime NOT NULL,
                    ISORIGINALFUNDING bit NOT NULL,
                    ISBENEFACTOR bit NOT NULL                    
                )
                as
                begin
                    insert into @DESIGNATIONLEVELDONORS(DESIGNATIONLEVELID, CONSTITUENTID, REVENUEID, DATE, AMOUNT, ISORIGINALFUNDING, ISBENEFACTOR)
                    select
                        @DESIGNATIONLEVELID,
                        DONORS.CONSTITUENTID,
                        DONORS.REVENUEID,
                        DONORS.DATE,
                        DONORS.AMOUNT,
                        COALESCE(DESIGNATIONLEVELREVENUEINFORMATION.ISORIGINALFUNDING, 0) as ISORIGINALFUNDING,
                        COALESCE(DESIGNATIONLEVELDONORINFORMATION.ISBENEFACTOR, 0) as ISBENEFACTOR
                    from dbo.UFN_DESIGNATIONLEVEL_GETDONORS(@DESIGNATIONLEVELID, null, null) DONORS 
                        left outer join dbo.DESIGNATIONLEVELDONORINFORMATION on DESIGNATIONLEVELDONORINFORMATION.CONSTITUENTID = DONORS.CONSTITUENTID
                        left outer join dbo.DESIGNATIONLEVELREVENUEINFORMATION on DESIGNATIONLEVELREVENUEINFORMATION.REVENUEID = DONORS.REVENUEID and DESIGNATIONLEVELREVENUEINFORMATION.DESIGNATIONLEVELID = @DESIGNATIONLEVELID

                    return;
                end