UFN_ITINERARY_GETSTAFFRESOURCES

Returns the staff resources associated with a given itinerary.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ITINERARYID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_ITINERARY_GETSTAFFRESOURCES
            (
                @ITINERARYID uniqueidentifier
            )
            returns table
            as return
                select ITINERARYSTAFFRESOURCE.ID AS ID,
                    ITINERARYSTAFFRESOURCE.VOLUNTEERTYPEID,
                    ITINERARYSTAFFRESOURCE.JOBID,
                    ITINERARYSTAFFRESOURCE.QUANTITYNEEDED,
                    ITINERARYSTAFFRESOURCE.FILLEDBYCODE,
                    coalesce(JOB.NAME, '') as JOBNAME,
                    coalesce(JOB.DESCRIPTION, '') as JOBDESCRIPTION,
                    ITINERARYSTAFFRESOURCE.PRICE,
                    ITINERARYSTAFFRESOURCE.PRICINGSTRUCTURECODE
                from dbo.ITINERARYSTAFFRESOURCE
                    inner join dbo.JOB 
                        on ITINERARYSTAFFRESOURCE.JOBID = JOB.ID
                where ITINERARYSTAFFRESOURCE.ITINERARYID = @ITINERARYID