Dimensional Warehouse Model Data Model

Entity

Entity Observation Result Fact

Description

A finding that is obtained by observing, monitoring, measuring or otherwise qualitatively or quantitatively recording one or more aspects of physiologic or psychologic processes.

Attributes
Abnormal Ind
Actual Approach Anatomic Site Cd
Actual Approach Anatomic Site Code Sk
Actual Body Position Cd
Actual Body Position Code Sk
Actual Body System Cd
Actual Body System Code Sk
Actual Category Cd
Actual Category Code Sk
Actual Confidentiality Cd
Actual Confidentiality Code Sk
Actual Contrast Agent Enhancement Ind
Actual Enhancement Descr
Actual Enhancement Rt
Actual Method Cd
Actual Method Code Sk
Actual Result Comment Txt
Actual Result Type Cd
Actual Result Type Code Sk
Actual Severity Cd
Actual Severity Code Sk
Actual Subcategory Cd
Actual Subcategory Code Sk
Actual Target Anatomic Site Cd
Actual Target Anatomic Site Code Sk
Actual Target Anatomic Site Laterality Cd
Actual Target Anatomic Site Laterality Code Sk
Actual Value Qty
Appearance Type Cd
Appearance Type Code Sk
Approach Anatomic Site Laterality Cd
Approach Anatomic Site Laterality Code Sk
As Collected Ind
Authorizing Party Role Dk
Authorizing Party Role Sk
AWM Load Info Sk
Baseline Ind
Biomarker Ind
Body System Cd
Body System Code Sk
Clinical Interpretation Severity Cd
Clinical Interpretation Severity Code Sk
Clinically Significant Ind
Conclusion Txt
Contact Anatomic Site Cd
Contact Anatomic Site Code Sk
Current Ind
Defect Type Cd
Defect Type Code Sk
Defined Approach Anatomic Site Cd
Defined Approach Anatomic Site Code Sk
Defined Body Position Cd
Defined Body Position Code Sk
Defined Category Cd
Defined Category Code Sk
Defined Confidentiality Cd
Defined Confidentiality Code Sk
Defined Contrast Agent Enhancement Ind
Defined Derivation Expression Txt
Defined Enhancement Descr
Defined Enhancement Rt
Defined Focal Date Range Qty
Defined Focal Duration Qty
Defined Method Cd
Defined Method Code Sk
Defined Result Comment Txt
Defined Result Type Cd
Defined Result Type Code Sk
Defined Severity Cd
Defined Severity Code Sk
Defined Subcategory Cd
Defined Subcategory Code Sk
Defined Target Anatomic Site Cd
Defined Target Anatomic Site Code Sk
Defined Target Anatomic Site Laterality Cd
Defined Target Anatomic Site Laterality Code Sk
Defined Target Coding System
Defined Value Negation Ind
Defined Value Qty
Device Malfunction Cd
Device Malfunction Code Sk
Differentiation Grade Cd
Differentiation Grade Code Sk
Dimension Product Qty
Disease Status Cd
Disease Status Code Sk
Disease Status Missing Reason Cd
Disease Status Missing Reason Code Sk
Display Order
Document Dk
Document Sk
DWM Load Info Sk
Effective From Dt
Effective To Dt
End Relative To Reference Cd
End Relative To Reference Code Sk
Evaluation Conclusion Cd
Evaluation Conclusion Code Sk
Expected Ind
Focal End Dt
Focal Start Dt
Grade Cd
Grade Code Sk
Highlighted Ind
Hospitalization Required Ind
Identification Num
Infectious Agent Txt
Involved Surgical Margin Ind
Lesion Qty
Location Descr
Measurable Ind
Medical Condition Clinically Significant Ind
Medical Condition End Relative To Reference Cd
Medical Condition End Relative To Reference Code Sk
Medical Condition Occurrence Date Range Qty
Medical Condition Occurrence Date Range Validation Cd
Medical Condition Occurrence Date Range Validation Code Sk
Medical Condition Severity Cd
Medical Condition Severity Code Sk
Medical History Ind
Name Code Modified Txt
Non Reason Cd
Non Reason Code Sk
Normal Range Comparison Cd
Normal Range Comparison Code Sk
Not Applicable Ind
Observation Fact Dk
Observation Result Fact Bk
Observation Result Fact Sk
Occurrence From Ts
Occurrence Pattern Cd
Occurrence Pattern Code Sk
Occurrence To Ts
Performing Party Role Dk
Performing Party Role Sk
Post Report Update Dt
Product Dk
Product Sk
Protocol Deviation Category Cd
Protocol Deviation Category Code Sk
Protocol Deviation Occurrence Date Range Qty
Protocol Deviation Severity Cd
Protocol Deviation Severity Code Sk
Protocol Deviation Subcategory Cd
Protocol Deviation Subcategory Code Sk
Recurrence Ind
Reported Dt
Required Ind
Result Classification Cd
Result Classification Code Sk
Source Cd
Source Code Sk
Standard Time Ind
Status Cd
Status Code Sk
Study Dk
Study Protocol Dk
Study Protocol Sk
Study Sk
Summary Txt
Target Anatomic Site Condition Cd
Target Anatomic Site Condition Code Sk
Target Biomarker Cd
Target Biomarker Code Sk
Tenant Sk
Toxicity Grade Cd
Toxicity Grade Code Sk
Toxicity Term Cd
Toxicity Term Code Sk
Treatment Emergent Ind
Uncertainty Cd
Uncertainty Code Sk
Unexpected Reason Cd
Unexpected Reason Code Sk
Valid From Ts
Valid To Ts
Value Code Modified Txt
Value Null Flavor Reason txt
xDimension Qty
yDimension Qty
zDimension Qty

