Table.

CREATE TABLE [dbo].[Claims](

[ClaimID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,

[SenderID] [int] NOT NULL,

[UserID] [int] NOT NULL,

[FileID] [int] NOT NULL,

[StrProviderID] [varchar](50) NOT NULL,

[ProviderID] [int] NOT NULL,

[PayToProviderID] [int] NULL,

[PayerID] [int] NOT NULL,

[AccountNumber] [varchar](30) NOT NULL,

[PayerClaimNumber] [varchar](30) NOT NULL,

[Type] [char](1) NOT NULL,

[GroupNumber] [varchar](30) NOT NULL,

[ClaimFilingIndicator] [char](2) NOT NULL,

[TotalClaimAmount] [money] NOT NULL,

[PayerPaidAmount] [money] NOT NULL,

[PatientPaidAmount] [money] NOT NULL,

[NonCoveredCharges] [money] NULL,

[CreationDate] [datetime] NULL,

[StatementDateFrom] [datetime] NULL,

[StatementDateTo] [datetime] NULL,

[AddressedDate] [datetime] NULL,

[StatusID] [int] NOT NULL,

[ClaimStatus] [varchar](3) NULL,

[RoutedDate] [datetime] NULL,

[CHNumber] [varchar](20) NOT NULL,

[PlatformID] [varchar](5) NOT NULL,

[ItemID] [int] NULL,

[SubscriberNumber] [varchar](80) NULL,

[SubscriberName] [varchar](105) NULL,

[PatientNumber] [varchar](80) NULL,

[PatientName] [varchar](105) NULL,

[StatusCategoryCode1] [varchar](3) NULL,

[StatusCode1] [varchar](3) NULL,

[StatusEntityIdentifier1] [varchar](3) NULL,

[StatusCategoryCode2] [varchar](3) NULL,

[StatusCode2] [varchar](3) NULL,

[StatusEntityIdentifier2] [varchar](3) NULL,

[StatusCategoryCode3] [varchar](3) NULL,

[StatusCode3] [varchar](3) NULL,

[StatusEntityIdentifier3] [varchar](3) NULL,

[StatusEffectiveDate] [datetime] NULL,

[StatusPaidAmount] [money] NULL,

[ProviderSecondaryIDQual] [varchar](2) NULL,

[ProviderSecondaryID] [varchar](30) NULL,

[GroupControlVersion] [varchar](30) NULL,

[RecordDate] [datetime] NOT NULL,

[PayerClaimTypeID] [int] NULL,

[FrequencyTypeCode] [char](1) NULL,

[PrincipalDiagnosisCode] [varchar](30) NOT NULL,

[AdmittingDiagnosisCode] [varchar](30) NOT NULL,

[ReasonForVisitDiagnosisCode] [varchar](30) NOT NULL,

[DiagnosisCode1] [varchar](30) NOT NULL,

[DiagnosisCode2] [varchar](30) NOT NULL,

[DiagnosisCode3] [varchar](30) NOT NULL,

[DiagnosisCode4] [varchar](30) NOT NULL,

[DiagnosisCode5] [varchar](30) NOT NULL,

[DiagnosisCode6] [varchar](30) NOT NULL,

[DiagnosisCode7] [varchar](30) NOT NULL,

[DiagnosisECode] [varchar](30) NOT NULL,

[LastStatusChanged] [datetime] NULL,

[IsClaimOrEncounter] [char](1) NULL,

[ContractualObligations] [money] NULL,

[CorrectionandReversals] [money] NULL,

[Otheradjustments] [money] NULL,

[PayorInitiatedReductions] [money] NULL,

[PatientResponsibility] [money] NULL,

[PaymentDate] [datetime] NULL,

[CheckOrEFTNumber] [varchar](30) NULL,

[Paid] [bit] NULL,

[ReferralNumber] [varchar](30) NULL,

[PriorAuthorizationNumber] [varchar](30) NULL,

[RoutingToPayer] [char](1) NOT NULL,

[NewPaidAmount] [money] NULL,

[PatientCollectedAmount] [money] NULL,

[IsProduction] [char](1) NULL,

[IsPoBox] [char](1) NULL,

[ProviderActionID] [char](1) NULL,

[RenderingIndOrOrgID] [int] NULL,

CONSTRAINT [PK_ClaimsAllParts] PRIMARY KEY CLUSTERED

(

[ClaimID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)

)

GO

SET ANSI_PADDING OFF

GO