UFN_ADDRESS_GETINFOSOURCE

                create function dbo.UFN_ADDRESS_GETINFOSOURCE(@ID uniqueidentifier) returns uniqueidentifier with execute as caller
                    as
                    begin
                        declare @RETVAL uniqueidentifier;

                        select @RETVAL = INFOSOURCECODEID from dbo.ADDRESSVALIDATIONUPDATE where ID = @ID;

                        return @RETVAL;
                    end