| Atomic Warehouse 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 |
| Relationship | |
 Order Set Item Detail_Order Set Item_FK |
|
| Primary Key | |
 Order Set Item Detail PK |
|
| Dependencies | |
 |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
Effective From Dt
| Description | Establishes a period where a set of attributes are true according to the business. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Effective To Dt
| Description | Ends a period of effectivity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Load Info Sk
| Description | The surrogate key of the load information entry describing the details regarding the loading of the row. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
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 Code Sk
| 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/Surrogate Key [INTEGER] |
| 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 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 |
Order Set Item Sk
| Description | Surrogate key for the anchor entity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Preselection Type Code Sk
| Description | Indicates whether this order set item will be preselected, unselected or required (preselected without an option to unselect) at the time an order session starts. Orders considered central to a protocol will be preselected, while optional and infrequent orders will be unselected at the time the order session is begun. Mandatory should be used only with caution in selected cases. Available choices are Yes, No or Mandatory (Required). |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Relationship Type Code Sk
| Description | Code identifying the actual type of the relationship as defined in the business data model. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [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 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 |
Source Code Sk
| Description | The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| 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 |
Tenant Sk
| Description | The surrogate key of the entry identifying the legal owner of the data. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Valid From Ts
| Description | Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Valid To Ts
| Description | Ends a period of validity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Order Set Item Detail_Order Set Item_FK
| Is Identifying Relationship | true |
| Child Table | Order Set Item Detail |
| Child Role Name | is detail for |
| 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 Item |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Primary Key Details |
Order Set Item Detail PK
| Key Attribute | Order Set Item Sk |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |