| Atomic Warehouse Model Data Model |
Description | An activity that is intended to occur or start at some point in the context of a particular study. For example: Pregnancy tests are planned for study subjects who are females of childbearing potential. |
Relationship | |
![]() |
Primary Key | |
![]() |
Dependencies | |
![]() |
|
![]() |
|
![]() |
Reverse Dependencies | |
![]() |
Attribute Details |
Description | The text description of an activity within a clinical trial or study. |
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 |
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 |
Description | Identifies the level of healthcare (care setting) required by the subject based on the nature of the procedure. For example: Some, but not all, agents given as inpatient All agents given as inpatient All agents given as outpatient |
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 |
Description | The textual representation of the planned activity from the point of view of a blinded participant (study subject or study investigator). For example: During the second treatment epoch of a study, Arms A and B are still blinded and Arm C is no longer blinded. So, Arm A and B must have identical blinded descriptions. In a study with 3 arms, Arm 1: standard vaccine given in three shots at 2 months, 5 months, and 12 months of age; Arm 2: new vaccine given in three shots at 2 months, 5 months, and 12 months of age; Arm 3: new vaccine given in two shots at 2 months and 5 months of age. Subjects assigned to the third arm are unblinded at some point during 5 months and 12 months. By the time of the Third Shot Epoch, the "Arm 3/Third Shot" activity can be called by this, its unblinded name. However, the "Arm 1/Third Shot" and "Arm2/Third Shot" activities still need blinded names. Both these activities would have the blinded name (something like) "3-shot Arm/Third Shot". |
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 |
Description | Classification of activities. For example: In the case where Category Code = "anti-cancer treatment", the Sub Category Code may = "radiotherapy" and the Name Code may = "external beam radiotherapy". |
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 |
Description | Additional description of the activity. For example: Guidance on how to perform the observation. |
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 |
Description | The textual representation of the activity. |
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 |
Description | The intended period of time for the planned activity as defined by the study. For example: 6 weeks may be the planned duration for a composite activity that represents the activities occurring during an epoch on arm A. |
Data Type | Standards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
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 |
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 |
Description | A unique symbol that establishes identity of an activity. For example: 12345 is the identifier for a substance administration |
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 |
Description | Specifies whether the planned activity is interruptible by asynchronous events. This may only be useful for Planned Subject Activity Groups or administrative activities. |
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 |
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 |
Description | The reason for the planned activity. For example: Treating a disease (treatment) Determining eligibility for a study (screening) Per GForge Tracker item 31402, this attribute is redundant and we're deprecating it in favor of the existing Activity Reason Code. |
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 |
Description | A coded value specifying the motivation, cause, or rationale of an activity. For example: Routine requirement Drug reaction Infectious disease reporting requirement On patient request |
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 |
Description | The period of time over which the activity is repeated. |
Data Type | Standards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The repeating frequency with which the treatment is to be administered. It is similar to the frequency and SIG code tables used in order entry systems. |
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 |
Description | A ratio representing the number of occurrences of a planned activity within a given time period. For example: Once per 12 hours 2 times per day |
Data Type | Standards - Data Domains.ddm/Data Domains/Ratio [FLOAT(5)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | An integer falling within minimum and maximum bounds that specifies how many times the planned activity occurs. If the frequency is more than once a day, this is still interpreted per time, for example, BID for 5 days is 10 repeats. |
Data Type | Standards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
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 |
Description | Specifies why the status has changed. |
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 |
Description | Indicates the phase in the lifecycle of the activity as part of a global library. For example: Draft New Released Retired Archived |
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 |
Description | The date and time the status for an activity as part of a study or clinical trial 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 |
Description | An integer specifying a percentage of target accrual for a study, which when reached triggers a notification. For example: 75% or 90% of the target accrual number. |
Data Type | Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The relative timing for a planned activity expressed as the number of days offset from the study-defined reference activity (for example, date of registration, start of treatment) for a particular subject, study subject or experimental unit. For example: Day 1 Days 10-20 |
Data Type | Standards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Specifies whether the activity is a key investigational activity for a study. If a study has study agents, one or more of the study activities will presumably use the agent and have this indicator set to true. For example: A study focused on investigating the effectiveness of a drug will flag the substance administration of the drug or a study focused on determining the average blood pressure of a certain population will flag the blood pressure observation. |
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 |
Description | An integer specifying a percentage of target accrual at a particular study site, which when reached triggers a notification. For example: 75% or 90% of the target accrual number. |
Data Type | Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Specifies a subdivision within a larger category of activities. For example: Chemotherapy Radiotherapy Hormonal therapy Alternative therapy |
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 |
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 |
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 |
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 |
Is Identifying Relationship | true |
Child Table | Planned Activity Detail |
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 | Activity |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Primary Key Details |
Key Attribute | Activity Sk |
Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |