UFN_KPIINSTANCEGOAL_GETYELLOWTARGET
Returns the yellow 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_GETYELLOWTARGET(
@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 @YELLOWTARGET decimal(20,5);
if @GOALAIMTYPECODE = 0
set @YELLOWTARGET = @GOALUPWARDLOWVALUE;
else
set @YELLOWTARGET = @GOALDOWNWARDHIGHVALUE;
return @YELLOWTARGET;
end