Comment TxtFasting Status IndPopulation ScopeReference TypeReference Value TxtTarget Anatomic SiteTarget Anatomic Site LateralityValue Type
| Business Data Model Data Model |
| Description | The possible or expected results that can be obtained by observing, monitoring, measuring or otherwise qualitatively or quantitatively recording one or more aspects of physiologic or psychologic processes. For example: The normal range for a systolic blood pressure reading is 110-130 for adult males: Reference Result Reference Type Code = normal range Reference Result Value Type Code = systolic blood pressure Reference Result Value = 110-130 mm[Hg] Reference Result Population Scope Code = adult males |
| Attributes | |
| Comment Txt |
|
| Fasting Status Ind |
|
| Population Scope |
|
| Reference Type |
|
| Reference Value Txt |
|
| Target Anatomic Site |
|
| Target Anatomic Site Laterality |
|
| Value Type |
|
| Relationship | |
 performedReferenceResult |
|
| referencedReferenceResult |
|
| ReferenceResult_Laboratory_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Comment Txt
| Description | Additional description of the reference 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 |
Fasting Status Ind
| Description | Specifies whether the subject had abstained from eating when the specimen was obtained. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Population Scope
| Description | Specifies the type of subjects to which this reference result applies. For example: Adult males Adult females Minor males Minor females |
| 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 |
Reference Type
| Description | Specifies the kind of reference, i.e. how it is to be used or what its purpose is. For example: Normal range Limit of quantitation Clinical concern range Data checking range Alert range |
| 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 |
Reference Value Txt
| Description | A reference for some measurement that a physician or other health professional can use to interpret a set of results for a particular experimental unit. For example: For systolic blood pressure, Reference Result Value (ANY) would be constrained to IVL<PQ> and would = 110-130 mm[Hg] |
| 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
| 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/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Target Anatomic Site Laterality
| 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/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Value Type
| Description | Specifies the kind of clinical result to which this reference result must be associated. For example: For a blood pressure measurement, the Value Type may be systolic or diastolic. |
| 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 |
| Relationship Details |
performedReferenceResult
| Description | |
| Is Identifying Relationship | false |
| Child Table | Reference Result |
| Child Role Name | performingDevice |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | SET_NULL |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | SET_NULL |
| Parent Table | Device |
| Parent Role Name | performedReferenceResult |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | SET_NULL |
| Parent Referential Integrity: On Update | SET_NULL |
referencedReferenceResult
| Description | |
| Is Identifying Relationship | false |
| Child Table | Reference Result |
| Child Role Name | referencingPerformedClinicalResult |
| 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 | Performed Clinical Result |
| Parent Role Name | referencedReferenceResult |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
ReferenceResult_Laboratory_FK
| Is Identifying Relationship | true |
| Child Table | Reference Result |
| 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 | Laboratory |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |