Business Data 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 Name
CDISC Common Tests Ind
Code Table Comment Txt
Comment Txt
Consumer Item Name
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
LOINC Class Name
LOINC Class Type
LOINC Code
LOINC Component Descr
LOINC Formula Descr
LOINC Last Change Date
LOINC Last Change Type
LOINC Property Descr
LOINC Scale Type Descr
LOINC Short Name
LOINC Species
LOINC System Descr
LOINC Test Status
LOINC Test Status Reason
Long Common Name
Map To New LOINC Code
Method Type Descr
Molecular Mass Amount Descr
NAACCR Id
Order OBS Descr
Reference Txt
Related Names 2 Comment Txt
Set Root Ind
Status Txt
Submitted Units Comment Txt
Survey Question Comment Txt
Survey Question Source Descr
Time Aspect Descr
Units Required Ind

Relationship
LOINC Test Record_LOINC Test Record_FK

Dependencies
NONE

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/Description Long [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

CAS Chemical Base Name

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 Small [VARCHAR(50)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Comment Txt

Description	Free-form comments that relate to the test result.
Data Type	Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Consumer Item Name

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/Description Long [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	A HL7 version 2.x data type that is sent in OBX-2 format 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	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 tests that comprise 99% of the total INPC result volume. See 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

LOINC Class Name

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

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

LOINC Code

Description	The unique LOINC Code.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	true
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/Business Key [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

LOINC Last Change Date

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

LOINC Last Change Type

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/Enumeration [VARCHAR(20)]
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 versus 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 Scale Type Descr

Description	The definition or description of the LOINC Scale Type.
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 Short Name

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

LOINC Species

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

LOINC System Descr

Description	Fourth major axis - type of specimen or system. For example: Serum versus 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 Status

Description	Status Code for this for the LOINC test.
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

LOINC Test Status Reason

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Long Common Name

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 Code

Description	LOINC code this code has been superseded with.
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

Method Type Descr

Description	Sixth major axis-method of measurement.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
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/Description Long [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

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 Medium [VARCHAR(255)]
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

Time Aspect Descr

Description	Third major axis - timing of the measurement frequency of the lab test. For example: Point in time versus 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 Role Name	new LOINC
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

Overview

Top

Package

Entity

Business Data Model Data Model