UFN_CONSTITUENTDUPLICATESEARCHSETTINGS_GETAUTOMATCHTHRESHOLD_BYID
Return
| Return Type |
|---|
| decimal(20, 4) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_CONSTITUENTDUPLICATESEARCHSETTINGS_GETAUTOMATCHTHRESHOLD_BYID (
@ID uniqueidentifier
)
returns decimal(20,4)
with execute as caller
as begin
declare @THRESHOLD decimal(20,4)
select @THRESHOLD = AUTOMATCHTHRESHOLD
from dbo.CONSTITUENTDUPLICATESEARCHSETTINGS
where ID = @ID
return @THRESHOLD;
end