[dbo].[arg_actionlk]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	107
Created	11:06:59 AM Wednesday, March 07, 2007
Last Modified	11:09:31 AM Wednesday, March 07, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

107

Created

11:06:59 AM Wednesday, March 07, 2007

Last Modified

11:09:31 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key XPKarg_actionlk: lkacadid\primary_object_uuid\lkac1ivi\lkacdadt\lkactitm\lkndid\secondary_object_uuid\lk2ivid\lkinstnc$	lkacadid	int	4
$Cluster Primary Key XPKarg_actionlk: lkacadid\primary_object_uuid\lkac1ivi\lkacdadt\lkactitm\lkndid\secondary_object_uuid\lk2ivid\lkinstnc$	primary_object_uuid	binary(16)	16
$Cluster Primary Key XPKarg_actionlk: lkacadid\primary_object_uuid\lkac1ivi\lkacdadt\lkactitm\lkndid\secondary_object_uuid\lk2ivid\lkinstnc$	lkac1ivi	smallint	2
$Cluster Primary Key XPKarg_actionlk: lkacadid\primary_object_uuid\lkac1ivi\lkacdadt\lkactitm\lkndid\secondary_object_uuid\lk2ivid\lkinstnc$	lkacdadt	datetime	8
$Cluster Primary Key XPKarg_actionlk: lkacadid\primary_object_uuid\lkac1ivi\lkacdadt\lkactitm\lkndid\secondary_object_uuid\lk2ivid\lkinstnc$	lkactitm	nvarchar(8)	16
$Cluster Primary Key XPKarg_actionlk: lkacadid\primary_object_uuid\lkac1ivi\lkacdadt\lkactitm\lkndid\secondary_object_uuid\lk2ivid\lkinstnc$	lkndid	smallint	2
$Cluster Primary Key XPKarg_actionlk: lkacadid\primary_object_uuid\lkac1ivi\lkacdadt\lkactitm\lkndid\secondary_object_uuid\lk2ivid\lkinstnc$	secondary_object_uuid	binary(16)	16
$Cluster Primary Key XPKarg_actionlk: lkacadid\primary_object_uuid\lkac1ivi\lkacdadt\lkactitm\lkndid\secondary_object_uuid\lk2ivid\lkinstnc$	lk2ivid	smallint	2
$Cluster Primary Key XPKarg_actionlk: lkacadid\primary_object_uuid\lkac1ivi\lkacdadt\lkactitm\lkndid\secondary_object_uuid\lk2ivid\lkinstnc$	lkinstnc	smallint	2
	primary_object_type	smallint	2
	secondary_object_type	smallint	2
	lkstrtdt	datetime	8
	lkenddt	datetime	8
	lkcommnt	nvarchar(255)	510
	creation_user	nvarchar(64)	128
	creation_date	int	4
	last_update_user	nvarchar(64)	128
	last_update_date	int	4
	version_number	int	4	((0))

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

$Cluster Primary Key XPKarg_actionlk: lkacadid\primary_object_uuid\lkac1ivi\lkacdadt\lkactitm\lkndid\secondary_object_uuid\lk2ivid\lkinstnc$

lkacadid

int

$Cluster Primary Key XPKarg_actionlk: lkacadid\primary_object_uuid\lkac1ivi\lkacdadt\lkactitm\lkndid\secondary_object_uuid\lk2ivid\lkinstnc$

primary_object_uuid

binary(16)

$Cluster Primary Key XPKarg_actionlk: lkacadid\primary_object_uuid\lkac1ivi\lkacdadt\lkactitm\lkndid\secondary_object_uuid\lk2ivid\lkinstnc$

lkac1ivi

smallint

$Cluster Primary Key XPKarg_actionlk: lkacadid\primary_object_uuid\lkac1ivi\lkacdadt\lkactitm\lkndid\secondary_object_uuid\lk2ivid\lkinstnc$

lkacdadt

datetime

$Cluster Primary Key XPKarg_actionlk: lkacadid\primary_object_uuid\lkac1ivi\lkacdadt\lkactitm\lkndid\secondary_object_uuid\lk2ivid\lkinstnc$

lkactitm

nvarchar(8)

$Cluster Primary Key XPKarg_actionlk: lkacadid\primary_object_uuid\lkac1ivi\lkacdadt\lkactitm\lkndid\secondary_object_uuid\lk2ivid\lkinstnc$

lkndid

smallint

$Cluster Primary Key XPKarg_actionlk: lkacadid\primary_object_uuid\lkac1ivi\lkacdadt\lkactitm\lkndid\secondary_object_uuid\lk2ivid\lkinstnc$

secondary_object_uuid

binary(16)

$Cluster Primary Key XPKarg_actionlk: lkacadid\primary_object_uuid\lkac1ivi\lkacdadt\lkactitm\lkndid\secondary_object_uuid\lk2ivid\lkinstnc$

lk2ivid

smallint

$Cluster Primary Key XPKarg_actionlk: lkacadid\primary_object_uuid\lkac1ivi\lkacdadt\lkactitm\lkndid\secondary_object_uuid\lk2ivid\lkinstnc$

lkinstnc

smallint

primary_object_type

smallint

secondary_object_type

smallint

lkstrtdt

datetime

lkenddt

datetime

lkcommnt

nvarchar(255)

510

creation_user

nvarchar(64)

128

creation_date

int

last_update_user

nvarchar(64)

128

last_update_date

int

version_number

int

((0))

	Name	Columns
