dbo.SXARCMWorksheet 
Default Table Name  SXARCMWorksheet 
Definition  To Store Proxy Claim Payer information for a given Proxy Claim Payer Configuration. 

dbo.SXARCMWorksheet Columns 
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. 
WorksheetID(PK)    bigint  NO  Auto generated unique primary key value. 
WorksheetTypeID(FK)    int  NO  A foreign key to the WorkSheetTypeID column in the SXARCMWorksheetType table. 
EpisodeID    bigint  YES  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(FK)    bigint  YES  A foreign key to the InsurancePlanID column in the SXARCMInsurancePlan table. 
SequenceNumber    int  YES  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    bigint  YES  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    bigint  YES  Receivable Asset UID(FK to SXARCMReceivableAssetUID) 
WorksheetStateID(FK)    int  YES  A foreign key to the WorksheetStateID column in the SXARCMWorksheetState table. 
WorksheetStatusID(FK)    int  NO  A foreign key to the WorksheetStatusID column in the SXARCMWorksheetStatus table. 
BillingRequestID    bigint  YES  Billing Request ID (FK to SXARCMBillingRequest) 
IsOnHold    bit  NO  Flag to identify Worksheet on Hold or not 
RevenueCycleDetailID(FK)    int  YES  A foreign key to the RevenueCycleDetailID column in the SXARCMRevenueCycleDetail table. 
RevenueCycleSetupID(FK)    int  YES  A foreign key to the RevenueCycleSetupID column in the SXARCMRevenueCycleSetup table. 
RevenueCycleSelfPayID(FK)    int  YES  A foreign key to the RevenueCycleSelfPayID column in the SXARCMRevenueCycleSelfPay table. 
FinancialClassHistory    xml  YES  Financial Class History Information 
FinancialClassID(FK)    int  YES  A foreign key to the FinancialClassID column in the SXARCMFinancialClass table. 
FinancialClassChangeReasonID(FK)    int  YES  A foreign key to the FinancialClassChangeReasonID column in the SXARCMChangeReason table. 
IsBadDebt    bit  NO  Flag to identify Worksheet in Bad Debt or not 
WorkSheetYear(PK)    int  NO  Primary key 
WasBadDebt    bit  NO  Flag to identify Worksheet was in Bad Debt or not 
WorksheetHoldTypeID    int  YES  Worksheet Hold Type ID (FK to SXARCMWorksheetHoldType) 
IsDenial    bit  NO  Flag to identify Worksheet in Denial or not 
GroupingLogic    varchar(100)  YES  string used to document the logic applied to group transactions onto a worksheet 
WorksheetStateModifiedOnUTC    datetimeoffset(3)  YES  Worksheet State Modified Date 
ProxyWorksheetID    bigint  YES  To Store the Proxy Worksheet ID 
ProxyWorksheetYear    int  YES  To Store the Proxy Worksheet Year 
IsStatementOnDemand    bit  YES  Is statement to be generated on demand, applicable only for selfpay worksheet 
IsRetired    bit  NO  Stores if a self pay WS is retired and new WS is created for Self pay 
IsHardDenialOnParentClaimWorksheet    bit  NO  It stores hard denial open on parent worksheet 
ClaimNumber    varchar(50)  YES  Claim Number 
IsProxy    bit  NO  Is Proxy ID for each Proxy Payer Configuration 
Balance    numeric(23, 4)  YES  To store the total balance of worksheet 
TotalCharges    SXACurrencyDt  NO  To store the total charges of worksheet 
TotalPayments    SXACurrencyDt  NO  To store the total payments of worksheet 
IsPreBadDebt    bit  NO  this column indicates whether the worksheet is in pre bad debt or not 
TotalAdjustments    SXACurrencyDt  NO  To store the total adjustments of worksheet 
LastPaymentAmount    SXACurrencyDt  NO  To store the last payment amount of worksheet 
IsHIPPSBilling    bit  NO  Used to store HIPPS Billing flag 
RevenueCycleInvoiceDetailID(FK)    int  YES  A foreign key to the RevenueCycleInvoiceDetailID column in the SXARCMRevenueCycleInvoiceDetail table. 
IsInvoiceWorksheet    bit  NO  This column will specify whether it is Invoice Worksheet 
FromDate    date  YES  Stores Worksheet From Date 
ThroughDate    date  YES  Stores Worksheet Through Date 
LastPaymentDate    date  YES  Stores Worksheet Last Payment Date 
BadDebtMoveInDate    date  YES  Stores Worksheet bad debt move in Date 
BadDebtMoveOutDate    date  YES  Stores Worksheet bad debt move out Date 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
FinancialClassLastChangeDateUTC    datetimeoffset(3)  YES  The date-time of the last change made to the worksheet financial class. 
AuthorizationNumber    varchar(50)  YES  Used to store the Claim Authorization Number 
PriorPayerRevenueCycleSetupID(FK)    int  YES  A foreign key to the RevenueCycleSetupID column in the SXARCMRevenueCycleSetup table. 
PriorPayerRevenueCycleDetailID(FK)    int  YES  A foreign key to the RevenueCycleDetailID column in the SXARCMRevenueCycleDetail table. 
IsCrossoverClaimMissing    bit  NO  Store crossover claim missing or not  
BVBadDebtMoveInDate    date  YES  Column similar to BadDebtMoveInDate just if will be null when IsBadDebt flag is zero in same table 

dbo.SXARCMWorksheet Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMWorksheetPK  PrimaryKey  WorksheetID, WorkSheetYear