Overview Top Package Entity

Dimensional Warehouse Model Data Model

---

Entity Activity Fact

Description

An action that can, in the context of a study or a post-marketing investigation, be defined, planned, scheduled or performed. For example: Administrative activities such as subject registration or informed consent. Clinical activities such as surgical procedure, laboratory test, administration of a drug.

Attributes

Activity Fact Bk

Activity Fact Dk

Activity Fact Sk

Activity Nm

Actual Active Ingredient Dose Descr

Actual Active Ingredient Dose Qty

Actual Copy of Dose Frequency Cd

Actual Copy of Dose Frequency Code Sk

Actual Dose Period Cd

Actual Dose Period Code Sk

Actual Flow Rt

Actual Period Active Ingredient Dose Total Qty

Actual Period Product Dose Total Qty

Actual Product Dose Descr

Actual Product Dose Qty

Actual Route Of Administration Cd

Actual Route Of Administration Code Sk

Agent Administration Care Setting Type Cd

Agent Administration Care Setting Type Code Sk

Approach Anatomic Site Cd

Approach Anatomic Site Code Sk

Approach Anatomic Site Laterality Cd

Approach Anatomic Site Laterality Code Sk

AWM Load Info Sk

Blinded Descr

Calendar Dk

Category Cd

Category Code Sk

Change Reason Txt

Change Type Cd

Change Type Code Sk

Comment Txt

Current Ind

Date Range Qty

Date Range Validation Cd

Date Range Validation Code Sk

Defined Dose Frequency Cd

Defined Dose Frequency Code Sk

Defined Dose Period Cd

Defined Dose Period Code Sk

Defined Dose Regimen Txt

Defined Flow Rt

Defined Notification Message Title Txt

Defined Notification Message Txt

Defined Period Product Dose Total Qty

Defined Product Dose Qty

Defined Route Of Administration Cd

Defined Route Of Administration Code Sk

Delay Duration Qty

Delivery Mechanism Cd

Delivery Mechanism Code Sk

Description Txt

Distinct Product Cnt

Document Dk

Document Sk

Donor Type Cd

Donor Type Code Sk

Duration Qty

DWM Load Info Sk

Effective From Dt

Effective To Dt

End Relative To Reference Cd

End Relative To Reference Code Sk

Epoch Dk

Epoch Sk

Experimental Unit Dk

Experimental Unit Sk

Fasting Status Ind

Identification Num

Informed Consent Ind

Informed Consent Ts

Interruptible Ind

Interruption Duration Qty

Material Store Method Cd

Material Store Method Code Sk

Medical History Ind

Method Cd

Method Code Sk

Name Code Modified Txt

Negation Ind

Negation Reason

Notified Organization Dk

Notified Organization Sk

Notified Person Dk

Notified Person Sk

Notified Practitioner Dk

Notified Practitioner Sk

Off Study Reason Cd

Off Study Reason Code Sk

Off Study Ts

Original Qty

Performed Notification Message Title Txt

Performed Notification Message Txt

Performing Organization Dk

Performing Organization Sk

Performing Person Dk

Performing Person Sk

Planned Change Ind

Planned Repeat Frequency Cd

Planned Repeat Frequency Code Sk

Planned Repeat Frequency Ratio

Planned Study Day Range Qty

Point Of Care Location Dk

Point Of Care Location Sk

Product Dk

Product Sk

Product Transport Method Cd

Product Transport Method Code Sk

Product Transport Standard Time Ind

Protocol Arm Dk

Protocol Arm Sk

Purpose Txt

Reason Cd

Reason Code Sk

Registration Ts

Relation Cd

Relation Code Sk

Repeat Duration Qty

Repeat Frequency Cd

Repeat Frequency Code Sk

Repeat Frequency Ratio

Repeat Quantity Range

Repetition Qty

Scheduled Active Ingredient Dose Qty

Scheduled End Dt

Scheduled Notification Message Title Txt

Scheduled Notification Message Txt

Scheduled Repetition Num

Scheduled Start Dt

Source Cd

Source Code Sk

Specimen Dk

Specimen Sk

Standard Time Ind

Start Relative To Reference Cd

Start Relative To Reference Code Sk

Status Cd

Status Change Reason Cd

Status Change Reason Code Sk

