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

result emergency indicatorrslt_emerg_ind

A flag designating a clinical test result as critical or emergent, triggering priority notification workflows to ordering providers and care teams when values fall outside safe thresholds requiring immediate clinical intervention in laboratory or EHR systems.

result end daterslt_end_dt

The date marking the conclusion of a test or procedure outcome's active period in EHR, LIS, and claims systems. Data engineers use this field to define record validity windows, support SCD Type 2 logic, and filter out expired result records in downstream reporting pipelines.

result end timerslt_end_tm

The timestamp marking the completion of a clinical test, procedure, or observation period associated with a diagnostic result, used in laboratory and clinical systems to calculate turnaround time, validate result sequencing, and support workflow performance reporting.

result entered byrslt_ent_by

The identifier of the user, clinician, or system that manually entered or submitted a clinical test result into the health information system, supporting accountability, audit trail documentation, and data quality review in laboratory and clinical workflows.

result ethnicityrslt_ethn

The ethnicity of the patient associated with a clinical test result, used in population health analytics, clinical research, and quality reporting to identify health disparities, benchmark outcomes across demographic groups, and support equity-focused care initiatives.

result expiration daterslt_exp_dt

The date after which a test or procedure outcome is considered invalid or superseded in EHR and laboratory systems. Data engineers use this field to exclude stale records from active datasets, enforce data freshness rules, and support time-bound clinical decision support logic.

result external identifierrslt_ext_id

A unique identifier assigned by an external system, reference laboratory, or trading partner to a clinical test result, enabling cross-system reconciliation and traceability when results are exchanged between EHR platforms, HIEs, or third-party diagnostic systems.

result faxrslt_fax

The facsimile number used to transmit a clinical test result to an ordering provider, specialist, or care facility, recorded in laboratory and health information systems to document the result delivery method and recipient contact information for communication auditing.

result feerslt_fee

The charge amount billed for performing and reporting a clinical test or diagnostic service, recorded in revenue cycle and claims systems to support cost accounting, reimbursement processing, and financial reconciliation of laboratory or ancillary service transactions.

result first namerslt_first_nm

The first name of the patient associated with a clinical test result, used to confirm patient identity during result routing, reporting, and reconciliation processes within laboratory information systems and clinical data management workflows.

result flagrslt_flg

The binary or categorical marker indicating a notable condition of a test or procedure outcome in EHR and LIS systems, such as high, low, or critical values. Data engineers use this field to trigger alerting logic, filter abnormal results, and drive quality reporting workflows.

result frequencyrslt_freq

The scheduled or observed frequency at which a clinical test or diagnostic measurement is performed or repeated for a patient, used in care management and chronic disease monitoring to track adherence to testing protocols and longitudinal result trend analysis.

result full namerslt_full_nm

The complete legal name of the patient associated with a clinical test result, used for patient identity verification during result release, report generation, and cross-system matching in laboratory, EHR, and health information exchange environments.

result genderrslt_gndr

The biological sex or gender identity of the patient associated with a clinical test result, used to apply sex-specific reference ranges, support demographic reporting, and enable population health stratification across laboratory and clinical analytics systems.

result glucoserslt_gluc

The measured blood glucose concentration value from a clinical laboratory or point-of-care test, recorded in mg/dL or mmol/L, used for diabetes monitoring, metabolic panel interpretation, and critical value alerting in EHR and laboratory information systems.

result group numberrslt_grp_nbr

The insurance group plan number associated with the patient at the time a clinical test result was generated, used to link diagnostic results to the applicable benefit plan for claims adjudication, coverage verification, and member benefits reporting.

result hemoglobinrslt_hgb

The measured hemoglobin concentration in a patient blood sample, expressed in g/dL, used to assess anemia, monitor chronic conditions such as kidney disease or sickle cell disorder, and evaluate treatment response in laboratory and clinical management systems.

result history present illnessrslt_hpi

Narrative description of the patient's current condition or complaint associated with a diagnostic test result, capturing the clinical context and symptom history that prompted the ordered test, used to support result interpretation in EHR and clinical data systems.

result identifierrslt_id

The unique primary key value assigned to a test or procedure outcome record in EHR, LIS, and claims systems. Data engineers rely on this field for deduplication, record linkage across source systems, and maintaining referential integrity in clinical data warehouses and analytics platforms.

result indexrslt_idx

The positional sequence number assigned to a test or procedure outcome within an ordered set in EHR and LIS systems. Data engineers use this field to preserve ordering of multi-component results, support panel-level aggregations, and reconstruct result sequences in downstream data models.

PreviousPage 577 of 806Next