Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| RateID | int identity | 4 | null |
|
|
Rate primary key - Unique identifier for each billing rate configuration |
||
| RateName | varchar | 200 | √ | null |
|
|
Rate name - Descriptive name for the billing rate |
|
| PaySource | varchar | 145 | √ | null |
|
|
Payment source - Name of the payment source or payer |
|
| Program | varchar | 255 | √ | null |
|
|
Program name - Name of the healthcare program |
|
| Claim | varchar | 100 | √ | null |
|
|
Claim type - Type of claim associated with this rate |
|
| RateRule | varchar | 100 | √ | null |
|
|
Rate rule - Description of the rate code rule applied |
|
| Amount | money | 21,4 | √ | null |
|
|
Rate amount - Monetary amount for this billing rate |
|
| 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 |
|
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Last update date - Date when rate was last updated |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated the rate |
|
| Modifier | varchar | 101 | √ | null |
|
|
Modifier name - Full name of the person who modified the rate |
|
| Minute | int | 4 | √ | null |
|
|
Minimum minutes - Minimum number of minutes for this rate |
|
| MinuteTo | int | 4 | √ | null |
|
|
Maximum minutes - Maximum number of minutes for this rate |
|
| NumInGroup | int | 4 | √ | null |
|
|
Group size - Number of participants in group for group rates |
|
| ModifierInfo | varchar | 151 | √ | null |
|
|
Modifier information - Combined modifier name and description |
|
| ProcedureInfo | varchar | 131 | √ | null |
|
|
Procedure information - Combined procedure code and description |
|
| ServiceInfo | varchar | 111 | √ | null |
|
|
Service information - Combined service type and description |
Relationships
Close relationships within degrees of separation
