| Business Data 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 |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Change Type
| 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/Enumeration [VARCHAR(20)] |
| 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
| Description | First major axis - component or analyte. For example: Potassium Hemoglobin Hepatitis C antigen |
| 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 |
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 | A percentage of the 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
| 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/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Laboratory Test Class
| 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/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Laboratory Test Property
| Description | Second major axis - property observed. For example: Mass versus Substance |
| 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 |
Laboratory Test Status
| 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 supersiding 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/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Laboratory Test Status Reason
| Description | Indicates the reason for the laboratory test concept status. For example: Ambiguous Duplicate Erroneous |
| 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 |
Laboratory Test Update Date
| 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 |
Method Type
| Description | Sixth major axis - method of measurement. |
| 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 |
Scale Type
| Description | Fifth major axis - scale of measurement. For example: Qualitative versus Quantitative |
| 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 |
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
| Description | Fourth major axis - type of specimen or system. For example: Serum versus Urine |
| 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 |
Time Aspect Code
| Description | Third major axis - timing of the measurement frequency of the laboratory test For example: Point in time versus 24 hours |
| 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 |
Laboratory Test_Common Code_FK
| Is Identifying Relationship | true |
| Child Table | Laboratory Test |
| Child Role Name | laboratory test is of |
| 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 |
| Business Data Model Data Model |