| Atomic Warehouse Model Data Model |
| Description | An activity that is anticipated to occur at some time in the future and has been assigned a time or date when that activity is to be performed. For example: An X-Ray scheduled for February 15 is in state "Scheduled." If John is unable to have the X-Ray on that date, the X-Ray would either be rescheduled (remain in "Scheduled" state, but "date" attribute would change) or moved to state "Canceled." |
| Relationship | |
 Scheduled Activity Detail_Activity_FK |
|
| Primary Key | |
 Scheduled Activity Detail PK |
|
| Dependencies | |
 |
|
| |
|
| |
|
| |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
Active Ingredient Dose Qty
| Description | The quantity of active ingredient anticipated to be administered. For example: 5 mg This is intended to be a subject-specific quantity. Defined Substance Administration Product Dose can contain a dose expressed in absolute or relative terms (for example, mg or mg/kg). Scheduled Substance Administration Active Ingredient Dose and Performed Substance Administration Product Dose must contain a dose expressed in absolute terms (for example, mg). If the Defined Substance Administration Product Dose was expressed in relative terms (for example, mg/kg), then the absolute dose must have been calculated using one or more observed factors as identified by the Defined Dose Expression Variable Relationship. |
| 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 |
Activity Nm
| 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 |
Activity 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 |
Category Code Sk
| 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 |
Comment Txt
| 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 Txt
| 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 |
Duration Qty
| 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 |
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 |
End Dt
| Description | The expected end date of the scheduled activity. |
| 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 |
Identification Num
| 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 |
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 |
Message Title Txt
| Description | The subject of the notification. |
| 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 |
Message Txt
| Description | The actual text scheduled to be included in the notification. This may mean that message variables have been replaced with actual data. |
| 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 |
Reason Code Sk
| 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 |
Repeat Duration Qty
| 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 |
Repeat Frequency Code Sk
| 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 |
Repeat Frequency Ratio
| Description | A ratio representing the number of occurrences of an 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 |
Repetition Num
| Description | An integer that identifies the particular occurrence of a repeating activity. The first repetition is defined as '1'. For example: A Planned Activity might have a repeat quantity of 4 which would result in 4 scheduled activities with repetition numbers of 1, 2, 3, and 4 respectively. |
| 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 |
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 |
Start Dt
| Description | The expected start date of the scheduled activity. |
| 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 |
Status Change Reason Code Sk
| 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 |
Status Code Sk
| 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 |
Status Dt
| 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 |
Subcategory Code Sk
| 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 |
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 |
Scheduled Activity Detail_Activity_FK
| Is Identifying Relationship | true |
| Child Table | Scheduled 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 |
Scheduled Activity Detail PK
| Key Attribute | Activity Sk |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |