| Atomic Warehouse Model Data Model |
| Description | A reusable template that describes possible findings of an observation. For example: A blood pressure measurement may result in a diastolic number and a systolic number. The Defined Observation Result class can be used to represent defined ranges for contingencies by constraining the result attribute from ANY to IVL<PQ>, for instance, or any other range value. Such Defined Observation Results may be used as criteria for conditional activities or repeated activities. |
| Relationship | |
 Defined Observation Result Detail_Defined Observation Result_FK |
|
| Primary Key | |
 Defined Observation Result Detail PK |
|
| Dependencies | |
 |
|
| |
|
| |
|
| |
|
| |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
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 |
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 |
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 Observation Result 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 |
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 |
Effective From Dt
| Description | Establishes a period where a set of attributes are true according to the business. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Effective To Dt
| Description | Ends a period of effectivity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Load Info Sk
| Description | The surrogate key of the load information entry describing the details regarding the loading of the row. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
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 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 |
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 |
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 |
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 |
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 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 |
Target Coding System Code Sk
| Description | The coding system to use for recording results for the associated activity or evaluation. |
| 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 |
Type Code Sk
| Description | Identifies the actual type of the entry based on the entity type hierarchy defined in the business data 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 |
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 |
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 |
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 |
| Relationship Details |
Defined Observation Result Detail_Defined Observation Result_FK
| Is Identifying Relationship | true |
| Child Table | Defined Observation Result 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 | Defined Observation Result |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Primary Key Details |
Defined Observation Result Detail PK
| Key Attribute | Defined Observation Result Sk |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |