UFN_RATESCALE_GETRATESCALEAPPLICATIONS

        CREATE function dbo.UFN_RATESCALE_GETRATESCALEAPPLICATIONS
        (
            @RATESCALEID uniqueidentifier
        ) returns table
        as
            return
            select
                RATESCALEAPPLICATION.ID,
                RATESCALEAPPLICATION.TYPECODE,
                case RATESCALEAPPLICATION.TYPECODE
                    when 0 then PROGRAM.NAME
                    when 1 then FEE.NAME
                    when 2 then RESOURCE.NAME
                    when 3 then VOLUNTEERTYPE.NAME
                end as NAME,
                RATESCALEAPPLICATION.[PERCENT],
                PROGRAMID,
                FEEID,
                RESOURCEID,
                VOLUNTEERTYPEID,
                RATESCALEAPPLICATION.SEQUENCE
            from
                dbo.RATESCALEAPPLICATION
            left join dbo.PROGRAM on 
                RATESCALEAPPLICATION.PROGRAMID = PROGRAM.ID
            left join dbo.FEE on 
                RATESCALEAPPLICATION.FEEID = FEE.ID
            left join dbo.RESOURCE on 
                RATESCALEAPPLICATION.RESOURCEID = RESOURCE.ID
            left join dbo.VOLUNTEERTYPE on 
                RATESCALEAPPLICATION.VOLUNTEERTYPEID = VOLUNTEERTYPE.ID
            where
                RATESCALEID = @RATESCALEID