UFN_CONSTITID_MAPFROM_REGISTRANTID
Maps a REGISTRANTID to a ConstituentID
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REGISTRANTID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_CONSTITID_MAPFROM_REGISTRANTID(@REGISTRANTID uniqueidentifier)
returns uniqueidentifier
as
begin
DECLARE @ID uniqueidentifier;
--CR284895-100407 For unnamed guests, map to their host constituent
select
@ID = coalesce(REGISTRANT.CONSTITUENTID, [HOST].[CONSTITUENTID])
from
dbo.REGISTRANT
left join dbo.REGISTRANT [HOST] on REGISTRANT.GUESTOFREGISTRANTID = [HOST].ID
where
REGISTRANT.ID = @REGISTRANTID;
RETURN @ID;
end