| 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 | |
Order Altering Txt |
|
Order Display Group |
|
Order Full Txt |
|
Order Sanction Logic Txt |
|
Order Set Item Preselection Type |
|
Order Set Item Seq |
|
Resource Link Url |
|
Strength Of Recommendation Scr |
|
| Relationship | |
Order Set Item Order Set FK |
|
Order Set Item Orderable Item FK |
|
| Dependencies | |
NONE |
|
| Reverse Dependencies | |
|
|
| Attribute Details |
Order Altering Txt
| 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 |
Order Display Group
| 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 |
Order Full Txt
| 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 |
Order Sanction Logic Txt
| 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 |
Order Set Item Preselection Type
| 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 |
Order Set Item Seq
| 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 |
Resource Link Url
| 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 |
Strength Of Recommendation Scr
| 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 |
Order Set Item Order Set FK
| 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 |
Order Set Item Orderable Item FK
| 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 |