| Atomic Warehouse Model Data Model |
| Description | An association between a study protocol and a product. |
| Relationship | |
 Study Protocol / Product_Study Protocol_FK |
|
| Study Protocol / Product_Product_FK |
|
| Primary Key | |
 Study Protocol / Product PK |
|
| Dependencies | |
 |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
Blinded Nm
| Description | Text description of the study agent to be used by participants from whom the identity of the study agent is not known. For example: In a study for which the study agents are a drug product and a matching placebo, both the active product and the placebo might simply be called "Study Drug." In a study with two different investigational products and their matching placebos, the blinded names might be "Bottle A" and "Bottle B". |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Characteristic Modified Ind
| Description | Specifies whether the agent's characteristic have been modified from those approved in the marketing authorization in a way that could affect its quality. Modification may include a change in pharmaceutical form (for example, over-encapsulation, color, dilution, re-tabletting for blinding etc.) or removal from the primary packaging and repacking (for example, removal from a blister and putting in a bottle). |
| 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 |
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 |
Expanded Access Ind
| Description | Specifies whether the product (drug or device) is available for patients who are not adequately treated by existing therapy, who do not meet the eligibility criteria for enrollment, or who are otherwise unable to participate in a controlled study. Expanded Access is a mechanism that provides non-protocol access to experimental treatments, including protocol exception, single-patient IND, treatment IND, compassionate use, emergency use, continued access and parallel track. |
| 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 |
First In Human Ind
| Description | Specifies whether this is the first time an active substance of the agent is to be administered to humans in a study. |
| 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 |
First In Human Risk Factor Code Sk
| Description | Specifies the risk factors identified with administering the agent's active substance to humans for the first time in a study. |
| 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 |
Function Code Sk
| Description | Specifies how this agent is used in the study. This is important to know in multi-agent studies. For example: Lead agent Comparator agent Placebo Active control |
| 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 |
Pediatric Formulation Ind
| Description | Specifies whether the pharmaceutical form of the agent is intended for pediatric usage. For example: A value of true may indicate that the agent is dissolvable, smaller, or grape flavored to be easily ingested by the pediatric population. |
| 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 |
Product Sk
| Description | Surrogate key for the anchor entity. |
| 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 |
Relationship Type Code Sk
| Description | Identifies the type of the relationship as defined in the business data model. |
| 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 |
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 |
Status Code Sk
| Description | Specifies the phase in the lifecycle of the agent's association to a study. For example: Pending Active Complete Cancelled |
| 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 |
Status Dt
| Description | The date and time the status/phase in the lifecycle of the agent's association to a study is defined. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Study Protocol Sk
| Description | Surrogate key for the anchor entity. |
| 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 |
Substitution Allowed Ind
| Description | Specifies whether this agent as identified by its active substance is permitted to be substituted by a local brand. For example: The study protocol may specify the use of Paracetamol which could be substituted locally in the United States with any brand containing acetaminophen, including Tylenol and Panadol. |
| 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 |
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 |
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 |
Study Protocol / Product_Study Protocol_FK
| Is Identifying Relationship | true |
| Child Table | Study Protocol / Product |
| 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 | Study Protocol |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Study Protocol / Product_Product_FK
| Is Identifying Relationship | true |
| Child Table | Study Protocol / Product |
| 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 | Product |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Primary Key Details |
Study Protocol / Product PK
| Key Attribute | Study Protocol Sk |
| Key Attribute | Product Sk |
| Key Attribute | Relationship Type Code Sk |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |