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. |
RevenueCycleSelfPayID |
Definition | Auto generated unique primary key value. |
Name |
Definition | User defined name. |
RuleUID |
Definition | RuleUID from SXAVWFRule table |
BillingIntervalOptionID |
Definition | A foreign key to the BillingIntervalOptionID column in the SXARCMBillingIntervalOption table. |
GuarantorCollectionProgressionID |
Definition | A foreign key to the GuarantorCollectionProgressionID column in the SXARCMGuarantorCollectionProgression table. |
BillingIntervalLength |
Definition | Length of billing interval (where applicable) |
IsGoingToProduceFinalZeroBalance |
Definition | Whether final statement should be produced even if it has a zero balance |
IsGoingToProduceCreditBalance |
Definition | Whether a statement should be produced even if there is a credit balance |
MinimumStmtAmt |
Definition | The minimum amount for which a statement should be produce |
BalanceForwardTypeID |
Definition | A foreign key to the BalanceForwardTypeID column in the SXARCMBalanceForwardType table. |
PGCombiningOptionGroupID |
Definition | A foreign key to the PGCombiningOptionGroupID column in the SXARCMPGCombiningOptionGroup table. |
SequenceNumber |
Definition | Sequence Number for Revenue Cycle Self Pay |
TypeofStatementID |
Definition | A foreign key to the TypeofStatementID column in the SXARCMTypeofStatement table. |
ElectronicConfigurationID |
Definition | A foreign key to the ElectronicConfigurationID column in the SXARCMElectronicFileConfiguration table. |
FinancialClassID |
Definition | A foreign key to the FinancialClassID column in the SXARCMFinancialClass table. |
MinPaymentPercent |
Definition | stores minimum % criteria for payment |
PGCombiningOptionID |
Definition | Store Combining Option ID for PG Billing |
InsuranceCarrierID |
Definition | New column will be added to store insurance carrier id |
StatementCombiningOptionID |
Definition | Will store int value for statement combining option.This value will come from enum. |
IsIncludeBadDebtWS |
Definition | Stores information whether to include bad debt WS |
MSReplrowguid |
Definition | Unique GUID used to support merge replication. |
ZeroBalanceProgressionID |
Definition | A foreign key to the GuarantorCollectionProgressionID column in the SXARCMGuarantorCollectionProgression table. |
IsExcludeZeroBalanceWS |
Definition | Specify whether zero balance worksheet excluded from statement or not |
IsExcludeCreditBalanceWS |
Definition | Specify whether credit balance worksheet excluded from statement or not |