Tables [dbo].[ClaimItem]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)1985
Created10:12:54 PM Thursday, December 28, 2006
Last Modified11:13:38 AM Monday, August 19, 2013
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Primary Key PK_ClaimItem: ClaimItemIDClaimItemIDint4
No
1 - 1
Cluster Key IX_ClaimItem_ClaimFID_Clustered: ClaimFIDForeign Keys FK_ClaimItem_Claim: [dbo].[Claim].ClaimFIDIndexes IX_ClaimItem_ClaimFID: ClaimFIDClaimFIDint4
No
ClaimDenialCodeFIDint4
Yes
Foreign Keys FK_ClaimItem_ClaimDamageType: [dbo].[ClaimDamageType].ClaimDamageTypeFIDClaimDamageTypeFIDint4
No
ClaimAmountmoney8
No
((0))
Descriptionvarchar(128)128
Yes
ExceptionsNotedvarchar(128)128
Yes
Foreign Keys FK_ClaimItem_ClaimItemStatus: [dbo].[ClaimItemStatus].ClaimItemStatusFIDClaimItemStatusFIDint4
Yes
TagColorvarchar(64)64
Yes
TagNumbervarchar(64)64
Yes
Indexes Indexes
NameColumnsUniqueFill Factor
Primary Key PK_ClaimItem: ClaimItemIDPK_ClaimItemClaimItemID
Yes
80
IX_ClaimItem_ClaimFIDClaimFID80
Cluster Key IX_ClaimItem_ClaimFID_Clustered: ClaimFIDIX_ClaimItem_ClaimFID_ClusteredClaimFID80
Check Constraints Check Constraints
NameConstraint
CK_ClaimItem_ClaimDamageType((1)=[dbo].[ClaimDamageTypeExistsForClaim]([ClaimDamageTypeFID],[ClaimFID]))
CK_ClaimItem_ClaimDenialCode((1)=[dbo].[ClaimDenialCodeExistsForClaim]([ClaimDenialCodeFID],[ClaimFID]))
Foreign Keys Foreign Keys
NameColumns
FK_ClaimItem_ClaimDamageTypeClaimDamageTypeFID->[dbo].[ClaimDamageType].[ClaimDamageTypeID]
FK_ClaimItem_ClaimClaimFID->[dbo].[Claim].[ClaimID]
FK_ClaimItem_ClaimItemStatusClaimItemStatusFID->[dbo].[ClaimItemStatus].[ClaimItemStatusID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[ClaimItem]
(
[ClaimItemID] [int] NOT NULL IDENTITY(1, 1),
[ClaimFID] [int] NOT NULL,
[ClaimDenialCodeFID] [int] NULL,
[ClaimDamageTypeFID] [int] NOT NULL,
[ClaimAmount] [money] NOT NULL CONSTRAINT [DF_ClaimItem_ClaimAmount] DEFAULT ((0)),
[Description] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExceptionsNoted] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ClaimItemStatusFID] [int] NULL,
[TagColor] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TagNumber] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ClaimItem] ADD CONSTRAINT [CK_ClaimItem_ClaimDamageType] CHECK (((1)=[dbo].[ClaimDamageTypeExistsForClaim]([ClaimDamageTypeFID],[ClaimFID])))
GO
ALTER TABLE [dbo].[ClaimItem] ADD CONSTRAINT [CK_ClaimItem_ClaimDenialCode] CHECK (((1)=[dbo].[ClaimDenialCodeExistsForClaim]([ClaimDenialCodeFID],[ClaimFID])))
GO
ALTER TABLE [dbo].[ClaimItem] ADD CONSTRAINT [PK_ClaimItem] PRIMARY KEY NONCLUSTERED  ([ClaimItemID]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ClaimItem_ClaimFID] ON [dbo].[ClaimItem] ([ClaimFID]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [IX_ClaimItem_ClaimFID_Clustered] ON [dbo].[ClaimItem] ([ClaimFID]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ClaimItem] ADD CONSTRAINT [FK_ClaimItem_ClaimDamageType] FOREIGN KEY ([ClaimDamageTypeFID]) REFERENCES [dbo].[ClaimDamageType] ([ClaimDamageTypeID])
GO
ALTER TABLE [dbo].[ClaimItem] ADD CONSTRAINT [FK_ClaimItem_Claim] FOREIGN KEY ([ClaimFID]) REFERENCES [dbo].[Claim] ([ClaimID])
GO
ALTER TABLE [dbo].[ClaimItem] ADD CONSTRAINT [FK_ClaimItem_ClaimItemStatus] FOREIGN KEY ([ClaimItemStatusFID]) REFERENCES [dbo].[ClaimItemStatus] ([ClaimItemStatusID])
GO
GRANT SELECT ON  [dbo].[ClaimItem] TO [MssExec]
GRANT INSERT ON  [dbo].[ClaimItem] TO [MssExec]
GRANT DELETE ON  [dbo].[ClaimItem] TO [MssExec]
GRANT UPDATE ON  [dbo].[ClaimItem] TO [MssExec]
GO
Uses
Used By