USP_DATALIST_RATESCALEAPPLICATION

            CREATE procedure dbo.USP_DATALIST_RATESCALEAPPLICATION
            (
                @CONTEXTID uniqueidentifier
            )
            as
                set nocount on;

                select
                    RATESCALEAPPLICATION.ID,
                    RATESCALEAPPLICATION.TYPE,
                    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,
                    cast(isnull(RATESCALEAPPLICATION.[PERCENT],0) as nvarchar(6)) + '%' as [PERCENT]
                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 = @CONTEXTID
                order by RATESCALEAPPLICATION.SEQUENCE