Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| RateID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each temporary rate record |
|
| Rates | money | 21,4 | √ | null |
|
|
Rate amount - The monetary rate or fee amount |
|
| DateEffective | smalldatetime | 16 | √ | null |
|
|
Effective date - Date when the rate becomes effective |
|
| GroupName | varchar | 50 | √ | null |
|
|
Rate group name - Name of the rate group or category |
|
| Comment | varchar | 500 | √ | null |
|
|
Rate comments - Additional comments about the rate |
|
| Patientid | int | 4 | √ | null |
|
|
Patient reference - Links to specific patient if rate is patient-specific |
|
| Servicetypeid | int | 4 | √ | null |
|
|
Service type reference - Links to iCS2.dbo.ServiceType for centralized service type definitions and standardized service codes |
|
| Modifierid | int | 4 | √ | null |
|
|
Modifier reference - Links to iCS2.dbo.Modifier for centralized billing modifier definitions and rate adjustments |
|
| ProcCode | int | 4 | √ | null |
|
|
Procedure code reference - Links to the procedure code |
|
| UserID | int | 4 | √ | null |
|
|
User reference - Links to the user associated with the rate |
|
| PayGroup | int | 4 | √ | null |
|
|
Pay group reference - Links to the pay group for the rate |
|
| DateEnd | smalldatetime | 16 | √ | null |
|
|
End date - Date when the rate expires or ends |
|
| RateStatus | varchar | 10 | √ | null |
|
|
Rate status - Current status of the rate (Active, Inactive, Pending, etc.) |
|
| Minutes | int | 4 | √ | null |
|
|
Duration minutes - Duration in minutes for time-based rates |
|
| fkCPID | int | 4 | √ | null |
|
|
Care plan reference - Links to the care plan if applicable |
|
| MinutesTo | int | 4 | √ | null |
|
|
Duration range end - End of minute range for tiered time-based rates |
Relationships
Close relationships within degrees of separation
