Dimensional Warehouse Model Data Model

Entity

Entity National Drug Code Array

Description

A unique identification code that is used in the United States for any drug intended for human use.

Attributes
Additional Dose Form Cd
Additional Dose Form Code Sk
Additional Dose Form Descr
AWM Load Info Sk
Brand Name Generic Cd
Brand Name Generic Code Sk
Brand Name Generic Descr
Color Cd
Color Code Sk
Color Descr
Core 10 Cd
Core 10 Code Descr
Core 10 Code Sk
Core 9 Cd
Core 9 Code Descr
Core 9 Code Sk
Current Ind
DWM Load Info Sk
Effective From Dt
Effective To Dt
Flavor Cd
Flavor Code Sk
Flavor Descr
Formatted Package Product Id Num
Image File Nm
Inner Pack Size Qty
Inner Pack Size UOM Cd
Inner Pack Size UOM Code Sk
Inner Pack Size UOM Descr
Inner Pack Unit Identifier Cd
Inner Pack Unit Identifier Code Sk
Inner Pack Unit Identifier Descr
Marking Side 1 Comment Descr
Marking Side 2 Comment Descr
Medication Dk
Medication Sk
National Drug Cd
National Drug Code Sk
National Drug Descr
NDC Labeler Num
NDC Labeler Sk
NDC Trade Name Id Num
NDC Trade Name Sk
NDC Trade Nm
Obsolete Dt
Orange Book Identifier Num
Outer Pack Size Qty
Outer Pack Size UOM Cd
Outer Pack Size UOM Code Sk
Outer Pack Size UOM Descr
Package Product Identifier Num
Preferred Brand Ind
Preferred Generic Ind
Repackaged Ind
Scored Ind
Search Markings Descr
Shape Cd
Shape Code Sk
Shape Descr
Source Code Sk
Standard Medication Code Sk
Tenant Sk
Top 200 Ind
Unit Dose Cd
Unit Dose Code Sk
Unit Dose Descr
Valid From Ts
Valid To Ts

Relationship
National Drug Code_Medication_FK

Primary Key
National Drug Code Array PK

Dependencies

Reverse Dependencies

Attribute Details

Additional Dose Form Cd

Description	Identifies the form of any additional dosages for the medicine.
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

Additional Dose Form Code Sk

Description	Identifies the form of any additional dosages for the medicine.
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

Additional Dose Form Descr

Description	Identifies the form of any additional dosages for the medicine.
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

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 Name Generic Cd

Description	Designates the product's status as a brand name product or a generic product.
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

Brand Name Generic Code Sk

Description	Designates the product's status as a brand name product or a generic product.
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

Brand Name Generic Descr

Description	Designates the product's status as a brand name product or a generic product.
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

Color Cd

Description	Identifies the color of a medicine.
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

Color Code Sk

Description	Identifies the color of a medicine.
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

Color Descr

Description	Identifies the color of a medicine.
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

Core 10 Cd

Description	Generated Unique Identifier for a Pharm Core 10 - Senior Clinical Staff Requirements.
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

Core 10 Code Descr

Description	Generated Unique Identifier for a Pharm Core 10 - Senior Clinical Staff Requirements.
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

Core 10 Code Sk

Description	Generated Unique Identifier for a Pharm Core 10 - Senior Clinical Staff Requirements.
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

Core 9 Cd

Description	Identifies a Pharm Core 9 - the National Drug Code that is unique to a product, the left 9 characters without the remaining 2, which are packaging descriptions.
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

Core 9 Code Descr

Description	Identifies a Pharm Core 9 - the National Drug Code that is unique to a product, the left 9 characters without the remaining 2, which are packaging descriptions.
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

Core 9 Code Sk

Description	Identifies a Pharm Core 9 - the National Drug Code that is unique to a product, the left 9 characters without the remaining 2, which are packaging descriptions.
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

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

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

Flavor Cd

Description	Identifies the flavor of a medicine.
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

Flavor Code Sk

Description	Identifies the flavor of a medicine.
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

Flavor Descr

Description	Identifies the flavor of a medicine.
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

Formatted Package Product Id Num

Description	Full NDC code for a given medication. Presents the National Drug Code in the format #####-####-##, where the first set of numbers identify the manufacturer of a product, the second set of numbers identify the product, and the last set identifies the package size of the product. This field differs from the package product id field in that it includes dashes between each set of numbers.
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

Image File Nm

Description	The name of an image file attached to a national drug code.
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Inner Pack Size Qty

