Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| RateID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each billing rate |
|
| fkPaysourceID | varchar | 20 | √ | null |
|
|
Payment source - Identifier for the payer or insurance company |
|
| fkCPID | int | 4 | √ | null |
|
|
Care plan reference - Links to care plan if rate is plan-specific |
|
| ProcedureID | int | 4 | √ | null |
|
|
Procedure reference - Links to procedures table for the CPT/HCPCS code |
|
| ServiceTypeid | int | 4 | √ | null |
|
|
Service type - Links to iCS2.dbo.ServiceType for centralized service type definitions and standardized service codes across the multi-tenant healthcare system |
|
| ModifierID | int | 4 | √ | null |
|
|
Modifier reference - Links to iCS2.dbo.Modifier for centralized billing modifier definitions and standardized modifier codes used across all healthcare billing processes |
|
| Minutes | int | 4 | √ | null |
|
|
Service duration - Duration in minutes for this rate (minimum) |
|
| RateAmt | money | 21,4 | √ | null |
|
|
Rate amount - Dollar amount charged per unit of service |
|
| DateRetroactive | datetime | 16,3 | √ | null |
|
|
Retroactive date - Date from which rate changes apply retroactively |
|
| DateEffective | datetime | 16,3 | √ | null |
|
|
Effective date - Date when this rate becomes effective |
|
| Dateinactive | datetime | 16,3 | √ | null |
|
|
Inactive date - Date when this rate becomes inactive |
|
| RateName | varchar | 200 | √ | null |
|
|
Rate name - Descriptive name for this rate structure |
|
| Comments | varchar | 500 | √ | null |
|
|
Rate comments - Notes about the rate or billing requirements |
|
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation date - Timestamp when the rate was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this rate |
|
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Last update date - Timestamp of the most recent rate update |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last modified this rate |
|
| MinutesTo | int | 4 | √ | null |
|
|
Maximum duration - Maximum duration in minutes for this rate |
|
| NumInGroup | int | 4 | √ | null |
|
|
Group size - Number of participants for group service rates |
|
| CPTCodeID | int | 4 | √ | null |
|
|
CPT code reference - Links to CPT code table for procedure coding |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__BillingRate__367DAEC7 | Primary key | Asc | RateID |
| IX_cpid | Performance | Asc | fkCPID |
| IX_Dateeffective | Performance | Asc | DateEffective |
| IX_DateInactive | Performance | Asc | Dateinactive |
| IX_Modifier | Performance | Asc | ModifierID |
| IX_PaysourceID | Performance | Asc | fkPaysourceID |
| IX_Procedure | Performance | Asc | ProcedureID |
| IX_ServiceTypeID | Performance | Asc | ServiceTypeid |
Relationships
Close relationships within degrees of separation
