Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| RateID | int | 4 | null |
|
|
Primary key - Unique identifier for the billing rate configuration |
||
| Rates | money | 21,4 | √ | null |
|
|
Rate amount - Monetary amount for the billing rate (per hour, per session, or per unit) |
|
| DateEffective | smalldatetime | 16 | √ | null |
|
|
Effective date - Date when this billing rate becomes effective |
|
| GroupName | varchar | 50 | √ | null |
|
|
Rate group name - Name of the rate group this configuration belongs to |
|
| Comment | varchar | 500 | √ | null |
|
|
Rate comments - Additional notes or comments about this billing rate configuration |
|
| Patientid | int | 4 | √ | null |
|
|
Patient identifier - Foreign key to specific patient if this is a patient-specific rate |
|
| 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 |
|
| ProcCode | int | 4 | √ | null |
|
|
Procedure code - Foreign key linking to specific procedure code this rate applies to |
|
| UserID | int | 4 | √ | null |
|
|
User identifier - Foreign key linking to specific healthcare provider this rate applies to |
|
| PayGroup | int | 4 | √ | null |
|
|
Pay group - Foreign key linking to pay group classification for this rate |
|
| DateEnd | smalldatetime | 16 | √ | null |
|
|
End date - Date when this billing rate expires or becomes inactive |
|
| RateStatus | varchar | 10 | √ | null |
|
|
Rate status - Current status of the billing rate (Active, Inactive, Pending, etc.) |
|
| Minutes | int | 4 | √ | null |
|
|
Minimum minutes - Minimum number of minutes required for this rate to apply |
|
| fkCPID | int | 4 | √ | null |
|
|
Claim type foreign key - Links to claim type configuration that uses this rate |
|
| MinutesTo | int | 4 | √ | null |
|
|
Maximum minutes - Maximum number of minutes this rate applies to (for tiered rates) |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - User ID of the person who created this rate configuration |
|
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation date - Timestamp when this rate configuration was created |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - User ID of the person who last modified this rate configuration |
|
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Update date - Timestamp when this rate configuration was last modified |
|
| Paysource | varchar | 10 | √ | null |
|
|
Payment source - Code identifying the funding source or insurance that uses this rate |
|
| ProCode | varchar | 30 | null |
|
|
Procedure code value - Actual procedure code value (CPT, HCPCS, etc.) for billing |
||
| Procedureid | int | 4 | √ | null |
|
|
Procedure identifier - Foreign key linking to procedure code definition |
|
| ModifierName | varchar | 151 | null |
|
|
Modifier name - Descriptive name of the billing modifier associated with this rate |
||
| ServiceTypeName | varchar | 111 | null |
|
|
Service type name - Descriptive name of the service type this rate applies to |
||
| ProviderName | varchar | 101 | null |
|
|
Provider name - Full name of the healthcare provider this rate applies to |
||
| ChildName | varchar | 101 | null |
|
|
Child name - Full name of the child/patient if this is a patient-specific rate |
||
| PayGroupID | int | 4 | √ | null |
|
|
Pay group identifier - Unique identifier for the pay group classification |
|
| RateGroupName | varchar | 30 | null |
|
|
Rate group name - Descriptive name of the rate group for organizational purposes |
Relationships
Close relationships within degrees of separation
