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

physical discharge datepe_dsch_dt

The date a member was formally discharged following an inpatient or observation stay during which a physical examination was conducted. Used in care transition workflows, post-discharge follow-up scheduling, and claims adjudication to establish the episode of care end boundary.

physical due datepe_due_dt

The target date by which a member's next physical examination is due based on their age, health plan benefit schedule, or clinical care plan. Used in preventive care outreach, HEDIS gap closure programs, and member engagement campaigns to prompt timely wellness visit completion.

physical durationpe_dur

The total time elapsed during a member's physical examination encounter, from start to completion. Used in clinical workflow analysis, provider productivity reporting, and encounter billing validation to ensure appropriate time-based evaluation and management coding is applied.

physical emailpe_eml

The electronic mail address associated with the member or provider contact record linked to a physical examination encounter. Used to facilitate digital communication for appointment reminders, result notifications, care gap outreach, and follow-up instructions related to the wellness visit.

physical emergency indicatorpe_emerg_ind

Flag identifying whether a physical examination was conducted under emergency circumstances. Used in clinical documentation to distinguish routine physicals from urgent evaluations, affecting triage priority, billing codes, and care coordination workflows in EHR systems.

physical end datepe_end_dt

The calendar date on which a physical examination was completed or concluded. Used in clinical scheduling and documentation systems to calculate exam duration, track provider productivity, and ensure timely completion of required periodic health assessments within care management workflows.

physical end timepe_end_tm

The clock time at which a physical examination was completed. Combined with start time to calculate total encounter duration for provider billing, resource utilization reporting, and clinical workflow analysis in scheduling and EHR documentation systems.

physical entered bype_ent_by

The username or identifier of the clinical staff member who recorded the physical examination findings into the system. Used for audit trail purposes, data quality accountability, and workflow tracking in EHR documentation and clinical data governance processes.

physical ethnicitype_ethn

The self-reported or recorded ethnic background of the patient at the time of physical examination. Used for population health analytics, health disparity reporting, and culturally competent care planning, supporting compliance with federal demographic data collection requirements in clinical systems.

physical expiration datepe_exp_dt

The date after which a completed physical examination is no longer considered current or valid for clinical, occupational, or insurance purposes. Used to trigger re-examination alerts, track compliance with periodic health screening schedules, and manage clearance validity in care management systems.

physical external identifierpe_ext_id

A reference identifier assigned by an external system, such as a referring facility or third-party platform, to uniquely identify a physical examination record. Enables cross-system matching and data reconciliation when exchanging clinical encounter data across integrated healthcare networks.

physical faxpe_fax

The facsimile number associated with the facility or provider location where a physical examination was conducted. Used for transmitting examination results, referral documentation, and records requests to external providers, insurers, or employers requiring physical examination reports.

physical feepe_fee

The charge amount billed for performing a physical examination, reflecting the applicable CPT code fee schedule or contracted rate. Used in revenue cycle management to support claims submission, patient cost estimation, and financial reporting for preventive care services.

physical first namepe_first_nm

The given first name of the patient or individual who underwent the physical examination. Used for patient identification, demographic verification, and accurate record matching within clinical documentation and health information management workflows to prevent misidentification errors.

physical flagpe_flg

A binary or coded indicator applied to a physical examination record to signal a specific condition, such as incompleteness, abnormal findings, follow-up required, or administrative hold. Used in clinical workflows to prioritize review and action by care teams or administrative staff.

physical frequencype_freq

The prescribed or recommended interval at which a patient should receive a physical examination, such as annually or every two years. Used in preventive care scheduling, care gap identification, and population health management programs to ensure adherence to clinical screening guidelines.

physical full namepe_full_nm

The complete legal name of the patient who underwent the physical examination, combining first, middle, and last name components. Used for formal documentation, insurance verification, identity matching across systems, and generation of official clinical reports or clearance letters.

physical genderpe_gndr

The gender identity or biological sex recorded for the patient at the time of a physical examination. Used to guide clinically appropriate screening recommendations, reference normal lab value ranges, and support demographic reporting in population health and quality measurement programs.

physical glucosepe_gluc

The blood glucose measurement recorded during a physical examination, typically captured as a fasting or random value in mg/dL. Used to screen for diabetes and prediabetes, monitor metabolic health trends, and inform clinical decision-making within preventive care and chronic disease management programs.

physical group numberpe_grp_nbr

The insurance group plan number associated with the patient at the time of a physical examination. Used to verify coverage eligibility, determine preventive care benefits, and route claims correctly to the appropriate payer contract during billing and revenue cycle processing.

PreviousPage 500 of 806Next