Business Data Model Data Model

Entity

Entity Pharmacy Order Medication Timing Quantity

Description

The quantity, frequency, priority and timings that are associated with pharmacy orders. This type of information may be specified by a practitioner when a pharmacy order is being requested.

Attributes
Service Calculated Qty
Service Condition Txt
Service Conjunction Type
Service Duration Qty
Service Duration Unit Of Measure
Service Explicit Tm
Service Instruction Txt
Service Occurrence Duration Qty
Service Occurrence Duration Unit Of Measure
Service Priority
Service Qty
Service Quantity Calculated Unit Of Measure
Service Quantity Unit Of Measure
Service Relative Time Qty
Service Relative Time Unit Of Measure
Service Repeat Frequency
Service Requested Start Ts
Service Requested Stop Ts
Service Total Occurrence Cnt
Timing Quantity Seq

Relationship
Planned Dispensed Timing Quantity_Pharmacy Order Medication_FK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Service Calculated Qty

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

Service Condition Txt

Description	A descriptive text that explains the circumstances under which the medication service 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

Service Conjunction Type

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

Service Duration Qty

Description	The duration for which the service is requested on the pharmacy order. For Example: 1 week 5 day
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

Service Duration Unit Of Measure

Description	The units of measure in which the pharmacy order 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

Service Explicit Tm

Description	The specific times when the medication administration service is to be delivered included in the pharmacy order.
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

Service Instruction Txt

Description	The descriptive, free-text notes associated with the service instruction that can 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

Service Occurrence Duration Qty

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

Service Occurrence Duration Unit Of Measure

Description	The units of measure in which pharmacy order service occurrence duration quantity is expressed. For example: Minutes 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

Service Priority

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

Service Qty

Description	Specifies the numeric quantity of the medication administration service that is ordered. 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

Service Quantity Calculated Unit Of Measure

Description	The unit of measure in which the pharmacy order's Service Calculated 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

Service Quantity Unit Of Measure

Description	The unit of measure in which the medication order 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

Service Relative Time Qty

Description	The defined scheduled time interval between medication administration services included in the pharmacy order. 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

Service Relative Time Unit Of Measure

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

Service Repeat Frequency

Description	The repeating frequency specified in the pharmacy order. 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

Service Requested Start Ts

Description	The very first date and time the medication administration service should start which is usually specified in the pharmacy order.
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

Service Requested Stop Ts

Description	The very last date and time the medication administration service should be performed which is usually specified on the pharmacy order.
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

Service Total Occurrence Cnt

Description	The total number of medication administration occurrences that should result from this pharmacy order.
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

Timing Quantity Seq

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

Planned Dispensed Timing Quantity_Pharmacy Order Medication_FK

Description	This relationship identifies the Planned Dispensed Frequency and Quantity for the planned dosage.
Is Identifying Relationship	false
Child Table	Pharmacy Order Medication 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 / Medication
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Overview

Top

Package

Entity

Business Data Model Data Model