Business Data Model Data Model

Entity

Entity Pharmacy Intervention Recommendation

Description

The detailed recommendations that a clinical pharmacist makes in respect of a patient medication. The recommendation details include medication, route of the medication, dosage and frequency. The physician can adhere to these recommendations or reject them.

Attributes
Dosage Form
Dose Qty
Dose Quantity Unit Of Measure
Dose Strength Qty
Dose Strength Unit Of Measure
Drug Strength Vol
Drug Strength Volume Unit Of Measure
Route Type
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 Relative Time Qty
Service Relative Time Unit Of Measure
Service Repeat Frequency
Service Requested Start Ts
Service Requested Stop Ts
Service Total Occurrence Cnt

Relationship
Pharmacy Intervention Recommendation_Medication_FK
Pharmacy Intervention Recommendation_Pharmacy Intervention_FK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Dosage Form

Description	Indicates the manner in which the treatment is aggregated for dispensing. For example: Tablets Capsules Suppositories
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Dose Qty

Description	The number of doses for each administration. For example: If two 75mg aspirin are given every six hours, the quantity is 2, or if one Ampicillin 500 mg is given four times per day, the quantity is 1.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Dose Quantity Unit Of Measure

Description	Identifies the units in which the dose quantity is expressed.
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

Dose Strength Qty

Description	The requested strength of the medication. For example: Ampicillin 500 mg four times a day, where the dose strength qty is 500 and the units are milligrams.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Dose Strength Unit Of Measure

Description	Indicates the units in which the dose strength quantity is expressed. These units can be a "compound quantity;" that is, the units may express a quantity per unit of 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

Drug Strength Vol

Description	The volume measurement in which the drug strength concentration is contained. For example, Acetaminophen 120 MG/5ML Elixir means that 120 MG of the drug is in a solution with a volume of 5 ML.
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

Drug Strength Volume Unit Of Measure

Description	Indicates the volumetric unit associated with the drug strength volume.
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	Indicates the route of administration. For example: Apply Externally Buccal Dental Intravenous Oral Intra-arterial
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Service Condition Txt

Description	A textual description of the conditions under which the drug is to be given. For example, PRN pain, or to keep blood pressure below 110. This descriptive text indicates that human review is needed to determine how and when this drug should be given.
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 service should be delivered in relation to any other current service request. 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 period of time over which the service is requested.
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	Indicate the units in which the service duration quantity is expressed.
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 actual time or times referenced by the service repeat frequency. This is used to clarify the service repeat frequency in cases where the actual administration times vary within an institution. If the service request spans more than a single day, use of this time is only practical if the same times of administration occur for each day of the service request.
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	A textual description of the service instruction.
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 period of time for which a single performance of a service is requested. For example an instruction to deliver inhaled medication using a nebulizer for 5 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 in which the service occurrence duration quantity is expressed.
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 Relative Time Qty

Description	The interval between schedules for service request or bottle records. When used, this overrides any value in the explicit time instruction.
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
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 with which the treatment is to be administered.
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 earliest date and time, specified by the requester, that the services should be started. In many cases, however, the start date and time will be implied or will be defined by other information in the service request record (for example, urgency - STAT).
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 latest date and time, specified by the requester, that the service should be performed. If it has not been performed by this specified time, it should not be performed at all.
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 times a service such as a drug administration must occur as a result of a service request. If the end date, end time and the total occurrences are specified for the service and the occurrences extend beyond the end date and end time, the end date and end time takes precedence. Otherwise, the number of occurrences takes precedence.
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

Relationship Details

Pharmacy Intervention Recommendation_Medication_FK

Description	This relationship identifies the Medications recommended by the Pharmacist.
Is Identifying Relationship	false
Child Table	Pharmacy Intervention Recommendation
Child Role Name	contains
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	Medication
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Pharmacy Intervention Recommendation_Pharmacy Intervention_FK

Description	This relationship identifies the suggestions / recommendations of the Pharmacist.
Is Identifying Relationship	false
Child Table	Pharmacy Intervention Recommendation
Child Role Name	suggested by pharmacist for
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 Intervention
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