USP_DATALIST_INCENTIVELEVELS

List of incentive levels.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_INCENTIVELEVELS(
@EVENTID uniqueidentifier,
@TYPECODE tinyint = null
)
as
    set nocount on;

    select FIL.ID,
           FIL.NAME,
           FIL.DESCRIPTION,
       dbo.UDA_BUILDLIST(B.NAME) as BENEFITS,
           FIL.MAXIMUMAMOUNT,      
       FIL.TYPE
    from dbo.FAFINCENTIVELEVEL FIL(nolock) 
  left join dbo.FAFINCENTIVELEVELBENEFIT FILB (nolock) on FIL.ID = FILB.FAFINCENTIVELEVELID
  left join dbo.BENEFIT B (nolock) on B.ID = FILB.BENEFITID   
    where EVENTID = @EVENTID and TYPECODE = isnull(@TYPECODE,TYPECODE)
  group by FIL.ID, FIL.NAME, FIL.DESCRIPTION, FIL.MAXIMUMAMOUNT, FIL.TYPE
  order by FIL.MAXIMUMAMOUNT