mdatool
Healthcare Data Dictionary for the Modern Data Stack
LibraryBlogPricing
mdatool
mdatool

The healthcare data dictionary for dbt, Snowflake, Databricks, and BigQuery. 100,000+ ISO-11179 standard terms, free SQL tools, and AI data modeling.

HIPAA-AlignedEnterprise Ready

Tools

  • SQL Linter
  • DDL Converter
  • Bulk Sanitizer
  • Naming Auditor
  • Name Generator
  • AI Data Modeling
  • HCC Calculator
  • Data Model Canvas

Library

  • Glossary
  • Guides
  • Blog

Company

  • About
  • Contact
  • Pricing

Account

  • Sign Up Free
  • Sign In
  • Upgrade to Pro
  • Dashboard

Legal

  • Privacy Policy
  • Terms of Service

© 2026 mdatool. All rights reserved.

Built for healthcare data teams.

Back to Glossary

Domain

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

loinc external identifierloinc_ext_id

Stores the reference identifier used by an external system, laboratory, or trading partner to represent a LOINC-mapped observation. Enables cross-system interoperability by linking the internal LOINC code assignment to identifiers used in external lab systems, HIEs, or reference laboratories.

loinc faxloinc_fax

Records the facsimile number associated with a laboratory or clinical entity linked to a LOINC code configuration record. Used when transmitting test orders, result reports, or LOINC-coded clinical documents to external laboratories, facilities, or referring providers.

loinc feeloinc_fee

Captures the service charge associated with performing or processing a LOINC-coded laboratory test or clinical observation. Used in revenue cycle and laboratory billing workflows to link standardized observation codes to their corresponding cost or reimbursement amounts.

loinc first nameloinc_first_nm

Stores the given name of an individual associated with a patient-level LOINC observation record, such as the ordering clinician or the patient. Used to support display, search, and reporting functions within clinical data systems that contextualize LOINC-coded results to specific individuals.

loinc flagloinc_flg

A binary or categorical marker applied to a LOINC-coded observation record to indicate a specific clinical or administrative condition, such as an abnormal result, a critical value, or a data quality issue requiring review or follow-up action in clinical workflows.

loinc frequencyloinc_freq

Specifies how often a LOINC-coded laboratory test or clinical observation is scheduled to be performed or reported, such as daily, weekly, or per encounter. Used in standing order management and longitudinal monitoring protocols within clinical care and chronic disease management programs.

loinc full nameloinc_full_nm

Contains the complete descriptive name of a LOINC code, combining the component, property, timing, system, scale, and method attributes into a human-readable label. Used to display standardized observation identifiers in clinical interfaces, reports, and laboratory result documentation.

loinc genderloinc_gndr

Records the biological sex or gender classification associated with a patient-level LOINC observation record. Used to apply gender-specific reference ranges for laboratory results and to support demographic stratification in clinical analytics and population health reporting.

loinc glucoseloinc_gluc

Stores the measured blood glucose value captured under a standardized LOINC code for glucose observations, such as LOINC 2339-0. Used in diabetes management, metabolic panels, and clinical decision support systems to track and trend patient blood sugar levels over time.

loinc group numberloinc_grp_nbr

Identifies the insurance group or benefit plan number associated with a patient record linked to a LOINC observation. Used to connect laboratory and clinical results data to the appropriate payer plan for billing, prior authorization, and population health analytics across member groups.

loinc hemoglobinloinc_hgb

Records the hemoglobin concentration value associated with a LOINC-coded blood test observation, such as LOINC 718-7. Used in hematology panels and chronic disease monitoring, including anemia management and diabetes care where HbA1c values are tracked longitudinally.

loinc history present illnessloinc_hpi

Captures the clinical narrative describing a patient's current condition as documented under a LOINC-coded HPI section of a clinical note. Used in structured clinical documentation to standardize the recording of symptom onset, duration, and progression within EHR encounter records.

loinc identifierloinc_id

The unique numeric code assigned by the Regenstrief Institute to a specific laboratory test, clinical observation, or measurement within the LOINC standard. Serves as the primary key for linking clinical results data across EHR systems, laboratories, and health information exchanges.

loinc indexloinc_idx

Represents the positional or sequential order of a LOINC-coded observation within a result panel, order set, or clinical document section. Used to control the display sequence of multiple related laboratory or clinical observations in reporting interfaces and structured data outputs.

loinc indicatorloinc_ind

A boolean or coded flag that signals a specific condition or status associated with a LOINC observation record, such as whether a result is final, preliminary, corrected, or meets a clinical alert threshold. Used in result management workflows and clinical decision support logic.

loinc instructionloinc_instr

Contains guidance text associated with a LOINC-coded test or observation, such as patient preparation requirements, specimen collection instructions, or result interpretation notes. Used by laboratory and clinical staff to ensure accurate test ordering and specimen handling procedures are followed.

loinc keyloinc_key

The primary lookup reference value used to uniquely identify a LOINC entry in clinical data systems. Serves as the indexed key for retrieving standardized laboratory and clinical observation codes across lab results, diagnostic reporting, and interoperability exchanges.

loinc labelloinc_lbl

The human-readable display text associated with a specific LOINC code, used to present standardized clinical observation names in laboratory reports, clinical interfaces, and health information exchanges where coded values must be rendered intelligibly for clinical users.

loinc languageloinc_lang

The language designation associated with a LOINC code entry, indicating the linguistic locale used for display names and descriptions. Supports multilingual clinical environments where lab results and observation labels must be rendered in the preferred language of the clinical user or patient.

loinc last nameloinc_last_nm

Likely a misapplied or repurposed field storing a surname-style text component within a LOINC reference table. In clinical data contexts, this may capture a component part of a LOINC long common name or panel descriptor used in observation identification and reporting.

PreviousPage 366 of 806Next