ALTERNATIVES
Description:
This table contains basic information about medication and procedure alternative records.
Primary Key
Column Name
Ordinal Position
ALTERNATIVE_ID
1
Column Information
Name
Type
Discontinued?
1
ALTERNATIVE_ID
NUMERIC
No
The unique alternative ID.
2
ALTERNATIVE_ID_ALTERNATIVE_NAME
VARCHAR
No
This column contains the name of the alternative medication and procedure records.
3
ALTERNATIVE_NAME
VARCHAR
No
This column contains the name of the alternative medication and procedure records.