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

Operations

Scheduling, facilities, departments, workflows, and staff

6,492 operations terms

prosthetic group numberpros_grp_nbr

The insurance group identifier linked to a prosthetic device claim or authorization record. Used to associate the prosthetic service with the correct employer group health plan, enabling accurate benefits application, claims adjudication, and reporting across DME service lines.

prosthetic medical record numberpros_mrn

The unique patient medical record number associated with a prosthetic device order or service. Used to link prosthetic fittings, adjustments, and replacements to the correct patient record across DME suppliers, orthotics and prosthetics (O&P) facilities, and clinical documentation systems.

prosthetic scheduled datepros_sched_dt

The calendar date on which a prosthetic device fitting, adjustment, delivery, or follow-up appointment is planned. Used in O&P clinic scheduling systems and DME workflows to coordinate patient visits, technician availability, and timely device delivery within prescribed treatment timelines.

prosthetic scheduled timepros_sched_tm

The specific time of day at which a prosthetic device appointment, fitting, or adjustment is planned to occur. Used alongside the scheduled date in O&P clinic and DME scheduling systems to manage patient flow, technician assignments, and appointment confirmation communications.

prosthetic street addresspros_st_addr

The street-level address line associated with a prosthetic device record, such as a patient's home delivery address or the O&P fitting facility location. Used in DME order fulfillment and claims processing to direct device shipment, schedule in-home fittings, or verify service location.

prosthetic unitpros_unt

The unit of measure or individual item count associated with a prosthetic device service, such as one artificial limb, socket, or component. Used in DME claims and inventory systems to quantify billed items, support accurate reimbursement calculations, and track device utilization per patient.

protocol scheduled dateproto_sched_dt

The calendar date on which a specific clinical protocol step, treatment session, or procedural intervention is planned to be performed. Used in care management and clinical trial systems to sequence protocol-driven activities, track adherence, and ensure timely delivery of standardized treatment regimens.

protocol scheduled timeproto_sched_tm

The specific time of day at which a clinical protocol step or intervention is planned to occur. Used in clinical operations and care coordination systems to sequence time-sensitive protocol activities, manage resource allocation, and confirm appointment scheduling for standardized treatment procedures.

protocol unitproto_unt

The unit of measure associated with a clinical protocol activity, such as a single session, dose, or procedural step. Used in care management and clinical documentation systems to quantify protocol-driven services, support billing accuracy, and track patient progress through standardized treatment sequences.

provider credentialing status codeprvdr_cred_sts_cd

A code indicating the current credentialing and privileging status of a healthcare provider within a facility or health plan network, such as application received, primary source verification in progress, committee review pending, approved, conditionally approved, denied, or expired. Credentialing status determines provider eligibility to practice at a facility and bill under a payer contract.

provider productivity relative value unitsprvdr_prod_rvu

The total work relative value units generated by a provider during a defined period, calculated by summing the CMS work RVU for each CPT code billed. Provider productivity in RVUs is the standard physician compensation benchmarking metric used in medical group operations analytics to compare productivity against MGMA national percentile benchmarks and calculate incentive compensation in productivity-based payment models.

psychiatric scheduled datepsych_sched_dt

The calendar date on which a psychiatric evaluation, therapy session, or mental health intervention is planned. Used in behavioral health scheduling and EHR systems to manage patient appointments, track treatment frequency, and ensure continuity of care for individuals receiving psychiatric services.

psychiatric scheduled timepsych_sched_tm

The specific time of day at which a psychiatric appointment or mental health session is planned to occur. Used in behavioral health clinic scheduling systems to manage provider calendars, coordinate patient access, and confirm appointment timing for psychiatric evaluations, therapy, or medication management visits.

psychiatric unitpsych_unt

Measurement unit defining the quantity metric for a psychiatric service, such as therapy session hours, inpatient bed days, or medication dosage in EHR, claims, and PBM systems. Used by data engineers to normalize behavioral health service quantities across heterogeneous source systems for utilization and cost analysis pipelines.

pulmonology addresspulm_addr

The full physical address associated with a pulmonology practice, clinic, or respiratory care facility. Used in provider directory management and referral workflows to route patients to lung specialty care, support prior authorization submissions, and populate claims with accurate service location information.

pulmonology effective datepulm_eff_dt

The date on which a pulmonology service record, referral authorization, or provider contract becomes active. Used in managed care and claims systems to validate that pulmonology services, such as spirometry or bronchoscopy, fall within an approved coverage or credentialing period for the treating specialist.

pulmonology scheduled datepulm_sched_dt

The calendar date on which a pulmonology consultation, respiratory function test, or lung specialty procedure is planned. Used in referral management and clinic scheduling systems to coordinate patient access to pulmonologists, track appointment adherence, and support care transitions for chronic respiratory conditions.

pulmonology scheduled timepulm_sched_tm

The specific time of day at which a pulmonology appointment or respiratory care procedure is planned to occur. Used in specialty clinic scheduling systems to manage pulmonologist availability, coordinate diagnostic testing such as pulmonary function tests, and confirm patient appointment details for lung specialty visits.

pulmonology street addresspulm_st_addr

The street-level address line for a pulmonology clinic or respiratory specialty care facility. Used in provider directory and referral management systems to direct patients to the correct lung specialty location, populate claims with service facility details, and support network adequacy reporting for respiratory care access.

pulmonology unitpulm_unt

The discrete unit of measure associated with pulmonology specialty care services, such as per session, per test, or per treatment. Used in clinical billing and EHR systems to quantify respiratory therapy, pulmonary function testing, or bronchoscopy procedures for accurate charge capture and claims submission.

PreviousPage 179 of 325Next