| Business Data Model Data Model |
Description | An association between an order set and an order master. Each individual order set item combined makes the order set. For example: Echocardiogram Breakfast tray Paracetamol 1gram |
Attributes | |
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
Relationship | |
![]() |
|
![]() |
Dependencies | |
![]() |
Reverse Dependencies | |
![]() |
Attribute Details |
Description | A text message which is displayed as an informational item with an order set item at the time of the order session. |
Data Type | Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Used to organize and display orders with similar actions or intent within an order set for ease of clinical browsing and to aid understanding and order selection. They may express intent, such as "Diagnostic" or "Treatments", or be organizational in nature, such as "Laboratory" or "Radiology". |
Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A complete textual description of the order, observation or goal, including purpose, instructions, frequency, priority, repetitions, etc. All order set items with full text description but an empty order set specification layer will be considered non-actionable by the order session and will be descriptive only and function as comments to the user when an order set is displayed. |
Data Type | Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | A decision criterion or knowledge construct which may employ patient record data in order to sanction (remove) an order set item in an order set at the time an order session is active. |
Data Type | Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | An item that indicates whether the order set item will be preselected, cleared or required (preselected without an option to clear) when an order session starts. Orders considered central to a protocol are preselected, while optional and infrequent orders are cleared when the order session has started. "Mandatory" must be used only with caution in selected cases. Available choices are Yes, No or Mandatory (Required). |
Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A number indicating the placement of this order set item within the order set. |
Data Type | Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | A URL attached to the order set or order set item that can direct web software to information services relevant to the clinical situation. |
Data Type | Standards - Data Domains.ddm/Data Domains/URL [VARCHAR(255)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A clinical order priority score that may be assigned as a default by the order set author, but which may be altered programmatically at the time of order processing by guideline decision logic. |
Data Type | Standards - Data Domains.ddm/Data Domains/Score [FLOAT(5)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Relationship Details |
Description | Links the order set item to the order set which is component of. |
Is Identifying Relationship | true |
Child Table | Order Set Item |
Child Role Name | is used in |
Child Multiplicity | ZERO_TO_MANY |
Child Referential Integrity: On Delete | NONE |
Child Referential Integrity: On Insert | NONE |
Child Referential Integrity: On Update | NONE |
Parent Table | Order Set |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | false |
Child Table | Order Set Item |
Child Multiplicity | ZERO_TO_MANY |
Child Referential Integrity: On Delete | NONE |
Child Referential Integrity: On Insert | NONE |
Child Referential Integrity: On Update | NONE |
Parent Table | Order Master |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |