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 active statuschem_actv_sts

A status descriptor indicating the current operational state of a laboratory chemistry test or result record, such as active, inactive, or pending. Used in lab information systems to manage the lifecycle of chemistry orders and results within clinical and analytical reporting environments.

chemistry admission datechem_admn_dt

The date on which a patient was admitted to a healthcare facility in the context of a laboratory chemistry encounter or order. Used in clinical data systems to correlate inpatient chemistry test ordering and result timelines with hospital admission events for longitudinal care analysis.

chemistry agechem_age

The calculated age of the patient at the time a laboratory chemistry test was ordered or resulted. Used in lab and clinical data systems to support age-based reference range validation, pediatric versus adult result interpretation, and demographic stratification in population health reporting.

chemistry allowed amountchem_alwd_amt

The maximum dollar amount a payer has approved for reimbursement of a laboratory chemistry service based on the contracted fee schedule. Used in claims and revenue cycle systems to reconcile billed charges against payer adjudication decisions for chemistry-related CPT codes.

chemistry amountchem_amt

The monetary value associated with a laboratory chemistry service, representing either the charge, payment, or cost depending on context. Used in revenue cycle and claims data systems to track financial transactions tied to specific chemistry test orders, panels, or result-based billing events.

chemistry approved bychem_appr_by

The identifier or name of the clinician, supervisor, or system user who authorized or validated a laboratory chemistry test order or result. Used in lab information systems to maintain an audit trail of approval accountability for result release and clinical decision-making workflows.

chemistry arrival timechem_arrv_tm

The recorded time at which a patient or specimen arrived at the laboratory or clinical facility in association with a chemistry test order. Used in lab operations and workflow systems to measure turnaround time, track specimen processing timelines, and support quality benchmarking.

chemistry arrived datechem_arrv_dt

The calendar date on which a patient or biological specimen arrived at the laboratory or care facility linked to a chemistry test order. Used in lab information systems and clinical data warehouses to establish specimen receipt timelines and support turnaround time and quality reporting.

chemistry assessmentchem_asmt

The clinical evaluation or interpretive narrative associated with a laboratory chemistry encounter, documenting the clinician's findings and conclusions based on chemistry results. Used in EHR and clinical documentation systems to capture diagnostic reasoning and support continuity of care across encounters.

chemistry balancechem_bal

The remaining unpaid dollar amount owed on a laboratory chemistry service after payments and adjustments have been applied. Used in revenue cycle and accounts receivable systems to track outstanding balances on chemistry-related claims and patient financial responsibility for billing reconciliation.

chemistry billed amountchem_bill_amt

The total dollar amount submitted to a payer or patient for a laboratory chemistry service at the time of claim submission. Used in claims and revenue cycle systems to record the gross charge before payer adjustments, contractual discounts, or patient payments are applied to chemistry transactions.

chemistry birth datechem_birth_dt

The date of birth of the patient associated with a laboratory chemistry test record. Used in lab information systems and clinical data warehouses to verify patient identity, calculate patient age at the time of testing, and apply appropriate age-specific reference ranges for chemistry result interpretation.

chemistry blood pressurechem_bp

The systolic and diastolic arterial blood pressure measurement recorded in association with a laboratory chemistry encounter or clinical visit. Used in EHR and clinical data systems to contextualize chemistry results with concurrent vital signs, supporting cardiovascular risk assessment and chronic disease monitoring.

chemistry cancelled datechem_cncl_dt

The date on which a laboratory chemistry test order was cancelled prior to specimen collection or result reporting. Used in lab information systems and order management platforms to track cancellation events, analyze order utilization patterns, and support operational and compliance audit reporting.

chemistry categorychem_cat

A classification grouping that organizes laboratory chemistry tests into defined categories such as metabolic panels, lipid panels, or hepatic function tests. Used in lab information systems and clinical data warehouses to support test organization, order set management, and structured reporting across chemistry workflows.

chemistry chief complaintchem_cc

The primary symptom or clinical concern documented by the patient or clinician that prompted the ordering of laboratory chemistry tests during an encounter. Used in EHR and clinical data systems to link chemistry order rationale to presenting complaints for diagnostic support and utilization analysis.

chemistry childchem_chld

A subordinate or component test that is part of a parent chemistry panel or order hierarchy within a laboratory information system. Used to represent individual analytes within grouped test orders, enabling result-level tracking, billing itemization, and hierarchical reporting of chemistry panels in clinical data systems.

chemistry citychem_city

The name of the municipality associated with the patient or facility address linked to a laboratory chemistry record. Used in clinical data warehouses and lab information systems to support geographic stratification, regional utilization analysis, and demographic reporting of chemistry test populations across service areas.

chemistry classchem_cls

Categorizes a laboratory chemistry test or panel into a defined grouping such as metabolic, lipid, hepatic, or renal. Used in clinical lab systems to organize test ordering, result routing, and billing within EHR and laboratory information systems.

chemistry codechem_cd

A standardized identifier assigned to a specific laboratory chemistry test or panel, such as a LOINC or internal lab code. Enables consistent test ordering, result mapping, and cross-system interoperability within clinical and laboratory information systems.

PreviousPage 93 of 806Next