Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AllowMultipleCT | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for BillingMethod records |
|||||||
| BaseRate | Unknown | 0 | null |
|
|
Base rate - Standard rate amount for this billing method |
||||||||
| BillingCycle | Unknown | 0 | null |
|
|
Billing cycle - Frequency of billing (Monthly, Quarterly, Annual) |
||||||||
| BillingMethodName | Unknown | 0 | null |
|
|
Method name - Descriptive name of the billing method |
||||||||
| BillingType | Unknown | 0 | null |
|
|
Billing type - Classification of billing approach (Per-claim, Monthly, Annual, etc.) |
||||||||
| EffectiveDate | Unknown | 0 | null |
|
|
Effective date - Date when this billing method becomes active |
||||||||
| ExpirationDate | Unknown | 0 | null |
|
|
Expiration date - Date when this billing method expires |
||||||||
| InvLogID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|||||||
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this billing method is currently available |
||||||||
| LogicName | varchar | 50 | √ | null |
|
|
Name field - Descriptive name or identifier for BillingMethod records |
|||||||
| InvoicePerBatch | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for BillingMethod records |
|||||||
| MaximumCharge | Unknown | 0 | null |
|
|
Maximum charge - Maximum billing amount cap if applicable |
||||||||
| MinimumCharge | Unknown | 0 | null |
|
|
Minimum charge - Minimum billing amount regardless of usage |
||||||||
| PatientPerVoucher | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for BillingMethod records |
|||||||
| MonthperVoucher | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for BillingMethod records |
|||||||
| Prefix | varchar | 5 | √ | null |
|
|
Text field - Prefix text information for BillingMethod records |
|||||||
| RateStructure | Unknown | 0 | null |
|
|
Rate structure - How rates are calculated and applied |
||||||||
| RecordNumLimit | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for BillingMethod records |
|||||||
| SeparateRebills | int | 4 | √ | null |
|
|
Financial amount - Monetary value or rate for BillingMethod financial calculations |
|||||||
| SeparateCases | int | 4 | √ | null |
|
|
Financial amount - Monetary value or rate for BillingMethod financial calculations |
|||||||
| SeparateBlankPA | int | 4 | √ | null |
|
|
Financial amount - Monetary value or rate for BillingMethod financial calculations |
|||||||
| UnitLimit | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for BillingMethod records |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__BillingMethod__3BF5C5A4 | Primary key | Asc | InvLogID |