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 revisiontst_rev

A sequential version or iteration number indicating that a diagnostic test record, result, or associated documentation has been updated or amended. Used in clinical data systems to maintain audit trails and ensure the most current test information is applied in clinical workflows.

test risktst_rsk

A coded or scored assessment of the clinical risk level associated with a diagnostic test, including patient risk factors or potential adverse outcomes. Used in clinical data systems to stratify patients, guide pre-authorization decisions, and inform care management interventions.

test routetst_rte

The administration pathway used when conducting a diagnostic test that involves introducing a substance into the body, such as intravenous, oral, or intradermal. Used in clinical and pharmacy data systems to ensure correct test execution and support adverse event monitoring.

test scoretst_scr

Numeric or alphanumeric rating assigned to a diagnostic examination result in EHR, lab, or clinical assessment systems. Used by data engineers to normalize scoring scales across instruments like PHQ-9, GAD-7, or APGAR in analytics pipelines.

test sequencetst_seq

Ordinal position assigned to a diagnostic examination within a series of related tests in EHR or laboratory information systems. Critical for data engineers ordering repeated lab draws, panels, or serial diagnostic results chronologically in clinical data workflows.

test severitytst_sev

Coded classification of condition seriousness associated with a diagnostic examination result in EHR, lab, or clinical decision support systems. Used by data engineers to stratify patient risk, trigger alerts, or route results to appropriate clinical workflows.

test sextst_sex

The biological sex of the patient associated with a diagnostic test record, typically coded as male, female, or unknown. Used in clinical data systems to apply sex-specific reference ranges for result interpretation, support demographic analysis, and meet regulatory reporting standards.

test sourcetst_src

Identifier indicating the originating system, facility, or specimen collection point for a diagnostic examination in EHR or laboratory information systems. Data engineers use this field to trace data provenance, resolve duplicates, and manage multi-source lab feed integrations.

test start datetst_start_dt

Calendar date marking the initiation of a diagnostic examination in EHR, laboratory, or radiology systems. Data engineers rely on this field to calculate turnaround times, sequence longitudinal test events, and enforce date-range filters in clinical reporting pipelines.

test start timetst_start_tm

The precise time of day at which a diagnostic test or clinical procedure was initiated. Used in laboratory and clinical data systems to sequence testing events, calculate procedure duration, measure turnaround times, and ensure accurate temporal documentation in patient records.

test statetst_st

The U.S. state or territory associated with the location where a diagnostic test was administered or the patient's address of record at the time of testing. Used in clinical and public health data systems for geographic reporting, licensure compliance, and epidemiological surveillance.

test statustst_sts

Coded value representing the current processing state of a diagnostic examination, such as ordered, in-progress, resulted, or cancelled, within EHR and lab systems. Data engineers use this field to filter incomplete records and track workflow completion in data pipelines.

test strengthtst_str

The concentration or dosage strength of a diagnostic agent, contrast medium, or reagent administered during a diagnostic test procedure. Used in clinical and pharmacy data systems to ensure correct dosing, support adverse event reporting, and maintain accurate test administration records.

test subtotaltst_subtot

An intermediate sum of charges, units, or values associated with a subset of diagnostic test components or line items before final totals are calculated. Used in billing and clinical data systems to itemize test-related costs and support claim adjudication and financial reporting.

test surgery datetst_surg_dt

The calendar date on which a surgical procedure associated with or preceding a diagnostic test was performed. Used in clinical data systems to establish the temporal relationship between operative interventions and subsequent diagnostic testing for care coordination and outcomes analysis.

test targettst_tgt

Reference identifier designating the intended destination system, analyte, or anatomical site for a diagnostic examination in EHR or laboratory information systems. Data engineers use this field to route results correctly and validate test-to-target mappings in integration workflows.

test taxonomy codetst_tax_cd

A standardized classification code identifying the specialty or type of clinical service associated with a diagnostic test. Used in claims and enrollment data systems to categorize test services by clinical discipline, supporting network management, reimbursement routing, and regulatory reporting.

test temperaturetst_temp

The patient's body temperature, typically measured in degrees Fahrenheit or Celsius, recorded at the time of a diagnostic test or clinical examination. Captured as a vital sign in clinical data systems to assess patient condition, detect fever, and monitor physiological status during testing.

test termination datetst_term_dt

The calendar date on which a diagnostic test protocol, testing episode, or associated clinical order was formally discontinued or ended. Used in clinical data systems to close active test records, calculate testing duration, and support audit reporting on test lifecycle management.

test timetst_tm

Time-of-day value capturing when a diagnostic examination was performed or specimens were collected in EHR and laboratory information systems. Data engineers use this field for sub-daily sequencing, shift-based reporting, and turnaround time calculations in clinical analytics.

PreviousPage 726 of 806Next