UFN_EVENTSTAFFRESOURCE_CONSTITUENTISVALID

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

Return

Return Type
bit

Parameters

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

Definition

Copy



            CREATE function dbo.UFN_EVENTSTAFFRESOURCE_CONSTITUENTISVALID
            (
                @EVENTSTAFFRESOURCEID uniqueidentifier,
                @CONSTITUENTID uniqueidentifier
            )
            returns bit
            as begin
                declare @FILLEDBYCODE tinyint;
                declare @UPPERBOUND datetime;
                declare @LOWERBOUND datetime;

                select @LOWERBOUND = EVENT.STARTDATETIME,
                        @UPPERBOUND = EVENT.ENDDATETIME,
                        @FILLEDBYCODE = EVENTSTAFFRESOURCE.FILLEDBYCODE
                from dbo.EVENT
                    inner join dbo.EVENTSTAFFRESOURCE
                        on EVENTSTAFFRESOURCE.EVENTID = EVENT.ID
                where EVENTSTAFFRESOURCE.ID = @EVENTSTAFFRESOURCEID

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