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 created timetst_crtd_tm

The precise timestamp recording when a diagnostic test order or record was first entered into the clinical or laboratory information system. Used to establish the beginning of the test lifecycle, calculate order-to-collection turnaround intervals, and support audit trail integrity for regulatory and quality reporting purposes.

test creatininetst_cr

The measured serum or urine creatinine level recorded during a diagnostic examination, used as a key biomarker for assessing renal function and glomerular filtration rate. Used in clinical data systems to monitor kidney disease progression, guide medication dosing decisions, and flag patients requiring nephrology intervention or care management.

test datetst_dt

Calendar date associated with a diagnostic test event or record in EHR, lab, or claims systems. Data engineers use this field to filter records by service period, validate temporal logic in claims adjudication, and align test data with enrollment or eligibility timelines in healthcare pipelines.

test datetimetst_dttm

Combined date and time timestamp associated with a diagnostic test event in EHR, LIS, or claims systems. Data engineers use this field for precise temporal ordering, latency measurement, event sequencing, and time-based joins across healthcare data integration and analytics pipelines.

test dea numbertst_dea_nbr

The Drug Enforcement Administration registration number associated with the prescriber or facility linked to a diagnostic test involving controlled substances, such as toxicology or substance monitoring tests. Used in clinical and pharmacy systems to verify prescriber authorization and maintain regulatory compliance with controlled substance monitoring programs.

test death datetst_death_dt

Date of death field associated with a diagnostic test or patient entity in EHR or member enrollment systems. Data engineers use this to enforce enrollment termination logic, suppress post-death records, and validate mortality data across claims, eligibility, and population health datasets.

test deleted datetst_del_dt

The date a diagnostic test order or result record was marked as deleted within a clinical or laboratory information system. Used in audit trails to track when erroneous, duplicate, or cancelled test records were removed, supporting data integrity and compliance reporting.

test deleted indicatortst_del_ind

A binary or coded flag indicating whether a diagnostic test order or result record has been logically deleted from a clinical or laboratory information system. Enables systems to retain deleted records for audit purposes while excluding them from active clinical workflows and reporting queries.

test descriptiontst_desc

Textual explanation field describing a diagnostic test record in EHR, lab, or claims systems. Data engineers use this field to support search indexing, populate display labels in reporting tools, and validate that description values align with associated test codes across healthcare data pipelines.

test detailtst_dtl

Granular information field containing specific attributes of a diagnostic test record in EHR, lab, or claims systems. Data engineers use this field to capture line-level test specifics, support detailed reporting requirements, and ensure completeness of test data within healthcare data integration workflows.

test discharge datetst_dsch_dt

Hospital release date associated with a diagnostic test or inpatient encounter record in EHR or claims systems. Data engineers use this field to calculate length of stay, validate claim date ranges, and support episode-of-care grouping logic in acute care healthcare data pipelines.

test due datetst_due_dt

The date by which a scheduled diagnostic test or screening procedure is expected to be completed for a patient. Used in preventive care management, chronic disease monitoring, and care gap identification to ensure timely completion of clinically ordered or protocol-driven testing.

test durationtst_dur

The total elapsed time required to perform or administer a diagnostic test or procedure, measured from initiation to completion. Used in laboratory and radiology workflow management to assess resource utilization, schedule appointments, and benchmark operational efficiency across testing procedures.

test emailtst_eml

Electronic mail address field associated with a diagnostic test entity or related contact in healthcare data systems such as EHR or provider directories. Data engineers use this field to support communication workflows, validate contact data formats, and enable patient or provider outreach integrations.

test emergency indicatortst_emerg_ind

A flag designating that a diagnostic test has been ordered on an urgent or STAT basis, requiring expedited processing and turnaround. Used in laboratory and clinical workflows to prioritize specimen handling, instrument queuing, and result reporting for time-critical patient care decisions.

test end datetst_end_dt

Completion date associated with a diagnostic test record or related period in EHR, claims, or lab systems. Data engineers use this field to define record validity windows, support date-range filtering, and validate that end dates are logically consistent with corresponding start dates in healthcare pipelines.

test end timetst_end_tm

The timestamp recording when a diagnostic test or procedure was completed or when specimen analysis concluded in a laboratory or diagnostic setting. Used to calculate turnaround times, measure laboratory performance, and support clinical documentation of procedure timing in patient records.

test entered bytst_ent_by

The identifier or username of the clinical staff member, technician, or system user who entered a diagnostic test order or result into the laboratory or clinical information system. Used for accountability tracking, audit logging, and quality control reviews of data entry accuracy.

test ethnicitytst_ethn

The self-reported or recorded ethnicity of the patient associated with a diagnostic test, captured to support population health analytics, health equity reporting, and identification of disparities in testing rates or outcomes across ethnic groups in compliance with regulatory requirements.

test expiration datetst_exp_dt

Validity end date indicating when a diagnostic test record, authorization, or related artifact expires in healthcare data systems such as EHR, PBM, or claims platforms. Data engineers use this to enforce expiration logic, filter stale records, and support prior authorization tracking workflows.

PreviousPage 722 of 806Next