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 |
|
bigint |
NO |
Auto generated unique primary key value. |
PaymentTransactionID |
|
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 |
|
int |
YES |
A foreign key to the TransactionReasonNoteID column in the SXARCMTransactionReasonNote table. |
SecondaryTransactionReasonNoteID |
|
int |
YES |
A foreign key to the TransactionReasonNoteID column in the SXARCMTransactionReasonNote table. |
PaymentAllocationMethodID |
|
int |
YES |
A foreign key to the PaymentAllocationMethodID column in the SXARCMPaymentAllocationMethod table. |
VisitID |
|
HVCIDdt |
YES |
Visit ID (Referring from CV3ClientVisit) |
EpisodeID |
|
bigint |
YES |
A foreign key to the EpisodeID column in the SXARCMEpisode table. |
WorksheetID |
|
bigint |
YES |
A foreign key to the WorksheetID column in the SXARCMWorksheet table. |
ReceivableAssetUID |
|
bigint |
NO |
Receivable Asset UID(FK to SXARCMReceivableAssetUID) |
PaymentTypeID |
|
int |
YES |
A foreign key to the PaymentTypeID column in the SXARCMPaymentType table. |
EpisodeYear |
|
int |
YES |
A foreign key to the EpisodeYear column in the SXARCMEpisode table. |
WorkSheetYear |
|
int |
YES |
A foreign key to the WorkSheetYear column in the SXARCMWorksheet table. |
TransactionYear |
|
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 |
|
int |
YES |
A foreign key to the DenialConfigID column in the SXARCMDenialConfig table. |
DenialConfigClaimReasonID |
|
int |
YES |
A foreign key to the DenialConfigClaimReasonID column in the SXARCMDenialConfigClaimReason table. |
InsuranceRemittanceConfigurationID |
|
int |
YES |
A foreign key to the InsuranceRemittanceConfigurationID column in the SXARCMInsuranceRemittanceConfiguration table. |
PatientGuarantorRemittanceConfigID |
|
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 |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3CareProvider table. |
CorrelatedTransactionID |
|
bigint |
YES |
A foreign key to the TransactionID column in the SXARCMTransaction table. |
CorrelatedTransactionYear |
|
int |
YES |
A foreign key to the TransactionYear column in the SXARCMTransaction table. |
LockboxVendorID |
|
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. |