| Business Data Model Data Model |
Description | The combinations of route, site, administration device and administration method that are prescribed for a pharmacy order. |
Attributes | |
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
Relationship | |
![]() |
Dependencies | |
![]() |
Reverse Dependencies | |
![]() |
Attribute Details |
Description | Indicates the mechanical device used to aid in the administration of the drug or other treatment. For Example: IV Pump Metered Inhaler Nebulizer PCA Pump |
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 | Identifies the specific method requested for the administration of the drug or treatment to the patient. For Example: Dissolve Chew Dust Insert |
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 | Indicates the body site through which the drug is administered. For Example: Face Mouth Arm |
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 | Identifies the modifier which modifies the meaning of the Administration Site. |
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 | Identifies the route of administration. For Example: Apply Externally Inhalation Dental Intravenous Oral Intra-arterial |
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 | Instructions for administration routing, especially in cases where more than one route of administration is possible. For example: Designating which IV line must be used when more than one IV line is a possible route for injection. |
Data Type | Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Relationship Details |
Description | This relationship identifies the Pharmacy/Treatment Route segment alternative combination of route, site, administration device, and administration method that are prescribed as they apply to a particular order. The pharmacy, treatment staff and/or nursing staff has a choice between the routes based on either their professional judgment or administration instructions provided by the physician. |
Is Identifying Relationship | false |
Child Table | Pharmacy Order Route |
Child Role Name | alternate route |
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 | Pharmacy Order / Medication |
Parent Multiplicity | ZERO_TO_ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |