Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkRateCodeID | int identity | 4 | null |
|
|
Primary key - Unique identifier for each rate code rule |
||
| CPID | int | 4 | null |
|
|
Claim procedure reference - Links to ClaimProcedure table for the procedure |
||
| RateRule | varchar | 100 | √ | null |
|
|
Rate rule name - Name or description of the rate rule |
|
| Claim | varchar | 100 | √ | null |
|
|
Claim information - Claim-related information for this rate rule |
|
| Program | varchar | 255 | √ | null |
|
|
Program name - Name of the program this rate rule applies to |
|
| PaySource | varchar | 131 | √ | null |
|
|
Payment source - Payment source information for this rate rule |
|
| LastUpdate | datetime | 16,3 | √ | null |
|
|
Last update date - Date when this rate rule was last updated |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated this rule |
|
| Modifier | varchar | 101 | √ | null |
|
|
Modifier information - Modifier details associated with this rate rule |
|
| CreatedDate | datetime | 16,3 | √ | null |
|
|
Creation date - Date when this rate rule was created |
|
| CreatedBy | varchar | 101 | √ | null |
|
|
Created by user - UserID of the person who created this rule |
Relationships
Close relationships within degrees of separation
