CREATE TABLE [dbo].[jmo_jhr]
(
[jhr_jschd] [char] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[jhr_name] [char] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[jhr_jno] [char] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[jhr_key] [char] (12) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jhr_ws] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jhr_avcpu] [int] NULL,
[jhr_hcnt] [smallint] NULL,
[jhr_erdt] [int] NULL,
[jhr_msdt] [int] NULL,
[jhr_deddt] [int] NULL,
[jhr_adate] [int] NULL,
[jhr_vdate] [int] NULL,
[jhr_sdate] [int] NULL,
[jhr_edate] [int] NULL,
[jhr_ertm] [int] NULL,
[jhr_mstm] [int] NULL,
[jhr_dedtm] [int] NULL,
[jhr_atime] [int] NULL,
[jhr_vtime] [int] NULL,
[jhr_stime] [int] NULL,
[jhr_etime] [int] NULL,
[jhr_relpt] [int] NULL,
[jhr_rcput] [int] NULL,
[jhr_code] [int] NULL,
[jhr_qual] [char] (4) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jhr_stat] [binary] (1) NULL,
[jhr_late] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jhr_cmrun] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jhr_cmhld] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jhr_cmrls] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jhr_cmcnc] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jhr_cmfrc] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jhr_cmstr] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jhr_cmcmp] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jhr_pid] [int] NULL,
[jhr_uxjno] [int] NULL,
[jhr_sysid] [varchar] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jhr_avelp] [int] NULL,
[jhr_qname] [char] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [baseidx_jmo_jhr] ON [dbo].[jmo_jhr] ([jhr_jschd], [jhr_name], [jhr_jno], [jhr_key]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[jmo_jhr] TO [emadmin]
GRANT INSERT ON  [dbo].[jmo_jhr] TO [emadmin]
GRANT DELETE ON  [dbo].[jmo_jhr] TO [emadmin]
GRANT UPDATE ON  [dbo].[jmo_jhr] TO [emadmin]
GRANT SELECT ON  [dbo].[jmo_jhr] TO [emuser]
GRANT SELECT ON  [dbo].[jmo_jhr] TO [jmoadmin]
GRANT INSERT ON  [dbo].[jmo_jhr] TO [jmoadmin]
GRANT DELETE ON  [dbo].[jmo_jhr] TO [jmoadmin]
GRANT UPDATE ON  [dbo].[jmo_jhr] TO [jmoadmin]
GRANT SELECT ON  [dbo].[jmo_jhr] TO [jmouser]
GRANT SELECT ON  [dbo].[jmo_jhr] TO [uniadmin]
GRANT INSERT ON  [dbo].[jmo_jhr] TO [uniadmin]
GRANT DELETE ON  [dbo].[jmo_jhr] TO [uniadmin]
GRANT UPDATE ON  [dbo].[jmo_jhr] TO [uniadmin]
GRANT SELECT ON  [dbo].[jmo_jhr] TO [uniuser]
GO