Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| EffectiveDate | Unknown | 0 | null |
|
|
Effective date - Date when this rate becomes active |
||
| ExpirationDate | Unknown | 0 | null |
|
|
Expiration date - Date when this rate expires |
||
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this rate is currently in effect |
||
| RateAmount | Unknown | 0 | null |
|
|
Rate amount - Monetary amount charged for this service |
||
| RateID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| fkPaysourceID | varchar | 20 | √ | null |
|
|
Foreign key reference - Reference to Paysource table for data relationships |
|
| fkCPID | int | 4 | √ | null |
|
|
Foreign key reference - Reference to CP table for data relationships |
|
| ProcedureID | int | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| RateType | Unknown | 0 | null |
|
|
Rate type - Classification of rate (Standard, Negotiated, etc.) |
||
| ServiceCode | Unknown | 0 | null |
|
|
Service code - Procedure or service code for which this rate applies |
||
| ServiceTypeID | int | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| ModifierID | int | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| Minutes | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for BillingRate records |
|
| RateAmt | money | 21,4 | √ | null |
|
|
Financial amount - Monetary value or rate for BillingRate financial calculations |
|
| DateRetroActive | datetime | 16,3 | √ | null |
|
|
Date/time field - Date and time when retroactive occurred or was recorded |
|
| DateEffective | datetime | 16,3 | √ | null |
|
|
Date/time field - Date and time when effective occurred or was recorded |
|
| Dateinactive | datetime | 16,3 | √ | null |
|
|
Date/time field - Date and time when inactive occurred or was recorded |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_BillingRate | Primary key | Asc | RateID |
| IX_CPID | Performance | Asc | fkCPID |
| IX_DateEffect | Performance | Asc | DateEffective |
| IX_DateInactive | Performance | Asc | Dateinactive |
| IX_Modifier | Performance | Asc | ModifierID |
| IX_Paysource | Performance | Asc | fkPaysourceID |