Build 
Definition  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 
Definition  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 
Definition  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 
Definition  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 
Definition  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 
Definition  Optimistic lock identifier using rowversion datatype. 

ClaimID 
Definition  Auto generated unique primary key value. 

EpisodeID 
Definition  A foreign key to the EpisodeID column in the SXARCMEpisode table. 

CarrierID 
Definition  Insurance plan 

ClaimNumber 
Definition  PHI: Claim Number Information 

BillingRequestID 
Definition  A foreign key to the BillingRequestID column in the SXARCMBillingRequest table. 

WorksheetID 
Definition  A foreign key to the WorksheetID column in the SXARCMWorksheet table. 

InsurancePlanID 
Definition  A foreign key to the InsurancePlanID column in the SXARCMInsurancePlan table. 

ClaimBreakID 
Definition  A foreign key to the ClaimBreakID column in the SXARCMClaimBreak table. 

ClaimBreakGroupkey 
Definition  It will store the claim group name; it’s basically a key which is generated based on claim break option and transaction value. 

RebillForBillRequestID 
Definition  This represents the bill request against which this re-bill request is generated. 

IsEditCheckPassed 
Definition  This indicates whether all the edit checks have passed and this claim has gone though edit checking. 

IsMarkForRelease 
Definition  This indicates that whether claim is ready for release. 

ReleasedUTC 
Definition  This indicates the date when this claim was released 

RevenueCycleDetailID 
Definition  A foreign key to the RevenueCycleDetailID column in the SXARCMRevenueCycleDetail table. 

RevenueCycleSetupID 
Definition  A foreign key to the RevenueCycleSetupID column in the SXARCMRevenueCycleSetup table. 

IsBilled 
Definition  flag to identify is claim billed 

BilledUTC 
Definition  Billed date time 

EpisodeYear 
Definition  Primary key  

QueuedForProductionUTC 
Definition  Claim Queued Production date time 

WorkSheetYear 
Definition  A foreign key to the WorkSheetYear column in the SXARCMWorksheet table. 

PolicyReference 
Definition  Claim Policy Reference Number 

RateCode 
Definition  Store Rate Code value 

VoidClaimReasonID 
Definition  A foreign key to the FinancialClassChangeReasonID column in the SXARCMChangeReason table. 

DocumentControlNumber 
Definition  PHI: Stores DocumentControlNumber entered by user 

VoidConditionCode 
Definition  Void condition Code 

RebillFrequencyCode 
Definition  The rebilling frequency code specified by user 

EDITransactionControlID 
Definition  A foreign key to the EDITransactionControlID column in the SXARCMEDITransactionControl table. 

PolicyNumber 
Definition  PHI: It stores Insurance Policy Number at the time of Claim Generation. 

RevenueCycleInvoiceDetailID 
Definition  A foreign key to the RevenueCycleInvoiceDetailID column in the SXARCMRevenueCycleInvoiceDetail table. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

ActualBilledAmount 
Definition  It stores claim amount based on claim lines for a claim 

AttendingProviderID 
Definition  Attending Provider's ID associated with the claim, set by claim break, based on attending provider history 

SubmittedDate 
Definition  Store Date of claim Submitted at Third party vendor 

OrderingProviderID 
Definition  This column will be used to save the Ordering provider Id in case of claim break on ordering provider. 

IsClaimReleaseNotAllowed 
Definition  Stores flag for claim to be released or not  

TimelyFilingDate 
Definition  This column contains timely filing date of claim.  

PaymentCycleDate 
Definition  This column contains payment cycle date of claim.