| Atomic Warehouse Model Data Model |
| Description | A set of universal names and ID codes for identifying laboratory and clinical test results. This is for test results that do not contain organisms. |
| Relationship | |
 Laboratory Test_Common Code_FK |
|
| Primary Key | |
 Laboratory Test PK |
|
| Dependencies | |
 |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
Change Type Code Sk
| Description | The type of change that was made. For example: Delete/Deprecate Add Change to Analyte/Component Change to name field Change to field other than name Undelete |
| 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 |
Class Code Sk
| Description | An arbitrary classification of the terms for grouping related observations together. The content of the laboratory test subclasses should be obvious from the subclass name. |
| 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 |
Comments Txt
| Description | Comments relating to the laboratory test 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 |
Component Code Sk
| Description | First major axis-component or analyte (i.e. potassium, hemoglobin, hepatitis C antigen, etc). |
| 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 |
Example Unit Txt
| Description | Text which shows representative, but not necessarily recommended units in which data could be submitted for this term. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Full Common Name Txt
| Description | Text which describes the fully specified laboratory result code name. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
INPC Percentage Pct
| Description | Percent of overall 13 month result volume within the INPC (circa 2006). A record with a value 0 indicates that this code is one of the common test results that comprise 99% of the total INPC result volume. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Laboratory Result Map To Code Sk
| Description | The new term that should be used when an existing term has been replaced by an updated term. |
| 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 |
Laboratory Test Sk
| Description | The generated unique key for Common Code table. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| 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 Type Code Sk
| Description | Sixth major axis - method of measurement. |
| 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 |
Property Code Sk
| Description | Second major axis-property observed (i.e. mass vs.substance). |
| 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 |
Scale Type Code Sk
| Description | Fifth major axis - scale of measurement (i.e. qualitative vs.quantitative). |
| 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 |
Status Code Sk
| Description | Describes the status of a laboratory test concept. For example: Active - Concept is active Trial- Concept is experimental in nature. Use with caution as the concept and associated attributes may change Discouraged - Concept is not recommended for current use. New mappings to this concept are discouraged; although existing mappings may continue to be valid in context. Wherever possible, the superseding concept is indicated in the Laboratory Result Map To field and should be used instead. Deprecated - Concept is deprecated. Concept should not be used, but it is retained for historical purposes. Wherever possible, the superseding concept is indicated in the Laboratory Result Map To field and should be used both for new mappings and updating existing implementations. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Status Reason Code Sk
| Description | Indicates the reason for the laboratory test concept status. For example: Ambiguous Duplicate Erroneous |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Status Txt
| Description | Explanation of concept status in narrative text. This field will be Null for ACTIVE concepts, and optionally populated for terms in other status. |
| 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 |
System Code Sk
| Description | Fourth major axis - type of specimen or system (i.e. serum vs.urine). |
| 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 |
Time Aspect Code Sk
| Description | Third major axis - timing of the measurement frequency of the laboratory test (i.e. point in time vs.24 hours). |
| 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 |
Update Dt
| Description | The date the laboratory test details are edited/updated. |
| 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 |
| Relationship Details |
Laboratory Test_Common Code_FK
| Is Identifying Relationship | true |
| Child Table | Laboratory Test |
| 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 | Common Code |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Primary Key Details |
Laboratory Test PK
| Key Attribute | Laboratory Test Sk |
| Atomic Warehouse Model Data Model |