[dbo].[jmo

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:07:18 AM Wednesday, March 07, 2007
Last Modified	11:10:02 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
$Cluster Key baseidx_jmo_jtrs: sim_key\jtr_scdn\jtr_name\jtr_jno\jtr_qual$	sim_key	char(4)	4
$Cluster Key baseidx_jmo_jtrs: sim_key\jtr_scdn\jtr_name\jtr_jno\jtr_qual$	jtr_scdn	char(65)	65
$Cluster Key baseidx_jmo_jtrs: sim_key\jtr_scdn\jtr_name\jtr_jno\jtr_qual$	jtr_name	char(65)	65
$Cluster Key baseidx_jmo_jtrs: sim_key\jtr_scdn\jtr_name\jtr_jno\jtr_qual$	jtr_jno	char(5)	5
$Cluster Key baseidx_jmo_jtrs: sim_key\jtr_scdn\jtr_name\jtr_jno\jtr_qual$	jtr_qual	char(5)	5
	jtr_ows	varchar(21)	21
	jtr_ws	varchar(21)	21
	jtr_subu	varchar(33)	33
	jtr_subfile	varchar(255)	255
	jtr_abscd	varchar(65)	65
	jtr_avgtb	int	4
	jtr_any	binary(1)	1
	jtr_uxjno	int	4
	jtr_erly	int	4
	jtr_must	int	4
	jtr_dedln	int	4
	jtr_mxtim	int	4
	jtr_avgt	int	4
	jtr_flg1	binary(1)	1
	jtr_bklog	binary(1)	1
	jtr_sutyp	binary(1)	1
	jtr_wstyp	char(1)	1
	jtr_desc	varchar(255)	255
	jtr_newpr	char(2)	2
	jtr_histc	smallint	2
	jtr_fordate	int	4
	jtr_erdt	int	4
	jtr_mudt	int	4
	jtr_dedt	int	4
	jtr_mxdt	int	4
	jtr_adate	int	4
	jtr_vdate	int	4
	jtr_sdate	int	4
	jtr_edate	int	4
	jtr_pdate	int	4
	jtr_atime	int	4
	jtr_vtime	int	4
	jtr_stime	int	4
	jtr_etime	int	4
	jtr_ptime	int	4
	jtr_dprty	int	4
	jtr_comp	int	4
	jtr_cput	int	4
	jtr_pid	int	4
	jtr_cc	varchar(9)	9
	jtr_hstat	binary(1)	1
	jtr_rstat	binary(1)	1
	jtr_flg3	binary(1)	1
	jtr_flg4	binary(1)	1
	jtr_flg5	binary(1)	1
	jtr_flg6	binary(1)	1
	jtr_cmrun	varchar(33)	33
	jtr_cmhld	varchar(33)	33
	jtr_cmrls	varchar(33)	33
	jtr_cmcnc	varchar(33)	33
	jtr_cmfrc	varchar(33)	33
	jtr_cmstr	varchar(33)	33
	jtr_cmcmp	varchar(33)	33
	jtr_luser	varchar(33)	33
	jtr_cal	varchar(9)	9
	jtr_cmsub	varchar(33)	33
	jtr_abcnt	int	4
	jtr_alias	varchar(65)	65
	jtr_nodea	varchar(65)	65
	jtr_emsg	char(4)	4
	jtr_faill	int	4
	jtr_failh	int	4
	jtr_subp	varchar(15)	15
	jtr_domain	varchar(16)	16
	jtr_cycle	char(1)	1
	jtr_freq	int	4
	jtr_count	int	4
	jtr_qname	char(1)	1
	jtr_can	char(1)	1

	Name	Columns	Unique
$Cluster Key baseidx_jmo_jtrs: sim_key\jtr_scdn\jtr_name\jtr_jno\jtr_qual$	baseidx_jmo_jtrs	sim_key, jtr_scdn, jtr_name, jtr_jno, jtr_qual

Type	Action	Owning Principal
Grant	Delete	emadmin
Grant	Insert	emadmin
Grant	Delete	jmoadmin
Grant	Insert	jmoadmin
Grant	Delete	uniadmin
Grant	Insert	uniadmin
Grant	Select	emadmin
Grant	Update	emadmin
Grant	Select	emuser
Grant	Select	jmoadmin
Grant	Update	jmoadmin
Grant	Select	jmouser
Grant	Select	uniadmin
Grant	Update	uniadmin
Grant	Select	uniuser

SQL Script

CREATE TABLE [dbo].[jmo_jtrs]
(
[sim_key] [char] (4) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[jtr_scdn] [char] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[jtr_name] [char] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[jtr_jno] [char] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[jtr_qual] [char] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[jtr_ows] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_ws] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_subu] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_subfile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_abscd] [varchar] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_avgtb] [int] NULL,
[jtr_any] [binary] (1) NULL,
[jtr_uxjno] [int] NULL,
[jtr_erly] [int] NULL,
[jtr_must] [int] NULL,
[jtr_dedln] [int] NULL,
[jtr_mxtim] [int] NULL,
[jtr_avgt] [int] NULL,
[jtr_flg1] [binary] (1) NULL,
[jtr_bklog] [binary] (1) NULL,
[jtr_sutyp] [binary] (1) NULL,
[jtr_wstyp] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_desc] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_newpr] [char] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_histc] [smallint] NULL,
[jtr_fordate] [int] NULL,
[jtr_erdt] [int] NULL,
[jtr_mudt] [int] NULL,
[jtr_dedt] [int] NULL,
[jtr_mxdt] [int] NULL,
[jtr_adate] [int] NULL,
[jtr_vdate] [int] NULL,
[jtr_sdate] [int] NULL,
[jtr_edate] [int] NULL,
[jtr_pdate] [int] NULL,
[jtr_atime] [int] NULL,
[jtr_vtime] [int] NULL,
[jtr_stime] [int] NULL,
[jtr_etime] [int] NULL,
[jtr_ptime] [int] NULL,
[jtr_dprty] [int] NULL,
[jtr_comp] [int] NULL,
[jtr_cput] [int] NULL,
[jtr_pid] [int] NULL,
[jtr_cc] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_hstat] [binary] (1) NULL,
[jtr_rstat] [binary] (1) NULL,
[jtr_flg3] [binary] (1) NULL,
[jtr_flg4] [binary] (1) NULL,
[jtr_flg5] [binary] (1) NULL,
[jtr_flg6] [binary] (1) NULL,
[jtr_cmrun] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_cmhld] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_cmrls] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_cmcnc] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_cmfrc] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_cmstr] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_cmcmp] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_luser] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_cal] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_cmsub] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_abcnt] [int] NULL,
[jtr_alias] [varchar] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_nodea] [varchar] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_emsg] [char] (4) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_faill] [int] NULL,
[jtr_failh] [int] NULL,
[jtr_subp] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_domain] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_cycle] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_freq] [int] NULL,
[jtr_count] [int] NULL,
[jtr_qname] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jtr_can] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [baseidx_jmo_jtrs] ON [dbo].[jmo_jtrs] ([sim_key], [jtr_scdn], [jtr_name], [jtr_jno], [jtr_qual]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[jmo_jtrs] TO [emadmin]
GRANT INSERT ON  [dbo].[jmo_jtrs] TO [emadmin]
GRANT DELETE ON  [dbo].[jmo_jtrs] TO [emadmin]
GRANT UPDATE ON  [dbo].[jmo_jtrs] TO [emadmin]
GRANT SELECT ON  [dbo].[jmo_jtrs] TO [emuser]
GRANT SELECT ON  [dbo].[jmo_jtrs] TO [jmoadmin]
GRANT INSERT ON  [dbo].[jmo_jtrs] TO [jmoadmin]
GRANT DELETE ON  [dbo].[jmo_jtrs] TO [jmoadmin]
GRANT UPDATE ON  [dbo].[jmo_jtrs] TO [jmoadmin]
GRANT SELECT ON  [dbo].[jmo_jtrs] TO [jmouser]
GRANT SELECT ON  [dbo].[jmo_jtrs] TO [uniadmin]
GRANT INSERT ON  [dbo].[jmo_jtrs] TO [uniadmin]
GRANT DELETE ON  [dbo].[jmo_jtrs] TO [uniadmin]
GRANT UPDATE ON  [dbo].[jmo_jtrs] TO [uniadmin]
GRANT SELECT ON  [dbo].[jmo_jtrs] TO [uniuser]
GO