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. |
StatementWorksheetInfoId |
Definition | Auto generated unique primary key value. |
WorksheetID |
Definition | A foreign key to the WorksheetID column in the SXARCMWorksheet table. |
StatementArtifactID |
Definition | A foreign key to the StatementArtifactID column in the SXARCMStatementArtifact table. |
WorksheetTypeID |
Definition | A foreign key to the WorkSheetTypeID column in the SXARCMWorksheetType table. |
InsurancePlanID |
Definition | A foreign key to the InsurancePlanID column in the SXARCMInsurancePlan table. |
SequenceNumber |
Definition | Contains the Sequence Number |
ReceivableAssetUID |
Definition | Contains the Receivable Asset Uid of the Worksheet statement |
BillingRequestID |
Definition | Contains the Billing Request Ids associated to the worksheet |
IsOnHold |
Definition | Contains the OnHold status of the statement artifact |
RevenueCycleDetailID |
Definition | Contains the Revenue Cycle detail Id |
RevenueCycleSetupID |
Definition | Contains the Revenue Cycle Setup Id |
RevenueCycleSelfPayID |
Definition | Contains the revenue cycle selfpay Id |
FinancialClassHistory |
Definition | Contains the Financial Class History |
IsBadDebt |
Definition | Contains the BadDebt status |
WorkSheetYear |
Definition | A foreign key to the WorkSheetYear column in the SXARCMWorksheet table. |
IsDenial |
Definition | Contains the Denial status |
GroupingLogic |
Definition | Contains the Grouping Logic |
FinancialClass |
Definition | Contains the Financial Class Id |
WorksheetState |
Definition | Current State of Worksheet(User Defined) |
WorksheetStatus |
Definition | Current Status of Worksheet(System Defined) |
BudgetPlanID |
Definition | Budget Plan ID(FK to SXARCMBudgetPlan) |
BudgetPlanNumberofMonths |
Definition | Number for Budget Plan Month |
BudgetPlanTotalAmount |
Definition | Total Amount for Budget Plan |
BudgetPlanAmount |
Definition | Current Amount for Budget Plan |
Budget |
Definition | Budget Name information |
BudgetFrequency |
Definition | Budget Frequency information |
BudgetGuarantorName |
Definition | Budget Guarantor Name information |
StatementArtifactYear |
Definition | A foreign key to the WorkSheetYear column in the SXARCMStatementArtifact table. |
BalanceDue |
Definition | It will hold Value specific to balance amound due of statement worksheet |
FromDate |
Definition | Stores worksheet from date |
ThroughDate |
Definition | Stores worksheet through date |
MSReplrowguid |
Definition | Unique GUID used to support merge replication. |
TotalWorksheetSelfPayPayments |
Definition | store sum of worksheet payment |