Alternate Data Model Proposal

Owned by Roger Friedman
Last updated: Nov 18, 2013

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