Alternate Data Model Proposal
ORDER fields
Identification:
OrderId
OrderType
OrderNumber
Links:
PatientId
EncounterId
Orderer
Grouping:
OrderGroup
Order Attributes:
Urgency
AdverseEventOccurred (new)
ConceptId
Indication
Instructions (patient and fulfiller see)
Comments (fulfiller sees)
Order Status and Versioning:
OrderAction
OrderStatus
OrderReasonCoded
OrderReasonNoncoded
PreviousOrder – link table with SuccessorOrders
SuccessorOrders – link table with PreviousOrder
(no longer needed: discontinued, date_discontinued, discontinued_reason, discontinued_reason_noncoded)
Order Start and End:
StartDate
AutoExpireDate
Fulfillment:
DirectedToLocation
DirectedToProvider
FulfillmentStatus
See also Managing Drug Concepts