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. 

ERATransactionSetClaimID 
Definition  Auto generated unique primary key value. 

ERATransactionSetID 
Definition  A foreign key to the ERATransactionSetID column in the SXARCMERATransactionSet table. 

PatientControlNumber 
Definition  PHI: Patient control number 

ClaimStatusCode 
Definition  Claim status code. This matches an entry in SXAEDIDictionaryEntry where DictionaryID = 247. No foreign key reference required. 

ClaimTotalCharges 
Definition  Total charges as reported in the claim segment 

ClaimTotalPayments 
Definition  Total payments as reported in the claim segment 

ClaimTotalAdjustments 
Definition  Total adjustments as reported in the CAS segments 

ClaimPatientResponsibility 
Definition  Patient responsibility as reported in the claim segment 

IsBalanced 
Definition  Flag Indicating whether the claim is balanced or not 

IsDenied 
Definition  Flag indicating whether the claim is denied 

IsCrossOver 
Definition  Flag indicating whether the claim was crossed over to another payer 

CrossOverPayerName 
Definition  Name of the cross-over insurance 

ClaimControlNumber 
Definition  Payer claim control number 

DRG 
Definition  Claim adjudication DRG 

DRGWeight 
Definition  Adjudicated DRG weight 

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

FacilityCodeValue 
Definition  Facility code 

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

ProviderIdentifier 
Definition  Contains the industry identifier value for the provider on a claim 

ClaimHeaderNumber 
Definition  This is a numerical value assigned by the payer to group multiple claims within a transaction set 

ERAProviderID 
Definition  A foreign key to the ERAProviderID column in the SXARCMERAProvider table. 

AllowedAmount 
Definition  Contains the value paid on a previous claim if not a primary claim 

ClaimID 
Definition  A foreign key to the ClaimID column in the SXARCMClaim table. 

TransactionID 
Definition  A foreign key to the TransactionID column in the SXARCMTransaction table. 

TransactionYear 
Definition  A foreign key to the TransactionYear column in the SXARCMTransaction table. 

StatusID 
Definition  Value indicating the status of a record 

LocationID 
Definition  ID column for the principal visit location 

VisitID 
Definition  ID column for the principal visit 

BillTypeCode 
Definition  single character representing the claim frequency type code 

ClaimType 
Definition  Value indicating the type of claim 

TransactionCodeMasterID 
Definition  A foreign key to the TransactionCodeMasterID column in the SXARCMTransactionCodeMaster table. 

PriorAuthorizationNumber 
Definition  Claim Prior Authorization Number 

InterestAmount 
Definition  Contains an optional amount representing the interest paid on a claim 

TransactionCodeOverride 
Definition  Store Override Transaction Code 

TransactionCodeMasterIDOverride 
Definition  Store Override Transaction Code ID 

RepricedClaimRefNumber 
Definition  Column to store the RepricedClaimRefNumber 

IsProxy 
Definition  Is Proxy for Proxy Claim Payer Configuration 

ActualCoveredDays 
Definition  Covred actual days 

PatientControlNumberReceived 
Definition  To store the actual patient control number received in 835 file 

AccountGroupType 
Definition  This is the Account Group from the client visit 

IsCrossedClaim 
Definition  this flag is used to set the crossed over insurance flag . It is informational 

IsWorkInProgress 
Definition  Is transactionSetClaim store properly or not with child tables. 

IsPRSet 
Definition  this flag is used to set patient Responsibility . It is informational 

InsuranceRemittanceConfigurationID 
Definition  A foreign key to the InsuranceRemittanceConfigurationID column in the SXARCMInsuranceRemittanceConfiguration table. 

ClaimPeriodStartDate 
Definition  Stores claim period start date 

ClaimPeriodEndDate 
Definition  Stores claim period end date 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

EpisodeYear 
Definition  A foreign key to the EpisodeYear column in the SXARCMClaim table.