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. 

Active 
Definition  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

ClaimWorksheetGroupID 
Definition  Auto generated unique primary key value. 

EpisodeID 
Definition  A foreign key to the EpisodeID column in the SXARCMEpisode table. 

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

Balance 
Definition  Balance on the claim group. 

TotalPayments 
Definition  Total of all payments on the claim group. 

TotalCharges 
Definition  Total charges on the claim group. 

TotalAdjustments 
Definition  Total adjusments on the claim group. 

TotalTransferIn 
Definition  Total tranfers in on the claim group. 

TotalTransferOut 
Definition  Total Transfers out on the claim group. 

InsurancePlanCode 
Definition  Insurance code identifier 

InsurancePlanName 
Definition  Insurance plan name from FRP. 

SequenceNumber 
Definition  Publicly facing number of the claim group 

ClaimReleaseDtmUTC 
Definition  The claim release date of the last active claim in the group. 

BilledDtmUTC 
Definition  The billed date of the last active claim in the group. 

ClaimSubmitDate 
Definition  The claim submit date of the last active claim in the group. 

ExpectedReimbursement 
Definition  Total expected reimbusement of all claims in the group. 

DRG 
Definition  DRG value for the last active claim in the group. 

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

PolicyGroupNumber 
Definition  Policy Group Number 

PolicyGroupName 
Definition  Policy Group Name 

PrincipalVisitID 
Definition  This is Principal Visit on the episode associated with claim worksheet group .