UFN_DECLARATION_ISUNIQUE

Validates whether the declaration is unique.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@CONSTITUENTID	uniqueidentifier	IN
@CHARITYCLAIMREFERENCENUMBERID	uniqueidentifier	IN
@DATEFROM	datetime	IN
@DATETO	datetime	IN
@PAYSTAXCODE	tinyint	IN

Definition

Copy



            CREATE function dbo.UFN_DECLARATION_ISUNIQUE
            (
                @CONSTITUENTID uniqueidentifier,
                @CHARITYCLAIMREFERENCENUMBERID uniqueidentifier,
                @DATEFROM datetime,
                @DATETO datetime,
                @PAYSTAXCODE tinyint
            )
            returns bit
            with execute as caller
            as begin
                declare @ISUNIQUE bit
                set @ISUNIQUE = 1

                if exists (
                    select
                        1
                    from
                        dbo.TAXDECLARATION
                    where
                        CONSTITUENTID = @CONSTITUENTID and
                        CHARITYCLAIMREFERENCENUMBERID = @CHARITYCLAIMREFERENCENUMBERID and
                        PAYSTAXCODE <> @PAYSTAXCODE and
                        dbo.UFN_DECLARATIONS_AREDATESOVERLAPPING(@DATEFROM, @DATETO, DECLARATIONSTARTS, DECLARATIONENDS) = 1)
                    set @ISUNIQUE = 0

                return @ISUNIQUE
            end