AcuityEnd TsEvidence Based IndLast Edit TsOrder Set DescrOrder Set IdOrder Set NameOrder Set TypePersonal IndProtocol CodeResource Link UrlStart TsUse Case Scenario DescrVersion Num
| Business Data Model Data Model |
| Description | A group of orders that are requested together for a patient. They are used to standardize and expedite the ordering process for a common clinical scenario. For example: Chest pain order set Pre operative order set |
| Relationship | |
 Order Set_Order Set_FK |
|
| Order Set_Practitioner_FK |
|
| Order Set_Procedure Code_FK |
|
| Order Set_Provider_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Acuity
| Description | Denotes the level of care or the urgency of a persons condition or treatment ordered or given. For example: Acute Chronic Emergency |
| 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 |
End Ts
| Description | The date and time that the availability of an order set ends and is no longer valid for use. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Evidence Based Ind
| Description | Indicates whether or not the order set is evidence based. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Last Edit Ts
| Description | The date and time when the order set was last modified. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Order Set Descr
| Description | A summary description of the order set. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Order Set Id
| Description | Uniquely identifies an order set and may be employed to nest an order set as an order set item within another order set. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Order Set Name
| Description | A descriptive name given to the order set. Also referred to as the title of the order set. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Order Set Type
| Description | Indicates the type of order set. For example: Protocol Care standard Convenience |
| 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 |
Personal Ind
| Description | Indicates whether or not the order set is owned by an individual. If the order set is owned by an individual, the value is true. If the order set is owned by an institution, the value is false. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Protocol Code
| Description | Identifies a protocol related to the order set. |
| 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 |
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 |
Start Ts
| Description | The date and time that the availability of an order set begins and is valid for use. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Use Case Scenario Descr
| Description | A more thorough description of the purpose and use of the order set. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description Long [VARCHAR(1024)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Version Num
| Description | Designates a value that can be used to identify a unique set of entries. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Order Set_Order Set_FK
| Description | A link to an earlier order set that is now superseded by the current order set. |
| Is Identifying Relationship | false |
| Child Table | Order Set |
| Child Role Name | replaces |
| 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_Practitioner_FK
| Description | The owner of the order set. These are order sets that are defined by individual practitioners in addition to the standard ones defined by the institutional provider. These custom defined order sets are typically available only to their author or those authorized by the author to use them. |
| Is Identifying Relationship | false |
| Child Table | Order Set |
| Child Role Name | is owned by |
| 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 | Practitioner |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Order Set_Procedure Code_FK
| Is Identifying Relationship | false |
| Child Table | Order Set |
| Child Role Name | is restricted by |
| 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 | Procedure Code |
| Parent Role Name | restricts applicability |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Order Set_Provider_FK
| Description | The health care provider that defined the oder set, typically as part of the standard order set that are pre-loaded in an ordering system. |
| Is Identifying Relationship | false |
| Child Table | Order Set |
| Child Role Name | is defined by |
| 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 | Provider |
| 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 |