Description: Define possible routes for a given medication
| Column Name |
Ordinal Position |
|
| Column Name |
Ordinal Position |
Referenced Table |
|
|
Name |
Type |
|
| 1 |
ROUTEID |
INT |
|
|
Description: The unique Id for the Route table
|
|
Name |
Type |
|
| 2 |
DESCRIPTION |
NVARCHAR |
|
|
Description: Detailed Description
|
|
Name |
Type |
|
| 3 |
DISPLAY |
NVARCHAR |
|
|
Description: The display value of a route
|
|
Name |
Type |
|
| 4 |
ABB |
NVARCHAR |
|
|
Description: The abbreviation of a route
|
|
Name |
Type |
|
| 5 |
ACTIVE |
DATETIME2 |
|
|
Description: The date time a route became active
|
|
Name |
Type |
|
| 6 |
INACTIVE |
DATETIME2 |
|
|
Description: The date time a route became inactive
|