UFN_INTERACTION_GETLOOKUPID

                create function dbo.UFN_INTERACTION_GETLOOKUPID(@ID uniqueidentifier)
                returns nvarchar(100)
                with execute as caller
                as
                begin
                    declare @LOOKUPID nvarchar(100)

                    select @LOOKUPID = LOOKUPID from dbo.INTERACTION where ID = @ID

                    return @LOOKUPID
                end