Atomic Warehouse Model Data Model

Entity

Entity LOINC Test Record

Description

A reference table that supports the loading of LOINC codes for tests, measurements, and observations.

Attributes
Acronym Synonym Txt
CAS Chemical Base Nm
CDISC Common Tests Ind
Code Table Comment Txt
Comment Txt
Consumer Item Nm
Curated Range And Units Comment Txt
Definition Description Help Comment Txt
Document Section Comment Txt
Exact Core Component Synonym Descr
Example Answers Comment Txt
Example SI UCUM Units Comment Txt
Example UCUM Units Comment Txt
Example Units Comment Txt
HL7 Field Subfield Id
HL7 V2 Data Type Comment Txt
HL7 V3 Data Type Comment Txt
INPC Pct
Last Change Dt
Last Change Type Code Sk
Load Info Sk
LOINC Class Nm
LOINC Class Type Code Sk
LOINC Component Descr
LOINC Formula Descr
LOINC Num Code Sk
LOINC Property Descr
LOINC Species Code Sk
LOINC System Descr
LOINC Test Record Sk
Long Common Nm
Map To New LOINC Num Code Sk
Method Type Descr
Molecular Mass Amount Descr
NAACCR Id
Order OBS Descr
Reference Txt
Related Names 2 Comment Txt
Set Root Ind
Short Nm
Source Code Sk
Status Code Sk
Status Reason Code Sk
Status Txt
Submitted Units Comment Txt
Survey Question Comment Txt
Survey Question Source Descr
Tenant Sk
Time Aspect Descr
Units Required Ind

Relationship
LOINC Test Record_LOINC Test Record_FK

Primary Key
LOINC Test Record PK

Dependencies

Reverse Dependencies

Attribute Details

Acronym Synonym Txt

Description	Chemical name synonyms, alternative name synonyms, and chemical formulae supplied by the Chemical Abstract Society.
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

CAS Chemical Base Nm

