UFN_PDACCOUNT_GETPURPOSECATEGORY_3

            create function dbo.UFN_PDACCOUNT_GETPURPOSECATEGORY_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 = DESIGNATIONLEVEL.DESIGNATIONLEVELCATEGORYCODEID
                from dbo.UFN_REVENUESPLITINFORMATION_FROMITEMLISTXML(@REVENUESPLITINFORMATION) as REVENUESPLITINFORMATION
                    inner join DESIGNATION
                        on DESIGNATION.ID = REVENUESPLITINFORMATION.DESIGNATIONID
                    inner join DESIGNATIONLEVEL
                        on DESIGNATION.DESIGNATIONLEVEL1ID = DESIGNATIONLEVEL.ID;

                return @RESULT;
            end