UFN_FAFEVENT_GETINCENTIVELEVEL

Get FAF incentive level

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@EVENTID uniqueidentifier IN

Definition

Copy


create function dbo.UFN_FAFEVENT_GETINCENTIVELEVEL(@EVENTID uniqueidentifier)
returns table
  as return 
    select 
      '00000000-0000-0000-0000-000000000000' as ID, 
      ID as COPYSOURCEID, 
      @EVENTID as COPYBATCHGUID, 
      NAME, 
      DESCRIPTION, 
      TYPECODE, 
      MAXIMUMAMOUNT, 
      MAXIMUMRETENTION, 
      MAXIMUMNUMBER
    from dbo.FAFINCENTIVELEVEL
    where 
      EVENTID = @EVENTID