UFN_CONSTITUENT_GETIDFROMAPPUSERID
Returns the constituent ID that is linked to a specific application user id.
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @APPUSERID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_CONSTITUENT_GETIDFROMAPPUSERID
(
@APPUSERID uniqueidentifier
)
returns uniqueidentifier with execute as caller
as
begin
declare @CONSTITUENTID uniqueidentifier
select @CONSTITUENTID = CONSTITUENTID from dbo.APPUSER where APPUSER.ID = @APPUSERID
return @CONSTITUENTID
end