Dimensional Warehouse Model Data Model

Entity

Entity Medication Dimension

Description

A standard list of pharmacy drugs must be available for mapping of facility data. The standardized pharmacy drug names may appear in alert functionality and/or reports. Pharmacy drugs contain a reference to the generic drug mentioned above in section 3.1, as well as the route, dose form, and strength information. Pharmacy Drugs are defined as the drugs ordered and administered for treatment of a patient. A separate requirements document will be created for laboratory drugs, used in microbiology susceptibility.

Attributes
AWM Load Info Sk
Brand Or Generic Code Sk
CSA Cd
CSA Code Sk
CSA Descr
Current Ind
Defined Daily Dosage Qty
Defined Daily Dosage UOM Cd
Defined Daily Dosage UOM Code Sk
Defined Daily Dosage UOM Descr
Dosage Calculation Ind
Dosage Formulation Cd
Dosage Formulation Code Sk
Dosage Formulation Descr
DWM Load Info Sk
Effective From Dt
Effective To Dt
Full Nm
Generic Drug Cd
Generic Drug Code Sk
Generic Drug Descr
Generic Product Index Cd
Half Life Empirical Ind
Half Life Hours Qty
Ingredient Ind
Investigational Drug Ind
J Cd
J Code Sk
J Descr
Manufacturer Generic Nm
Manufacturer Generic Product Nm
Medication Bk
Medication Cd
Medication Descr
Medication Dimension Domain Nm
Medication Dk
Medication Sk
Multisource Ind
Obsolete Dt
Pregnancy Risk Factor Cd
Pregnancy Risk Factor Code Sk
Pregnancy Risk Factor Descr
Product Ind
RX OTC Status Cd
RX OTC Status Code Sk
RX OTC Status Descr
Source Cd
Source Code Descr
Source Code Sk
Standard Medication Code Sk
Standard Route Cd
Standard Route Code Sk
Standard Route Descr
Strength Cd
Strength Code Sk
Strength Denominator Num
Strength Denominator UOM Cd
Strength Denominator UOM Code Descr
Strength Denominator UOM Code Sk
Strength Descr
Strength Numerator Num
Strength Numerator UOM Cd
Strength Numerator UOM Code Descr
Strength Numerator UOM Code Sk
Tenant Sk
Use Facility Dose Ind
Use Reduced Calculation Ind
Use Strength Dose Ind
Valid From Ts
Valid To Ts

Primary Key
Medication Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

AWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
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

Brand Or Generic Code Sk

Description	Code indicating if the medication is a brand name medication or a generic.
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

CSA Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
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	true
Is Derived	false
Is Surrogate Key	false

CSA Descr

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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Current Ind

Description	Set to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Defined Daily Dosage Qty

Description	Amount recorded as the defined daily dose for a medication.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Defined Daily Dosage UOM Cd

Description	Indicates the unit of measure for the defined daily dosage quantity.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Defined Daily Dosage UOM Code Sk

Description	Indicates the unit of measure for the defined daily dosage quantity.
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

Defined Daily Dosage UOM Descr

Description	Indicates the unit of measure for the defined daily dosage quantity.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Dosage Calculation Ind

Description	Indicates whether or not the drug strength should be calculated for strength dosage such as premix IV bags.
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 Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
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	true
Is Derived	false
Is Surrogate Key	false

Dosage Formulation Descr

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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

DWM 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

Effective From Dt

Description	Establishes a period where a set of attributes are true according to the business.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Effective To Dt

Description	Ends a period of effectivity.
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

Full Nm

Description	The generated unique key for Common Code table.
Data Type	Standards - Data Domains.ddm/Data Domains/Name Medium [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Generic Drug Cd

Description	A code which identifies a generic medication.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Generic Drug Code Sk

Description	The generated unique key for a generic drug.
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 Drug Descr

Description	Additional details about a generic medication.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Generic Product Index Cd

Description	Identifies the medication by therapeutic classifications.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Half Life Empirical Ind

Description	Indicates whether or not the half-life is arrived at empirically.
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

Half Life Hours Qty

Description	Indicates the amount of time required for the concentration of the drug to be reduced to half of its peak value.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Ingredient Ind

Description	Indicates whether this drug is used as an ingredient in another drug. 1 Ingredient 0 Not an ingredient
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

Investigational Drug Ind

Description	Indicates if the drug is still in experimental status.
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 Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
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	true
Is Derived	false
Is Surrogate Key	false

J Descr

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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Manufacturer Generic Nm

Description	The manufacturer's generic name for this drug.
Data Type	Standards - Data Domains.ddm/Data Domains/Name Long [VARCHAR(255)]
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 Bk

Description	Concatenated values of a set of business attributes that uniquely identify the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Medication Cd

Description	Indicates the medication.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Medication Descr

Description	Additional information about a medication.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Medication Dimension Domain Nm

Description	A unique name for a group or type of codes. For example: RxNorm NDC
Data Type	Standards - Data Domains.ddm/Data Domains/Domain Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Medication Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	true

Medication Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
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

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

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

Pregnancy Risk Factor Cd

Description	Indicates whether there are any pregnancy risks associated with this drug.
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

Pregnancy Risk Factor Code Sk

Description	Indicates whether there are any pregnancy risks associated with this drug.
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

Pregnancy Risk Factor Descr

Description	Indicates whether there are any pregnancy risks associated with this drug.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Product Ind

Description	Indicates whether or not this drug is a stand-alone product.
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

RX OTC Status Cd

Description	The Over the Counter / Prescription Status Code of this drug or medication.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
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	true
Is Derived	false
Is Surrogate Key	false

RX OTC Status Descr

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

Source Cd

Description	The code that corresponds to the Source Code Sk.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Source Code Descr

Description	The description that corresponds to the Source Type Cd.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
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

Standard 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Standard Route Cd

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

Standard 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	true
Is Derived	false
Is Surrogate Key	false

Standard Route Descr

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

Strength Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
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	true
Is Derived	false
Is Surrogate Key	false

Strength Denominator Num

Description	The denominator for the strength of a drug prescribed as a ratio.
Data Type	Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Strength Denominator UOM Cd

Description	The unit of measure for the strength of a denominator for a drug prescribed as a ratio.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Strength Denominator UOM Code Descr

Description	The unit of measure for the strength of a denominator for a drug prescribed as a ratio.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Strength Denominator UOM Code Sk

Description	The unit of measure for the strength of a denominator for a drug prescribed as a ratio.
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

Strength Descr

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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Strength Numerator Num

Description	The numerator for the strength of a drug prescribed as a ratio.
Data Type	Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Strength Numerator UOM Cd

Description	The unit of measure of a numerator for the strength of a drug prescribed as a ratio.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Strength Numerator UOM Code Descr

Description	The unit of measure of a numerator for the strength of a drug prescribed as a ratio.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Strength Numerator UOM Code Sk

Description	The unit of measure of a numerator for the strength of a drug prescribed as a ratio.
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

Use Facility Dose Ind

Description	Indicates whether or not the drug strength should be calculated for facility dosage such as bulk containers of topical ointments/creams (package size rather than dose supplied).
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

Use Reduced Calculation Ind

Description	Indicates whether or not the drug strength should be calculated for calculated reduced strength dosage such as 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

Use Strength Dose Ind

Description	Indicates whether or not the drug strength should be calculated for strength dosage such as premix IV bags.
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

Valid From Ts

Description	Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Valid To Ts

Description	Ends a period of validity.
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

Primary Key Details

Medication Dimension PK

Key Attribute

Medication Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model