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. 

StatementRCTransactionInfoId 
Definition  Auto generated unique primary key value. 

StatementArtifactID 
Definition  A foreign key to the StatementArtifactID column in the SXARCMStatementArtifact table. 

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

BatchID 
Definition  A foreign key to the BatchID column in the SXARCMBatch table. 

PostedUTC 
Definition  Contains the Posted UTC of the transaction 

TransactionCodeMasterID 
Definition  Contains the TransactionCodeMasterID of the transaction 

Amount 
Definition  Contains the Amount of the transaction 

VisitID 
Definition  Contains the VisitID of the transaction 

ReverseTransactionID 
Definition  Contains the Reverse TransactionID 

TransactionCodeDescription 
Definition  Contains the Transaction Code Description 

IsLateCharge 
Definition  Contains the LateCharge status 

PostingStatus 
Definition  Contains the Posting Status 

IsEditedAfterPost 
Definition  Contains the EditedAfterPost status 

IsAutoGenerated 
Definition  Contains the AutoGenerated status 

TransactionNote 
Definition  PHI: Contains the Transaction Note 

IsTransferred 
Definition  Contains the Transferred status 

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

EpisodeID 
Definition  Contains the Episode ID associated to the transaction 

WorksheetID 
Definition  Contains the WorksheetID associated to the transaction 

WorksheetTypeID 
Definition  Contains the Worksheet Type ID of the worksheet 

WorkSheetYear 
Definition  Contains the statement artifact Id's WorksheetYear to which the records are associated 

TransactionType 
Definition  Transaction Type Information like Charge, Adjustment etc. 

TransactionCodeMaster 
Definition  Transaction Code Master information 

WorksheetTransferTransactionID 
Definition  A foreign key to the WorksheetTransferTransactionID column in the SXARCMWorksheetTransferTransaction table. 

Provider 
Definition  Stores Provider name 

StatementArtifactYear 
Definition  A foreign key to the WorkSheetYear column in the SXARCMStatementArtifact table. 

ServiceDescription 
Definition  stores transaction code description 

ServiceDate 
Definition  PHI: Stores transaction service date 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

RevenueCode 
Definition  Stores revenue code of transaction 

RevenueCodeDescription 
Definition  Stores revenue code description of transaction 

AlternateDescription1 
Definition  store transaction code description1 associated with transaction code 

AlternateDescription2 
Definition  store transaction code description2 associated with transaction code