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

test external identifiertst_ext_id

A unique identifier assigned to a diagnostic test by an external system, reference laboratory, or interfacing application, used to cross-reference and reconcile test records across disparate healthcare platforms, laboratory information systems, and health information exchanges.

test faxtst_fax

The facsimile number associated with the ordering provider, laboratory, or facility to which diagnostic test results or reports should be transmitted. Used in result delivery workflows to route printed reports when electronic interfaces are unavailable or when regulatory or provider preference requires fax-based communication.

test feetst_fee

The charge amount associated with performing a specific diagnostic test or laboratory procedure, used in healthcare billing and revenue cycle management. Represents the cost billed to payers or patients based on fee schedules, CPT codes, or contractual rates negotiated with insurance carriers.

test first nametst_first_nm

The given or first name of the patient associated with a diagnostic test record, used to verify patient identity during specimen collection, result reporting, and record matching. Critical for preventing misidentification errors in laboratory and clinical information systems.

test flagtst_flg

Binary marker in EHR, LIS, and claims systems indicating whether a diagnostic test result is abnormal, critical, or requires follow-up. Data engineers use tst_flg to filter result sets, trigger alerts, and route records in clinical data pipelines.

test frequencytst_freq

The prescribed interval or recurrence schedule at which a diagnostic test should be repeated for a patient, such as daily, weekly, or annually. Used in care management protocols, chronic disease monitoring, and preventive screening programs to ensure timely and consistent test administration.

test full nametst_full_nm

The complete, unabbreviated name of a diagnostic test or laboratory procedure as defined in the ordering system or test catalog. Used for clinical documentation, result reporting, and display in patient records to ensure clarity and prevent confusion between similarly named or coded tests.

test gendertst_gndr

The biological sex or gender identity of the patient associated with a diagnostic test, used to apply sex-specific reference ranges for laboratory result interpretation and to support population health stratification, health equity analysis, and regulatory reporting requirements.

test glucosetst_gluc

The measured blood glucose concentration recorded as part of a diagnostic test, expressed in mg/dL or mmol/L. Used in diabetes management, metabolic disorder screening, inpatient glucose monitoring protocols, and to evaluate glycemic control against clinically established normal reference ranges.

test group numbertst_grp_nbr

The insurance group plan identifier associated with the patient at the time a diagnostic test was ordered or performed. Used in laboratory billing and claims processing to link test charges to the correct employer group health plan and ensure accurate reimbursement routing.

test hemoglobintst_hgb

The measured hemoglobin concentration in a patient's blood sample, recorded as part of a complete blood count or targeted diagnostic test. Used to assess anemia, monitor chronic conditions, evaluate surgical risk, and track treatment response across clinical care settings.

test history present illnesstst_hpi

A narrative description of the patient's current symptoms, onset, and clinical context documented at the time a diagnostic test was ordered. Provides clinical justification for test ordering, supports medical necessity determination, and is used in chart documentation and insurance authorization workflows.

test identifiertst_id

Unique alphanumeric key assigned to a diagnostic test order or result in LIS, EHR, and claims platforms. tst_id links lab orders to results, billing records, and clinical workflows, serving as the primary join key across diagnostic data tables.

test indextst_idx

Sequential or positional integer assigned to a diagnostic test within an ordered set or panel in LIS and EHR systems. tst_idx enables data engineers to maintain result ordering, support panel-level aggregations, and reconstruct test sequences during ETL processing.

test indicatortst_ind

Boolean or coded field in EHR, LIS, and claims systems that signals a specific condition about a diagnostic test, such as stat urgency, fasting requirement, or repeat status. tst_ind drives conditional logic in clinical data pipelines and reporting workflows.

test instructiontst_instr

Free-text or coded guidance stored in LIS and EHR systems specifying patient preparation, specimen collection, or handling requirements for a diagnostic test. tst_instr is parsed by data engineers to standardize pre-analytic conditions and support order management integrations.

test keytst_key

A unique surrogate or natural key value assigned to a diagnostic test record within a clinical or laboratory information system, used as the primary reference for joining related data across tables in clinical data warehouses, analytics platforms, and laboratory result reporting systems.

test labeltst_lbl

The human-readable display text assigned to a diagnostic test or laboratory examination within clinical information systems. Used to present test names consistently across order entry, results reporting, and clinical documentation, ensuring accurate identification at the point of care.

test languagetst_lang

The language in which a diagnostic test's instructions, results, or associated documentation are communicated to patients or clinicians. Supports multilingual workflows in laboratory and clinical systems, ensuring test-related materials are delivered in the patient's or provider's preferred language.

test last nametst_last_nm

Captures the surname component associated with a test-related person record, such as an ordering clinician or patient linked to a diagnostic examination. Used in laboratory and clinical data systems to support accurate person identification and result attribution workflows.

PreviousPage 723 of 806Next