UFN_NOTIFICATION_CONSTITID_MAPFROM_REGISTRANTID

Maps a REGISTRANTID to a ConstituentID for notifications

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@REGISTRANTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_NOTIFICATION_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