Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| RateID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each provider rate |
||||
| Rates | money | 21,4 | √ | null |
|
|
Rate amount - Dollar amount paid to provider per unit of service |
||||
| DateEffective | smalldatetime | 16 | √ | null |
|
|
Effective date - Date when this rate becomes effective |
||||
| GroupName | varchar | 100 | √ | null |
|
|
Rate group - Name of the rate group or classification |
||||
| Comment | varchar | 500 | √ | null |
|
|
Rate comments - Notes about the rate or payment terms |
||||
| Patientid | int | 4 | √ | null |
|
|
Patient reference - Links to Patient table if rate is patient-specific |
||||
| 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 |
||||
| ProcCode | int | 4 | √ | null |
|
|
Procedure code - Reference to procedure code for rate determination |
||||
| UserID | int | 4 | √ | null |
|
|
Provider reference - Links to AccessUser table for the healthcare provider |
||||
| PayGroup | int | 4 | √ | null |
|
|
Pay group - Links to UserPayGroup table for payroll classification |
||||
| DateEnd | smalldatetime | 16 | √ | null |
|
|
End date - Date when this rate expires or becomes inactive |
||||
| RateStatus | varchar | 10 | √ | null |
|
|
Rate status - Current status of the rate (Active, Inactive, etc.) |
||||
| Minutes | int | 4 | √ | null |
|
|
Service duration - Duration in minutes for this rate (minimum) |
||||
| fkCPID | int | 4 | √ | null |
|
|
Care plan reference - Links to care plan if rate is plan-specific |
||||
| MinutesTo | int | 4 | √ | null |
|
|
Maximum duration - Maximum duration in minutes for this rate |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this rate |
||||
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation date - Timestamp when the rate was created |
||||
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated this rate |
||||
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Last update date - Date when the rate was last modified |
||||
| Paysource | varchar | 10 | √ | null |
|
|
Payment source - Payment source or funding source for this rate |
||||
| NumInGroup | int | 4 | √ | null |
|
|
Group size - Number of participants in group sessions for this rate |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__Rate__61F08603 | Primary key | Asc | RateID |
Relationships
Close relationships within degrees of separation
