Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| BillingRate | Unknown | 0 | null |
|
|
Billing rate - Standard billing rate for this service mode |
||
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this mode is currently available |
||
| ModeDescription | Unknown | 0 | null |
|
|
Mode description - Detailed description of the service mode |
||
| ModeName | Unknown | 0 | null |
|
|
Mode name - Name of the service delivery mode |
||
| pkModeID | int identity | 4 | √ | null |
|
|
Primary key - KinneyModes unique identifier for each record |
|
| ModeID | int | 4 | null |
|
|
Primary key - KinneyModes unique identifier for each service mode |
||
| Mode | varchar | 500 | √ | null |
|
|
Text field - Mode text information for KinneyModes records |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_KinneyModes | Primary key | Asc | pkModeID |