UFN_PDACCOUNT_GETFUNDRAISINGPURPOSE_3

            create function dbo.UFN_PDACCOUNT_GETFUNDRAISINGPURPOSE_3
            (
                @REVENUESPLITINFORMATION xml 
            ) returns uniqueidentifier
            As 
            begin
                declare @RESULT as uniqueidentifier;

                -- REVISIT: There are five designation levels, we are currently pulling level one!

                select @RESULT = DESIGNATION.DESIGNATIONLEVEL1ID 
                from dbo.UFN_REVENUESPLITINFORMATION_FROMITEMLISTXML(@REVENUESPLITINFORMATION ) as REVENUESPLITINFORMATION
                    inner join dbo.DESIGNATION
                        on REVENUESPLITINFORMATION.DESIGNATIONID = DESIGNATION.ID;

                return @RESULT;
            end