Atomic Warehouse 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
Active Ind
Compound Or Out Of The Box Ind
Compound Type Code Sk
Controlled Substance Ind
Create Dt
CSA Code Sk
Descr
Dispensing Unit Of Measure Code Sk
Dosage Formulation Code Sk
Drug Branding Type Code Sk
Drug Dosage Format Code Sk
Drug Product Average Wholesale Price AWP Amt
Drug Purpose Code Sk
Drug Therapeutic Category Code Sk
Drug Therapeutic Class Code Sk
Generic Drug Code Sk
Generic Product Index Code Sk
J Code Sk
Legend Drug Ind
List Price New
Load Info Sk
Make Code Sk
Manufacturer Generic Product Nm
Medication Code Sk
Multisource Ind
National Drug Code NDC
Number of Compound Ingredient Components
Obsolete Dt
Pharmacologic Class Code Sk
Route Code Sk
RxNorm Code Sk
RX OTC Status Code Sk
Safety Rating Code Sk
Source Code Sk
Specification Year
Strength Code Sk
Tenant Sk
Update Dt

Relationship
Medication_Generic Drug_FK
Medication_Common Code_FK

Primary Key
Medication PK

Dependencies

Reverse Dependencies

Attribute Details

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

Compound Or Out Of The Box Ind

Description	Indicates whether the drug product must be made up by a pharmacist (Compound) or is available in a pre-manufactured 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 Code Sk

Description	Classifies the Compound Drug Product by type.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
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 Dt

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 Sk

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/Surrogate Key [INTEGER]
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 Code Sk

Description	Specifies the Unit of Measure in which the medication dispensing is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Dosage Formulation Code Sk

Description	A standard list of dose formulations must be available for mapping of facility data. The standardized dose formulations may appear in alert functionality and/or reports. The formulation is associated to the pharmacy drug as packaged.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Drug Branding Type Code Sk

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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Drug Dosage Format Code Sk

Description	Classifies drug products according to the dosage form of the complete compound mixture.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
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 Code Sk

Description	Classifies a drug according to its intended purpose.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Drug Therapeutic Category Code Sk

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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Drug Therapeutic Class Code Sk

Description	A grouping of drugs with similar characteristics.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Generic Drug Code Sk

Description	The generated unique key for Common Code table.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Generic Product Index Code Sk

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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

J Code Sk

Description	A designation for the Health Care Common Procedure Code (J-Code) used for submitting claims to insurance organizations.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
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

Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Make Code Sk

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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Manufacturer Generic Product Nm

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 Code Sk

Description	The generated unique key for Common Code table.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	true
Is Required	true
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 Dt

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 Code Sk

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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Route Code Sk

Description	Identifies the route of administration. For example: Apply Externally Buccal Dental Intravenous Oral Intra-arterial
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

RxNorm Code Sk

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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

RX OTC Status Code Sk

Description	The Over the Counter / Prescription Status Code of this drug or medication.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Safety Rating Code Sk

Description	A rating of the degree to which the classified object represents a hazard.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Source Code Sk

Description	The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
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

Strength Code Sk

Description	A standard list of drug product strengths must be available for mapping of facility data. The standardized strengths may appear in alert functionality and/or reports. The strength is associated to the pharmacy drug as packaged.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Tenant Sk

Description	The surrogate key of the entry identifying the legal owner of the data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Update Dt

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

Relationship Details

Medication_Generic Drug_FK

Is Identifying Relationship	false
Child Table	Medication
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	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 Multiplicity	ZERO_TO_MANY
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

Primary Key Details

Medication PK

Key Attribute

Medication Code Sk

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model