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. |
TransactionID |
|
bigint |
NO |
Auto generated unique primary key value. |
BatchID |
|
bigint |
YES |
A foreign key to the BatchID column in the SXARCMBatch table. |
PostedUTC |
|
datetimeoffset(3) |
YES |
Store posted date of transaction |
TransactionCodeMasterID |
|
int |
NO |
A foreign key to the TransactionCodeMasterID column in the SXARCMTransactionCodeMaster table. |
Amount |
|
SXACurrencyDt |
NO |
Transaction Amount |
VisitID |
|
bigint |
YES |
Referred from CV3ClientVisit Table of SCM Database |
IsReadyForPosting |
|
bit |
YES |
Flag to check if Posting is ready |
CopiedFromTransactionID |
|
int |
YES |
FK Key Reference To SXARCMTransaction Table |
ReverseTransactionID |
|
bigint |
YES |
A foreign key to the TransactionID column in the SXARCMTransaction table. |
TransactionCodeDescription |
|
nvarchar(100) |
YES |
Transaction code description. |
IsLateCharge |
|
bit |
NO |
Flag to check if late charge is true or false |
PostingStatus |
|
int |
YES |
Posting status of Transaction |
ContainerID |
|
bigint |
YES |
FK Key Reference to SXARCMContainer Table |
ContainerType |
|
int |
NO |
Type of Container |
IsEditedAfterPost |
|
bit |
NO |
Flag to check if transaction edited after Posting or not |
IsAutoGenerated |
|
bit |
NO |
Flag to check to transaction generated automatically or not |
TransactionNote |
|
varchar(250) |
YES |
Remark for Transaction |
IsTransferred |
|
bit |
NO |
Flag to identify that Transaction is Transferred or not |
TransactionYear |
|
int |
NO |
Primary key |
VisitLevelDiagnosisCodeID1 |
|
bigint |
YES |
A foreign key to the VisitLevelDiagnosisCodeID column in the SXARCMVisitLevelDiagnosisCodes table. |
VisitLevelDiagnosisCodeID2 |
|
bigint |
YES |
A foreign key to the VisitLevelDiagnosisCodeID column in the SXARCMVisitLevelDiagnosisCodes table. |
VisitLevelDiagnosisCodeID3 |
|
bigint |
YES |
A foreign key to the VisitLevelDiagnosisCodeID column in the SXARCMVisitLevelDiagnosisCodes table. |
VisitLevelDiagnosisCodeID4 |
|
bigint |
YES |
A foreign key to the VisitLevelDiagnosisCodeID column in the SXARCMVisitLevelDiagnosisCodes table. |
DiagnosisGroupID |
|
bigint |
YES |
Diagnosis Group ID for Visit from SXARCMVisitLevelDiagnosisCodes table |
CustomBatchID |
|
nvarchar(30) |
YES |
Custom Batch ID for Batch Charge Entry |
TransactionGeneratedSource |
|
int |
YES |
Source of the Transaction. |
RoomLocationID |
|
HVCIDdt |
YES |
store Room Location ID which refer from CV3Location |
AccomodationID |
|
int |
YES |
store Accomodation ID |
IsMigrated |
|
bit |
NO |
Flag to identify Transation is migrated one |
ReverseTransactionYear |
|
int |
YES |
A foreign key to the TransactionYear column in the SXARCMTransaction table. |
InterfaceTransactionID |
|
bigint |
YES |
To store interfacetransaction ID |
IsBadDebt |
|
bit |
NO |
Bad Debt flag |
ObsChargeIntervalInMin |
|
int |
YES |
Store Interval in Min. for observation charge applied |
VisitTransferTransactionID |
|
bigint |
YES |
A foreign key to the TransactionID column in the SXARCMTransaction table. |
VisitTransferTransactionYear |
|
int |
YES |
A foreign key to the TransactionYear column in the SXARCMTransaction table. |
ServiceDate |
|
date |
NO |
Stores transaction service date |
MSReplrowguid |
|
uniqueidentifier |
NO |
Unique GUID used to support merge replication. |
IsReversed |
|
bit |
NO |
Specifies whether the original transaction is reveresed or not |
TaxTransactionID |
|
bigint |
YES |
A foreign key to the TransactionID column in the SXARCMTransaction table. |
TaxTransactionYear |
|
int |
YES |
A foreign key to the TransactionYear column in the SXARCMTransaction table. |
ReferenceNumber |
|
varchar(250) |
YES |
SXARCMTransaction |