Relationship
Observation Result Fact_Product Dimension_FK
Observation Result Fact_Party Role Dimension_FK
Observation Result Fact_Party Role Dimension_FK1
Observation Result Fact_Document Dimension_FK
Observation Result Fact_Study Dimension_FK
Observation Result Fact_Study Protocol Dimension_FK

Primary Key
Observation Result Fact PK

Dependencies

Reverse Dependencies

Attribute Details

Abnormal Ind

Description	Specifies whether an interpreted event is abnormal.
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

Actual 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

Actual 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

Actual Body Position Cd

Description	Specifies the 3-dimensional spatial orientation of a subject during a particular observation. For example: Supine Trendelenburg Standing
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 Body Position Code Sk

Description	Specifies the 3-dimensional spatial orientation of a subject during a particular observation. For example: Supine Trendelenburg Standing
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 Body System Cd

Description	Specifies the anatomical structure that consists of organs and organ subclasses responsible for certain body functions. For example: Gastrointestinal system Urinary system Hematopoietic system
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 Body System Code Sk

Description	Specifies the anatomical structure that consists of organs and organ subclasses responsible for certain body functions. For example: Gastrointestinal system Urinary system Hematopoietic system
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 Category Cd

Description	Classification of the adverse event. For example: Bleeding Hypoglycemia
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 Category Code Sk

Description	Classification of the adverse event. For example: Bleeding Hypoglycemia
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 Confidentiality Cd

Description	The level of security and/or privacy surrounding the order or observation result. For example: Highly confidential Not confidential Confidential Restricted Do not reveal to study sponsor.
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 Confidentiality Code Sk

Description	The level of security and/or privacy surrounding the order or observation result. For example: Highly confidential Not confidential Confidential Restricted Do not reveal to study sponsor.
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 Contrast Agent Enhancement Ind

Description	Specifies whether the image is enhanced by the use of a contrast agent.
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

Actual Enhancement Descr

Description	The textual representation for how an image is enhanced either physically or electronically.
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 Enhancement Rt

Description	The numeric value to indicate an increase in voxel signal over time for an MRI, expressed as signal intensity units per second.
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 Method Cd

Description	Specifies the technique used to perform the observation. For example: Arterial puncture, sphygmomanometry (for blood pressure measurement) Global introspection, algorithm, bayesian (for Adverse Event causality) Estrogen Receptor Assay, Progesterone Receptor Assay, p53 Assay (for clinical result assay)
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 Method Code Sk

Description	Specifies the technique used to perform the observation. For example: Arterial puncture, sphygmomanometry (for blood pressure measurement) Global introspection, algorithm, bayesian (for Adverse Event causality) Estrogen Receptor Assay, Progesterone Receptor Assay, p53 Assay (for clinical result assay)
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 Result Comment Txt

Description	Additional description of the observation result. For example: Comments from the investigator regarding the condition of the specimen or any other observation. Comments in addition to the specimen condition from the central or performing laboratory describing the specimen.
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 Result Type Cd

Description	Specifies the kind of observation result. For example: For blood pressure, the results might be 120 for systolic and 80 for diastolic, where systolic and diastolic are the types distinguishing the two numbers.
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 Result Type Code Sk

Description	Specifies the kind of observation result. For example: For blood pressure, the results might be 120 for systolic and 80 for diastolic, where systolic and diastolic are the types distinguishing the two numbers.
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 Severity Cd

Description	Specifies the intensity of an activity, event or condition. For example: Major Moderate Minor
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 Severity Code Sk

Description	Specifies the intensity of an activity, event or condition. For example: Major Moderate Minor
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 Subcategory Cd

Description	Specifies a subdivision within a larger category of an adverse event. For example: Neurologic
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 Subcategory Code Sk

Description	Specifies a subdivision within a larger category of an adverse event. For example: Neurologic
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 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

Actual 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

Actual 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

Actual 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

Actual Value Qty

Description	Data or information that is determined by an act of observation. For example: The result of a lab test, physical finding, self-reported symptom. The adverse event term code.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Very Large [VARCHAR(2048)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Appearance Type Cd

Description	Identifies the appearance of a superficial lesion. For example: Flat Nodular
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

Appearance Type Code Sk

Description	Identifies the appearance of a superficial lesion. For example: Flat Nodular
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

As Collected Ind

Description	Specifies whether the observation is represented in the units or values as originally collected. For example: A performing lab may have completed the observation or lab test using conventional units, but the sponsor may wish to have the test reported in SI units. This flag will be set to "true" on the lab test that has the original units, and "false" on the lab test in which the units that are different than the lab test's original units.
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

Authorizing Party Role 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

Authorizing Party Role 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

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

Baseline Ind

Description	Specifies whether the result is a starting point to which other results may be compared.
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

Biomarker Ind

Description	Specifies whether a result is considered a biomarker. This is based on a result as stated in the NCI Thesaurus for Biomarker: A variation in cellular or biochemical components or processes, structures, or functions that is objectively measurable in a biological system and that characterizes normal biologic processes, pathogenic processes, an organism's state of health or disease, likelihood of developing a disease, prognosis, or response to a particular therapeutic intervention. Biomarkers include but not limited to such phenotypic parameters as specific enzyme or hormone concentration, specific gene phenotype, presence or absence of biological substances.
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

Body System Cd

Description	Specifies the anatomical structure that consists of organs and organ subclasses responsible for certain body functions. For example: Gastrointestinal system Urinary system Hematopoietic system
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

Body System Code Sk

Description	Specifies the anatomical structure that consists of organs and organ subclasses responsible for certain body functions. For example: Gastrointestinal system Urinary system Hematopoietic system
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

Clinical Interpretation Severity Cd

Description	Specifies the intensity of an activity, event or condition. For example: Major Moderate Minor
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

Clinical Interpretation Severity Code Sk

Description	Specifies the intensity of an activity, event or condition. For example: Major Moderate Minor
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

Clinically Significant Ind

Description	Specifies whether a subject's clinical condition is important based on judgment.
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

Conclusion Txt

Description	A text or otherwise formatted description of the final results drawn from the investigation.
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

Contact Anatomic Site Cd

Description	Specifies the anatomic site (single) in contact with the lesion.
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

Contact Anatomic Site Code Sk

Description	Specifies the anatomic site (single) in contact with the lesion.
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

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

Defect Type Cd

Description	Specifies the kind of device-related events that characterize the reported event/problem. For example: malfunction
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

Defect Type Code Sk

Description	Specifies the kind of device-related events that characterize the reported event/problem. For example: malfunction
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 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

Defined 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

Defined Body Position Cd

Description	Specifies the 3-dimensional spatial orientation of a subject during a particular observation. For example: Supine Trendelenburg Standing
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 Body Position Code Sk

Description	Specifies the 3-dimensional spatial orientation of a subject during a particular observation. For example: Supine Trendelenburg Standing
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 Category Cd

Description	Classification of the adverse event. For example: Bleeding Hypoglycemia
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 Category Code Sk

Description	Classification of the adverse event. For example: Bleeding Hypoglycemia
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 Confidentiality Cd

Description	The level of security and/or privacy surrounding the order or observation result. For example: Highly confidential Not confidential Confidential Restricted Do not reveal to study sponsor.
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 Confidentiality Code Sk

Description	The level of security and/or privacy surrounding the order or observation result. For example: Highly confidential Not confidential Confidential Restricted Do not reveal to study sponsor.
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 Contrast Agent Enhancement Ind

Description	Specifies whether the image is enhanced by the use of a contrast agent.
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

Defined Derivation Expression Txt

Description	A character string containing a formal language expression that specifies how the observation result's attributes are, should be, or have been derived from input parameters associated with 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

Defined Enhancement Descr

Description	The textual representation for how an image is enhanced either physically or electronically.
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 Enhancement Rt

Description	The numeric value to indicate an increase in voxel signal over time for an MRI, expressed as signal intensity units per second.
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 Focal Date Range Qty

Description	The time period in which the observation result is held to be true, expressed either as a simple date range or as an evaluable expression that references a study-defined date or milestone. For example: For a survey question, "Have you traveled to Europe between 1990 and 1999?", the focal date range would be "January 1, 1990 to December 31, 1999".
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 Focal Duration Qty

Description	A quantity of time in which the observation result is held to be true. For example: 2 months is the focal duration for the question, "Have you smoked in the last 2 months?"
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 Method Cd

Description	Specifies the technique used to perform the observation. For example: Arterial puncture, sphygmomanometry (for blood pressure measurement) Global introspection, algorithm, bayesian (for Adverse Event causality) Estrogen Receptor Assay, Progesterone Receptor Assay, p53 Assay (for clinical result assay)
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 Method Code Sk

Description	Specifies the technique used to perform the observation. For example: Arterial puncture, sphygmomanometry (for blood pressure measurement) Global introspection, algorithm, bayesian (for Adverse Event causality) Estrogen Receptor Assay, Progesterone Receptor Assay, p53 Assay (for clinical result assay)
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 Result Comment Txt

Description	Additional description of the observation result.
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 Result Type Cd

Description	Specifies the kind of observation result. For example: For blood pressure, the results might be 120 for systolic and 80 for diastolic, where systolic and diastolic are the types distinguishing the two numbers.
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 Result Type Code Sk

Description	Specifies the kind of observation result. For example: For blood pressure, the results might be 120 for systolic and 80 for diastolic, where systolic and diastolic are the types distinguishing the two numbers.
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 Severity Cd

Description	Specifies the intensity of an activity, event or condition. For example: Major Moderate Minor
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 Severity Code Sk

Description	Specifies the intensity of an activity, event or condition. For example: Major Moderate Minor
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 Subcategory Cd

Description	Specifies a subdivision within a larger category of an adverse event. For example: Neurologic
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 Subcategory Code Sk

Description	Specifies a subdivision within a larger category of an adverse event. For example: Neurologic
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 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

Defined 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

Defined 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

Defined 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

Defined Target Coding System

Description	The coding system to use for recording results for the associated activity or evaluation.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Defined Value Negation Ind

Description	Specifies whether, when the observation event occurred, the finding communicated by the value attribute was NOT found. This should only be used when the terminology used for Defined Observation Result is not itself capable of expressing negated findings (for example, ICD9).
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

Defined Value Qty

Description	Data or information that is determined by an act of observation. For example: The result of a lab test, physical finding, self-reported symptom.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Very Large [VARCHAR(2048)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Device Malfunction Cd

Description	A coded value specifying the defect or malfunction that occurred during use of the suspect device whether or not the problem is associated with an adverse event. Codes are FDA CDRH device codes.
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

Device Malfunction Code Sk

Description	A coded value specifying the defect or malfunction that occurred during use of the suspect device whether or not the problem is associated with an adverse event. Codes are FDA CDRH device codes.
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

Differentiation Grade Cd

Description	Specifies the degree of cellular differentiation in a tissue sample. For example: A brain tumor could be grade 3
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

Differentiation Grade Code Sk

Description	Specifies the degree of cellular differentiation in a tissue sample. For example: A brain tumor could be grade 3
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

Dimension Product Qty

Description	The result or product of multiplying dimensions (2 or 3) of a site or specimen.
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

Disease Status Cd

Description	Specifies the amount of disease present in a subject. For example: metastatic and disease-free (cancer-specific examples)
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

Disease Status Code Sk

Description	Specifies the amount of disease present in a subject. For example: metastatic and disease-free (cancer-specific examples)
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

Disease Status Missing Reason Cd

Description	Specifies why a disease status is missing. The distinctions between unevaluable, missing reason and not assessed, will be made in the hierarchy of the reason codes and need not be made as distinct attributes, since they are mutually exclusive. For example: "the sample was damaged" is a reason code within the "unevaluable" classification.
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

Disease Status Missing Reason Code Sk

Description	Specifies why a disease status is missing. The distinctions between unevaluable, missing reason and not assessed, will be made in the hierarchy of the reason codes and need not be made as distinct attributes, since they are mutually exclusive. For example: "the sample was damaged" is a reason code within the "unevaluable" classification.
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

Display Order

Description	The sequence or position of a component in a list of question or data items.
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

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

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

Evaluation Conclusion Cd

Description	A coded value specifying the relevant fact within the context of the evaluation final results for a reported suspect medical device. Based on FDA CDRH Conclusion Codes.
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

Evaluation Conclusion Code Sk

Description	A coded value specifying the relevant fact within the context of the evaluation final results for a reported suspect medical device. Based on FDA CDRH Conclusion Codes.
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

Expected Ind

Description	Specifies whether the specificity (nature), frequency, or severity of an adverse event is consistent with the applicable study documentation (for example, investigator's brochure, protocol document, or consent document) or product labeling (package insert).
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

Focal End Dt

Description	The quantity of time in which the observation result is held to be true. For example: 2 months is the focal duration for a question such as "Have you smoked in the last 2 months?".
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

Focal Start Dt

Description	The time period in which the observation result is held to be true.
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

Grade Cd

Description	A coded value specifying the level of injury suffered by the subject or study subject for whom the event is reported. For example: The grade code could be 3 if the CTCAE coding system is being used.
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

Grade Code Sk

Description	A coded value specifying the level of injury suffered by the subject or study subject for whom the event is reported. For example: The grade code could be 3 if the CTCAE coding system is being used.
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

Highlighted Ind

Description	Specifies whether the adverse event or reaction term is a major concern or reason for reporting the adverse event.
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

Hospitalization Required Ind

Description	Specifies whether the subject or study subject requires hospitalization or prolongation of existing hospitalization as a result of the adverse event.
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	The unique symbol that establishes identity of the observation result.
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

Infectious Agent Txt

Description	The name of the specific microbe that the test is intended to identify. For example: Streptococcus pneumoniae Staphylococcus aureus
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

Involved Surgical Margin Ind

Description	Specifies whether the margins of surgical resection are infiltrated by the abnormal tissue.
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

Lesion Qty

Description	The integer assigned to a lesion for a subject. Once a lesion number is designated for a specific lesion that number may not change or re-used to denote a different lesion.
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

Location Descr

Description	The textual representation of the physical location of the subject or study subject when the adverse event began.
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

Measurable Ind

Description	Specifies whether a lesion or site of disease is measurable.
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

Medical Condition Clinically Significant Ind

Description	Specifies whether a subject's clinical condition is important based on judgment.
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

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

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

Medical Condition Occurrence Date Range Qty

Description	The date and time span in which the medical condition began and ended.
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

Medical Condition Occurrence Date Range Validation Cd

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

Medical Condition Occurrence Date Range Validation Code Sk

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

Medical Condition Severity Cd

Description	Specifies the intensity of an activity, event or condition. For example: Major Moderate Minor
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

Medical Condition Severity Code Sk

Description	Specifies the intensity of an activity, event or condition. For example: Major Moderate Minor
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 condition 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

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

Non Reason Cd

Description	A coded value specifying the motivation, cause or rationale that is explicitly NOT why an activity occurred.
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

Non Reason Code Sk

Description	A coded value specifying the motivation, cause or rationale that is explicitly NOT why an activity occurred.
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

Normal Range Comparison Cd

Description	Specifies the relationship of a value to a normal range or reference range of values. For example: High Low Within normal range Outside normal range
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

Normal Range Comparison Code Sk

Description	Specifies the relationship of a value to a normal range or reference range of values. For example: High Low Within normal range Outside normal range
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

Not Applicable Ind

Description	Specifies whether the specific eligibility criterion is not applicable to this participant.
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

Observation 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

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

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

Occurrence From Ts

Description	The date and time span in which the adverse event began.
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

Occurrence Pattern Cd

Description	Specifies the time recurrence by which an adverse event occurs. For example: Intermittent Continuous Single event
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

Occurrence Pattern Code Sk

Description	Specifies the time recurrence by which an adverse event occurs. For example: Intermittent Continuous Single event
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

Occurrence To Ts

Description	The date and time span in which the adverse event ended.
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

Performing Party Role 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 Party Role 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

Post Report Update Dt

Description	The date (and time) on which the adverse event was updated after it had been submitted.
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

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

Protocol Deviation Category Cd

Description	Classification of protocol deviation. For example: Concomitant Medications Data Integrity Compromised Eligibility not checked Eligibility waiver Informed Consent Other specify Study Procedures Treatment [NCI CRF Standard examples]
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

Protocol Deviation Category Code Sk

Description	Classification of protocol deviation. For example: Concomitant Medications Data Integrity Compromised Eligibility not checked Eligibility waiver Informed Consent Other specify Study Procedures Treatment [NCI CRF Standard examples]
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

Protocol Deviation Occurrence Date Range Qty

Description	The date and time span specifying when the protocol deviation began and ended.
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

Protocol Deviation Severity Cd

Description	Specifies the intensity of an activity, event or condition. For example: Major Moderate Minor
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

Protocol Deviation Severity Code Sk

Description	Specifies the intensity of an activity, event or condition. For example: Major Moderate Minor
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

Protocol Deviation Subcategory Cd

Description	Specifies a subdivision within a larger category of a protocol deviation.
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

Protocol Deviation Subcategory Code Sk

Description	Specifies a subdivision within a larger category of a protocol deviation.
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

Recurrence Ind

Description	Specifies whether this is a reappearance of the existing disease.
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

Reported Dt

Description	The date and time the result for a performed observation in a clinical trial or study is noted.
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

Required Ind

Description	Specifies whether this reply is necessary to include/exclude a potential subject on a 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

Result Classification Cd

Description	The highest level of the terminology describing the result distinguished by anatomical or physiological system, etiology, or purpose. For example: Blood and lymphatic system disorders Cardiac disorders Congenital, familial and genetic disorders Ear and labyrinth disorders Endocrine disorders
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

Result Classification Code Sk

Description	The highest level of the terminology describing the result distinguished by anatomical or physiological system, etiology, or purpose. For example: Blood and lymphatic system disorders Cardiac disorders Congenital, familial and genetic disorders Ear and labyrinth disorders Endocrine disorders
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

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

Standard Time Ind

Description	Specifies whether the time of the process step 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

Status Cd

Description	Specifies the phase in the lifecycle of the reported result. For example: Preliminary Final Corrected
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 Sk

Description	Specifies the phase in the lifecycle of the reported result. For example: Preliminary Final Corrected
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 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 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 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

Summary Txt

Description	A description of the adverse event and the treatment of the event.
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

Target Anatomic Site Condition Cd

Description	Specifies the state of the target anatomic site. For example: The subject's left arm was bruised where the IV was inserted.
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 Condition Code Sk

Description	Specifies the state of the target anatomic site. For example: The subject's left arm was bruised where the IV was inserted.
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 Biomarker Cd

Description	A coded value specifying a variation in cellular or biochemical components or processes, structures, or functions that is objectively measurable in a biological system and that characterizes normal biologic processes, pathogenic processes, an organism's state of health or disease, likelihood of developing a disease, prognosis, or response to a particular therapeutic intervention. This is the focus of an observation. For example: Biomarkers include but are not limited to such phenotypic parameters as specific enzyme or hormone concentration, specific gene phenotype, presence or absence of biological substance. For an observation with a Name Code of "Determine the Allele for the HLA-A Locus on Chromosome 6", the observation result might have a Target Biomarker Code of "HLA-A" and a value of "HLA-A*01:01:01" (the specific allele)
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 Biomarker Code Sk

Description	A coded value specifying a variation in cellular or biochemical components or processes, structures, or functions that is objectively measurable in a biological system and that characterizes normal biologic processes, pathogenic processes, an organism's state of health or disease, likelihood of developing a disease, prognosis, or response to a particular therapeutic intervention. This is the focus of an observation. For example: Biomarkers include but are not limited to such phenotypic parameters as specific enzyme or hormone concentration, specific gene phenotype, presence or absence of biological substance. For an observation with a Name Code of "Determine the Allele for the HLA-A Locus on Chromosome 6", the observation result might have a Target Biomarker Code of "HLA-A" and a value of "HLA-A*01:01:01" (the specific allele)
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

Toxicity Grade Cd

Description	Specifies the numeric grade for the toxicity.
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

Toxicity Grade Code Sk

Description	Specifies the numeric grade for the toxicity.
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

Toxicity Term Cd

Description	Specifies the degree to which a substance is able to damage an exposed organism. Similar to CTC Term (short name), for example, the National Cancer Institute's Common Toxicity Criteria terminology. For example: Hypocalcaemia
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

Toxicity Term Code Sk

Description	Specifies the degree to which a substance is able to damage an exposed organism. Similar to CTC Term (short name), for example, the National Cancer Institute's Common Toxicity Criteria terminology. For example: Hypocalcaemia
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

Treatment Emergent Ind

Description	Specifies whether the adverse event is something that first arose or become more severe during the studied treatment.
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

Uncertainty Cd

Description	Describes whether and to what degree this evaluation or observation has been asserted to be in doubt in any way. For example: A patient might have had a cholecystectomy procedure in the past, but isn't sure what the outcome was.
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

Uncertainty Code Sk

Description	Describes whether and to what degree this evaluation or observation has been asserted to be in doubt in any way. For example: A patient might have had a cholecystectomy procedure in the past, but isn't sure what the outcome was.
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

Unexpected Reason Cd

Description	Describes why an adverse event (experience or reaction) is considered unanticipated. For example: Severity Frequency Specificity from what has been previously documented
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

Unexpected Reason Code Sk

Description	Describes why an adverse event (experience or reaction) is considered unanticipated. For example: Severity Frequency Specificity from what has been previously documented
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

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

Value Code Modified Txt

Description	A character string that is a revision of the original text observation result to enable the coding of the text. For example: If the Original Text is "hedache", the Value Code Modified Text could be changed to "headache", 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

Value Null Flavor Reason txt

Description	The text and/or code that describes why no result was provided. For example: Subject refused to answer question.
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

xDimension Qty

Description	The measurement of a lesion or location in the 'X' (first or length) dimension. This is the longest measurement or largest value if only one measurement is captured.
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

yDimension Qty

Description	The measurement of a lesion in the 'Y' (second or width) dimension.
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

zDimension Qty

Description	The measurement of a lesion in the 'Z' (third) dimension.
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

Relationship Details

Observation Result Fact_Product Dimension_FK

Is Identifying Relationship	false
Child Table	Observation Result 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

Observation Result Fact_Party Role Dimension_FK

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

Observation Result Fact_Party Role Dimension_FK1

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

Observation Result Fact_Document Dimension_FK

Is Identifying Relationship	false
Child Table	Observation Result 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

Observation Result Fact_Study Dimension_FK

Is Identifying Relationship	false
Child Table	Observation Result 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

Observation Result Fact_Study Protocol Dimension_FK

Is Identifying Relationship	false
Child Table	Observation Result 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 Protocol 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

Observation Result Fact PK

Key Attribute

Observation Fact Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model