UFN_REVENUEBATCHREGISTRANT_VALIDCONSTITUENTID

Validates that the registrant is not registered for the event more than once.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@EVENTID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN
@BATCHID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_REVENUEBATCHREGISTRANT_VALIDCONSTITUENTID
            (
                @EVENTID uniqueidentifier = null,
                @CONSTITUENTID uniqueidentifier = null,
                @BATCHID uniqueidentifier = null
            ) 
            returns bit with execute as caller
            as
            begin                
                if @CONSTITUENTID is not null
                    if dbo.UFN_REVENUEBATCHREGISTRANT_GETREGISTRATIONCOUNTFORCONSTITUENTID(@EVENTID, @CONSTITUENTID, @BATCHID) > 1
                        return 0

                return 1
            end