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 legal nametst_legal_nm

The officially registered or legally recognized name associated with a diagnostic test or related person entity. Used in clinical and laboratory systems to ensure compliance with regulatory documentation requirements and to distinguish formal names from aliases or preferred display names.

test leveltst_lvl

Hierarchical position indicator within a diagnostic test panel or order group in LIS and EHR systems. tst_lvl identifies whether a test is a top-level order, sub-panel, or individual analyte, enabling data engineers to build accurate parent-child result hierarchies.

test license numbertst_lic_nbr

The professional licensure identifier associated with the clinician or laboratory entity authorized to order or perform a specific diagnostic test. Used in clinical and laboratory systems to validate ordering authority, support credentialing verification, and meet regulatory compliance requirements.

test marital statustst_mar_sts

The marital or domestic relationship status of a patient associated with a diagnostic test record. Captured in clinical and laboratory systems where demographic context is required for accurate patient matching, eligibility determination, or population health reporting linked to diagnostic activity.

test master identifiertst_mstr_id

The enterprise-level unique identifier assigned to a diagnostic test record across all connected healthcare systems. Used in laboratory information systems and clinical data repositories to ensure consistent cross-system identification, deduplication, and longitudinal tracking of test orders and results.

test maximumtst_max

The upper boundary value defined for a diagnostic test result, reference range, or dosage threshold. Used in laboratory and clinical decision support systems to flag results exceeding normal or safe limits, trigger alerts, and support interpretation of quantitative diagnostic measurements.

test middle nametst_mid_nm

The middle name or initial associated with a person entity linked to a diagnostic test record, such as a patient or ordering provider. Used in laboratory and clinical systems to support full-name matching, reduce patient identification errors, and improve demographic data accuracy.

test minimumtst_min

The lower boundary value defined for a diagnostic test result, reference range, or acceptable measurement threshold. Used in laboratory and clinical decision support systems to identify results falling below normal limits, trigger clinical alerts, and support quantitative result interpretation and quality control.

test mobiletst_mob

The mobile or cellular phone number associated with a patient or contact person linked to a diagnostic test record. Used in laboratory and clinical systems to facilitate result notification, appointment reminders, and direct outreach when test results require timely communication to the patient.

test modified bytst_mod_by

The unique identifier of the user or system account that last updated a diagnostic test record. Captured in laboratory and clinical audit trails to support data governance, change tracking, accountability, and compliance with healthcare data integrity and regulatory requirements.

test modified datetst_mod_dt

Timestamp recording the most recent update to a diagnostic test record in LIS, EHR, or claims systems. tst_mod_dt is critical for data engineers implementing incremental load strategies, change data capture, and audit trail reconciliation across laboratory data pipelines.

test modified timetst_mod_tm

The precise date and timestamp recording when a diagnostic test record was last updated in the clinical or laboratory system. Used in audit logging, data synchronization, and change management workflows to maintain accurate version history and support regulatory compliance requirements.

test nametst_nm

Human-readable label assigned to a diagnostic test in LIS, EHR, and claims systems, often mapped to LOINC or CPT nomenclature. tst_nm is used by data engineers for display rendering, cross-system test matching, and standardization during terminology harmonization workflows.

test notetst_nt

Unstructured or semi-structured annotation attached to a diagnostic test record in LIS and EHR systems, capturing clinician comments, collection exceptions, or interpretation caveats. tst_nt requires NLP processing by data engineers for meaningful inclusion in analytical datasets.

test numbertst_nbr

Facility-assigned or system-generated reference number for a diagnostic test in LIS, EHR, and claims platforms. tst_nbr is used by data engineers to cross-reference accession numbers, support billing reconciliation, and link test orders to result and payment records.

test onset datetst_onset_dt

The date on which symptoms or the clinical condition prompting a diagnostic test first appeared in the patient. Captured in clinical and laboratory systems to provide temporal context for test ordering decisions, support differential diagnosis, and enable accurate disease timeline reconstruction in patient records.

test oxygen saturationtst_o2sat

The measured percentage of hemoglobin in the blood that is saturated with oxygen, recorded as a vital sign associated with a diagnostic examination. Used in clinical systems to monitor respiratory status, guide oxygen therapy decisions, and track patient acuity during diagnostic or treatment episodes.

test paid amounttst_pd_amt

The total dollar amount remitted as payment for a diagnostic test, reflecting reimbursement from a payer or patient responsibility settlement. Used in healthcare claims and revenue cycle systems to reconcile test-related charges, track payment adjudication outcomes, and support financial reporting.

test paid datetst_pd_dt

The date on which payment was received or applied for a diagnostic test charge. Used in healthcare revenue cycle and claims management systems to track payment timelines, reconcile outstanding balances, calculate days in accounts receivable, and support financial audit and reporting workflows.

test parenttst_prnt

Foreign key or reference linking a diagnostic test to its parent panel, order group, or encounter in LIS and EHR systems. tst_prnt enables data engineers to reconstruct hierarchical test structures, aggregate panel-level results, and resolve rollup logic in analytical models.

PreviousPage 724 of 806Next