UFN_BATCHSPONSORSHIPCONSTITUENTRELATION_ISVALIDBUSINESS

Checks that the RELATIONID points to an organization batch constituent record.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@RELATIONID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_BATCHSPONSORSHIPCONSTITUENTRELATION_ISVALIDBUSINESS(@RELATIONID uniqueidentifier) returns bit
            as
            begin
                declare @result bit;
                set @result = 0
                select @result=1 from dbo.BATCHSPONSORSHIPCONSTITUENT where ID = @RELATIONID and ISORGANIZATION = 1;
                return @result;
            end;