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

pharmacist procedure datephrm_proc_dt

Date on which a pharmacist performed a clinical service or medication-related procedure, such as a medication therapy management session or immunization. Used in pharmacy claims processing, clinical documentation, and billing to establish the date of service for pharmacist-delivered care.

pharmacist surgery datephrm_surg_dt

Date recorded by a pharmacist associated with a patient's surgical procedure, used for perioperative medication management, antibiotic stewardship, or post-surgical prescription dispensing. Referenced in pharmacy records to coordinate medication therapy with surgical care timelines.

physical active indicatorpe_actv_ind

Boolean flag indicating whether a physical examination record or finding is currently active and clinically relevant for the patient. Used in EHR problem list management and clinical documentation to distinguish current physical findings from resolved or historical examination results.

physical active statuspe_actv_sts

Categorical status value indicating the current activity state of a physical examination record, such as active, inactive, or resolved. Used in clinical data management to filter and display relevant physical assessment findings within patient records and care planning workflows.

physical admission datepe_admn_dt

The date a patient was admitted to a facility in connection with a physical examination encounter. Used in clinical and administrative systems to establish the encounter timeline, support length-of-stay calculations, and align billing records with the correct service period.

physical agepe_age

The patient's age in years at the time of a physical examination encounter. Captured in clinical records to support age-appropriate screening protocols, risk stratification, preventive care scheduling, and compliance with age-based clinical guidelines during the exam visit.

physical allowed amountpe_alwd_amt

The maximum dollar amount a payer will reimburse for a physical examination service based on the contracted fee schedule. Used in claims adjudication to determine payment after applying plan rules, network discounts, deductibles, and cost-sharing obligations.

physical amountpe_amt

The monetary value associated with a physical examination transaction, which may represent charges, payments, or adjustments. Used in billing and financial reporting systems to track the cost of preventive or diagnostic physical exam services rendered to a patient.

physical approved bype_appr_by

The identifier or name of the clinician or administrative user who authorized a physical examination record, order, or associated workflow action. Used in audit trails and clinical governance processes to ensure accountability and compliance with documentation requirements.

physical arrival timepe_arrv_tm

The recorded time a patient arrived at the clinical facility for a scheduled or walk-in physical examination. Used in operational and scheduling systems to measure patient flow efficiency, wait times, and throughput metrics for preventive care and wellness visit programs.

physical arrived datepe_arrv_dt

The calendar date on which a patient arrived at the facility for a physical examination encounter. Used alongside arrival time in scheduling and operational systems to reconcile appointments, track no-shows, and support reporting on preventive care utilization patterns.

physical assessmentpe_asmt

The clinician's documented evaluation and clinical impressions gathered during a physical examination encounter. Contains narrative or structured findings that inform diagnosis, care planning, and follow-up recommendations, and forms a core component of the medical record for the visit.

physical balancepe_bal

The remaining patient financial obligation for a physical examination after payments, adjustments, and insurance reimbursements have been applied. Used in accounts receivable and patient billing systems to track outstanding balances and generate statements for preventive care encounters.

physical billed amountpe_bill_amt

The gross charge submitted by a provider on a claim for a physical examination service before payer adjustments, contractual discounts, or patient cost-sharing are applied. Used in claims processing and revenue cycle reporting to track gross revenue and adjudication outcomes.

physical birth datepe_birth_dt

The patient's date of birth as recorded in the context of a physical examination encounter. Used to verify patient identity, calculate age at time of service, determine eligibility for age-specific screenings, and ensure accurate matching across clinical and administrative records.

physical blood pressurepe_bp

The systolic and diastolic arterial pressure measurement recorded during a physical examination, typically expressed in mmHg. A key vital sign used to assess cardiovascular health, screen for hypertension, and establish baseline clinical data for ongoing patient monitoring and care management.

physical cancelled datepe_cncl_dt

The date on which a scheduled physical examination appointment or associated service was formally cancelled. Used in scheduling, utilization, and care gap reporting systems to track missed preventive visits, support outreach workflows, and measure appointment adherence rates.

physical categorype_cat

The classification grouping assigned to a physical examination record, used to distinguish exam types such as annual wellness visits, sports physicals, or occupational health exams. Supports filtering, reporting, and workflow routing in clinical and administrative systems.

physical chief complaintpe_cc

The primary symptom, concern, or reason for visit as reported by the patient at the start of a physical examination encounter. Documented in clinical records to guide the examination focus, support diagnostic coding, and provide context for the clinician's assessment and plan.

physical childpe_chld

A subordinate or dependent record linked to a parent physical examination encounter, used in hierarchical data models to associate related sub-encounters, findings, or orders. Supports drill-down reporting and relational data structures within clinical or administrative systems.

PreviousPage 498 of 806Next