dbo.SXARCMERATransactionSet 
Default Table Name  SXARCMERATransactionSet 
Definition  table holding transaction set records of each ST segment for electronic remittances received into SFM 

dbo.SXARCMERATransactionSet 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. 
ERATransactionSetID(PK)    bigint  NO  Auto generated unique primary key value. 
MessageID    bigint  NO  Record ID in table SXAEDI835XMLMessage 
FileReceivedDtmUTC    datetimeoffset(3)  NO  Date and time when the file was received 
TransactionSetControlNumber    varchar(9)  YES  Transaction Set Control Number for the ST/SE envelop this record represent in the electronic remittance 
TransactionHandlingCode    varchar(2)  YES  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    SXACurrencyDt  YES  Total payment amount for this ST/SE 
CreditDebitFlag    varchar(1)  YES  Flag indicating whether the transaction is a Credit (C) or a debit (D) 
PaymentMethodCode    varchar(3)  YES  Payment Method Code for this ST/SE pair. Matches an entry in SXAEDIDictionaryEntry where DictionaryID = 252. No constraint or foreign key required 
ReferenceIdentification    varchar(50)  YES  Check number or EFT trace number 
IsSystemSelectedConfiguration    bit  YES  Indicates if the record is system defined 
PayerIdentificationOverwrite    nvarchar(80)  YES  Optional value a user can enter to overwrite the payer ID 
ERATransactionSetPayerID(FK)    bigint  YES  A foreign key to the ERATransactionSetPayerID column in the SXARCMERATransactionSetPayer table. 
TransactionSetStatusID    int  NO  Status of the remittance processing. References table SXARCMERATransactionSetStatus, no foreign key required 
FileName    varchar(256)  YES  Name of the ERA file received. 
InsuranceRemittanceConfigurationID(FK)    int  YES  A foreign key to the InsuranceRemittanceConfigurationID column in the SXARCMInsuranceRemittanceConfiguration table. 
IsValid    bit  NO  Flag indicating whether the original file is valid 
IsBalanced    bit  NO  Flag indicating whether the transaction set is balanced 
FileTransmittedDtmUTC    datetimeoffset(3)  YES  Date and time when the original file was produced/transmitted 
InsurancePlanID    bigint  YES  Record ID referencing an entry in table SXARCMInsurancePlan 
IsLocked    bit  NO  Flag indicating whether the record is locked for processing 
LockedBy    varchar(128)  YES  Identifier for the process that locked the file 
LockedWhenUTC    datetimeoffset(3)  YES  Date and time when the record was locked 
IsLockBoxPayment    bit  NO  Flag indicating whether the record is for a lock box payment 
ERAProviderID(FK)    bigint  YES  A foreign key to the ERAProviderID column in the SXARCMERAProvider table. 
BatchID    bigint  YES  A foreign key to the BatchID column in the SXARCMBatch table. 
IsDuplicateFile    bit  NO  Flag indicating whether the File is Duplicate 
IsDuplicateCheck    bit  NO  Flag indicating whether the File Check for Duplicate 
CommunicationNumber    varchar(256)  YES  To store Communication number or Bank deposit reference number as per the Flag 'OverWriteERADepositNumber' set in XA Configuration 
PatientGuarantorRemittanceConfigID(FK)    int  YES  A foreign key to the PatientGuarantorRemittanceConfigID column in the SXARCMPatientGuarantorRemittanceConfig table. 
IsWorkInProgress    bit  NO  Is transactionSet store properly or not with child tables. 
MessageTypeID    tinyint  NO  this flag is used to set messagetypeId 
CheckDepositDate    date  YES  Storescheck deposit date 
RemittanceDate    date  YES  Stores remittance date 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
MarkRemovedBy    varchar(50)  YES  Who marked transaction as removed 
MarkRemovedWhenUTC    datetimeoffset(3)  YES  When transaction was marked as removed 
IgnoredBy    varchar(50)  YES  Who marked transaction as ignored 
IgnoredWhenUTC    datetimeoffset(3)  YES  When transaction was marked as ignored 
FunctionalGroupDate    date  YES  Store functional group received date from GS04 

dbo.SXARCMERATransactionSet Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMERATransactionSetPK  PrimaryKey  ERATransactionSetID