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. 

WorksheetTransactionAllocationID 
Definition  Auto generated unique primary key value. 

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

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

BillingRequestID 
Definition  A foreign key to the BillingRequestID column in the SXARCMBillingRequest table. 

InsurancePlanID 
Definition  A foreign key to the InsurancePlanID column in the SXARCMInsurancePlan table. 

ClaimBreakID 
Definition  A foreign key to the ClaimBreakID column in the SXARCMClaimBreak table. 

TransferReasonTypeID 
Definition  A foreign key to the TransferReasonTypeID column in the SXARCMTransferReasonType table. 

CoveredAmount 
Definition  Covered Amount for Worksheet Transaction Allocation 

ClaimLineID 
Definition  A foreign key to the ClaimLineID column in the SXARCMClaimLine table. 

CoverageTypeID 
Definition  A foreign key to the CoverageTypeID column in the SXARCMCoverageType table. 

TransformedHCPCSCode 
Definition  TransformedHICPICCode is of WorksheetTransactionAllocation 

TransformedRevenueCode 
Definition  TransformedREVCode is of WorksheetTransactionAllocation 

IsSelfPay 
Definition  IsSelfPay is of WorksheetTransactionAllocation 

SelfPayVisitID 
Definition  This is an FK to principal visit 

ClaimBreakGroupkey 
Definition  It will store the claim group name; it’s basically a key which is generated based on claim break option and transaction value. 

ChargeSummarizationKey 
Definition  Charge Summarization Key Information 

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

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

SortOrderToken 
Definition  Worksheet Transaction Allocation Token Sort Order information 

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. 

IsInformational 
Definition  Flag to Identify Worksheet Transaction Allocation Usable or not 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

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