| Business Data Model Data Model |
| Description | The combinations of route, site, administration device and administration method that are prescribed for a pharmacy order. |
| Attributes | |
Administration Device |
|
Administration Method |
|
Administration Site |
|
Administration Site Modifier |
|
Route Type |
|
Routing Instruction Txt |
|
| Relationship | |
Pharmacy Order Route_Pharmacy Order Medication_FK |
|
| Dependencies | |
NONE |
|
| Reverse Dependencies | |
|
|
| Attribute Details |
Administration Device
| 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 |
Administration Method
| 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 |
Administration Site
| 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 |
Administration Site Modifier
| 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 |
Route Type
| 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 |
Routing Instruction Txt
| 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 |
Pharmacy Order Route_Pharmacy Order Medication_FK
| 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 |