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 deleted datept_del_dt

The calendar date on which a patient record was marked as deleted or inactivated within the healthcare information system. Used in data governance and audit workflows to support soft-delete processing, record retention compliance, and historical data reconstruction across clinical and administrative systems.

patient deleted indicatorpt_del_ind

A boolean flag indicating whether a patient record has been logically removed from active use within the healthcare information system. Supports soft-delete data management practices, allowing records to be retained for audit, compliance, and historical reporting purposes without appearing in active patient workflows.

patient descriptionpt_desc

Free-text description for patient within Eligibility processes in Healthcare implementations. Used for reporting, integrations, and downstream analytics.

patient detailpt_dtl

Granular record containing demographic, clinical, or administrative attributes for an individual patient across EHR, claims, and enrollment systems. Used by data engineers to populate patient master data tables, support identity resolution, and feed downstream clinical and financial reporting.

patient discharge datept_dsch_dt

Date field marking the official hospital release of an inpatient, captured in EHR and institutional claims systems including UB-04 submissions. Used in length-of-stay calculations, DRG reimbursement validation, readmission risk modeling, and inpatient encounter analytics pipelines.

patient due datept_due_dt

The date by which a patient's financial balance, claim payment, or scheduled service is expected to be fulfilled. Used in revenue cycle management and patient billing systems to track outstanding balances, trigger collection workflows, and report on aging accounts receivable at the patient level.

patient durationpt_dur

The calculated length of time associated with a patient event, encounter, treatment episode, or enrollment period. Used in clinical and operational reporting to measure service delivery timeframes, length of stay, therapy session lengths, or continuous coverage periods within health plan and clinical data systems.

patient effectivept_eff

The date on which a patient record, care plan, or treatment authorization becomes active in a healthcare data system. Used in clinical data management to determine when care plans are valid, when treatment authorizations apply, and when patient-provider relationships become effective.

patient effective datept_eff_dt

Date from which a patient record, benefit, or care plan becomes active within EHR, member enrollment, or payer systems. Used by data engineers to manage slowly changing dimensions, eligibility lookups, coverage overlap detection, and temporal validity in analytical data models.

patient emailpt_eml

Electronic mail address for an individual patient stored in EHR demographics, member enrollment, and patient portal systems. Used in data integration for appointment reminders, care gap outreach, and patient engagement analytics; requires PII masking in non-production environments.

patient emergency indicatorpt_emerg_ind

A flag designating that a patient encounter or service was classified as an emergency at the time of care. Used in claims processing and clinical documentation to apply appropriate billing codes, override prior authorization requirements, and support reporting on emergency utilization patterns across the patient population.

patient end datept_end_dt

Date marking the conclusion of a patient record's validity period, care episode, or enrollment span in EHR and payer systems. Used by data engineers in slowly changing dimension logic, coverage gap analysis, retroactive eligibility processing, and historical record management pipelines.

patient end timept_end_tm

The timestamp recording when a patient encounter, procedure, therapy session, or clinical event concluded. Used in scheduling, clinical documentation, and operational reporting systems to calculate encounter duration, measure throughput efficiency, and support accurate billing for time-based procedural services.

patient enrollment statuspt_enrl_sts

The current state of a patient's active participation in a health plan, managed care program, or clinical registry, such as enrolled, terminated, suspended, or pending. Used in member eligibility systems to determine coverage validity at the time of service and drive downstream claims adjudication and care management workflows.

patient entered bypt_ent_by

The identifier of the staff member or system user who manually entered patient data into the healthcare information system, distinct from the record creator in automated workflows. Used in clinical data quality audits and compliance reviews to trace data entry accountability and support correction workflows.

patient ethnicitypt_ethn

The self-reported or administratively assigned ethnic background of a patient, typically coded using standardized classifications such as those defined by OMB standards. Used in population health reporting, health equity analyses, and federally mandated demographic data collection across clinical and health plan administrative systems.

patient expirationpt_exp

The date on which a patient record, care plan, or treatment authorization expires or becomes inactive in a healthcare data system. Used in clinical data management to identify expired care plans, lapsed treatment authorizations, and inactive patient-provider relationships.

patient expiration datept_exp_dt

Date after which a patient's record, authorization, or benefit coverage is no longer valid in EHR, payer, or PBM systems. Used in eligibility verification workflows, prior authorization management, claims adjudication edits, and member disenrollment tracking across healthcare data pipelines.

patient external identifierpt_ext_id

A unique identifier assigned to a patient by an external system, trading partner, or third-party platform, used to cross-reference records across disparate healthcare systems. Supports patient matching, data integration, and interoperability workflows between EHR platforms, health information exchanges, and payer systems.

patient faxpt_fax

The facsimile telephone number associated with a patient's contact record, used for transmitting medical documents, referral authorizations, and clinical correspondence. Maintained in patient demographic and administrative systems to support secure document exchange in compliance with healthcare privacy regulations.

PreviousPage 97 of 142Next