[dbo].[si_arg_legaldoc_sum

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	12:31:17 PM Sunday, December 05, 2010
Last Modified	11:24:41 PM Monday, January 10, 2011

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

12:31:17 PM Sunday, December 05, 2010

Last Modified

11:24:41 PM Monday, January 10, 2011

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_si_arg_legaldoc_sum_prop: legaldoc_uuid\data_source$	legaldoc_uuid	binary(16)	16
	ext_company	nvarchar(100)	200
	int_company	nvarchar(100)	200
	eff_date	datetime	8
$Indexes IX_si_arg_legaldoc_sum_prop_1: data_source\status\term_date$ $Indexes IX_si_legdoc_prop_1: data_source\status\term_date$	term_date	datetime	8
	description	nvarchar(100)	200
$Indexes IX_si_arg_legaldoc_sum_prop_1: data_source\status\term_date$ $Indexes IX_si_legdoc_prop_1: data_source\status\term_date$	status	nvarchar(255)	510
$Cluster Primary Key PK_si_arg_legaldoc_sum_prop: legaldoc_uuid\data_source$ $Indexes IX_si_arg_legaldoc_sum_prop_1: data_source\status\term_date$ $Indexes IX_si_legdoc_prop_1: data_source\status\term_date$	data_source	nvarchar(128)	256
	vendor	nvarchar(100)	200
	leinact	int	4
	documentidentifier	nvarchar(50)	100
	legaltemplate	nvarchar(50)	100
	costcenter	nvarchar(100)	200
	location	nvarchar(255)	510
	inactive	nvarchar(60)	120

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_si_arg_legaldoc_sum_prop: legaldoc_uuid\data_source$

legaldoc_uuid

binary(16)

ext_company

nvarchar(100)

200

int_company

nvarchar(100)

200

eff_date

datetime

$Indexes IX_si_arg_legaldoc_sum_prop_1: data_source\status\term_date$ $Indexes IX_si_legdoc_prop_1: data_source\status\term_date$

term_date

datetime

description

nvarchar(100)

200

$Indexes IX_si_arg_legaldoc_sum_prop_1: data_source\status\term_date$ $Indexes IX_si_legdoc_prop_1: data_source\status\term_date$

status

nvarchar(255)

510

$Cluster Primary Key PK_si_arg_legaldoc_sum_prop: legaldoc_uuid\data_source$ $Indexes IX_si_arg_legaldoc_sum_prop_1: data_source\status\term_date$ $Indexes IX_si_legdoc_prop_1: data_source\status\term_date$

data_source

nvarchar(128)

256

vendor

nvarchar(100)

200

leinact

int

documentidentifier

nvarchar(50)

100

legaltemplate

nvarchar(50)

100

costcenter

nvarchar(100)

200

location

nvarchar(255)

510

inactive

nvarchar(60)

120

	Name	Columns
$Cluster Primary Key PK_si_arg_legaldoc_sum_prop: legaldoc_uuid\data_source$	PK_si_arg_legaldoc_sum_prop	legaldoc_uuid, data_source
	IX_si_arg_legaldoc_sum_prop_1	data_source, status, term_date
	IX_si_legdoc_prop_1	data_source, status, term_date

Name

Columns

Unique

$Cluster Primary Key PK_si_arg_legaldoc_sum_prop: legaldoc_uuid\data_source$

PK_si_arg_legaldoc_sum_prop

legaldoc_uuid, data_source

IX_si_arg_legaldoc_sum_prop_1

data_source, status, term_date

IX_si_legdoc_prop_1

data_source, status, term_date

Type	Action	Owning Principal
Grant	Delete	aiadmin
Grant	Insert	aiadmin
Grant	Select	aiadmin
Grant	Update	aiadmin
Grant	Select	aipublic

Type

Action

Owning Principal

Grant

Delete

aiadmin

Grant

Insert

aiadmin

Grant

Select

aiadmin

Grant

Update

aiadmin

Grant

Select

aipublic

SQL Script

CREATE TABLE [dbo].[si_arg_legaldoc_sum_prop]
(
[legaldoc_uuid] [binary] (16) NOT NULL,
[ext_company] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[int_company] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[eff_date] [datetime] NULL,
[term_date] [datetime] NULL,
[description] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[status] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[data_source] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[vendor] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[leinact] [int] NULL,
[documentidentifier] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[legaltemplate] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[costcenter] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[location] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[inactive] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[si_arg_legaldoc_sum_prop] ADD CONSTRAINT [PK_si_arg_legaldoc_sum_prop] PRIMARY KEY CLUSTERED ([legaldoc_uuid], [data_source]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_si_arg_legaldoc_sum_prop_1] ON [dbo].[si_arg_legaldoc_sum_prop] ([data_source], [status], [term_date]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_si_legdoc_prop_1] ON [dbo].[si_arg_legaldoc_sum_prop] ([data_source], [status], [term_date]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[si_arg_legaldoc_sum_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[si_arg_legaldoc_sum_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[si_arg_legaldoc_sum_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[si_arg_legaldoc_sum_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[si_arg_legaldoc_sum_prop] TO [aipublic]
GO