UFN_RELATIONSHIP_VALIDCONTACT

Validates whether the spouse record is valid.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@ISCONTACT	bit	IN
@RELATIONSHIPCONSTITUENTID	uniqueidentifier	IN
@RECIPROCALCONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_RELATIONSHIP_VALIDCONTACT(@ISCONTACT bit, @RELATIONSHIPCONSTITUENTID uniqueidentifier, @RECIPROCALCONSTITUENTID uniqueidentifier) returns bit with execute as caller
            AS
            BEGIN

                declare @RELATIONISORGANIZATION bit
                declare @RECIPROCALISORGANIZATION bit

                if @ISCONTACT = 0 begin
                    return 1
                end else begin
                    select @RELATIONISORGANIZATION = ISORGANIZATION from dbo.CONSTITUENT where ID = @RELATIONSHIPCONSTITUENTID;
                    select @RECIPROCALISORGANIZATION = ISORGANIZATION from dbo.CONSTITUENT where ID = @RECIPROCALCONSTITUENTID;

                    if @RELATIONISORGANIZATION <> @RECIPROCALISORGANIZATION 
                        return 1
                    else
                        return 0
                end 

                return 0
            end