UFN_CONSTITUENT_ISHOUSEHOLD

This function determines whether a group is a household.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



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