Dimensional Warehouse Model Data Model

Entity

Entity Study Execution Dimension

Description

An ongoing or past performance of a formal investigation as specified in a study protocol.

Attributes
Anticipated Ind
AWM Load Info Sk
Current Ind
DWM Load Info Sk
Effective From Dt
Effective To Dt
Enrolled Study Subject Num
Recruitment Status Cd
Recruitment Status Code Descr
Recruitment Status Code Sk
Recruitment Status Dt
Source Cd
Source Code Descr
Source Code Sk
Status Cd
Status Code Descr
Status Code Sk
Status Comment Txt
Status Dt
Study Execution Bk
Study Execution Dk
Study Execution Sk
Study Stopped Reason Cd
Study Stopped Reason Code Descr
Study Stopped Reason Code Sk
Tenant Sk
Valid From Ts
Valid To Ts

Primary Key
Study Execution Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

Anticipated Ind

Description	Specifies whether the overall status of the study is an estimate.
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

AWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
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

Current Ind

Description	Set to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

DWM 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

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

Enrolled Study Subject Num

Description	An integer specifying the quantity of study subjects enrolled in the study at the current time. This can be derived by counting the number of enrolled subjects.
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

Recruitment Status Cd

Description	Specifies the phase in the lifecycle of recruitment for the study. For example: Not yet recruiting Recruiting Enrolling by invitation Active Not recruiting Completed Suspended Terminated Withdrawn.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Recruitment Status Code Descr

Description	Specifies the phase in the lifecycle of recruitment for the study. For example: Not yet recruiting Recruiting Enrolling by invitation Active Not recruiting Completed Suspended Terminated Withdrawn.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Recruitment Status Code Sk

Description	Specifies the phase in the lifecycle of recruitment for the study. For example: Not yet recruiting Recruiting Enrolling by invitation Active Not recruiting Completed Suspended Terminated Withdrawn.
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

Recruitment Status Dt

Description	The date and time when the recruitment status for 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

Source Cd

Description	The code that corresponds to the Source Code Sk.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Source Code Descr

Description	The description that corresponds to the Source Type Cd.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
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 Cd

Description	Specifies the phase in the lifecycle of the study as a whole. For example: In Review Approved Active Closed to Accrual Closed to Accrual and Intervention Temporary Closed to Accrual Temporary Closed to Accrual and Intervention Disapproved Withdrawn Administratively complete
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Status Code Descr

Description	Specifies the phase in the lifecycle of the study as a whole. For example: In Review Approved Active Closed to Accrual Closed to Accrual and Intervention Temporary Closed to Accrual Temporary Closed to Accrual and Intervention Disapproved Withdrawn Administratively complete
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Status Code Sk

Description	Specifies the phase in the lifecycle of the study as a whole. For example: In Review Approved Active Closed to Accrual Closed to Accrual and Intervention Temporary Closed to Accrual Temporary Closed to Accrual and Intervention Disapproved Withdrawn Administratively complete
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 Comment Txt

Description	Additional description of the overall status of the 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

Status Dt

Description	The date and time the comprehensive state of the 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 Execution Bk

Description	Concatenated values of a set of business attributes that uniquely identify the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Study Execution Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
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	true

Study Execution Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
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

Study Stopped Reason Cd

Description	Specifies why the study has been halted or terminated (for suspended, terminated or withdrawn studies).
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Study Stopped Reason Code Descr

Description	Specifies why the study has been halted or terminated (for suspended, terminated or withdrawn studies).
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Study Stopped Reason Code Sk

Description	Specifies why the study has been halted or terminated (for suspended, terminated or withdrawn studies).
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	false
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

Primary Key Details

Study Execution Dimension PK

Key Attribute

Study Execution Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model