UFN_RECURRINGGIFTELIGIBILITY

            CREATE function dbo.UFN_RECURRINGGIFTELIGIBILITY
            (
                @ID uniqueidentifier
            )
            returns nvarchar(30)
            with execute as caller
            as 
            begin
                declare @ELIGIBILITYSTATUSCODE tinyint;
                set @ELIGIBILITYSTATUSCODE = dbo.UFN_RECURRINGGIFTELIGIBILITYSTATUS(@ID);

                if @ELIGIBILITYSTATUSCODE = 2
                    return 'Valid declaration';
                else if @ELIGIBILITYSTATUSCODE = 1
                    return 'Not eligible';

                return 'No valid declaration';
            end