| Business Data Model Data Model |
| Description | A drug product that may be the equivalent of one or more branded drug products in terms of dosage form, strength, route of administration, quality and performance characteristics, and intended use. |
| Relationship | |
 Generic Drug_Common Code_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
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 |
Defined Daily Dosage Qty
| Description | Indicates the recommended dosage of a drug for an adult as defined by the World Health Organization (WHO). |
| 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 Unit Of Measure
| Description | Indicates the unit of measure for the defined daily dosage quantity. |
| 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 Cd 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 |
Generic Drug Update Date
| Description | The date upon which the generic drug 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 |
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 Amount Cnt
| 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/Number Integer [INTEGER] |
| 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 |
Manufacturer Generic Name
| 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 |
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 |
Pregnancy Risk Factor
| 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 | false |
| 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
| 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 |
| Relationship Details |
Generic Drug_Common Code_FK
| Is Identifying Relationship | true |
| Child Table | Generic Drug |
| Child Role Name | gen drug 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 |
| Business Data Model Data Model |