Status Code Sk

Status Dt

Study Accrual Threshold Pct

Study Day Range Qty

Study Dk

Study Focus Ind

Study Protocol Dk

Study Protocol Sk

Study Reference From Ts

Study Reference To Ts

Study Site Accrual Threshold Pct

Study Site Dk

Study Site Sk

Study Sk

Study Subject Dk

Study Subject Sk

Subcategory Cd

Subcategory Code Sk

Substance Unknown Ind

Target Anatomic Site Cd

Target Anatomic Site Code Sk

Target Anatomic Site Laterality Cd

Target Anatomic Site Laterality Code Sk

Temperature Range Txt

Tenant Sk

Transfer Qty

Treatment Vehicle Qty

Valid From Ts

Valid To Ts

Variance Reason Cd

Variance Reason Code Sk

Variance Type Cd

Variance Type Code Sk

Relationship

Activity Fact_Product Dimension_FK

Activity Fact_Experimental Unit Dimension_FK

Activity Fact_Organization Dimension_FK

Activity Fact_Practitioner Dimension_FK

Activity Fact_Point Of Care Location Dimension_FK

Activity Fact_Document Dimension_FK

Activity Fact_Person Dimension_FK

Activity Fact_Person Dimension_FK1

Activity Fact_Organization Dimension_FK1

Activity Fact_Calendar Dimension_FK

Activity Fact_Study Protocol Dimension_FK

Activity Fact_Protocol Arm Dimension_FK

Activity Fact_Epoch_FK

Activity Fact_Study Dimension_FK

Activity Fact_Study Subject Dimension_FK

Activity Fact_Specimen Dimension_FK

Activity Fact_Study Site Dimension_FK

Primary Key

Activity Fact PK

Dependencies

Reverse Dependencies

Attribute Details

 Activity Fact 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

---

 Activity Fact 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

---

 Activity Fact 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

---

 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

---

 Actual Active Ingredient Dose Descr

Description	The textual representation of active ingredients in the dosing amounts or a range of dosing information used in a substance administration. For example: 200-400
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

---

 Actual Active Ingredient Dose Qty

Description	The quantity of active ingredients used in a substance administration. For example: 5 mg
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

---

 Actual Copy of Dose Frequency Cd

Description	Specifies how often doses are administered. Used to capture multiple substance administrations in one act, rather than each time a patient swallows a pill, for example "The patient took med X 3 times a day for 10 days starting on June 9th". For example: BID TID QID
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

---

 Actual Copy of Dose Frequency Code Sk

Description	Specifies how often doses are administered. Used to capture multiple substance administrations in one act, rather than each time a patient swallows a pill, for example "The patient took med X 3 times a day for 10 days starting on June 9th". For example: BID TID QID
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

---

 Actual Dose Period Cd

Description	Specifies the period during which the dose total is administered. For example: Daily Course
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

---

 Actual Dose Period Code Sk

Description	Specifies the period during which the dose total is administered. For example: Daily Course
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

---

 Actual Flow Rt

Description	A ratio specifying the speed with which the substance is introduced into the subject. For example: 100 mL/h 1 g/d 40 mmol/h
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Actual Period Active Ingredient Dose Total Qty

Description	The total amount of active ingredient in all doses of treatment in a given period of time.
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

---

 Actual Period Product Dose Total Qty

Description	The total of all doses of treatment in a given period of time. The given period of time is defined in Dose Period.
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

---

 Actual Product Dose Descr

Description	The textual representation of dosing amounts or a range of dosing information used in a substance administration. For example: 200-400
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

---

 Actual Product Dose Qty

Description	The quantity of a substance or medication to be administered. For example: 5 mg 20 mg of drug per kg of subject weight
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

---

 Actual Route Of Administration Cd

Description	Identifies the route of administration. For example: Apply Externally Buccal Dental Intravenous Oral Intra-arterial
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

---

 Actual Route Of Administration Code Sk

Description	Identifies the route of administration. For example: Apply Externally Buccal Dental Intravenous Oral Intra-arterial
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

---

 Agent Administration Care Setting Type Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Agent Administration Care Setting Type Code Sk

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

---

 Approach Anatomic Site Cd

