Business Data Model Data Model

Entity

Entity Medication

Description

Drug products that may be administered to or taken by a person typically for the purpose of curing a medical condition, relieving the symptoms of a medical condition or preventing the development of a medical condition.

Attributes
Compound Or Out Of The Box Ind
Compound Type
Controlled Substance Ind
Create Date
CSA Code
Descr
Dispensing Unit Of Measure
Dosage Calculation Ind
Dosage Formulation
Drug Branding Type
Drug Dosage Format
Drug Product Average Wholesale Price AWP Amt
Drug Purpose
Drug Therapeutic Category
Drug Therapeutic Class
Generic Product Index Code
Is Active Ind
J Code
Legend Drug Ind
List Price New
Make
Manufacturer Generic Product Name
Medication Strength
Medication Update Date
Multisource Ind
National Drug Code NDC
Number of Compound Ingredient Components
Obsolete Date
Pharmacologic Class
Route Type
RxNorm Code
RX OTC Status
Safety Rating
Specification Year

Relationship
Pharmacy Drug Code Generic Drug Code_FK
Medication_Common Code_FK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Compound Or Out Of The Box Ind

Description	An indicator that shows whether the drug product must be made up by a pharmacist (Compound) or is available in a premanufactured format (for example, a commercial cough syrup) (Out Of The Box). For example: C = Compound Product O = Out Of The Box Product
Data Type	Standards - Data Domains.ddm/Data Domains/Single Letter [CHAR(1)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Compound Type

Description	Classifies the Compound Drug Product by type.
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

Controlled Substance Ind

Description	Indicates whether or not this drug is a controlled substance. A controlled substance is a dangerous or abusable drug, such as narcotics and non-narcotics listed in the five schedules of Title 21 of the US.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Create Date

Description	The date upon which this record was created on the source system.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

CSA Code

Description	Describes the drug class assigned to a specific product type under the Controlled Substances Act of 1970. For example: Drug is not subject to the Controlled Substances Act of 1970. High potential for abuse. Prescriptions must be written in ink or typewritten and signed by the practitioner. Verbal prescriptions must be reduced to writing within 72 hours and may be given only in a genuine emergency. No refills are allowed.
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

Descr

Description	A free-text statement describing the medication.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Dispensing Unit Of Measure

Description	Specifies the Unit of Measure in which the medication dispensing 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

Dosage Calculation Ind

Description	Indicates how the drug strength should be calculated. For example: Blank Dose: Bulk containers of topical ointments/creams (package size rather than dose supplied) Use Strength Dose - Premix IV bags Use Reduced Calc - Suspensions, especially pediatric concentrations
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Dosage Formulation

Description	A standard list of dose formulations for mapping of facility data. The standardized dose formulations can appear in alert functionality, reports or both. The formulation is associated to the pharmacy drug as packaged.
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 Branding Type

Description	Classifies drug products according to how it is brought to market, whether under a highly specific brand name, the generic drug name or both to a greater or lesser prominence.
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 Dosage Format

Description	Classifies drug products according to the dosage form of the complete compound mixture.
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 Product Average Wholesale Price AWP Amt

Description	The Average Wholesale Price is a commercially published reference price for a drug based on information from manufacturers and distributors. It is not necessarily based on actual sales data. It is used as a basis for determining reimbursement for a prescription as well as for determining rebates from drug manufacturers.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Drug Purpose

Description	Classifies a drug according to its intended purpose.
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 Therapeutic Category

Description	Classifies drugs based typically on diseases or symptoms that they are used to treat, such as pain or depression.
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 Therapeutic Class

Description	A grouping of drugs with similar characteristics.
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

Generic Product Index Code

Description	A code taken from the FDA's Approved Drug Products list, also known as the 'Orange Book', that shows equivalence between the reference listed drug and the approved generic. (US only)
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

Is Active Ind

Description	Indicates whether or not this drug is active.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

J Code

Description	A designation for the Healthcare Common Procedure Code (J-Code) used for submitting claims to insurance organizations.
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

Legend Drug Ind

Description	Indicates whether, by law, the medication cannot be dispensed without a prescription, or can be made available over the counter. For example: 0 = Over The Counter 1 = Prescription Only
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

List Price New

Description	The purchase price of this particular medication.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Make

Description	Identifies the family or range to which a medication belongs. For example: Bayer Aspirin for drugs.
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

Manufacturer Generic Product Name

Description	The manufacturer's generic name for this drug.
Data Type	Standards - Data Domains.ddm/Data Domains/Name Compound [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Medication Strength

Description	A standard list of drug product strengths for mapping facility data. The standardized strengths can appear in alert functionality, reports or both. The strength is associated with the pharmacy drug as packaged.
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

Medication Update Date

Description	The date upon which the medication details are edited/updated.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Multisource Ind

Description	Indicates whether or not this medication can be obtained from more than a single supplier.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

National Drug Code NDC

Description	Identifies prescription and non-prescription drugs. NDC codes reflect the manufacturer or distributor, the product code, drug formulation, strength, dosage form (tablet or capsule), and package size. The National Drug Code Directory is managed by the US Food and Drug Administration (FDA). For example: 10-digit 3-segment number: 12345-678-90
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number of Compound Ingredient Components

Description	In case of a compound drug product, the number of distinct ingredients, which are defined as drug products themselves, that are included in the compound drug product.
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

Obsolete Date

Description	The date upon which this drug becomes obsolete, no longer available.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Pharmacologic Class

Description	A sub classification of therapeutic category, primarily based on the drug's mechanism of action. The combination of these pharmacological classes and the therapeutic categories that are not subdivided into classes create unique drug groupings.
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 Buccal 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

RxNorm Code

Description	References an external RxNorm database containing normalized names for clinical drugs as well as links to drug vocabularies.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

RX OTC Status

Description	The Over the Counter / Prescription Status Code of this drug or medication.
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

Safety Rating

Description	A rating of the degree to which the classified object represents a hazard.
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

Specification Year

Description	The year for this drug specification. Note that drug specification may change from year to year.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Pharmacy Drug Code Generic Drug Code_FK

Is Identifying Relationship	false
Child Table	Medication
Child Role Name	contains
Child Multiplicity	ONE_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Generic Drug
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Medication_Common Code_FK

Is Identifying Relationship	true
Child Table	Medication
Child Role Name	medication is of
Child Multiplicity	ZERO_TO_ONE
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Common Code
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