UFN_BATCHSPONSORSHIPCONSTITUENT_ISHOUSEHOLD

This function determines whether a group is a household.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHSPONSORSHIPCONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_BATCHSPONSORSHIPCONSTITUENT_ISHOUSEHOLD(@BATCHSPONSORSHIPCONSTITUENTID uniqueidentifier)
            returns bit
            begin
                return (select case when (select GROUPTYPECODE from dbo.BATCHSPONSORSHIPCONSTITUENT where ID=@BATCHSPONSORSHIPCONSTITUENTID) = 0 then 1 else 0 end);
            end