UFN_DISCOUNT_ISCONSTITUENTMEMBER

Validates whether the constituent holds any membership that is eligible for discount.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_DISCOUNT_ISCONSTITUENTMEMBER
          (
              @CONSTITUENTID uniqueidentifier
          ) 
      returns bit
            with execute as caller
            as begin

              if exists ( select MEMBER.ID
                        from dbo.MEMBER 
                        inner join dbo.MEMBERSHIP on MEMBER.MEMBERSHIPID = MEMBERSHIP.ID 
                        inner join dbo.MEMBERSHIPLEVELTERM on MEMBERSHIP.MEMBERSHIPLEVELTERMID = MEMBERSHIPLEVELTERM.ID
                        where MEMBER.CONSTITUENTID = @CONSTITUENTID 
                            and MEMBER.ISDROPPED = 0 
                            and MEMBERSHIP.STATUSCODE = 0
                  )
                return 1;

              return 0;

      end