UFN_VALIDYESDECLARATION

Returns whether a constituent has a valid declaration on file with pays tax equal to yes.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@DATE	datetime	IN
@CONSTITUENTID	uniqueidentifier	IN
@DESIGNATIONID	uniqueidentifier	IN
@REGISTRANTID	uniqueidentifier	IN
@MEMBERSHIPID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_VALIDYESDECLARATION(
                @DATE as datetime = null, 
                @CONSTITUENTID as uniqueidentifier = null,
                @DESIGNATIONID as uniqueidentifier = null,
                @REGISTRANTID as uniqueidentifier = null,
                @MEMBERSHIPID as uniqueidentifier = null
            )
            returns bit
            with execute as caller
            as begin
                declare @VALIDYESDECLARATIONEXISTS bit, @VALIDDECLARATIONCODE tinyint

                set @VALIDDECLARATIONCODE = dbo.UFN_VALIDDECLARATION(@DATE, @CONSTITUENTID, @DESIGNATIONID, @REGISTRANTID, @MEMBERSHIPID)
                if @VALIDDECLARATIONCODE = 2
                    set @VALIDYESDECLARATIONEXISTS = 1
                else
                    set @VALIDYESDECLARATIONEXISTS = 0

                return @VALIDYESDECLARATIONEXISTS
            end