CREATE TABLE [dbo].[HARUSDHISTORY]
(
[HARVESTPACKAGENAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OPERATION] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RESULT] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WEBSERVICE] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FAULTCODE] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FAULTSTRING] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USDPACKAGENAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USDPACKAGEVERSION] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LOGDATE] [datetime] NOT NULL
) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'Caption', N'The HARUSDHISTORY table maintains common USD package maintenance and deployment history. ', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDHISTORY', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'In the event of an error, the web service fault code associated with the failing operation', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDHISTORY', 'COLUMN', N'FAULTCODE'
GO
EXEC sp_addextendedproperty N'Caption', N'In the event of an error, the web service fault string', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDHISTORY', 'COLUMN', N'FAULTSTRING'
GO
EXEC sp_addextendedproperty N'Caption', N'The name of the CA SCM package', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDHISTORY', 'COLUMN', N'HARVESTPACKAGENAME'
GO
EXEC sp_addextendedproperty N'Caption', N'The date and time the event occurred', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDHISTORY', 'COLUMN', N'LOGDATE'
GO
EXEC sp_addextendedproperty N'Caption', N'The operation. For example, create package, deploy, and so on', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDHISTORY', 'COLUMN', N'OPERATION'
GO
EXEC sp_addextendedproperty N'Caption', N'The result of the operation; Success | Failed', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDHISTORY', 'COLUMN', N'RESULT'
GO
EXEC sp_addextendedproperty N'Caption', N'The name of the USD package', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDHISTORY', 'COLUMN', N'USDPACKAGENAME'
GO
EXEC sp_addextendedproperty N'Caption', N'The USD package version', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDHISTORY', 'COLUMN', N'USDPACKAGEVERSION'
GO
EXEC sp_addextendedproperty N'Caption', N'In the event of an error, the web service method that resulted in the failure', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDHISTORY', 'COLUMN', N'WEBSERVICE'
GO