Description	Identifies the anatomic location or access point for an observation or procedure. Neither target anatomic site nor approach anatomic site is necessarily required or relevant for certain observations, however if either or both are present then the distinction between them is that the approach site is the access point for the measurement or observation and the target site is what is ultimately being evaluated. For example: Anus for a colonoscopy observation Arm for an injection Trans-abdominal for a nephrectomy
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

---

 Approach Anatomic Site Code Sk

Description	Identifies the anatomic location or access point for an observation or procedure. Neither target anatomic site nor approach anatomic site is necessarily required or relevant for certain observations, however if either or both are present then the distinction between them is that the approach site is the access point for the measurement or observation and the target site is what is ultimately being evaluated. For example: Anus for a colonoscopy observation Arm for an injection Trans-abdominal for a nephrectomy
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

---

 Approach Anatomic Site Laterality Cd

Description	Specifies the side of the body (or a paired organ) that is an access point for an observation or procedure. For example: Bilateral Left Right
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

---

 Approach Anatomic Site Laterality Code Sk

Description	Specifies the side of the body (or a paired organ) that is an access point for an observation or procedure. For example: Bilateral Left Right
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

---

 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

---

 Blinded Descr

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

---

 Calendar 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Category Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
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

---

 Change Reason Txt

Description	The rationale for changing the substance administration in relation to the previous substance administration. For example: Dose reduced due to hematologic toxicity
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

---

 Change Type Cd

Description	Specifies the modification of the substance administration in relation to the previous substance administration. For example: Agent Added Agent Dose Decreased Agent Dose Increased
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

---

 Change Type Code Sk

Description	Specifies the modification of the substance administration in relation to the previous substance administration. For example: Agent Added Agent Dose Decreased Agent Dose Increased
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

---

 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

---

 Date Range Qty

Description	The date and time span when this activity began and ended. For example: The date and time when a sample is taken from the subject.
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

---

 Date Range Validation Cd

Description	Specifies the degree of authoritativeness or certitude of the date of the activity. For example: Date estimated Date greater than 100 days - day is correct
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

---

 Date Range Validation Code Sk

Description	Specifies the degree of authoritativeness or certitude of the date of the activity. For example: Date estimated Date greater than 100 days - day is correct
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

---

 Defined Dose Frequency Cd

Description	Specifies how often doses are administered. Used to capture multiple substance administrations in one act, rather than each time a patient swallows a pill, for example "The patient took med X 3 times a day for 10 days starting on June 9th". For example: BID TID QID
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

---

 Defined Dose Frequency Code Sk

Description	Specifies how often doses are administered. Used to capture multiple substance administrations in one act, rather than each time a patient swallows a pill, for example "The patient took med X 3 times a day for 10 days starting on June 9th". For example: BID TID QID
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

---

 Defined Dose Period Cd

Description	Specifies the period during which the dose total is administered. For example: Daily Course
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

---

 Defined Dose Period Code Sk

Description	Specifies the period during which the dose total is administered. For example: Daily Course
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

---

 Defined Dose Regimen Txt

Description	Text description of the intended schedule for administering a substance. For example: 2 weeks on, 2 weeks off This represents the dosing calendar in a text format. This is a non-computational description that may need to be expanded as additional use cases arise.
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

---

 Defined Flow Rt

Description	A ratio specifying the speed with which the substance is introduced into the subject. For example: 100 mL/h 1 g/d 40 mmol/h
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Defined Notification 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

---

 Defined Notification Message Txt

Description	The text that is to be included in the notification. The message text may contain substitution tags that when used in the context of a particular study are replaced with study name or study site and so on.
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

---

 Defined Period Product Dose Total Qty

Description	Total of all doses of this agent in a given period of time. The given period of time is defined in Dose Period. This is needed because the dose may not always be derivable, for example, if it is a string, and because it is often used as a cross-check on dose to ensure mistakes are not made in dosing subjects.
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

---

 Defined Product Dose Qty

Description	The quantity of a substance or medication to be administered. For example: 5 mg 20 mg of drug per kg of subject weight
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

---

 Defined Route Of Administration Cd

Description	Identifies the route of administration. For example: Apply Externally Buccal Dental Intravenous Oral Intra-arterial
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

---

 Defined Route Of Administration Code Sk

