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 start timepe_start_tm

The specific time at which a physical examination or an individual examination component commenced. Used alongside the start date to provide precise temporal documentation of the clinical encounter, supporting accurate patient records, workflow management, and audit requirements within healthcare information systems.

physical statepe_st

The geographic state or province associated with a physical examination record, typically indicating the location where the examination was performed. Used for regulatory compliance, jurisdictional reporting, and geographic analysis of clinical data across different service delivery regions or licensed practice areas.

physical statuspe_sts

The current processing or clinical state of a physical examination record, such as pending, completed, reviewed, or amended. Tracks the lifecycle of examination documentation from initial entry through clinician sign-off, supporting workflow management and ensuring complete, accurate records within the clinical data system.

physical strengthpe_str

The assessed muscular strength or physical capacity recorded during a physical examination, typically measured using standardized grading scales such as the Medical Research Council scale. Documents a patient's neuromuscular function to identify weakness, monitor rehabilitation progress, or detect functional decline over successive clinical encounters.

physical subtotalpe_subtot

Intermediate sum of scored components within a physical examination record, representing a partial aggregate before additional findings are included in the final score. Used in clinical documentation to track cumulative assessment values across exam sections.

physical surgery datepe_surg_dt

Date on which a surgical procedure was performed, as documented within the physical examination record. Used to correlate operative history with current clinical findings, supporting continuity of care, pre- and post-operative assessment tracking, and longitudinal patient records.

physical targetpe_tgt

Reference value or clinical goal associated with a physical examination finding, such as a target measurement for a vital sign or therapeutic outcome. Used to benchmark current exam results against established clinical objectives or treatment plan milestones.

physical taxonomy codepe_tax_cd

Standardized specialty classification code associated with the clinician or service type documented in a physical examination record. Derived from NUCC taxonomy standards, this code identifies the clinical discipline under which the examination findings were recorded and reported.

physical temperaturepe_temp

Recorded body temperature measurement captured during a physical examination, expressed in Fahrenheit or Celsius. This vital sign is used to assess fever, hypothermia, or baseline metabolic status and is a standard component of patient encounter documentation in clinical settings.

physical termination datepe_term_dt

Date on which a physical examination record, associated care episode, or related clinical activity was formally closed or ended. Used in longitudinal patient records to define the endpoint of a care period and support accurate duration calculations for clinical reporting.

physical timepe_tm

Time of day at which a physical examination was conducted or a specific clinical finding was recorded. Captured to support precise event sequencing within the patient encounter, enabling accurate clinical timelines and correlation with other time-stamped care activities.

physical timestamppe_ts

Combined date and time value marking when a physical examination record was created, modified, or a specific clinical finding was documented. Used to establish an authoritative audit trail for clinical data integrity, sequencing of care events, and regulatory compliance reporting.

physical titlepe_ttl

Formal label or descriptive heading assigned to a physical examination record or specific clinical finding section. Used to organize and identify exam components within clinical documentation systems, supporting structured data retrieval and standardized reporting across care settings.

physical totalpe_tot

Aggregate sum of all scored or measured components within a physical examination record, representing the complete cumulative value across all documented findings. Used to produce composite clinical scores, support risk stratification, and enable comparison across patient encounters.

physical total countpe_tot_cnt

Total number of discrete findings, observations, or data entries recorded within a physical examination record. Used in clinical data analysis to quantify exam completeness, measure documentation volume, and support quality metrics reporting across patient populations.

physical typepe_typ

Classification category identifying the kind of physical examination performed, such as annual wellness, pre-operative, sports, or specialist evaluation. Used to differentiate exam records by purpose, supporting appropriate clinical workflows, billing categorization, and population health reporting.

physical updated datepe_upd_dt

Date on which a physical examination record was most recently modified or amended in the clinical system. Used to track data currency, support audit trail requirements, and identify records that have been revised following initial documentation or clinician review.

physical urgencype_urg

Clinical priority level assigned to a physical examination or related finding, indicating the time sensitivity required for follow-up or intervention. Used to triage patient needs, prioritize care team actions, and ensure appropriate escalation pathways are followed based on exam outcomes.

physical versionpe_ver

Sequential version number assigned to a physical examination record, incrementing each time the record is revised or updated. Used to maintain a complete revision history, ensure data integrity, and support auditing of changes made to clinical documentation over time.

physical zippe_zip

Postal ZIP code associated with the location where a physical examination was conducted or the patient's address recorded at the time of the exam. Used to support geographic analysis, population health reporting, care access studies, and regional clinical benchmarking.

PreviousPage 504 of 806Next