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 |