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 |
||
| fkClaimTypeID | Unknown | 0 | null |
|
|
Claim type reference - Reference to the claim type |
||
| fkpaysourceid | varchar | 20 | √ | null |
|
|
Foreign key reference - Reference to paysourceid table for data relationships |
|
| fkcpid | int | 4 | √ | null |
|
|
Foreign key reference - Reference to cpid table for data relationships |
|
| procedureid | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for claimtypeBillRates records |
|
| RateAmount | Unknown | 0 | null |
|
|
Rate amount - Billing rate for this claim type |
||
| RateID | Unknown | 0 | null |
|
|
Primary key - claimtypeBillRates unique identifier for each rate record |
||
| servicetypeid | int | 4 | null |
|
|
Type classification - Category or classification type for claimtypeBillRates records |
||
| modifierid | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for claimtypeBillRates records |
|
| minutes | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for claimtypeBillRates records |
|
| rateamt | money | 21,4 | √ | null |
|
|
Financial amount - Monetary value or rate for claimtypeBillRates 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 |