UFN_ITINERARYSTAFFRESOURCE_CONSTITUENTISVALID

Checks if a constituent is a valid staff or board member for an itinerary staff resource.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@ITINERARYSTAFFRESOURCEID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_ITINERARYSTAFFRESOURCE_CONSTITUENTISVALID
            (
                @ITINERARYSTAFFRESOURCEID uniqueidentifier,
                @CONSTITUENTID uniqueidentifier
            )
            returns bit
            as begin
                declare @FILLEDBYCODE tinyint;
                declare @UPPERBOUND datetime;
                declare @LOWERBOUND datetime;

                select @LOWERBOUND = ITINERARY.STARTDATETIME,
                        @UPPERBOUND = ITINERARY.ENDDATETIME,
                        @FILLEDBYCODE = ITINERARYSTAFFRESOURCE.FILLEDBYCODE
                from dbo.ITINERARY
                    inner join dbo.ITINERARYSTAFFRESOURCE
                        on ITINERARYSTAFFRESOURCE.ITINERARYID = ITINERARY.ID
                where ITINERARYSTAFFRESOURCE.ID = @ITINERARYSTAFFRESOURCEID

                return dbo.UFN_STAFFRESOURCE_CONSTITUENTISVALID(@CONSTITUENTID, @FILLEDBYCODE, @LOWERBOUND, @UPPERBOUND);
            end