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. 

PaymentAdjustmentTransactionDetailID 
Definition  Auto generated unique primary key value. 

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

PaymentMethodCodeID 
Definition  Payment Method Code ID (FK to SXARCMPaymentMethodCode) 

CheckNumber 
Definition  PHI: Check number issued for payment 

RemittanceNumber 
Definition  PHI: Enter the Remittance # for the payment or adjustment transaction. This Remittance number entered will override the original Remittance 3 on the original transaction 

DocumentControlNumber 
Definition  Enter the Document control number from the paid claim’s Remittance advice and this will display in Form locator 64 A-C on the UB04 

PrimaryTransactionReasonNoteID 
Definition  A foreign key to the TransactionReasonNoteID column in the SXARCMTransactionReasonNote table. 

SecondaryTransactionReasonNoteID 
Definition  A foreign key to the TransactionReasonNoteID column in the SXARCMTransactionReasonNote table. 

PaymentAllocationMethodID 
Definition  A foreign key to the PaymentAllocationMethodID column in the SXARCMPaymentAllocationMethod table. 

VisitID 
Definition  Visit ID (Referring from CV3ClientVisit) 

EpisodeID 
Definition  A foreign key to the EpisodeID column in the SXARCMEpisode table. 

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

ReceivableAssetUID 
Definition  Receivable Asset UID(FK to SXARCMReceivableAssetUID) 

PaymentTypeID 
Definition  A foreign key to the PaymentTypeID column in the SXARCMPaymentType table. 

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

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

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

ElectronicClaimStatusCode 
Definition  Electronic Claim Status Code information 

DepositDate 
Definition  Deposit date. 

DepositNumber 
Definition  PHI: Deposit number. 

AllocateTo 
Definition  Store the way payment allocation is done 

IsSelectedForAutoTransfer 
Definition  indicates if current Total is marked for Auto Transfer 

PaymentMethodReferenceID 
Definition  It will store payment method reference id from table SXARCMPaymentMethodReference 

ChequeAccountName 
Definition  PHI: It will store Account holder’s name on cheque 

ChequeBankBsb 
Definition  PHI: It will store Cheque’s Bank BSB 

ChequeBankAccount 
Definition  PHI: It will store Account number of cheque 

MoneyOrder 
Definition  PHI: It will store money order number 

IsPrintReceipt 
Definition  By default, 0 mean No. 1 mean Yes. It indicates whether receipt is printed or not. 

EntryID 
Definition  Column For EntryID 

ModifiedFieldsIndicator 
Definition  It used to track changed made to fields by overriding values given in batch default. By default, it will be 0 (zero). 

IsSelectedBalanceTransfer 
Definition  indicates if current Balance is marked for Auto Transfer 

PaymentMethodId 
Definition  It will store payment method as received in File. 

DenialConfigID 
Definition  A foreign key to the DenialConfigID column in the SXARCMDenialConfig table. 

DenialConfigClaimReasonID 
Definition  A foreign key to the DenialConfigClaimReasonID column in the SXARCMDenialConfigClaimReason table. 

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

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

SmallBalanceTransferFromWorksheetID 
Definition  This stores the Small Balance Transfer from Worksheet ID 

SmallBalanceTransferFromWorksheetYear 
Definition  This stores the Small Balance Transfer from Worksheet Year 

SmallBalanceTransferToWorksheetID 
Definition  This stores the Small Balance Transfer to Worksheet ID 

SmallBalanceTransferToWorksheetYear 
Definition  This stores the Small Balance Transfer to Worksheet Year 

CorrelationCode 
Definition  This Stores the UI Adjustment needed when controls are rendered in UI. 

GurantorClientGUID 
Definition  This Stores the Row No , to tell the control to bind to which row. 

ERATransactionSetStatementID 
Definition  To store the ERA statement id from SXARCMERATransactionSetStatement table 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

AuthorizationNumber 
Definition  Stores Merchant Authorization Number against a payment done. 

PaymentSourceType 
Definition  Stores Source of Payment, currently targetted for Portal Payment, in future can be used for Manual/835/etc 

BalanceTransferAmount 
Definition  Store balance transfer amount 

RenderingProviderID 
Definition  A foreign key to the GUID column in the CV3CareProvider table. 

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

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

LockboxVendorID 
Definition  A foreign key to the LockboxVendorID column in the SXARCMLockboxVendor table. 

IsOriginalTransactionFrom835 
Definition  1 if transaction was created via 835 batch processing, 0 otherwaise. 0 by default.