[dbo].[jmo

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

	Name	Data Type	Max Length (Bytes)
$Cluster Key baseidx_jmo_trg: trg_trev\trg_trid$	trg_trev	char(9)	9
$Cluster Key baseidx_jmo_trg: trg_trev\trg_trid$	trg_trid	char(65)	65
	trg_apc7	varchar(9)	9
	trg_desc	varchar(255)	255
	trg_jnam	varchar(65)	65
	trg_usid	varchar(33)	33
	trg_stan	varchar(21)	21
	trg_faill	int	4
	trg_failh	int	4
	trg_file	varchar(255)	255
	trg_ustat	char(2)	2
	trg_skip	varchar(5)	5
	trg_jobn	varchar(5)	5
	trg_scdn	varchar(65)	65
	trg_estar	varchar(8)	8
	trg_efend	varchar(8)	8
	trg_qnam	char(2)	2
	trg_bklog	char(2)	2
	trg_cal	varchar(9)	9
	trg_auto	char(2)	2
	trg_recs1	char(2)	2
	trg_ccal	varchar(9)	9
	trg_cri	varchar(255)	255
	trg_hact	char(2)	2
	trg_nwact	char(2)	2
	trg_cadj	varchar(5)	5

	Name	Columns	Unique
$Cluster Key baseidx_jmo_trg: trg_trev\trg_trid$	baseidx_jmo_trg	trg_trev, trg_trid

Type	Action	Owning Principal
Grant	Insert	jmoadmin
Grant	Delete	uniadmin
Grant	Insert	uniadmin
Grant	Delete	emadmin
Grant	Insert	emadmin
Grant	Delete	jmoadmin
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_trg]
(
[trg_trev] [char] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[trg_trid] [char] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[trg_apc7] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trg_desc] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trg_jnam] [varchar] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trg_usid] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trg_stan] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trg_faill] [int] NULL,
[trg_failh] [int] NULL,
[trg_file] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trg_ustat] [char] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trg_skip] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trg_jobn] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trg_scdn] [varchar] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trg_estar] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trg_efend] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trg_qnam] [char] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trg_bklog] [char] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trg_cal] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trg_auto] [char] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trg_recs1] [char] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trg_ccal] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trg_cri] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trg_hact] [char] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trg_nwact] [char] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trg_cadj] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [baseidx_jmo_trg] ON [dbo].[jmo_trg] ([trg_trev], [trg_trid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[jmo_trg] TO [emadmin]
GRANT INSERT ON  [dbo].[jmo_trg] TO [emadmin]
GRANT DELETE ON  [dbo].[jmo_trg] TO [emadmin]
GRANT UPDATE ON  [dbo].[jmo_trg] TO [emadmin]
GRANT SELECT ON  [dbo].[jmo_trg] TO [emuser]
GRANT SELECT ON  [dbo].[jmo_trg] TO [jmoadmin]
GRANT INSERT ON  [dbo].[jmo_trg] TO [jmoadmin]
GRANT DELETE ON  [dbo].[jmo_trg] TO [jmoadmin]
GRANT UPDATE ON  [dbo].[jmo_trg] TO [jmoadmin]
GRANT SELECT ON  [dbo].[jmo_trg] TO [jmouser]
GRANT SELECT ON  [dbo].[jmo_trg] TO [uniadmin]
GRANT INSERT ON  [dbo].[jmo_trg] TO [uniadmin]
GRANT DELETE ON  [dbo].[jmo_trg] TO [uniadmin]
GRANT UPDATE ON  [dbo].[jmo_trg] TO [uniadmin]
GRANT SELECT ON  [dbo].[jmo_trg] TO [uniuser]
GO