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

prosthetic completed datepros_cmpl_dt

Date on which the fitting, fabrication, or delivery of a member's prosthetic device was finalized by the DME supplier or orthotist. Used in DME claims processing and care management tracking to confirm service fulfillment and trigger coverage or reimbursement milestones.

prosthetic confidential indicatorpros_conf_ind

Flag indicating that the prosthetic device record contains sensitive information requiring restricted access, such as records tied to sensitive diagnoses or vulnerable member populations. Used in DME and care management systems to enforce privacy controls and limit data visibility to authorized personnel only.

prosthetic countpros_cnt

Numeric value representing the total quantity of prosthetic devices prescribed, dispensed, or tracked for a member within a defined period. Used in DME utilization reporting and care management workflows to monitor device usage, identify duplicate orders, and support benefit limit enforcement.

prosthetic countrypros_ctry

Country associated with the delivery address, manufacturer, or supplier of a member's prosthetic device. Used in DME supply chain tracking and member enrollment records to support international coverage determinations, cross-border benefit coordination, and regulatory compliance reporting.

prosthetic created bypros_crtd_by

Username or system identifier of the individual or automated process that initially created the prosthetic device record in the healthcare data system. Used in DME management and care coordination platforms for audit trail purposes, accountability tracking, and data governance compliance.

prosthetic created datepros_crtd_dt

Calendar date on which the prosthetic device record was first entered into the healthcare data system. Used in DME management and care coordination workflows to establish a chronological audit trail, support data lineage tracking, and identify when a prosthetic need was first documented.

prosthetic created timepros_crtd_tm

Timestamp indicating the exact time a prosthetic device record was first created in the healthcare data system. Used alongside the created date in DME management and care coordination workflows to provide precise audit trail information for data governance and record sequencing purposes.

prosthetic creatininepros_cr

Creatinine lab value recorded in association with a member's prosthetic care episode, typically used to assess renal function prior to procedures or anesthesia related to prosthetic implantation or surgical fitting. Used in clinical documentation to support pre-operative screening and medical necessity determination.

prosthetic datepros_dt

General-purpose date field capturing a key calendar date associated with a prosthetic device record, such as the date of prescription, fitting, or authorization. Used in DME claims processing and care management systems when a more specific date field is not designated for the event being documented.

prosthetic datetimepros_dttm

Combined date and time value capturing a specific moment associated with a prosthetic device event, such as a fitting appointment or authorization decision. Used in DME management and care coordination systems to provide precise temporal context for clinical and administrative activities related to prosthetic care.

prosthetic dea numberpros_dea_nbr

Drug Enforcement Administration (DEA) registration number associated with a prescribing clinician involved in a prosthetic care episode, typically relevant when controlled substances are prescribed for pain management or procedural sedation during prosthetic fitting or surgery. Used in clinical and pharmacy records for prescriber verification.

prosthetic death datepros_death_dt

Date of death recorded in association with a member's prosthetic device record, used to close active prosthetic authorizations, terminate ongoing DME rentals, and update benefit eligibility status. Used in member enrollment and DME management systems to ensure accurate claims adjudication and coverage termination.

prosthetic deleted datepros_del_dt

Date on which a prosthetic device record was marked as deleted or inactivated in the healthcare data system. Used in DME management and care coordination platforms to maintain a soft-delete audit trail, support data retention compliance, and allow historical record retrieval without permanent data removal.

prosthetic deleted indicatorpros_del_ind

Boolean or coded flag indicating that a prosthetic device record has been logically removed from active use in the healthcare data system without physical deletion. Used in DME management and care coordination workflows to filter out inactive records from operational reporting while preserving them for audit and compliance purposes.

prosthetic descriptionpros_desc

Human-readable text describing the type, characteristics, or intended use of a member's prosthetic device, such as 'below-knee endoskeletal prosthesis with dynamic foot.' Used in DME claims, prior authorization requests, and care management records to communicate device details to clinicians, payers, and members.

prosthetic detailpros_dtl

Granular clinical or administrative information associated with a prosthetic device record, capturing specifics such as component specifications, socket type, suspension system, or functional level classification. Used in DME management and care coordination systems to support detailed device documentation and evidence-based prior authorization reviews.

prosthetic discharge datepros_dsch_dt

Date on which a member was discharged from an inpatient or rehabilitation facility in connection with a prosthetic fitting or implantation episode of care. Used in DME claims processing and care management workflows to coordinate post-acute prosthetic services, follow-up authorizations, and benefit transitions from facility to home care.

prosthetic due datepros_due_dt

Target date by which a prosthetic device order, authorization, fitting, or related administrative action is expected to be completed. Used in DME management and care coordination workflows to drive task prioritization, monitor timely delivery of prosthetic services, and ensure compliance with coverage authorization timelines.

prosthetic durationpros_dur

The total length of time a prosthetic device is authorized, prescribed, or actively used by a patient. Captures the approved service period in claims, prior authorization, and durable medical equipment records to support utilization review and replacement scheduling.

prosthetic emailpros_eml

The electronic mail address associated with the prosthetic device supplier, orthotist, or prosthetist responsible for fitting and maintaining the artificial limb or body part. Used in DME claims and vendor management systems to facilitate order coordination and follow-up communication.

PreviousPage 525 of 806Next