USP_IDMAPPER_ORGUNITUSER_TO_APPUSER

CREATE procedure dbo.USP_IDMAPPER_ORGUNITUSER_TO_APPUSER
(
    @SOURCEID nvarchar(136),
    @TARGETID uniqueidentifier output
)
as
    set nocount on;

    if len(@SOURCEID) > 0
    begin
        declare @BINARYSOURCEID varbinary(85) = convert(varbinary(85), @SOURCEID, 1);

        select
            @TARGETID = ID
        from
            dbo.APPUSER
        where
            USERSID = @BINARYSOURCEID;
    end

    return 0;