UFN_ITINERARYITEM_GETSTAFFRESOURCES

Returns the staff resources associated with a given itinerary item.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ITINERARYITEMID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_ITINERARYITEM_GETSTAFFRESOURCES
        (
            @ITINERARYITEMID uniqueidentifier
        )
        returns table
        as return
            select ITINERARYITEMSTAFFRESOURCE.ID AS ID,
                ITINERARYITEMSTAFFRESOURCE.VOLUNTEERTYPEID,
                ITINERARYITEMSTAFFRESOURCE.JOBID,
                ITINERARYITEMSTAFFRESOURCE.QUANTITYNEEDED,
                ITINERARYITEMSTAFFRESOURCE.FILLEDBYCODE,
                coalesce(JOB.NAME, '') as JOBNAME,
                coalesce(JOB.DESCRIPTION, '') as JOBDESCRIPTION,
                dbo.UFN_JOBOCCURRENCE_GETASSIGNMENTSTRING(ITINERARYITEMSTAFFRESOURCE.JOBOCCURRENCEID) as ASSIGNEDRESOURCES,
                ITINERARYITEMSTAFFRESOURCE.PRICE,
                ITINERARYITEMSTAFFRESOURCE.PRICINGSTRUCTURECODE
            from dbo.ITINERARYITEMSTAFFRESOURCE
                left outer join dbo.JOB
                    on ITINERARYITEMSTAFFRESOURCE.JOBID = JOB.ID
            where ITINERARYITEMSTAFFRESOURCE.ITINERARYITEMID = @ITINERARYITEMID