UFN_RELATIONSHIP_VALIDPRIMARYBUSINESS

Validates whether the primary business record is valid.

Return

Return Type
bit

Parameters

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

Definition

Copy



            create function dbo.UFN_RELATIONSHIP_VALIDPRIMARYBUSINESS(@ISPRIMARYBUSINESS bit, @RELATIONSHIPCONSTITUENTID uniqueidentifier, @RECIPROCALCONSTITUENTID uniqueidentifier) returns bit with execute as caller
            as
            begin

                declare @RELATIONISORGANIZATION bit
                declare @RECIPROCALISORGANIZATION bit

                if @ISPRIMARYBUSINESS = 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