dbo.SXARCMPaymentAdjustmentTransactionDetail 
Default Table Name  SXARCMPaymentAdjustmentTransactionDetail 
Definition  Existing table which stores payment details 

dbo.SXARCMPaymentAdjustmentTransactionDetail 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. 
PaymentAdjustmentTransactionDetailID(PK)    bigint  NO  Auto generated unique primary key value. 
PaymentTransactionID(FK)    bigint  NO  A foreign key to the TransactionID column in the SXARCMTransaction table. 
PaymentMethodCodeID    int  YES  Payment Method Code ID (FK to SXARCMPaymentMethodCode) 
CheckNumber    nvarchar(60)  YES  PHI: Check number issued for payment 
RemittanceNumber    varchar(25)  YES  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    varchar(50)  YES  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(FK)    int  YES  A foreign key to the TransactionReasonNoteID column in the SXARCMTransactionReasonNote table. 
SecondaryTransactionReasonNoteID(FK)    int  YES  A foreign key to the TransactionReasonNoteID column in the SXARCMTransactionReasonNote table. 
PaymentAllocationMethodID(FK)    int  YES  A foreign key to the PaymentAllocationMethodID column in the SXARCMPaymentAllocationMethod table. 
VisitID    HVCIDdt  YES  Visit ID (Referring from CV3ClientVisit) 
EpisodeID(FK)    bigint  YES  A foreign key to the EpisodeID column in the SXARCMEpisode table. 
WorksheetID(FK)    bigint  YES  A foreign key to the WorksheetID column in the SXARCMWorksheet table. 
ReceivableAssetUID    bigint  NO  Receivable Asset UID(FK to SXARCMReceivableAssetUID) 
PaymentTypeID(FK)    int  YES  A foreign key to the PaymentTypeID column in the SXARCMPaymentType table. 
EpisodeYear(FK)    int  YES  A foreign key to the EpisodeYear column in the SXARCMEpisode table. 
WorkSheetYear(FK)    int  YES  A foreign key to the WorkSheetYear column in the SXARCMWorksheet table. 
TransactionYear(FK)    int  NO  A foreign key to the TransactionYear column in the SXARCMTransaction table. 
ElectronicClaimStatusCode    int  YES  Electronic Claim Status Code information 
DepositDate    date  YES  Deposit date. 
DepositNumber    nvarchar(100)  YES  PHI: Deposit number. 
AllocateTo    int  YES  Store the way payment allocation is done 
IsSelectedForAutoTransfer    bit  NO  indicates if current Total is marked for Auto Transfer 
PaymentMethodReferenceID    int  YES  It will store payment method reference id from table SXARCMPaymentMethodReference 
ChequeAccountName    varchar(40)  YES  PHI: It will store Account holder’s name on cheque 
ChequeBankBsb    varchar(10)  YES  PHI: It will store Cheque’s Bank BSB 
ChequeBankAccount    varchar(30)  YES  PHI: It will store Account number of cheque 
MoneyOrder    varchar(30)  YES  PHI: It will store money order number 
IsPrintReceipt    bit  NO  By default, 0 mean No. 1 mean Yes. It indicates whether receipt is printed or not. 
EntryID    uniqueidentifier  YES  Column For EntryID 
ModifiedFieldsIndicator    int  NO  It used to track changed made to fields by overriding values given in batch default. By default, it will be 0 (zero). 
IsSelectedBalanceTransfer    bit  NO  indicates if current Balance is marked for Auto Transfer 
PaymentMethodId    int  YES  It will store payment method as received in File. 
DenialConfigID(FK)    int  YES  A foreign key to the DenialConfigID column in the SXARCMDenialConfig table. 
DenialConfigClaimReasonID(FK)    int  YES  A foreign key to the DenialConfigClaimReasonID column in the SXARCMDenialConfigClaimReason table. 
InsuranceRemittanceConfigurationID(FK)    int  YES  A foreign key to the InsuranceRemittanceConfigurationID column in the SXARCMInsuranceRemittanceConfiguration table. 
PatientGuarantorRemittanceConfigID(FK)    int  YES  A foreign key to the PatientGuarantorRemittanceConfigID column in the SXARCMPatientGuarantorRemittanceConfig table. 
SmallBalanceTransferFromWorksheetID    bigint  YES  This stores the Small Balance Transfer from Worksheet ID 
SmallBalanceTransferFromWorksheetYear    int  YES  This stores the Small Balance Transfer from Worksheet Year 
SmallBalanceTransferToWorksheetID    bigint  YES  This stores the Small Balance Transfer to Worksheet ID 
SmallBalanceTransferToWorksheetYear    int  YES  This stores the Small Balance Transfer to Worksheet Year 
CorrelationCode    uniqueidentifier  YES  This Stores the UI Adjustment needed when controls are rendered in UI. 
GurantorClientGUID    HVCIDdt  YES  This Stores the Row No , to tell the control to bind to which row. 
ERATransactionSetStatementID    bigint  YES  To store the ERA statement id from SXARCMERATransactionSetStatement table 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
AuthorizationNumber    varchar(100)  YES  Stores Merchant Authorization Number against a payment done. 
PaymentSourceType    int  YES  Stores Source of Payment, currently targetted for Portal Payment, in future can be used for Manual/835/etc 
BalanceTransferAmount    SXACurrencyDt  YES  Store balance transfer amount 
RenderingProviderID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3CareProvider table. 
CorrelatedTransactionID(FK)    bigint  YES  A foreign key to the TransactionID column in the SXARCMTransaction table. 
CorrelatedTransactionYear(FK)    int  YES  A foreign key to the TransactionYear column in the SXARCMTransaction table. 
LockboxVendorID(FK)    int  YES  A foreign key to the LockboxVendorID column in the SXARCMLockboxVendor table. 
IsOriginalTransactionFrom835    bit  NO  1 if transaction was created via 835 batch processing, 0 otherwaise. 0 by default. 

dbo.SXARCMPaymentAdjustmentTransactionDetail Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMPaymentAdjustmentTransactionDetailPK  PrimaryKey  PaymentAdjustmentTransactionDetailID