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

chemistry commentchem_cmt

Free-text notation entered by laboratory staff or clinicians regarding a specific chemistry test or result. May include collection notes, specimen quality observations, critical value notifications, or interpretive remarks recorded in laboratory information systems.

chemistry completed datechem_cmpl_dt

The calendar date on which a laboratory chemistry test or panel was fully analyzed and results were finalized. Used in laboratory information systems to track turnaround time, result availability, and compliance with testing timeliness standards.

chemistry confidential indicatorchem_conf_ind

A flag designating that a laboratory chemistry result requires restricted access due to sensitivity, such as toxicology screens or substance abuse panels. Controls result visibility in clinical systems to comply with patient privacy regulations including HIPAA and 42 CFR Part 2.

chemistry countchem_cnt

The total number of chemistry tests or panels ordered, resulted, or associated with a specific encounter, patient, or time period. Used in laboratory reporting and analytics to measure test volume, monitor utilization trends, and support operational planning.

chemistry countrychem_ctry

The country associated with a laboratory chemistry record, such as the location where a specimen was collected or analyzed. Relevant in international health systems, reference laboratory networks, or global clinical trial data management contexts.

chemistry created bychem_crtd_by

The unique identifier of the user, system, or interface that initially created a laboratory chemistry record. Used for audit trail purposes in laboratory information systems to support data integrity review and regulatory compliance tracking.

chemistry created datechem_crtd_dt

The calendar date on which a laboratory chemistry record was first entered or generated in the system. Used in laboratory information systems for audit trail tracking, record lifecycle management, and data governance compliance monitoring.

chemistry created timechem_crtd_tm

The timestamp at which a laboratory chemistry record was first entered or generated in the system. Combined with the created date, provides precise audit trail documentation for laboratory information systems and regulatory compliance reporting.

chemistry creatininechem_cr

The measured serum or urine creatinine value from a laboratory chemistry panel, used as a primary biomarker for assessing renal function. Reported in mg/dL and used clinically to calculate eGFR, monitor chronic kidney disease progression, and adjust medication dosing.

chemistry datechem_dt

The calendar date associated with a laboratory chemistry test event, which may represent the collection, processing, or result date depending on context. Used in clinical and laboratory systems to sequence results, track trends, and correlate findings with clinical encounters.

chemistry datetimechem_dttm

The combined date and time value associated with a laboratory chemistry test event, providing precise temporal context for specimen collection, processing, or result release. Used in laboratory systems for result sequencing, critical value tracking, and clinical decision support.

chemistry dea numberchem_dea_nbr

The Drug Enforcement Administration registration number associated with a chemistry-related controlled substance order or test. Used in laboratory and pharmacy systems to document regulatory authorization when ordering or processing controlled substance screening panels.

chemistry death datechem_death_dt

The recorded date of patient death as captured within a laboratory chemistry record context, used to close active orders, suppress pending results, and update patient status in laboratory information systems following a patient mortality event.

chemistry deleted datechem_del_dt

The calendar date on which a laboratory chemistry record was marked as deleted or voided in the system. Used in laboratory information systems to maintain audit trail integrity, support data reconciliation, and track record lifecycle management activities.

chemistry deleted indicatorchem_del_ind

A flag identifying that a laboratory chemistry record has been voided, cancelled, or logically removed from active use. Enables laboratory information systems to retain historical data for audit purposes while excluding removed records from active reporting and clinical workflows.

chemistry descriptionchem_desc

The human-readable name or narrative explanation of a laboratory chemistry test or panel, such as 'Comprehensive Metabolic Panel' or 'Serum Glucose.' Displayed in clinical interfaces, laboratory reports, and patient-facing documents to communicate test identity clearly.

chemistry detailchem_dtl

Granular information associated with a specific laboratory chemistry test or result, including methodology, reference ranges, specimen requirements, or individual component values. Used in laboratory information systems to provide complete clinical context for result interpretation.

chemistry discharge datechem_dsch_dt

The date a patient was discharged from an inpatient or outpatient facility, recorded in association with a laboratory chemistry result. Used to correlate chemistry findings with the inpatient stay, support discharge planning, and enable post-discharge result follow-up workflows.

chemistry due datechem_due_dt

The deadline by which a chemistry lab panel or test must be completed or resulted. Used in laboratory information systems to prioritize pending orders, trigger alerts for overdue specimens, and ensure timely reporting of clinical chemistry results to ordering providers.

chemistry durationchem_dur

The total elapsed time between the initiation and completion of a chemistry laboratory test or panel. Tracked in LIS and clinical data warehouses to monitor lab turnaround performance, identify processing bottlenecks, and support quality metrics for chemistry testing workflows.

PreviousPage 94 of 806Next