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 |
|
bigint |
NO |
Auto generated unique primary key value. |
WorksheetTypeID |
|
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 |
|
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 |
|
int |
YES |
A foreign key to the WorksheetStateID column in the SXARCMWorksheetState table. |
WorksheetStatusID |
|
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 |
|
int |
YES |
A foreign key to the RevenueCycleDetailID column in the SXARCMRevenueCycleDetail table. |
RevenueCycleSetupID |
|
int |
YES |
A foreign key to the RevenueCycleSetupID column in the SXARCMRevenueCycleSetup table. |
RevenueCycleSelfPayID |
|
int |
YES |
A foreign key to the RevenueCycleSelfPayID column in the SXARCMRevenueCycleSelfPay table. |
FinancialClassHistory |
|
xml |
YES |
Financial Class History Information |
FinancialClassID |
|
int |
YES |
A foreign key to the FinancialClassID column in the SXARCMFinancialClass table. |
FinancialClassChangeReasonID |
|
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 |
|
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 |
|
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 |
|
int |
YES |
A foreign key to the RevenueCycleSetupID column in the SXARCMRevenueCycleSetup table. |
PriorPayerRevenueCycleDetailID |
|
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 |