UFN_ITINERARYSTAFFRESOURCE_GETVOLUNTEERS

Returns the volunteers associated with a given itinerary staff resource.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@JOBOCCURRENCEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_ITINERARYSTAFFRESOURCE_GETVOLUNTEERS
            (
                @JOBOCCURRENCEID uniqueidentifier
            )
            returns table
            as return
                select VOLUNTEERASSIGNMENT.ID,
                        VOLUNTEERASSIGNMENT.VOLUNTEERID,
                        (select top 1 NUMBER
                            from dbo.UFN_CONSTITUENT_GETPHONES(VOLUNTEERASSIGNMENT.VOLUNTEERID)
                            where (ISPRIMARY = 1)) as PRIMARYPHONE,
                        VOLUNTEERASSIGNMENT.DATE
                from dbo.VOLUNTEERASSIGNMENT
                where VOLUNTEERASSIGNMENT.JOBOCCURRENCEID = @JOBOCCURRENCEID