Atomic Warehouse Model Data Model

Entity

Entity National Drug Code

Description

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

Attributes
Additional Dose Form Code Sk
Brand Name Generic Code Sk
Color Code Sk
Core 10 Code Sk
Core 9 Code Sk
Create Dt
Flavor Code Sk
Formatted Package Product Id Num
Image File Name Nm
Inner Pack Size Qty
Inner Pack Unit Identifier Code Sk
Load Info Sk
Marking Side 1 Comment Descr
Marking Side 2 Comment Descr
Medication Code Sk
National Drug Code Sk
NDC Labeler Code Sk
NDC Trade Name Code Sk
Obsolete Dt
Orange Book Identifier Num
Outer Pack Size Qty
Preferred Brand Ind
Preferred Generic Ind
Repackaged Ind
RX OTC Status Code Sk
Scored Ind
Search Markings Descr
Shape Code Sk
Source Code Sk
Standard Synonym Code Sk
Tenant Sk
Top 200 Ind
Unit Dose Code Sk
Update Dt

Relationship
National Drug Code_Common Code_FK
National Drug Code_National Drug Code Labeler_FK
National Drug Code_Common Code_FK1
National Drug Code_Medication_FK

Primary Key
National Drug Code PK

Dependencies

Reverse Dependencies

Attribute Details

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

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

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	false
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 Name 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 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

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

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

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

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

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

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

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

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

Scored Ind

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

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

Standard Synonym Code Sk

Description	The synonym supplied by the medication data author relating drugs at the generic, medication and NCD levels.
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

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

Update Dt

Description	The date upon which the national drug code 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

National Drug Code_Common Code_FK

Is Identifying Relationship	false
Child Table	National Drug Code
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

National Drug Code_National Drug Code Labeler_FK

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

National Drug Code_Common Code_FK1

Is Identifying Relationship	true
Child Table	National Drug Code
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

National Drug Code_Medication_FK

Is Identifying Relationship	false
Child Table	National Drug Code
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

Primary Key Details

National Drug Code PK

Key Attribute

National Drug Code Sk

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model