Confidentiality IndEffective From DtEffective To DtLoad Info SkPayment Method Code SkPlanned Subject QtySource Code SkStatus Code SkStudy Subject SkSubject Id NumTenant SkValid From TsValid To Ts
| Atomic Warehouse Model Data Model |
| Description | A subject that is potentially available for research studies. A patient study subject is also known as a research version of the patient, housing none of the patients identifying information. For example: A person who is registered in a study as a recipient of an investigational product or as a control. Individuals who are being screened for studies. Individuals participating in observational or other studies. A pacemaker. A fuse that can be used in medical devices. A cow. A pen of pigs. A tissue sample from a tissue bank. |
| Relationship | |
 Study Subject Detail_Study Subject_FK |
|
| Primary Key | |
 Study Subject Detail PK |
|
| Dependencies | |
 |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
Confidentiality Ind
| Description | Specifies whether the study subject, or their legally acceptable representative, has not authorized the use and disclosure of their protected health information (that is, the study subject's data is private and confidential). |
| 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 |
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 |
Payment Method Code Sk
| Description | Specifies the primary payer/insurance carrier information at the time of treatment on a study. For example: Private Insurance Medicare Medicare And Private Insurance Medicaid |
| 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 |
Planned Subject Qty
| Description | An integer falling within minimum and maximum bounds that specifies how many of a particular type of subject are planned to be included in the study. |
| 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 |
Status Code Sk
| Description | Identifies the status that can be associated with an individual subject in a cohort. For example: Consented Qualified Treatment phase Post treatment Active Disqualified. |
| 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 |
Study Subject 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 |
Subject Id Num
| Description | A unique reference code or number that establishes identity of the study subject. This can originate from an external system or be created by the data warehouse and it may be published to the research community. |
| 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 |
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 Subject Detail_Study Subject_FK
| Is Identifying Relationship | true |
| Child Table | Study Subject 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 | Study Subject |
| 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 Subject Detail PK
| Key Attribute | Study Subject Sk |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |