Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| RuleID | int | 4 | null |
|
|
Rule identifier - Unique identifier for each payroll rate rule |
||
| RateRule | varchar | 100 | √ | null |
|
|
Rate rule name - Descriptive name of the payroll rate rule |
|
| Claim | varchar | 100 | √ | null |
|
|
Claim type - Type of claim associated with this rate rule |
|
| Program | varchar | 255 | √ | null |
|
|
Program name - Healthcare program associated with this rate rule |
|
| RateGroup | nvarchar | 1073741823 | √ | null |
|
|
Rate group - Rate group classification for this rule |
|
| LastUpdate | datetime | 16,3 | √ | null |
|
|
Last update date - Date when this rate rule was last modified |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - Links to AccessUser table for the user who last updated this rule |
|
| Modifier | varchar | 101 | √ | null |
|
|
Rate modifier - Modifier code or description affecting the rate calculation |
|
| PayGroupID | int | 4 | null |
|
|
Pay group identifier - Identifier for the pay group associated with this rate rule |
||
| UsePaysource | varchar | 3 | null |
|
|
Use payment source flag - Indicates whether payment source is considered in rate calculation (Yes/No) |
Relationships
Close relationships within degrees of separation
