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

Member

Enrollment, eligibility, demographics and plan attribution

2,833 member terms

patient phonept_ph

The telephone contact number stored for a patient within EHR, member enrollment, and care management systems, including home, mobile, and work phone fields. Used by data engineers in patient outreach workflows, contact data quality assessments, and communication preference routing pipelines.

patient planpt_pln

The documented clinical treatment plan outlining a patient's care goals, interventions, medications, and follow-up actions as determined by the treating clinician. Recorded in EHR encounter notes and used to coordinate ongoing care across providers and care settings.

patient policy numberpt_pol_nbr

The unique alphanumeric identifier assigned by a health insurance payer to a patient's insurance policy or group coverage. Used in claims submission, eligibility verification, and member enrollment systems to link a patient to their specific insurance benefit plan.

patient preferred namept_pref_nm

The name by which a patient prefers to be addressed, which may differ from their legal name as recorded on insurance or identification documents. Captured in EHR demographic records to support respectful, patient-centered communication across clinical encounters.

patient previouspt_prev

A reference to the prior version of a patient record in a healthcare data system. Used in clinical data management to track historical changes to patient demographics, diagnoses, and care team assignments. Supports longitudinal patient analysis and audit trail requirements in clinical data warehouses.

patient pricept_prc

The cost amount assigned to a medical service, procedure, or item that is billable or estimated for a specific patient, factoring in applicable insurance adjustments, discounts, or self-pay rates. Used in billing and revenue cycle systems to generate patient-facing cost estimates.

patient primary indicatorpt_prim_ind

A flag designating whether a patient is the primary insured member on a health plan, as opposed to a dependent or secondary beneficiary. Used in member enrollment and claims processing to determine coordination of benefits rules and billing responsibility.

patient prioritypt_prty

An importance or urgency ranking assigned to a patient within care management, scheduling, or triage systems, indicating the order or level of clinical attention required. Data engineers use this attribute to build prioritized worklists, escalation logic, and population stratification models in healthcare platforms.

patient procedure datept_proc_dt

The calendar date on which a medical procedure, surgery, or clinical intervention was performed on the patient. Recorded on medical claims and in clinical systems to establish the service date used for billing, authorization validation, and outcomes tracking.

patient quantitypt_qty

A measured numeric quantity associated with a patient record within pharmacy and clinical systems, such as days supply, dispensed units, or dosage amounts. Used by data engineers to calculate medication utilization metrics, validate pharmacy claims data, and support PBM analytics pipelines.

patient racept_race

The racial category self-reported or recorded for a patient, based on standard classifications such as OMB categories. Captured in clinical and enrollment systems to support population health reporting, health equity analysis, and federally mandated demographic data collection.

patient rangept_rng

The defined minimum and maximum value boundaries for a patient-level clinical or operational metric, such as lab result reference ranges or dosage thresholds in EHR systems. Data engineers use this field for data validation rules, clinical alerting logic, and outlier detection in healthcare datasets.

patient ratept_rt

An applied rate value associated with a patient record within eligibility and premium billing systems, such as a premium rate, copay rate, or utilization rate. Used by data engineers to calculate patient-level cost allocations, actuarial analytics, and financial reporting in healthcare data warehouses.

patient ratingpt_rtg

A scored assessment value assigned to a patient based on clinical, behavioral, or satisfaction criteria, such as a patient-reported outcome score, satisfaction survey result, or acuity rating. Used in quality measurement and care management programs to stratify and monitor patient populations.

patient ratiopt_ratio

A calculated proportional value relating a patient-level metric to a broader benchmark or population measure, such as a nurse-to-patient staffing ratio or a patient's lab result relative to a normal reference range. Used in quality reporting and operational analytics.

patient reasonpt_rsn

A coded or descriptive reason field associated with a patient-level event in eligibility and claims systems, such as a reason for termination, denial, or referral. Used by data engineers in root cause analysis, workflow automation, and audit reporting across healthcare data platforms.

patient received datept_rcvd_dt

The date on which a patient record, referral, authorization request, or clinical document was received by a facility, department, or health plan. Used in operational workflows to measure response times, track intake processing, and monitor service level compliance.

patient referencept_ref

An external pointer or cross-system identifier linking a patient record to a related entity in EHR, claims, or interoperability systems, such as an NPI, MRN, or payer-assigned ID. Critical for data engineers performing patient identity resolution, master data management, and cross-platform record linkage in healthcare pipelines.

patient resolution datept_resol_dt

The date on which a patient's medical condition, complaint, or care issue was documented as resolved or closed. Used in clinical records and case management systems to calculate episode duration, measure treatment effectiveness, and close active care management cases.

patient resultpt_rslt

The recorded outcome of a clinical test, procedure, or assessment for a patient within EHR and laboratory information systems, such as lab values, diagnostic findings, or screening outcomes. Data engineers use this field to build clinical quality measures, longitudinal outcome tracking, and population health analytics pipelines.

PreviousPage 100 of 142Next