dbo.SXARCMERATransactionSetClaim 
Default Table Name  SXARCMERATransactionSetClaim 
Definition  This table stores the information fetched from the 835 XML message for each CLP segment 

dbo.SXARCMERATransactionSetClaim 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. 
ERATransactionSetClaimID(PK)    bigint  NO  Auto generated unique primary key value. 
ERATransactionSetID(FK)    bigint  NO  A foreign key to the ERATransactionSetID column in the SXARCMERATransactionSet table. 
PatientControlNumber    varchar(38)  NO  PHI: Patient control number 
ClaimStatusCode    tinyint  NO  Claim status code. This matches an entry in SXAEDIDictionaryEntry where DictionaryID = 247. No foreign key reference required. 
ClaimTotalCharges    SXACurrencyDt  NO  Total charges as reported in the claim segment 
ClaimTotalPayments    SXACurrencyDt  NO  Total payments as reported in the claim segment 
ClaimTotalAdjustments    SXACurrencyDt  NO  Total adjustments as reported in the CAS segments 
ClaimPatientResponsibility    SXACurrencyDt  NO  Patient responsibility as reported in the claim segment 
IsBalanced    bit  NO  Flag Indicating whether the claim is balanced or not 
IsDenied    bit  NO  Flag indicating whether the claim is denied 
IsCrossOver    bit  NO  Flag indicating whether the claim was crossed over to another payer 
CrossOverPayerName    varchar(60)  YES  Name of the cross-over insurance 
ClaimControlNumber    varchar(50)  NO  Payer claim control number 
DRG    varchar(4)  YES  Claim adjudication DRG 
DRGWeight    varchar(15)  YES  Adjudicated DRG weight 
WorksheetID(FK)    bigint  YES  A foreign key to the WorksheetID column in the SXARCMWorksheet table. 
FacilityCodeValue    varchar(2)  YES  Facility code 
WorksheetYear(FK)    int  YES  A foreign key to the WorkSheetYear column in the SXARCMWorksheet table. 
ProviderIdentifier    varchar(80)  YES  Contains the industry identifier value for the provider on a claim 
ClaimHeaderNumber    int  NO  This is a numerical value assigned by the payer to group multiple claims within a transaction set 
ERAProviderID(FK)    bigint  YES  A foreign key to the ERAProviderID column in the SXARCMERAProvider table. 
AllowedAmount    SXACurrencyDt  YES  Contains the value paid on a previous claim if not a primary claim 
ClaimID(FK)    bigint  YES  A foreign key to the ClaimID column in the SXARCMClaim table. 
TransactionID(FK)    bigint  YES  A foreign key to the TransactionID column in the SXARCMTransaction table. 
TransactionYear(FK)    int  YES  A foreign key to the TransactionYear column in the SXARCMTransaction table. 
StatusID    int  NO  Value indicating the status of a record 
LocationID    bigint  YES  ID column for the principal visit location 
VisitID    bigint  YES  ID column for the principal visit 
BillTypeCode    varchar(1)  YES  single character representing the claim frequency type code 
ClaimType    tinyint  NO  Value indicating the type of claim 
TransactionCodeMasterID(FK)    int  YES  A foreign key to the TransactionCodeMasterID column in the SXARCMTransactionCodeMaster table. 
PriorAuthorizationNumber    varchar(50)  YES  Claim Prior Authorization Number 
InterestAmount    SXACurrencyDt  YES  Contains an optional amount representing the interest paid on a claim 
TransactionCodeOverride    varchar(50)  YES  Store Override Transaction Code 
TransactionCodeMasterIDOverride    int  YES  Store Override Transaction Code ID 
RepricedClaimRefNumber    varchar(50)  YES  Column to store the RepricedClaimRefNumber 
IsProxy    bit  NO  Is Proxy for Proxy Claim Payer Configuration 
ActualCoveredDays    int  YES  Covred actual days 
PatientControlNumberReceived    varchar(50)  YES  To store the actual patient control number received in 835 file 
AccountGroupType    int  YES  This is the Account Group from the client visit 
IsCrossedClaim    bit  NO  this flag is used to set the crossed over insurance flag . It is informational 
IsWorkInProgress    bit  NO  Is transactionSetClaim store properly or not with child tables. 
IsPRSet    bit  NO  this flag is used to set patient Responsibility . It is informational 
InsuranceRemittanceConfigurationID(FK)    int  YES  A foreign key to the InsuranceRemittanceConfigurationID column in the SXARCMInsuranceRemittanceConfiguration table. 
ClaimPeriodStartDate    date  YES  Stores claim period start date 
ClaimPeriodEndDate    date  YES  Stores claim period end date 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
EpisodeYear(FK)    int  YES  A foreign key to the EpisodeYear column in the SXARCMClaim table. 

dbo.SXARCMERATransactionSetClaim Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMERATransactionSetClaimPK  PrimaryKey  ERATransactionSetClaimID