Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkRateCodeID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each rate code rule record |
|
| fkCPID | int | 4 | null |
|
|
Claim type program reference - Links to claim type program configuration that this rate code rule applies to |
||
| PaySourceID | varchar | 30 | null |
|
|
Payment source identifier - Identifier for the payment source or payer that this rate code rule applies to |
||
| fkRateCode | varchar | 20 | null |
|
|
Rate code reference - Reference to the specific rate code or rate structure for this rule |
||
| LastUpdate | datetime | 16,3 | √ | null |
|
|
Last update timestamp - Date and time when this rate code rule was last modified |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - Links to AccessUser table for the user who last updated this rate code rule |
|
| CreatedDate | datetime | 16,3 | √ | null |
|
|
Creation timestamp - Date and time when this rate code rule was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - Links to AccessUser table for the user who created this rate code rule |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - Date and time when this rate code rule was soft deleted |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_RateCodeRule | Primary key | Asc | pkRateCodeID |
| IX_CPID | Performance | Asc | fkCPID |
| IX_PaySource | Performance | Asc | PaySourceID |
| IX_PaySourceID | Performance | Asc | PaySourceID |
Relationships
Close relationships within degrees of separation
