USP_DATALIST_MEMBERSHIPLEVELTERMS

Displays a list of Membership Level Terms.

Parameters

Parameter	Parameter Type	Mode	Description
@MEMBERSHIPLEVELID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_MEMBERSHIPLEVELTERMS
            (
                @MEMBERSHIPLEVELID uniqueidentifier
            )
            as
                set nocount on;

                select 
                    MEMBERSHIPLEVELTERM.ID,
          case  when MEMBERSHIPPROGRAM.PROGRAMTYPECODE = 0 then cast(MEMBERSHIPLEVELTERM.TERMTIMELENGTH as nvarchar(5)) + ' '+ MEMBERSHIPLEVELTERM.TERMLENGTH
                when MEMBERSHIPPROGRAM.PROGRAMTYPECODE = 2 and MEMBERSHIPLEVELTERM.LIFETIMEPAYMENTOPTIONCODE = 0 then  MEMBERSHIPLEVELTERM.LIFETIMEPAYMENTOPTION
                when MEMBERSHIPPROGRAM.PROGRAMTYPECODE = 2 and MEMBERSHIPLEVELTERM.LIFETIMEPAYMENTOPTIONCODE <> 0 then cast(MEMBERSHIPLEVELTERM.LIFETIMENUMBEROFPAYMENTS as nvarchar(5)) + ' ' + lower(MEMBERSHIPLEVELTERM.LIFETIMEPAYMENTOPTION) + ' payment(s)'
                end as TERM,
                    MEMBERSHIPLEVELTERM.AMOUNT,
                    MEMBERSHIPLEVELTERM.SEQUENCE,
                    MEMBERSHIPLEVELTERM.BASECURRENCYID,
                    MEMBERSHIPLEVELTERM.ISACTIVE,
                    MEMBERSHIPLEVELTERM.LIFETIMEPAYMENTOPTIONCODE,
                    MEMBERSHIPLEVELTERM.LIFETIMENUMBEROFPAYMENTS
                from 
                    dbo.MEMBERSHIPLEVELTERM
                inner join dbo.MEMBERSHIPLEVEL on MEMBERSHIPLEVEL.ID = @MEMBERSHIPLEVELID
                inner join dbo.MEMBERSHIPPROGRAM on MEMBERSHIPLEVEL.MEMBERSHIPPROGRAMID = MEMBERSHIPPROGRAM.ID
                where
                    MEMBERSHIPLEVELTERM.LEVELID = @MEMBERSHIPLEVELID
                order by
                    MEMBERSHIPLEVELTERM.SEQUENCE