| Business Data Model Data Model |
Description | The quantity, frequency, priority and timings that are associated with the planned giving of pharmacy orders. This type of information may be specified by a practitioner when a pharmacy order is being requested. |
Relationship | |
![]() |
Dependencies | |
![]() |
Reverse Dependencies | |
![]() |
Attribute Details |
Description | Specifies the calculated numeric quantity of the medication administration service that should be provided at each interval. For Example: If two saline nebulizers are to be given every 4 hours then the quantity is 2 |
Data Type | Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A descriptive text that explains the circumstances under which the medication, treatment service or both must be delivered, and indicates that human review is needed to determine how and when this service must be given. For example: For acute pain For nausea and vomiting |
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 |
Description | Indicates how the medication administration service should be delivered in relation to any other medication administration service. For example: Synchronous Asynchronous Actuation Time |
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 | The duration for which the service is requested. For Example: 1 week 5 days |
Data Type | Standards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The units of measure in which the medication administration Service Duration Qty is expressed. For Example: Days Weeks Hours |
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 | The specific times when the medication administration service is to be delivered. |
Data Type | Standards - Data Domains.ddm/Data Domains/Time [TIME] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The descriptive free text notes associated with the service instruction. It may include a detailed description of the conditions or procedure to be followed when administering the medication. |
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 |
Description | The duration for a single performance of a medication administration service. For Example: IV Antibiotics over 30 minutes |
Data Type | Standards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The unit of measure describing the duration for which a single performance of a service is requested. |
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 | Describes the urgency of the request. For example: Route Stat Urgent |
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 | Specifies the numeric quantity of the medication administration service that is scheduled for each instance. For Example: If two saline nebulizers are to be given every 4 hours then the quantity is 2 |
Data Type | Standards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The unit of measure in which the calculated medication administration service quantity is expressed. For Example: If two saline nebulizers are to be given every 4 hours then the unit of measure is nebulizer |
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 | The unit of measure in which the medication administration service quantity is expressed. For Example: If two saline nebulizers are to be given every 4 hours then the unit of measure is nebulizer |
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 | Used to define the scheduled time interval between scheduled medication administration services. For Example: Every 4 hours Every 6 hours |
Data Type | Standards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The units of measure in which the service relative time is expressed. For example: Minutes Hours Days |
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 | The repeating frequency with which the medication administration service is to be provided. For Example: QID - Four Times Daily OD- Once Daily |
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 | The very first date and time the medication administration service should start which is usually specified by the requester. |
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 |
Description | The very last date and time the medication administration service should be performed which is usually specified by the requester. |
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 |
Description | The total number of medication administration occurrences that should result from this service request. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | An integer number starting at 1 and incrementing by one to provide uniqueness for each occurrence of a service delivery. For example: 3rd of 4 saline nebulizers 2nd of 4 physiotherapy assessments. |
Data Type | Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Relationship Details |
Is Identifying Relationship | true |
Child Table | Pharmacy Order Give Timing Quantity |
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 Give |
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 |