dbo.SXARCMClaim 
Default Table Name  SXARCMClaim 
Definition  This table stores information of generated claims with all necessary information like worksheet,worksheetyear & episode id , episode Year 

dbo.SXARCMClaim Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Build    int  NO  Identifies the build number and patch level of the software that inserted/updated this row. The format is the Build number followed by 3 digits for the patch level which is typically 000. The build number is tied to specific versions of the software, e.g. Sunrise 15.3 is Build 5021, Sunrise 16.3 is Build 5503. 
TouchedBy    varchar(50)  NO  Information about the user that last updated the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 
TouchedWhenUTC    datetimeoffset(3)  NO  The date and time that the row was last updated including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 
CreatedBy    varchar(50)  NO  Information about the user that created the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 
CreatedWhenUTC    datetimeoffset(3)  NO  The date and time that the row was created including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 
MSRowVersion    timestamp  NO  Optimistic lock identifier using rowversion datatype. 
ClaimID(PK)    bigint  NO  Auto generated unique primary key value. 
EpisodeID(FK)    bigint  NO  A foreign key to the EpisodeID column in the SXARCMEpisode table. 
CarrierID    int  YES  Insurance plan 
ClaimNumber    int  YES  PHI: Claim Number Information 
BillingRequestID    bigint  YES  A foreign key to the BillingRequestID column in the SXARCMBillingRequest table. 
WorksheetID(FK)    bigint  YES  A foreign key to the WorksheetID column in the SXARCMWorksheet table. 
InsurancePlanID(FK)    bigint  YES  A foreign key to the InsurancePlanID column in the SXARCMInsurancePlan table. 
ClaimBreakID(FK)    int  YES  A foreign key to the ClaimBreakID column in the SXARCMClaimBreak table. 
ClaimBreakGroupkey    varchar(200)  YES  It will store the claim group name; it’s basically a key which is generated based on claim break option and transaction value. 
RebillForBillRequestID    bigint  YES  This represents the bill request against which this re-bill request is generated. 
IsEditCheckPassed    bit  YES  This indicates whether all the edit checks have passed and this claim has gone though edit checking. 
IsMarkForRelease    bit  YES  This indicates that whether claim is ready for release. 
ReleasedUTC    datetimeoffset(3)  YES  This indicates the date when this claim was released 
RevenueCycleDetailID(FK)    int  YES  A foreign key to the RevenueCycleDetailID column in the SXARCMRevenueCycleDetail table. 
RevenueCycleSetupID(FK)    int  NO  A foreign key to the RevenueCycleSetupID column in the SXARCMRevenueCycleSetup table. 
IsBilled    bit  NO  flag to identify is claim billed 
BilledUTC    datetimeoffset(3)  YES  Billed date time 
EpisodeYear(PK)(FK)    int  NO  Primary key  
QueuedForProductionUTC    datetimeoffset(3)  YES  Claim Queued Production date time 
WorkSheetYear(FK)    int  YES  A foreign key to the WorkSheetYear column in the SXARCMWorksheet table. 
PolicyReference    bigint  NO  Claim Policy Reference Number 
RateCode    varchar(5)  YES  Store Rate Code value 
VoidClaimReasonID(FK)    int  YES  A foreign key to the FinancialClassChangeReasonID column in the SXARCMChangeReason table. 
DocumentControlNumber    varchar(50)  YES  PHI: Stores DocumentControlNumber entered by user 
VoidConditionCode    varchar(10)  YES  Void condition Code 
RebillFrequencyCode    int  YES  The rebilling frequency code specified by user 
EDITransactionControlID(FK)    int  YES  A foreign key to the EDITransactionControlID column in the SXARCMEDITransactionControl table. 
PolicyNumber    varchar(50)  YES  PHI: It stores Insurance Policy Number at the time of Claim Generation. 
RevenueCycleInvoiceDetailID(FK)    int  YES  A foreign key to the RevenueCycleInvoiceDetailID column in the SXARCMRevenueCycleInvoiceDetail table. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
ActualBilledAmount    SXACurrencyDt  YES  It stores claim amount based on claim lines for a claim 
AttendingProviderID    bigint  YES  Attending Provider's ID associated with the claim, set by claim break, based on attending provider history 
SubmittedDate    date  YES  Store Date of claim Submitted at Third party vendor 
OrderingProviderID    HVCIDdt  YES  This column will be used to save the Ordering provider Id in case of claim break on ordering provider. 
IsClaimReleaseNotAllowed    bit  NO  Stores flag for claim to be released or not  
TimelyFilingDate    date  YES  This column contains timely filing date of claim.  
PaymentCycleDate    date  YES  This column contains payment cycle date of claim.  

dbo.SXARCMClaim Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMClaimPK  PrimaryKey  ClaimID, EpisodeYear