USP_DATALIST_RESERVATIONRATESCALEAPPLICATION

Lists all applications for a rate scale on a reservation.
Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
Definition

Copy


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

                select
                    RESERVATIONRATESCALEAPPLICATION.ID,
                    RESERVATIONRATESCALEAPPLICATION.TYPE,
                    case RESERVATIONRATESCALEAPPLICATION.TYPECODE
                        when 0 then PROGRAM.NAME
                        when 1 then FEE.NAME
                        when 2 then RESOURCE.NAME
                        when 3 then VOLUNTEERTYPE.NAME
                    end as NAME,
                    RESERVATIONRATESCALEAPPLICATION.AMOUNT,
                    case
                        when
                            dbo.UFN_RESERVATIONRATESCALEAPPLICATION_ISDISTRIBUTED(RESERVATIONRATESCALEAPPLICATION.ID) = 1 and
                            dbo.UFN_RESERVATIONRATESCALEAPPLICATION_INCLUDEDINFLATRATE(RESERVATIONRATESCALEAPPLICATION.ID) = 1
                                then 1
                        else 0
                    end as ISAPPLIED,
                    case
                        when dbo.UFN_RESERVATIONRATESCALEAPPLICATION_INCLUDEDINFLATRATE(RESERVATIONRATESCALEAPPLICATION.ID) = 0 then
                            'No - not included in rate scale'
                        when dbo.UFN_RESERVATIONRATESCALEAPPLICATION_ISDISTRIBUTED(RESERVATIONRATESCALEAPPLICATION.ID) = 0 and
                             dbo.UFN_RESERVATIONRATESCALEAPPLICATION_INCLUDEDINFLATRATE(RESERVATIONRATESCALEAPPLICATION.ID) = 1 then
                            'No - not part of an itinerary'
                        else 'Yes' 
                    end as REASON
                from
                    dbo.RESERVATIONRATESCALEAPPLICATION
                left join dbo.PROGRAM on 
                    RESERVATIONRATESCALEAPPLICATION.PROGRAMID = PROGRAM.ID
                left join dbo.FEE on 
                    RESERVATIONRATESCALEAPPLICATION.FEEID = FEE.ID
                left join dbo.RESOURCE on 
                    RESERVATIONRATESCALEAPPLICATION.RESOURCEID = RESOURCE.ID
                left join dbo.VOLUNTEERTYPE on 
                    RESERVATIONRATESCALEAPPLICATION.VOLUNTEERTYPEID = VOLUNTEERTYPE.ID
                where
                    RESERVATIONRATESCALEID = @CONTEXTID