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. 

WorksheetID 
Definition  Auto generated unique primary key value. 

WorksheetTypeID 
Definition  A foreign key to the WorkSheetTypeID column in the SXARCMWorksheetType table. 

EpisodeID 
Definition  EpisodeId is mandatory only when worksheet is of type Third party. In case of self pay there will be only one worksheet being shared by multiple episodes 

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

SequenceNumber 
Definition  If the worksheet is created for insurance plan that it will contain the sequence number i.e. the order in which insurance plan is liable for printing. 

PrincipalVisitID 
Definition  This represents the principal visit against which this self pay worksheet is created. This will be populated only when the worksheet type is Self Pay. 

ReceivableAssetUID 
Definition  Receivable Asset UID(FK to SXARCMReceivableAssetUID) 

WorksheetStateID 
Definition  A foreign key to the WorksheetStateID column in the SXARCMWorksheetState table. 

WorksheetStatusID 
Definition  A foreign key to the WorksheetStatusID column in the SXARCMWorksheetStatus table. 

BillingRequestID 
Definition  Billing Request ID (FK to SXARCMBillingRequest) 

IsOnHold 
Definition  Flag to identify Worksheet on Hold or not 

RevenueCycleDetailID 
Definition  A foreign key to the RevenueCycleDetailID column in the SXARCMRevenueCycleDetail table. 

RevenueCycleSetupID 
Definition  A foreign key to the RevenueCycleSetupID column in the SXARCMRevenueCycleSetup table. 

RevenueCycleSelfPayID 
Definition  A foreign key to the RevenueCycleSelfPayID column in the SXARCMRevenueCycleSelfPay table. 

FinancialClassHistory 
Definition  Financial Class History Information 

FinancialClassID 
Definition  A foreign key to the FinancialClassID column in the SXARCMFinancialClass table. 

FinancialClassChangeReasonID 
Definition  A foreign key to the FinancialClassChangeReasonID column in the SXARCMChangeReason table. 

IsBadDebt 
Definition  Flag to identify Worksheet in Bad Debt or not 

WorkSheetYear 
Definition  Primary key 

WasBadDebt 
Definition  Flag to identify Worksheet was in Bad Debt or not 

WorksheetHoldTypeID 
Definition  Worksheet Hold Type ID (FK to SXARCMWorksheetHoldType) 

IsDenial 
Definition  Flag to identify Worksheet in Denial or not 

GroupingLogic 
Definition  string used to document the logic applied to group transactions onto a worksheet 

WorksheetStateModifiedOnUTC 
Definition  Worksheet State Modified Date 

ProxyWorksheetID 
Definition  To Store the Proxy Worksheet ID 

ProxyWorksheetYear 
Definition  To Store the Proxy Worksheet Year 

IsStatementOnDemand 
Definition  Is statement to be generated on demand, applicable only for selfpay worksheet 

IsRetired 
Definition  Stores if a self pay WS is retired and new WS is created for Self pay 

IsHardDenialOnParentClaimWorksheet 
Definition  It stores hard denial open on parent worksheet 

ClaimNumber 
Definition  Claim Number 

IsProxy 
Definition  Is Proxy ID for each Proxy Payer Configuration 

Balance 
Definition  To store the total balance of worksheet 

TotalCharges 
Definition  To store the total charges of worksheet 

TotalPayments 
Definition  To store the total payments of worksheet 

IsPreBadDebt 
Definition  this column indicates whether the worksheet is in pre bad debt or not 

TotalAdjustments 
Definition  To store the total adjustments of worksheet 

LastPaymentAmount 
Definition  To store the last payment amount of worksheet 

IsHIPPSBilling 
Definition  Used to store HIPPS Billing flag 

RevenueCycleInvoiceDetailID 
Definition  A foreign key to the RevenueCycleInvoiceDetailID column in the SXARCMRevenueCycleInvoiceDetail table. 

IsInvoiceWorksheet 
Definition  This column will specify whether it is Invoice Worksheet 

FromDate 
Definition  Stores Worksheet From Date 

ThroughDate 
Definition  Stores Worksheet Through Date 

LastPaymentDate 
Definition  Stores Worksheet Last Payment Date 

BadDebtMoveInDate 
Definition  Stores Worksheet bad debt move in Date 

BadDebtMoveOutDate 
Definition  Stores Worksheet bad debt move out Date 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

FinancialClassLastChangeDateUTC 
Definition  The date-time of the last change made to the worksheet financial class. 

AuthorizationNumber 
Definition  Used to store the Claim Authorization Number 

PriorPayerRevenueCycleSetupID 
Definition  A foreign key to the RevenueCycleSetupID column in the SXARCMRevenueCycleSetup table. 

PriorPayerRevenueCycleDetailID 
Definition  A foreign key to the RevenueCycleDetailID column in the SXARCMRevenueCycleDetail table. 

IsCrossoverClaimMissing 
Definition  Store crossover claim missing or not  

BVBadDebtMoveInDate 
Definition  Column similar to BadDebtMoveInDate just if will be null when IsBadDebt flag is zero in same table