UFN_KPIINSTANCEGOAL_GETGREENTARGET
Returns the green target value for a given KPI.
Return
| Return Type |
|---|
| decimal(20, 5) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @GOALAIMTYPECODE | tinyint | IN | |
| @GOALUPWARDLOWVALUE | decimal(20, 5) | IN | |
| @GOALUPWARDMIDVALUE | decimal(20, 5) | IN | |
| @GOALDOWNWARDMIDVALUE | decimal(20, 5) | IN | |
| @GOALDOWNWARDHIGHVALUE | decimal(20, 5) | IN |
Definition
Copy
CREATE function dbo.UFN_KPIINSTANCEGOAL_GETGREENTARGET(
@GOALAIMTYPECODE tinyint,
@GOALUPWARDLOWVALUE decimal(20,5),
@GOALUPWARDMIDVALUE decimal(20,5),
@GOALDOWNWARDMIDVALUE decimal(20,5),
@GOALDOWNWARDHIGHVALUE decimal(20,5)
)
returns decimal(20,5)
with execute as caller
as begin
declare @GREENTARGET decimal(20,5);
if @GOALAIMTYPECODE = 0
set @GREENTARGET = @GOALUPWARDMIDVALUE;
else
set @GREENTARGET = @GOALDOWNWARDMIDVALUE;
return @GREENTARGET;
end