Description	Identifies the route of administration. For example: Apply Externally Buccal Dental Intravenous Oral Intra-arterial
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

---

 Delay Duration Qty

Description	The period of time that an action is delayed relative to an original schedule. Derived from comparing the dates of the scheduled activity with the corresponding performed activity. For example: If a substance administration is delayed 2 days as a result of an adverse event, then the delay duration is 2 days.
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

---

 Delivery Mechanism Cd

Description	Specifies how the notification message is to be delivered. For example: email
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

---

 Delivery Mechanism Code Sk

Description	Specifies how the notification message is to be delivered. For example: email
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 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

---

 Distinct Product Cnt

Description	The number of products (resulting from different collections) used for this substance administration. This is a count of distinct donations, typically used for stem cell transplants. For example: If blood is taken from 2 people (two donations from one of them), this would be counted as 3 different collections.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Document 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Document 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

---

 Donor Type Cd

Description	Specifies the kind of donor that is used. For example: Syngeneic HLA-identical sibling HLA-matched other relative HLA-mismatched relative Unrelated donor
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

---

 Donor Type Code Sk

Description	Specifies the kind of donor that is used. For example: Syngeneic HLA-identical sibling HLA-matched other relative HLA-mismatched relative Unrelated donor
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

---

 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

---

 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

---

 End Relative To Reference Cd

Description	Specifies when this event ended with respect to the sponsor-defined reference period. For example: Before During During/after After
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

---

 End Relative To Reference Code Sk

Description	Specifies when this event ended with respect to the sponsor-defined reference period. For example: Before During During/after After
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

---

 Epoch 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Epoch 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

---

 Experimental Unit 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Experimental Unit 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

---

 Fasting Status Ind

Description	Specifies whether the subject had abstained from eating when the specimen was obtained.
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

---

 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

---

 Informed Consent Ind

Description	Specifies whether the study subject gave official consent by signing the official consent form.
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

---

 Informed Consent Ts

Description	The date (and time) the study subject gives official consent by signing the official consent form.
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

---

 Interruptible Ind

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

---

 Interruption Duration Qty

Description	The period of time during which a substance administration is interrupted. For example: An infusion started at 12:15pm and ended at 2:37pm, but there was an interruption of 17 minutes.
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

---

 Material Store Method Cd

Description	Specifies the technique that is used to store the material. For example: Liquid nitrogen Vapor phase Electric freezer
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

---

 Material Store Method Code Sk

Description	Specifies the technique that is used to store the material. For example: Liquid nitrogen Vapor phase Electric freezer
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

---

 Medical History Ind

Description	Specifies whether the activity is considered part of the historical record of a subject, that is, it did not occur within the bounds of the study.
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

---

 Method Cd

Description	Identifies the technique that is used for the procedure. For example: Finger stick Veni puncture Abdominal/ ascites effusion Biopsy Bronchial alveolar lavage (BAL) Open Laparoscopic
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

---

 Method Code Sk

Description	Identifies the technique that is used for the procedure. For example: Finger stick Veni puncture Abdominal/ ascites effusion Biopsy Bronchial alveolar lavage (BAL) Open Laparoscopic
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

---

 Name Code Modified Txt

Description	A character string that is a revision of the original text of the procedure to enable the coding of the text. For example: If the original text is "message", the Name Code Modified Text could be set to "massage", so that the text can be successfully coded.
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

---

 Negation Ind

Description	Specifies whether an activity did not occur. For example: If a subject did not take aspirin in the previous week, the negation indicator = "true".
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

---

 Negation Reason

Description	The text and/or code that describes why an activity did not occur. For example: Forgot to ask Sample lost
Data Type	Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Notified Organization 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Notified Organization 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

---

 Notified Person 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Notified Person 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

---

 Notified Practitioner 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Notified Practitioner 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

---

 Off Study Reason Cd

Description	Specifies why the subject is removed from a study. For example: Patient died
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

---

 Off Study Reason Code Sk

Description	Specifies why the subject is removed from a study. For example: Patient died
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

---

 Off Study Ts

Description	The date (and time) when the study subject is removed from the study. For example: The subject is not being followed and will not be retreated.
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

---

 Original Qty

Description	The amount and unit of study agent transferred in original units. Original units can be derived from the translation attribute of the PQ data type Performed Study Agent Transfer Quantity.
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

