Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| dateeffective | smalldatetime | 16 | √ | null |
|
|
Date effective - Date when this payment rate configuration becomes effective |
|
| comment | varchar | 500 | √ | null |
|
|
Rate comments - Administrative comments or notes about this payment rate |
|
| dateend | smalldatetime | 16 | √ | null |
|
|
End date - Date when this payment rate configuration expires or becomes inactive |
|
| EffectiveDate | Unknown | 0 | null |
|
|
Effective date - Date when this payment rate becomes active |
||
| ExpirationDate | Unknown | 0 | null |
|
|
Expiration date - Date when this payment rate expires |
||
| fkClaimTypeID | Unknown | 0 | null |
|
|
Claim type reference - Reference to the claim type |
||
| fkPayerID | Unknown | 0 | null |
|
|
Payer reference - Reference to the insurance payer |
||
| groupname | varchar | 61 | √ | null |
|
|
Group name - Name of the payment group or rate category this rate belongs to |
|
| patientid | int | 4 | √ | null |
|
|
Patient reference - Reference to a specific patient if this is a patient-specific rate |
|
| PaymentRate | Unknown | 0 | null |
|
|
Payment rate - Amount paid per unit for this claim type |
||
| PayRateID | Unknown | 0 | null |
|
|
Primary key - claimtypePayRates unique identifier for each payment rate |
||
| rates | money | 21,4 | √ | null |
|
|
Rate amount - The actual payment rate amount for this claim type and payer combination |
|
| servicetypeid | int | 4 | null |
|
|
Service type reference - Reference to the service type for this payment rate |
||
| modifierid | int | 4 | √ | null |
|
|
Modifier reference - Reference to billing modifiers that affect this payment rate |
|
| proccode | int | 4 | √ | null |
|
|
Procedure code reference - Reference to the procedure code for this payment rate |
|
| userid | int | 4 | √ | null |
|
|
User reference - Reference to the user who created or manages this payment rate |
|
| paygroup | int | 4 | √ | null |
|
|
Payment group - Numeric identifier for the payment group or rate tier |
|
| ratestatus | varchar | 10 | √ | null |
|
|
Rate status - Current status of this payment rate (Active, Inactive, Pending, etc.) |
|
| minutes | int | 4 | √ | null |
|
|
Service minutes - Duration in minutes for services covered by this payment rate |
|
| fkcpid | int | 4 | √ | null |
|
|
CP reference - Reference to the claim processing or contract provider identifier |