UFN_BATCHREVENUECONSTITUENT_ISHOUSEHOLD

This function determines whether a group is a household.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHREVENUECONSTITUENTID	uniqueidentifier	IN

Definition

Copy



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