Description	Identifies the number of individual units present in the innermost packaging of a drug.
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

Inner Pack Size UOM Cd

Description	Identifies the number of individual units present in the innermost packaging of a drug.
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

Inner Pack Size UOM Code Sk

Description	Identifies the number of individual units present in the innermost packaging of a drug.
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

Inner Pack Size UOM Descr

Description	Identifies the number of individual units present in the innermost packaging of a drug.
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

Inner Pack Unit Identifier Cd

Description	Describes the package size. Not all drug products require a package unit description for a complete representation of the packaging. For example: For a bottle of 100 tablets, the package unit description would be 0 (no Package Unit Description needed). For a tube of 15 grams, the package unit description code would be 680 (representing a Package Unit Description of gm).
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

Inner Pack Unit Identifier Code Sk

Description	Describes the package size. Not all drug products require a package unit description for a complete representation of the packaging. For example: For a bottle of 100 tablets, the package unit description would be 0 (no Package Unit Description needed). For a tube of 15 grams, the package unit description code would be 680 (representing a Package Unit Description of gm).
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

Inner Pack Unit Identifier Descr

Description	Describes the package size. Not all drug products require a package unit description for a complete representation of the packaging. For example: For a bottle of 100 tablets, the package unit description would be 0 (no Package Unit Description needed). For a tube of 15 grams, the package unit description code would be 680 (representing a Package Unit Description of gm).
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

Marking Side 1 Comment Descr

Description	Comments on side 1 of a drug tablet, capsule etc.
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Marking Side 2 Comment Descr

Description	Comments on side 2 of a drug tablet, capsule etc.
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
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	false

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

National Drug Cd

Description	The coded identifier for a National Drug Code record.
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

National Drug Code Sk

Description	The generated unique key for national drug 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

National Drug Descr

Description	The description of the coded identifier for a National Drug Code record.
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

NDC Labeler Num

Description	An identifying number for a National Drug Code labeler.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

NDC Labeler 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

NDC Trade Name Id Num

Description	The National Drug Code unique identifier for a trade name.
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

NDC Trade Name 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

NDC Trade Nm

Description	The National Drug Code's trade name for a drug.
Data Type	Standards - Data Domains.ddm/Data Domains/Name Compound [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
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

Orange Book Identifier Num

Description	Unique coded value for each Orange Book code.
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

Outer Pack Size Qty

Description	Designates the total number of inner packages present in the final packaged product.
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

Outer Pack Size UOM Cd

Description	Designates the total number of inner packages present in the final packaged product.
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

Outer Pack Size UOM Code Sk

Description	Designates the total number of inner packages present in the final packaged product.
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

Outer Pack Size UOM Descr

Description	Designates the total number of inner packages present in the final packaged product.
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

Package Product Identifier Num

Description	Full NDC code for a given medication. Presents the National Drug Code in the format #####-####-##, where the first set of numbers identify the manufacturer of a product, the second set of numbers identify the product, and the last set identifies the package size of the product. This field differs from the package product id field in that it includes dashes between each set of numbers.
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

Preferred Brand Ind

Description	Indicates whether or not this manufacturer's brand is preferred by the provider.
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

Preferred Generic Ind

Description	Indicates whether or not this manufacturer's generic is preferred by the provider.
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

Repackaged Ind

Description	Indicates whether or not another drug vendor has repackaged the original 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

Scored Ind

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

Search Markings Descr

Description	Describes the concatenated text of the Marking Side 1 Comment Descr with Marking Side 2 Comment Descr.
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Shape Cd

Description	Identifies a shape for one unit (pill, capsule, powder) of a medicine.
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

Shape Code Sk

Description	Identifies a shape for one unit (pill, capsule, powder) of a medicine.
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

Shape Descr

Description	Identifies a shape for one unit (pill, capsule, powder) of a medicine.
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 a standard medication 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

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

Top 200 Ind

Description	Designates a drug's status is one of the 20 most prescribed brand or generic drugs in the United States during the previous year.
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

Unit Dose Cd

Description	Indicates whether the product is supplied in unit dose packaging.
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

Unit Dose Code Sk

Description	Indicates whether the product is supplied in unit dose packaging.
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

Unit Dose Descr

Description	Indicates whether the product is supplied in unit dose packaging.
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

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	true
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

Relationship Details

National Drug Code_Medication_FK

Is Identifying Relationship	true
Child Table	National Drug Code Array
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 Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

National Drug Code Array PK

Key Attribute	Medication Dk
Key Attribute	National Drug Code Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model