UFN_CREDIT_REFUND_GETITEMDESCRIPTION

CREATE function dbo.UFN_CREDIT_REFUND_GETITEMDESCRIPTION
(
    @REVENUESPLITID uniqueidentifier
)
returns nvarchar(150)
with execute as caller
as 
begin

    declare @DESCRIPTION nvarchar(150) = '';

    select
        @DESCRIPTION = REVENUESPLIT.APPLICATION + ' - ' +
            case REVENUESPLIT.APPLICATIONCODE
                when 0 then (select NAME from dbo.DESIGNATION where ID = REVENUESPLIT.DESIGNATIONID)
                when 1 then (
                        select 
                            EVENT.NAME
                        from dbo.EVENTREGISTRANTPAYMENT 
                        inner join dbo.REGISTRANT 
                            on EVENTREGISTRANTPAYMENT.REGISTRANTID = REGISTRANT.ID 
                        inner join dbo.EVENT
                            on REGISTRANT.EVENTID = EVENT.ID
                        where EVENTREGISTRANTPAYMENT.PAYMENTID = REVENUESPLIT.ID
                    )
                when 5 then (
                        select
                            MEMBERSHIPLEVEL.NAME + ' - ' + MEMBERSHIPTRANSACTION.ACTION
                        from dbo.MEMBERSHIPTRANSACTION 
                        inner join dbo.MEMBERSHIPLEVEL
                            on MEMBERSHIPTRANSACTION.MEMBERSHIPLEVELID = MEMBERSHIPLEVEL.ID
                        where REVENUESPLITID = REVENUESPLIT.ID
                    )
            end
    from
        dbo.REVENUESPLIT
    left outer join dbo.MEMBERSHIPTRANSACTION
        on REVENUESPLIT.ID = MEMBERSHIPTRANSACTION.REVENUESPLITID
    left outer join dbo.EVENTREGISTRANTPAYMENT
        on REVENUESPLIT.ID = EVENTREGISTRANTPAYMENT.PAYMENTID
    where
        REVENUESPLIT.ID = @REVENUESPLITID;

    return @DESCRIPTION;
end