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 citype_city

The name of the municipality associated with a physical examination record, typically reflecting the patient's residential address or the facility location where the exam was performed. Used in population health analytics, geographic reporting, and care access assessments.

physical classpe_cls

The classification tier assigned to a physical examination, such as comprehensive, limited, or preventive, based on the scope and complexity of the exam performed. Used for appropriate CPT coding, reimbursement categorization, and utilization reporting across clinical programs.

physical codepe_cd

The standardized alphanumeric identifier assigned to a physical examination service, procedure, or finding, such as a CPT or SNOMED code. Used across clinical, billing, and data systems to ensure consistent identification, claims submission, and interoperability of physical exam records.

physical commentpe_cmt

Free-text notation entered by a clinician or administrative user in relation to a physical examination record. Used to capture supplemental observations, clarifications, or context that does not fit structured data fields, supporting complete documentation and communication across care team members.

physical completed datepe_cmpl_dt

The date on which a member's physical examination was fully completed and documented in the clinical record. Used in care management and preventive health tracking to monitor compliance with annual wellness visit requirements and close gaps in care.

physical confidential indicatorpe_conf_ind

A flag designating whether a member's physical examination record contains sensitive or restricted clinical findings requiring elevated privacy protections. Controls access to the examination results within EHR and care management systems in accordance with HIPAA privacy rules.

physical countpe_cnt

The total number of physical examinations documented for a member within a defined period. Used in preventive care analytics and population health reporting to assess utilization patterns, identify members with multiple wellness visits, and support quality measure calculations.

physical countrype_ctry

The country in which a member's physical examination was conducted or where the examining facility is located. Supports international care coordination and is used in member enrollment and claims processing when services are rendered outside the member's home country.

physical created bype_crtd_by

The system username or clinician identifier of the individual who initially entered the physical examination record into the clinical or care management system. Used for audit trail purposes and to attribute data entry responsibility within EHR and health information systems.

physical created datepe_crtd_dt

The calendar date on which the physical examination record was first entered into the clinical or care management system. Used for data integrity auditing, record lifecycle tracking, and distinguishing between the date of service and the date of documentation entry.

physical created timepe_crtd_tm

The exact time at which the physical examination record was initially created in the clinical or care management system. Combined with the created date to provide a precise timestamp for audit trail purposes and to support workflow sequencing in high-volume clinical environments.

physical creatininepe_cr

The serum or urine creatinine measurement captured during a member's physical examination, used as a key biomarker for assessing kidney function. Elevated levels may indicate chronic kidney disease and are used to trigger clinical follow-up, care management outreach, and quality measure reporting.

physical datepe_dt

The calendar date on which a member's physical examination was performed by a licensed clinician. Used in preventive care gap analysis, HEDIS measure calculations, and member outreach programs to determine whether wellness visit requirements have been met within a measurement year.

physical datetimepe_dttm

The combined date and time value recording when a member's physical examination occurred or was documented in the clinical system. Provides a precise timestamp used in clinical workflow sequencing, audit logging, and time-sensitive care coordination activities.

physical dea numberpe_dea_nbr

The Drug Enforcement Administration registration number associated with a provider who conducted a physical examination and may prescribe controlled substances. Used to validate prescribing authority during physical encounters and to support controlled substance monitoring program compliance.

physical death datepe_death_dt

The recorded date of death for a member whose physical examination record exists in the system. Used to terminate active care plans, close open quality measure gaps, update enrollment status, and ensure deceased members are excluded from future outreach and wellness campaigns.

physical deleted datepe_del_dt

The date on which a physical examination record was marked as deleted or voided within the clinical or care management system. Used in data governance and audit processes to track record lifecycle events and maintain a complete history of documentation changes.

physical deleted indicatorpe_del_ind

A binary flag indicating whether a physical examination record has been logically removed or voided from active clinical data without permanent deletion. Used in data reconciliation and quality reporting to exclude invalid records while retaining the audit history of all documented examinations.

physical descriptionpe_desc

A free-text or structured narrative field capturing the clinician's summary observations and findings from a member's physical examination. Used in clinical documentation to communicate overall health status, support care coordination handoffs, and provide context for coded diagnoses and orders.

physical detailpe_dtl

Granular clinical information recorded at the component level of a physical examination, such as individual body system findings, vital sign observations, or specific test results. Used to support detailed clinical documentation, coding accuracy, and structured data extraction for quality reporting.

PreviousPage 499 of 806Next