Atomic Warehouse Model Data Model

Entity

Entity Activity Observation Detail

Description

A completed action of observing, monitoring, measuring or otherwise qualitatively or quantitatively gathering data or information about one or more aspects of a subject, study subject, or experimental unit.

For example:
Lab test
Taking vital signs
Physical exam

Attributes
Activity Observation Sk
Approach Anatomic Site Code Sk
Approach Anatomic Site Laterality Code Sk
Body Position Code Sk
Body System Code Sk
Contrast Agent Enhancement Ind
Display Order
Effective From Dt
Effective To Dt
Enhancement Descr
Enhancement Rt
Focal End Dt
Focal Start Dt
Load Info Sk
Method Code Sk
Name Code Modified Txt
Non Reason Code Sk
Not Applicable Ind
Observation Type Code Sk
Source Code Sk
Standard Time Ind
Target Anatomic Site Code Sk
Target Anatomic Site Condition Code Sk
Target Anatomic Site Laterality Code Sk
Tenant Sk
Valid From Ts
Valid To Ts

Relationship
Activity Observation Detail_Activity Observation_FK

Primary Key
Activity Observation Detail PK

Dependencies

Reverse Dependencies

Attribute Details

Activity Observation Sk

Description	Surrogate key for the anchor entity.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

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

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

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

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

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

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

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

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

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

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

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

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

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 Type Code Sk

Description	Code identifying the actual type of the entity as per the type hierarchy defined in the business data model. For example: Casual Assessment Performed Eligibility Criterion Performed Imaging
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

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

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

Tenant Sk

Description	The surrogate key of the entry identifying the legal owner of the data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Valid From Ts

Description	Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Valid To Ts

Description	Ends a period of validity.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Activity Observation Detail_Activity Observation_FK

Is Identifying Relationship	true
Child Table	Activity Observation Detail
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Activity Observation
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 Observation Detail PK

Key Attribute	Activity Observation Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model