Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| fkRatecode | varchar | 20 | null |
|
|
Rate code foreign key - Links to the rate code configuration |
||
| paysourceid | varchar | 30 | null |
|
|
Payment source identifier - Identifies the insurance or funding source for rate lookup |
||
| fkcpid | int | 4 | null |
|
|
Claim type foreign key - Links to claim type configuration |
||
| procedureid | int | 4 | √ | null |
|
|
Procedure identifier - Foreign key linking to procedure code (CPT, HCPCS) |
|
| servicetypeid | int | 4 | √ | null |
|
|
Service type identifier - Foreign key linking to iCS2.dbo.ServiceType for centralized service type definitions and standardized service codes |
|
| modifierid | int | 4 | √ | null |
|
|
Modifier identifier - Foreign key linking to iCS2.dbo.Modifier for centralized billing modifier definitions and standardized modifier codes |
|
| minutes | int | 4 | √ | null |
|
|
Minimum minutes - Minimum service duration for this rate to apply |
|
| RateAmt | money | 21,4 | √ | null |
|
|
Rate amount - Billing rate amount for the specified service configuration |
|
| dateretroactive | datetime | 16,3 | √ | null |
|
|
Retroactive date - Date from which rate changes apply retroactively |
|
| dateeffective | datetime | 16,3 | √ | null |
|
|
Effective date - Date when this billing rate becomes effective |
|
| dateinactive | datetime | 16,3 | √ | null |
|
|
Inactive date - Date when this billing rate becomes inactive |
|
| MinutesTo | int | 4 | √ | null |
|
|
Maximum minutes - Maximum service duration for this rate (for tiered rates) |
|
| NumInGroup | int | 4 | √ | null |
|
|
Group size - Number of participants for group service rates |
|
| CPTCodeID | int | 4 | √ | null |
|
|
CPT code identifier - Foreign key linking to specific CPT procedure code |
Relationships
Close relationships within degrees of separation
