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