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

capacity updated datecap_upd_dt

The most recent date on which a facility or service capacity limit was modified in the system. Used in facility management and scheduling systems to audit changes to bed counts, appointment slots, or other capacity constraints over time.

capacity urgencycap_urg

The time-sensitivity classification assigned to a capacity limit or constraint, indicating how quickly the capacity issue must be addressed. Used in facility operations to prioritize resource allocation decisions during high-demand or emergency situations.

capacity utilization ratecap_utilztn_rt

The percentage of available facility capacity, such as licensed beds, operating rooms, or clinic appointment slots, that is occupied or scheduled during a defined period. Capacity utilization rates are a primary metric in healthcare operations analytics used for staffing optimization, capital planning, and identifying facilities or units operating above safe capacity thresholds.

capacity versioncap_ver

The sequential version number assigned to a capacity record each time it is updated, enabling historical tracking of capacity limit changes. Used in facility management systems to maintain a complete audit trail of capacity modifications over time.

capacity zipcap_zip

The five or nine-digit postal code associated with the physical location of a facility or service site where a capacity limit applies. Used in facility management and network planning systems to geographically identify and report on capacity constraints by location.

cardiology addresscard_addr

Physical location data element (card_addr) stored in provider master files, EHR practice management systems, and claims databases to capture the street address of cardiology specialty practices. Used in provider directory maintenance, network adequacy reporting, referral routing workflows, and care coordination systems for cardiovascular specialty services.

cardiology effective datecard_eff_dt

Identifies the date on which a cardiology-related record, authorization, contract term, or provider designation becomes active within EHR, payer, or provider management systems. Used in temporal filtering logic during ETL processing to ensure only currently valid cardiology data is surfaced in operational and analytical reporting.

cardiology scheduled datecard_sched_dt

The calendar date on which a cardiology appointment or cardiac procedure is planned to occur. Used in cardiology scheduling systems to coordinate patient access to heart specialty services including consultations, stress tests, echocardiograms, and interventional procedures.

cardiology scheduled timecard_sched_tm

The specific clock time at which a cardiology appointment or cardiac procedure is planned to begin. Used in cardiology scheduling systems alongside the scheduled date to manage patient flow, staff assignments, and equipment availability for cardiac care services.

cardiology street addresscard_st_addr

The physical street address of the cardiology practice, clinic, or hospital department where cardiac care services are delivered. Used in provider directories, referral management, and patient scheduling systems to direct patients to the correct cardiology service location.

cardiology unitcard_unt

The unit of measure applied to a cardiology clinical observation, test result, or service quantity as recorded in EHR, laboratory, or claims systems, such as beats per minute, mL/min, or mmHg. Data engineers use this field to normalize cardiac measurement data for cross-system aggregation and clinical analytics.

care coordinator identifiercare_coord_id

A unique identifier for the care coordinator assigned to manage transitions and coordinate services for a patient across the care continuum, used to link coordination activities, patient outreach records, and outcomes data to the responsible staff member for performance evaluation, caseload management, and care coordination program analytics.

care gap closure ratecare_gap_clsr_rt

The percentage of identified quality care gaps that were successfully closed through completion of recommended preventive services, chronic disease monitoring, or follow-up visits during a defined measurement period, used in quality improvement analytics and value-based care performance reporting to track progress toward quality metric targets.

care transition type codecare_trans_type_cd

A code classifying the specific type of care transition a patient undergoes, such as hospital to home, hospital to skilled nursing facility, emergency department to observation, or primary care to specialist, used in care coordination analytics to measure transition quality, identify high-risk transition patterns, and track post-transition follow-up completion rates.

carrier addresscarr_addr

The physical mailing or business address of the insurance carrier responsible for processing claims and managing member benefits. Used in claims adjudication, provider contracting, and enrollment systems to route correspondence, remittances, and contractual communications to the correct carrier location.

carrier effective datecarr_eff_dt

The date on which an insurance carrier's contract, agreement, or participation status becomes active and enforceable. Used in claims processing and member enrollment systems to validate coverage eligibility, apply correct reimbursement rates, and determine applicable benefit structures.

carrier scheduled datecarr_sched_dt

The calendar date on which a scheduled interaction, submission, or transaction with an insurance carrier is planned to occur. Used in claims management and payer relations systems to track submission deadlines, contract review dates, or scheduled EDI transaction exchanges with carrier partners.

carrier scheduled timecarr_sched_tm

The specific clock time associated with a planned interaction or transaction with an insurance carrier. Used alongside the carrier scheduled date in payer relations and claims management systems to coordinate time-sensitive submissions, eligibility checks, or contractual communications.

carrier street addresscarr_st_addr

The physical street address of an insurance carrier's office or headquarters used for claims correspondence, contract negotiations, and regulatory filings. Used in provider contracting and claims systems to ensure accurate routing of paper claims, appeals, and formal communications to the correct carrier location.

carrier unitcarr_unt

The specific business unit, division, or subsidiary of an insurance carrier responsible for administering a particular line of coverage or product. Used in claims processing and enrollment systems to route transactions to the correct internal carrier department handling medical, dental, vision, or specialty benefits.

PreviousPage 53 of 325Next