SET QUOTED_IDENTIFIER OFF
GO

create view ujo_proc_eventvu
as

select     eoid,
    stamp,
    evt_num,
    joid,
    job_name,
    box_name,
    AUTOSERV,
    event,
    ev.text eventtxt,
    status,
    s.text statustxt,
    alarm,
    a.text alarmtxt,
    event_time_gmt,
    exit_code,
    que_status,
    que_status_stamp,
    run_num,
    ntry,
    e.text text,
    machine

from    ujo_proc_event e, ujo_intcodes ev, ujo_intcodes s, ujo_intcodes a

where    e.event = ev.code and ev.fld='event'
and    e.status = s.code  and s.fld='status'
and    e.alarm  = a.code and a.fld='alarm'


GO
GRANT SELECT ON  [dbo].[ujo_proc_eventvu] TO [ujoadmin]
GO