Arm DescrArm NmArm SkEffective From DtEffective To DtLoad Info SkRandomization Weight RatioSource Code SkTarget Accrual Number Range QtyTenant SkType Code SkValid From TsValid To Ts
| Atomic Warehouse Model Data Model |
| Description | A path through the study that describes what activities the study subject or experimental unit will be involved in as they pass through the study. For example: A study could have 2 arms named IV-Oral and Oral-IV. The name IV-Oral reflects a path that passes through IV treatment, then Oral treatment. |
| Relationship | |
 Arm Detail_Arm_FK |
|
| Primary Key | |
 Arm Detail PK |
|
| Dependencies | |
 |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
Arm Descr
| Description | The textual representation of the arm. This is a description of the pathway followed by all subjects, study subjects, or experimental units in a particular treatment regimen. For example: Study subjects receive Drug X Experimental units receive Placebo Study subjects receive drug A IV in the first phase, drug B Oral in the second phase |
| 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 |
Arm Nm
| Description | A non-unique textual identifier for the arm. For example: Treatment A |
| 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 |
Arm 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 |
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 |
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 |
Randomization Weight Ratio
| Description | The relative proportion of study subjects to be randomized to the arm. For example: If 1/3 of study subjects are to be randomized to Arm A and 2/3 to Arm B, then the values of randomization weight for Arms A and B, respectively, could be expressed as 1 and 2 or as 1/3 and 2/3. |
| 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 |
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 |
Target Accrual Number Range Qty
| Description | An integer falling within minimum and maximum bounds that specifies how many study subjects are to be accrued for the arm. This may represent the minimum number of study subjects needed to support data analysis and/or the maximum number of study subjects that may be accrued to this arm. |
| 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 |
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 |
Type Code Sk
| Description | Identifies the actual type of the entry based on the entity type hierarchy defined in the business data model. |
| 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 |
Arm Detail_Arm_FK
| Is Identifying Relationship | true |
| Child Table | Arm 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 | Arm |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Primary Key Details |
Arm Detail PK
| Key Attribute | Arm Sk |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |