[dbo].[HARUDP]

Property	Value
Row Count	47
Created	5:00:13 AM Monday, March 02, 2009
Last Modified	5:00:28 AM Monday, March 02, 2009

	Name	Data Type	Collation	Max Length (Bytes)	Default
$Foreign Keys HARUDP_PPID_FK: [dbo].[HARLINKEDPROCESS].PARENTPROCOBJID\PROCESSOBJID$ $Indexes HARUDP_PSOBJID: PROCESSOBJID\PROCESSNAME$ $Indexes HARUDP_PSTATEOBJID: PROCESSOBJID\STATEOBJID$	PROCESSOBJID	int		4
$Indexes HARUDP_PSOBJID: PROCESSOBJID\PROCESSNAME$	PROCESSNAME	varchar(128)	SQL_Latin1_General_CP1_CS_AS	128
$Foreign Keys HARUDP_PPID_FK: [dbo].[HARLINKEDPROCESS].PARENTPROCOBJID\PROCESSOBJID$	PARENTPROCOBJID	int		4
$Indexes HARUDP_PSTATEOBJID: PROCESSOBJID\STATEOBJID$	STATEOBJID	int		4
	OUTPUTTARGET	varchar(8)	SQL_Latin1_General_CP1_CI_AS	8
	ONERRORACTION	varchar(8)	SQL_Latin1_General_CP1_CI_AS	8
	CREATIONTIME	datetime		8
	CREATORID	int		4
	MODIFIEDTIME	datetime		8
	MODIFIERID	int		4
	DESCRIPTION	varchar(255)	SQL_Latin1_General_CP1_CI_AS	255
	PROGRAMNAME	varchar(255)	SQL_Latin1_General_CP1_CI_AS	255
	INPUTPARM	varchar(2000)	SQL_Latin1_General_CP1_CI_AS	2000
	NOTE	varchar(2000)	SQL_Latin1_General_CP1_CI_AS	2000
	SECUREUDPINPUT	char(1)	SQL_Latin1_General_CP1_CI_AS	1
	UDPTYPE	varchar(8)	SQL_Latin1_General_CP1_CI_AS	8
	UDPNOPROMPT	char(1)	SQL_Latin1_General_CP1_CI_AS	1	('N')

	Name	Columns	Unique
	HARUDP_PK	PROCESSOBJID
	HARUDP_PSOBJID	PROCESSOBJID, PROCESSNAME
	HARUDP_PSTATEOBJID	PROCESSOBJID, STATEOBJID
	HARUDP_PARENTPROCOBJID	PARENTPROCOBJID

Name	Delete	Columns
HARUDP_PPID_FK	Cascade	PARENTPROCOBJID->[dbo].[HARLINKEDPROCESS].[PARENTPROCOBJID] PROCESSOBJID->[dbo].[HARLINKEDPROCESS].[PROCESSOBJID]

Name	Level 2 Type	Level 2 Name	Value
Caption			The HARUDP table stores the definition of a User-defined Process.
Caption	COLUMN	CREATIONTIME	Time object was created
Caption	COLUMN	CREATORID	Object ID of creator
Caption	COLUMN	DESCRIPTION	User-defined description
Caption	COLUMN	INPUTPARM	Additional input parameters
Caption	COLUMN	MODIFIEDTIME	Time object was modified
Caption	COLUMN	MODIFIERID	Object ID of modifier
Caption	COLUMN	NOTE	User-defined note
Caption	COLUMN	ONERRORACTION	DISPLAY or DISCARD
Caption	COLUMN	OUTPUTTARGET	DISPLAY or DISCARD
Caption	COLUMN	PARENTPROCOBJID	Object ID of parent process
Caption	COLUMN	PROCESSNAME	Name of the process
Caption	COLUMN	PROCESSOBJID	Object ID of process
Caption	COLUMN	PROGRAMNAME	Name of program
Caption	COLUMN	SECUREUDPINPUT	Modifiable UDP input flag (Y/N)
Caption	COLUMN	STATEOBJID	Object ID of state
Caption	COLUMN	UDPNOPROMPT	Modifiable prompt flag (Y/N)
Caption	COLUMN	UDPTYPE	Execute on server or client

SQL Script

CREATE TABLE [dbo].[HARUDP]
(
[PROCESSOBJID] [int] NOT NULL,
[PROCESSNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[PARENTPROCOBJID] [int] NULL,
[STATEOBJID] [int] NULL,
[OUTPUTTARGET] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ONERRORACTION] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CREATIONTIME] [datetime] NOT NULL,
[CREATORID] [int] NOT NULL,
[MODIFIEDTIME] [datetime] NOT NULL,
[MODIFIERID] [int] NOT NULL,
[DESCRIPTION] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PROGRAMNAME] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INPUTPARM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NOTE] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SECUREUDPINPUT] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UDPTYPE] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UDPNOPROMPT] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARUDP__UDPNOPRO__03BB8E22] DEFAULT ('N')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARUDP] ADD CONSTRAINT [HARUDP_PK] PRIMARY KEY CLUSTERED ([PROCESSOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARUDP_PARENTPROCOBJID] ON [dbo].[HARUDP] ([PARENTPROCOBJID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARUDP_PSOBJID] ON [dbo].[HARUDP] ([PROCESSOBJID], [PROCESSNAME]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARUDP_PSTATEOBJID] ON [dbo].[HARUDP] ([PROCESSOBJID], [STATEOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARUDP] ADD CONSTRAINT [HARUDP_PPID_FK] FOREIGN KEY ([PARENTPROCOBJID], [PROCESSOBJID]) REFERENCES [dbo].[HARLINKEDPROCESS] ([PARENTPROCOBJID], [PROCESSOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARUDP table stores the definition of a User-defined Process.', 'SCHEMA', N'dbo', 'TABLE', N'HARUDP', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was created', 'SCHEMA', N'dbo', 'TABLE', N'HARUDP', 'COLUMN', N'CREATIONTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of creator', 'SCHEMA', N'dbo', 'TABLE', N'HARUDP', 'COLUMN', N'CREATORID'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined description', 'SCHEMA', N'dbo', 'TABLE', N'HARUDP', 'COLUMN', N'DESCRIPTION'
GO
EXEC sp_addextendedproperty N'Caption', N'Additional input parameters', 'SCHEMA', N'dbo', 'TABLE', N'HARUDP', 'COLUMN', N'INPUTPARM'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was modified', 'SCHEMA', N'dbo', 'TABLE', N'HARUDP', 'COLUMN', N'MODIFIEDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of modifier', 'SCHEMA', N'dbo', 'TABLE', N'HARUDP', 'COLUMN', N'MODIFIERID'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined note', 'SCHEMA', N'dbo', 'TABLE', N'HARUDP', 'COLUMN', N'NOTE'
GO
EXEC sp_addextendedproperty N'Caption', N'DISPLAY or DISCARD', 'SCHEMA', N'dbo', 'TABLE', N'HARUDP', 'COLUMN', N'ONERRORACTION'
GO
EXEC sp_addextendedproperty N'Caption', N'DISPLAY or DISCARD', 'SCHEMA', N'dbo', 'TABLE', N'HARUDP', 'COLUMN', N'OUTPUTTARGET'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of parent process', 'SCHEMA', N'dbo', 'TABLE', N'HARUDP', 'COLUMN', N'PARENTPROCOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of the process', 'SCHEMA', N'dbo', 'TABLE', N'HARUDP', 'COLUMN', N'PROCESSNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of process', 'SCHEMA', N'dbo', 'TABLE', N'HARUDP', 'COLUMN', N'PROCESSOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of program', 'SCHEMA', N'dbo', 'TABLE', N'HARUDP', 'COLUMN', N'PROGRAMNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Modifiable UDP input flag (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARUDP', 'COLUMN', N'SECUREUDPINPUT'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of state', 'SCHEMA', N'dbo', 'TABLE', N'HARUDP', 'COLUMN', N'STATEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Modifiable prompt flag (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARUDP', 'COLUMN', N'UDPNOPROMPT'
GO
EXEC sp_addextendedproperty N'Caption', N'Execute on server or client', 'SCHEMA', N'dbo', 'TABLE', N'HARUDP', 'COLUMN', N'UDPTYPE'
GO