---

 Performed Notification 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

---

 Performed Notification Message Txt

Description	The actual text that was included in 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

---

 Performing Organization 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Performing Organization 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

---

 Performing Person 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Performing Person 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

---

 Planned Change Ind

Description	Specifies whether a change in the substance administration in relation to the previous substance administration is planned or not. For example: True = planned False = unplanned
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

---

 Planned Repeat Frequency Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Planned 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

---

 Planned Repeat Frequency Ratio

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

---

 Planned Study Day Range Qty

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

---

 Point Of Care Location 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Point Of Care Location 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

---

 Product 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 [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Product 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

---

 Product Transport Method Cd

Description	Specifies the technique that is used to transport the product. For example: Frozen gel pack Room temperature per transplant center request
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

---

 Product Transport Method Code Sk

Description	Specifies the technique that is used to transport the product. For example: Frozen gel pack Room temperature per transplant center 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

---

 Product Transport Standard Time Ind

Description	Specifies whether the time of the product transport is specified using standard (as opposed to daylight savings) time. If the location and date are known, this data is derivable.
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

---

 Protocol Arm 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Protocol Arm 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

---

 Purpose Txt

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

---

 Reason Cd

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/Tenant Common Code [VARCHAR(80)]
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

---

 Registration Ts

Description	The date (and time) the subject has been registered to the study assuming they have finished screening and have been found eligible.
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

---

 Relation Cd

Description	Specifies the self-relationship of the source to the target. For example: Autologous (self) Allogeneic-related Allogeneic Unrelated
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

---

 Relation Code Sk

Description	Specifies the self-relationship of the source to the target. For example: Autologous (self) Allogeneic-related Allogeneic Unrelated
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 Cd

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/Tenant Common Code [VARCHAR(80)]
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

---

 Repeat Quantity Range

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

---

 Repetition Qty

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 and performed activities with repetition numbers of 1, 2, 3, and 4 respectively. Derived from Scheduled ActivityRepetition Number.
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

---

 Scheduled 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

---

 Scheduled 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

---

 Scheduled Notification 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

---

 Scheduled Notification 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

---

 Scheduled 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

---

 Scheduled 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

---

 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 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

---

 Specimen 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Specimen 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

---

 Standard Time Ind

Description	Specifies whether the time of the substance administration is specified using standard (as opposed to daylight savings) time. If the location and date are known, this data is derivable.
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

---

 Start Relative To Reference Cd

Description	Specifies when this event started with respect to the sponsor-defined reference period. Medications that are ongoing at the end of the reference period should have a value of "during/after". For example: Before During During/after After
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

---

 Start Relative To Reference Code Sk

Description	Specifies when this event started with respect to the sponsor-defined reference period. Medications that are ongoing at the end of the reference period should have a value of "during/after". For example: Before During During/after After
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 Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Status Change Reason Cd

Description	Specifies why the status has changed.
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 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

---

 Study Accrual Threshold Pct

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

---

 Study Day Range Qty

Description	The relative timing for a performed activity expressed as the number of days offset from the study-defined reference activity (for example, date of registration, start of treatment) for this particular 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

---

 Study 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Study Focus Ind

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

---

 Study Protocol 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Study Protocol 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 Reference From Ts

Description	The date (and time) used to indicate the start of the study for a subject.
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

---

 Study Reference To Ts

Description	The date (and time) used to indicate the end of the study for a subject.
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

---

 Study Site Accrual Threshold Pct

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

---

 Study Site 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Study Site 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 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 Subject 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Study Subject 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

---

 Subcategory Cd

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/Tenant Common Code [VARCHAR(80)]
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

---

 Substance Unknown Ind

Description	Specifies whether the substance administered was not known.
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

---

 Target Anatomic Site Cd

Description	Specifies the anatomic location that is the focus of the observation, procedure, study or result. The target site of an observation result may be different than the target site of the observation that generated it. For instance, the target site of the observation may be broad (for example, skin) while the target site of the observation result is specific (for example, skin on chest). Multiple contiguous sites within the same organ system may be referenced. For example: Lower intestine Arm Breast Ovary Kidney
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

---

 Target Anatomic Site Code Sk

Description	Specifies the anatomic location that is the focus of the observation, procedure, study or result. The target site of an observation result may be different than the target site of the observation that generated it. For instance, the target site of the observation may be broad (for example, skin) while the target site of the observation result is specific (for example, skin on chest). Multiple contiguous sites within the same organ system may be referenced. For example: Lower intestine Arm Breast Ovary Kidney
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

---

 Target Anatomic Site Laterality Cd

Description	Specifies the side of the body (or a paired organ) that is a target site for an observation. For example: Bilateral Left Right
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

---

 Target Anatomic Site Laterality Code Sk

Description	Specifies the side of the body (or a paired organ) that is a target site for an observation. For example: Bilateral Left Right
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

---

 Temperature Range Txt

Description	The thermal reading at which the storage unit was set. For example: gt -80 degrees celsius -135 to -80 degrees celsius
Data Type	Standards - Data Domains.ddm/Data Domains/Text Small [VARCHAR(50)]
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

---

 Transfer Qty

Description	The amount and unit of study agent transferred in standard or canonical units.
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

---

 Treatment Vehicle Qty

Description	The quantity and units of treatment vehicle used. For example: 10 milligrams 2 milliliters
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

---

 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

---

 Variance Reason Cd

Description	Describes why what occurred is different from what was expected. For example: Subject received early treatment because of vacation plans.
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

---

 Variance Reason Code Sk

Description	Describes why what occurred is different from what was expected. For example: Subject received early treatment because of vacation plans.
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

---

 Variance Type Cd

Description	Specifies the kind of variance. For example: Early / late occurrence of an act Higher / lower amount transferred
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

---

 Variance Type Code Sk

Description	Specifies the kind of variance. For example: Early / late occurrence of an act Higher / lower amount transferred
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

Relationship Details

 Activity Fact_Product Dimension_FK

Is Identifying Relationship	false
Child Table	Activity Fact
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	Product Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Activity Fact_Experimental Unit Dimension_FK

Is Identifying Relationship	false
Child Table	Activity Fact
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	Experimental Unit Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Activity Fact_Organization Dimension_FK

Is Identifying Relationship	false
Child Table	Activity Fact
Child Role Name	performing
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	Organization Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Activity Fact_Practitioner Dimension_FK

Is Identifying Relationship	false
Child Table	Activity Fact
Child Role Name	notified
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	Practitioner Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Activity Fact_Point Of Care Location Dimension_FK

Is Identifying Relationship	false
Child Table	Activity Fact
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	Point Of Care Location Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Activity Fact_Document Dimension_FK

Is Identifying Relationship	false
Child Table	Activity Fact
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	Document Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Activity Fact_Person Dimension_FK

Is Identifying Relationship	false
Child Table	Activity Fact
Child Role Name	performing
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	Person Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Activity Fact_Person Dimension_FK1

Is Identifying Relationship	false
Child Table	Activity Fact
Child Role Name	notified
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	Person Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Activity Fact_Organization Dimension_FK1

Is Identifying Relationship	false
Child Table	Activity Fact
Child Role Name	notified
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	Organization Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Activity Fact_Calendar Dimension_FK

Is Identifying Relationship	false
Child Table	Activity Fact
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	Calendar Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Activity Fact_Study Protocol Dimension_FK

Is Identifying Relationship	false
Child Table	Activity Fact
Child Role Name	required by
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 Protocol Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Activity Fact_Protocol Arm Dimension_FK

Is Identifying Relationship	false
Child Table	Activity Fact
Child Role Name	performed in
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	Protocol Arm Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Activity Fact_Epoch_FK

Is Identifying Relationship	false
Child Table	Activity Fact
Child Role Name	component of
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	Epoch Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Activity Fact_Study Dimension_FK

Is Identifying Relationship	false
Child Table	Activity Fact
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 Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Activity Fact_Study Subject Dimension_FK

Is Identifying Relationship	false
Child Table	Activity Fact
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 Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Activity Fact_Specimen Dimension_FK

Is Identifying Relationship	false
Child Table	Activity Fact
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	Specimen Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Activity Fact_Study Site Dimension_FK

Is Identifying Relationship	false
Child Table	Activity Fact
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 Site Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

 Activity Fact PK

Key Attribute

Activity Fact Dk

---

Overview Top Package Entity

Dimensional Warehouse Model Data Model