Description	Chemical base name from CAS.
Data Type	Standards - Data Domains.ddm/Data Domains/Name Medium [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

CDISC Common Tests Ind

Description	Indicates whether a term is a part of subset of terms used by CDISC in clinical trials.
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

Code Table Comment Txt

Description	Examples on CR0050 Cancer Registry.
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

Comment Txt

Description	Free-text comments relating to the 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

Consumer Item Nm

Description	An experimental (beta) consumer friendly name for this item.
Data Type	Standards - Data Domains.ddm/Data Domains/Name Long [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Curated Range And Units Comment Txt

Description	A curated list of normal ranges and associated units (expressed as near UCUM codes) for physical quantities and survey scores. Intended as tailorable starter sets for applications that use LOINC forms as a way to capture data. Units are separated from normal ranges by XXX and sets of normal range/units pairs are separated by YYY.
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

Definition Description Help Comment Txt

Description	Field that is similar to the current COMMENTS field that tells users what the LOINC term is and what to do with it. (should separate HELP from DEFINITION/DESCRIPTION field)
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

Document Section Comment Txt

Description	Classification of whether this LOINC code can be used a full document, a section of a document, or both. This field was created in the context of HL7 CDA messaging, and populated in collaboration with the HL7 Structured Documents Technical Committee.
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

Exact Core Component Synonym Descr

Description	An exact synonym for the core component of the LOINC component name.
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Example Answers Comment Txt

Description	An example of a valid answer for a test / measurement. For example: 1:64negative @ 1:16 or 55.
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

Example SI UCUM Units Comment Txt

Description	The Unified Code for Units of Measure (UCUM) is a code system intended to include all units of measures being contemporarily used in international science, engineering, and business. (www.unitsofmeasure.org) This field contains example units of measures for this term expressed as SI UCUM units.
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

Example UCUM Units Comment Txt

Description	The Unified Code for Units of Measure (UCUM) is a code system intended to include all units of measures being contemporarily used in international science, engineering, and business. (www.unitsofmeasure.org). This field contains example units of measures for this term expressed as UCUM units.
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

Example Units Comment Txt

Description	Populated with a combination of submitters units and units that people have sent us. Its purpose is to show users representative, but not necessarily recommended, units in which data could be sent for this term.
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

HL7 Field Subfield Id

Description	Indicates whether the content should be delivered in the named field/subfield of the HL7 message. When NULL, the data for this data element should be sent in an OBX segment with this LOINC code stored in OBX-3 and with the value in the OBX-5.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

HL7 V2 Data Type Comment Txt

Description	HL7 version 2.x data type that would be sent in OBX-2 when this data is delivered in an HL7 message.
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

HL7 V3 Data Type Comment Txt

Description	HL7 version 3.0 data type that is compatible with this LOINC code.
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

INPC 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 tests that comprise 99% of the total INPC result volume. See also PMID: 18693941.
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

Last Change Dt

Description	The last date a Logical Observation Identifiers Names and Codes (LOINC) test record is modified.
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

Last Change Type Code Sk

Description	Change Type Code, Last Change Type will indicate if the system using the LOINC code needs to account for this changed version of the code.
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

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

LOINC Class Nm

Description	An arbitrary classification of the terms for grouping related observations together.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

LOINC Class Type Code Sk

Description	Categorization of LOINC codes. For example: 1=Laboratory class 2=Clinical class 3=Claims attachments 4=Surveys
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

LOINC Component Descr

Description	First major axis-component or analyte. For example: Potassium Hemoglobin Hepatitis C antigen
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

LOINC Formula Descr

Description	Regression equation details for many OB.US calculated terms.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

LOINC Num Code Sk

Description	The unique LOINC Code.
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

LOINC Property Descr

Description	Second major axis-property observed. For example: Mass vs. Substance
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

LOINC Species Code Sk

Description	Indicates which non-human species the term applies to. If blank, human is assumed.
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

LOINC System Descr

Description	Fourth major axis-type of specimen or system. For example: Serum vs. Urine.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

LOINC Test Record Sk

Description	The unique identifier of the LOINC Test Record.
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	true

Long Common Nm

Description	The LOINC term in a more readable format than the fully specified name. The long common names have been created via a table driven algorithmic process. Most abbreviations and acronyms that are used in the LOINC database have been fully spelled out in English.
Data Type	Standards - Data Domains.ddm/Data Domains/Name Compound [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Map To New LOINC Num Code Sk

Description	Used when a field has been dropped from the active database (by entering DEL in the Status field) because it has been replaced by an updated term. In those cases, MAP_TO contains the LOINC code of the new term that should be used.
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

Method Type Descr

Description	Sixth major axis-method of measurement.
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Molecular Mass Amount Descr

Description	The molecular weights of chemical moieties.
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

NAACCR Id

Description	North American Association of Central Cancer Registries Identification Number.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Order OBS Descr

Description	Defines term as order only, observation only, or both. A fourth category, Subset, is used for terms that are subsets of a panel but do not represent a package that is known to be orderable.
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Reference Txt

Description	Contains references to medical literature, product announcements, or other written sources of information on the test or measurement described by the LOINC record.
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

Related Names 2 Comment Txt

Description	A synonym(s) for each of the parts of the fully specified LOINC name (component, property, time, system, scale, method).
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

Set Root Ind

Description	Indicates whether this record is the root of a set of LOINC codes. Currently used for claims attachments.
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

Short Nm

Description	A concatenation of the fully specified LOINC name.
Data Type	Standards - Data Domains.ddm/Data Domains/Name Compound [VARCHAR(250)]
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	Status Code for this for the LOINC test.
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	Classification of the reason for concept status. This field will be Null for ACTIVE concepts, and optionally populated for terms in other status where the reason is clear. DEPRECATED or DISCOURAGED terms may take values of: AMBIGUOUS, DUPLICATE, or 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

Submitted Units Comment Txt

Description	Units have been moved to a new structure that can be viewed in the details screen in RELMA.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Small [VARCHAR(50)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Survey Question Comment Txt

Description	Verbatim question from the survey instrument.
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

Survey Question Source Descr

Description	Exact name of the survey instrument and the item/question number.
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
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 Descr

Description	Third major axis-timing of the measurement frequency of the lab test. For example: Point in time vs.24 hours
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Units Required Ind

Description	Y/N field that indicates that units are required when this LOINC is included as an OBX segment in a HIPAA attachment.
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

Relationship Details

LOINC Test Record_LOINC Test Record_FK

Is Identifying Relationship	false
Child Table	LOINC Test Record
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	LOINC Test Record
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

LOINC Test Record PK

Key Attribute

LOINC Test Record Sk

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model