UFN_ITINERARYSTAFFRESOURCE_GETASSIGNMENTS

Returns the board or staff members associated with the itinerary staff resource.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ITINERARYSTAFFRESOURCEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_ITINERARYSTAFFRESOURCE_GETASSIGNMENTS
            (
                @ITINERARYSTAFFRESOURCEID uniqueidentifier
            )
            returns table
            as return
                select ITINERARYSTAFFRESOURCEASSIGNMENT.ID,
                        ITINERARYSTAFFRESOURCEASSIGNMENT.CONSTITUENTID,
                        (select top 1 NUMBER
                            from dbo.UFN_CONSTITUENT_GETPHONES(ITINERARYSTAFFRESOURCEASSIGNMENT.CONSTITUENTID)
                            where (ISPRIMARY = 1)) as PRIMARYPHONE
                from dbo.ITINERARYSTAFFRESOURCEASSIGNMENT
                where ITINERARYSTAFFRESOURCEASSIGNMENT.ITINERARYSTAFFRESOURCEID = @ITINERARYSTAFFRESOURCEID