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