$Cluster Primary Key XPKarg_actionlk: lkacadid\primary_object_uuid\lkac1ivi\lkacdadt\lkactitm\lkndid\secondary_object_uuid\lk2ivid\lkinstnc$	XPKarg_actionlk	lkacadid, primary_object_uuid, lkac1ivi, lkacdadt, lkactitm, lkndid, secondary_object_uuid, lk2ivid, lkinstnc
	lkindex02	primary_object_uuid
	lkindex03	secondary_object_uuid

Name

Columns

Unique

$Cluster Primary Key XPKarg_actionlk: lkacadid\primary_object_uuid\lkac1ivi\lkacdadt\lkactitm\lkndid\secondary_object_uuid\lk2ivid\lkinstnc$

XPKarg_actionlk

lkacadid, primary_object_uuid, lkac1ivi, lkacdadt, lkactitm, lkndid, secondary_object_uuid, lk2ivid, lkinstnc

lkindex02

primary_object_uuid

lkindex03

secondary_object_uuid

Type	Action	Owning Principal
Grant	Delete	swcmadmin
Grant	Insert	swcmadmin
Grant	Delete	uapmbatch_group
Grant	Insert	uapmbatch_group
Grant	Delete	uapmadmin
Grant	Insert	uapmadmin
Grant	Delete	uapmbatch
Grant	Insert	uapmbatch
Grant	Delete	uapmadmin_group
Grant	Insert	uapmadmin_group
Grant	Select	ca_itrm_group
Grant	Select	uapmadmin_group
Grant	Update	uapmadmin_group
Grant	Select	uapmbatch_group
Grant	Update	uapmbatch_group
Grant	Select	uapmreporting_group
Grant	Select	amsgroup
Grant	Select	ca_itrm_group_ams
Grant	Select	uapmadmin
Grant	Update	uapmadmin
Grant	Select	uapmbatch
Grant	Update	uapmbatch
Grant	Select	uapmreporting
Grant	Select	swcmadmin
Grant	Update	swcmadmin

Type

Action

Owning Principal

Grant

Delete

swcmadmin

Grant

Insert

swcmadmin

Grant

Delete

uapmbatch_group

Grant

Insert

uapmbatch_group

Grant

Delete

uapmadmin

Grant

Insert

uapmadmin

Grant

Delete

uapmbatch

Grant

Insert

uapmbatch

Grant

Delete

uapmadmin_group

Grant

Insert

uapmadmin_group

Grant

Select

ca_itrm_group

Grant

Select

uapmadmin_group

Grant

Update

uapmadmin_group

Grant

Select

uapmbatch_group

Grant

Update

uapmbatch_group

Grant

Select

uapmreporting_group

Grant

Select

amsgroup

Grant

Select

ca_itrm_group_ams

Grant

Select

uapmadmin

Grant

Update

uapmadmin

Grant

Select

uapmbatch

Grant

Update

uapmbatch

Grant

Select

uapmreporting

Grant

Select

swcmadmin

Grant

Update

swcmadmin

SQL Script

CREATE TABLE [dbo].[arg_actionlk]
(
[lkacadid] [int] NOT NULL,
[primary_object_uuid] [binary] (16) NOT NULL,
[lkac1ivi] [smallint] NOT NULL,
[lkacdadt] [datetime] NOT NULL,
[lkactitm] [nvarchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[lkndid] [smallint] NOT NULL,
[secondary_object_uuid] [binary] (16) NOT NULL,
[lk2ivid] [smallint] NOT NULL,
[lkinstnc] [smallint] NOT NULL,
[primary_object_type] [smallint] NULL,
[secondary_object_type] [smallint] NULL,
[lkstrtdt] [datetime] NULL,
[lkenddt] [datetime] NULL,
[lkcommnt] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__arg_actio__versi__5B78929E] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_actionlk] ADD CONSTRAINT [XPKarg_actionlk] PRIMARY KEY CLUSTERED ([lkacadid], [primary_object_uuid], [lkac1ivi], [lkacdadt], [lkactitm], [lkndid], [secondary_object_uuid], [lk2ivid], [lkinstnc]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [lkindex02] ON [dbo].[arg_actionlk] ([primary_object_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [lkindex03] ON [dbo].[arg_actionlk] ([secondary_object_uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[arg_actionlk] TO [amsgroup]
GRANT SELECT ON  [dbo].[arg_actionlk] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[arg_actionlk] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[arg_actionlk] TO [swcmadmin]
GRANT INSERT ON  [dbo].[arg_actionlk] TO [swcmadmin]
GRANT DELETE ON  [dbo].[arg_actionlk] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[arg_actionlk] TO [swcmadmin]
GRANT SELECT ON  [dbo].[arg_actionlk] TO [uapmadmin]
GRANT INSERT ON  [dbo].[arg_actionlk] TO [uapmadmin]
GRANT DELETE ON  [dbo].[arg_actionlk] TO [uapmadmin]
GRANT UPDATE ON  [dbo].[arg_actionlk] TO [uapmadmin]
GRANT SELECT ON  [dbo].[arg_actionlk] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[arg_actionlk] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[arg_actionlk] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[arg_actionlk] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[arg_actionlk] TO [uapmbatch]
GRANT INSERT ON  [dbo].[arg_actionlk] TO [uapmbatch]
GRANT DELETE ON  [dbo].[arg_actionlk] TO [uapmbatch]
GRANT UPDATE ON  [dbo].[arg_actionlk] TO [uapmbatch]
GRANT SELECT ON  [dbo].[arg_actionlk] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[arg_actionlk] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[arg_actionlk] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[arg_actionlk] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[arg_actionlk] TO [uapmreporting]
GRANT SELECT ON  [dbo].[arg_actionlk] TO [uapmreporting_group]
GO