UFN_BATCHREVENUECONSTITUENTRELATION_ISVALIDSPOUSE

Checks that the relationid points to a valid batch constituent spouse.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@RELATIONID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_BATCHREVENUECONSTITUENTRELATION_ISVALIDSPOUSE(@RELATIONID uniqueidentifier) returns bit
            as
            begin
                declare @result bit
                set @result = 0
                select @result=1 from dbo.BATCHREVENUECONSTITUENT where ID = @RELATIONID and ISORGANIZATION = 0 and ISGROUP = 0;
                return @result;
            end;