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. 

ERATransactionSetID 
Definition  Auto generated unique primary key value. 

MessageID 
Definition  Record ID in table SXAEDI835XMLMessage 

FileReceivedDtmUTC 
Definition  Date and time when the file was received 

TransactionSetControlNumber 
Definition  Transaction Set Control Number for the ST/SE envelop this record represent in the electronic remittance 

TransactionHandlingCode 
Definition  Transaction Handling Code for the ST/SE envelop this record represent in the electronic remittance. Matches an entry in SXAEDIDictionaryEntry where DictionaryID = 250. No constraint or foreign key required 

MonetaryAmount 
Definition  Total payment amount for this ST/SE 

CreditDebitFlag 
Definition  Flag indicating whether the transaction is a Credit (C) or a debit (D) 

PaymentMethodCode 
Definition  Payment Method Code for this ST/SE pair. Matches an entry in SXAEDIDictionaryEntry where DictionaryID = 252. No constraint or foreign key required 

ReferenceIdentification 
Definition  Check number or EFT trace number 

IsSystemSelectedConfiguration 
Definition  Indicates if the record is system defined 

PayerIdentificationOverwrite 
Definition  Optional value a user can enter to overwrite the payer ID 

ERATransactionSetPayerID 
Definition  A foreign key to the ERATransactionSetPayerID column in the SXARCMERATransactionSetPayer table. 

TransactionSetStatusID 
Definition  Status of the remittance processing. References table SXARCMERATransactionSetStatus, no foreign key required 

FileName 
Definition  Name of the ERA file received. 

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

IsValid 
Definition  Flag indicating whether the original file is valid 

IsBalanced 
Definition  Flag indicating whether the transaction set is balanced 

FileTransmittedDtmUTC 
Definition  Date and time when the original file was produced/transmitted 

InsurancePlanID 
Definition  Record ID referencing an entry in table SXARCMInsurancePlan 

IsLocked 
Definition  Flag indicating whether the record is locked for processing 

LockedBy 
Definition  Identifier for the process that locked the file 

LockedWhenUTC 
Definition  Date and time when the record was locked 

IsLockBoxPayment 
Definition  Flag indicating whether the record is for a lock box payment 

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

BatchID 
Definition  A foreign key to the BatchID column in the SXARCMBatch table. 

IsDuplicateFile 
Definition  Flag indicating whether the File is Duplicate 

IsDuplicateCheck 
Definition  Flag indicating whether the File Check for Duplicate 

CommunicationNumber 
Definition  To store Communication number or Bank deposit reference number as per the Flag 'OverWriteERADepositNumber' set in XA Configuration 

PatientGuarantorRemittanceConfigID 
Definition  A foreign key to the PatientGuarantorRemittanceConfigID column in the SXARCMPatientGuarantorRemittanceConfig table. 

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

MessageTypeID 
Definition  this flag is used to set messagetypeId 

CheckDepositDate 
Definition  Storescheck deposit date 

RemittanceDate 
Definition  Stores remittance date 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

MarkRemovedBy 
Definition  Who marked transaction as removed 

MarkRemovedWhenUTC 
Definition  When transaction was marked as removed 

IgnoredBy 
Definition  Who marked transaction as ignored 

IgnoredWhenUTC 
Definition  When transaction was marked as ignored 

FunctionalGroupDate 
Definition  Store functional group received date from GS04