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

credit scheduled timecr_sched_tm

The specific time of day scheduled for processing a credit transaction, such as an overpayment adjustment or billing reduction. Used in healthcare revenue cycle management to coordinate timing of financial corrections applied to patient accounts or claims.

credit street addresscr_st_addr

The street-level mailing or billing address associated with a credit transaction, such as an overpayment refund or account reduction. Used in healthcare billing systems to route financial correspondence and process refund checks to the correct payer, patient, or facility address.

credit unitcr_unt

The unit of measure or individual line item associated with a credit transaction in healthcare billing, such as a single service unit being reversed or reduced. Used in revenue cycle systems to quantify the scope of overpayment adjustments applied to a claim or patient account.

ct addressct_addr

The physical facility or department address where a computed tomography scan is performed or ordered. Used in radiology information systems to identify the imaging location, support result routing, and link CT orders to the correct facility within a multi-site health network.

ct approval statusct_appr_sts

The current authorization or approval state of a computed tomography scan order, indicating whether the CT has been requested, approved, denied, or is pending review. Used in radiology workflows and prior authorization tracking to ensure payer approval before the imaging procedure is performed.

ct charge amountct_chrg_amt

The billed dollar amount associated with performing a computed tomography scan, capturing the fee charged to the patient or payer for the imaging service. Used in radiology billing and claims processing to record the gross charge before adjustments, contractual discounts, or insurance payments are applied.

ct effective datect_eff_dt

The date on which a computed tomography scan order, authorization, or associated record becomes active and clinically valid. Used in radiology information systems and prior authorization workflows to define the window during which the CT scan may be scheduled and performed under the applicable approval.

ct medical record numberct_mrn

The unique patient medical record number linked to a computed tomography scan order or result. Used in radiology information systems to associate CT imaging data with the correct patient record, ensuring accurate identification across ordering, imaging, and reporting workflows within the health system.

ct scheduled datect_sched_dt

The calendar date on which a computed tomography scan is scheduled to be performed. Used in radiology scheduling systems to manage imaging appointment slots, coordinate patient preparation instructions, and track scan completion relative to the original order date and clinical urgency.

ct scheduled timect_sched_tm

The specific time of day at which a computed tomography scan appointment is scheduled. Used in radiology department scheduling systems to allocate scanner capacity, coordinate patient arrival, and manage workflow sequencing across imaging modalities within a radiology department.

ct street addressct_st_addr

The street-level address of the facility or imaging center where a computed tomography scan is scheduled or performed. Used in radiology scheduling and patient communication systems to direct patients to the correct imaging location and support inter-facility coordination of CT services.

ct unitct_unt

The specific computed tomography scanner unit or imaging station assigned to perform a scheduled CT scan. Used in radiology department management systems to allocate equipment resources, track scanner utilization, and associate imaging results with the specific unit used during the procedure.

culture scheduled datecult_sched_dt

The calendar date on which a microbiology culture specimen collection or processing is scheduled. Used in laboratory information systems to coordinate specimen timing, ensure samples are collected within clinically appropriate windows, and track turnaround time from order to culture result reporting.

culture scheduled timecult_sched_tm

The specific time of day at which a microbiology culture specimen is scheduled for collection or laboratory processing. Used in laboratory information systems to sequence specimen handling, coordinate nursing collection workflows, and ensure time-sensitive cultures such as blood cultures are processed within required intervals.

culture unitcult_unt

The standardized measurement unit applied to microorganism growth test results in EHR and laboratory information systems (LIS). Defines how culture findings are quantified, such as colony-forming units (CFU/mL), enabling accurate interpretation and comparison of microbiology lab data across clinical systems.

customer addresscust_addr

The physical or mailing address associated with a customer entity, such as an employer group or plan sponsor, stored in payer and PBM contract management systems. Used for billing correspondence, contract documentation, and regulatory reporting, and must be validated against USPS standards for accurate data quality.

customer effectivecust_eff

The date on which a customer record, contract, or benefit configuration becomes active within a payer, PBM, or enrollment system. Critical for eligibility determination, premium billing cycles, and claims adjudication logic, ensuring that plan sponsor agreements are applied only within their valid contractual coverage periods.

data governance policy codedata_gov_pol_cd

A code identifying the specific data governance policy, classification standard, or access control framework applied to a data asset or field, used in data governance analytics to track policy coverage, measure compliance with data management standards, and enforce consistent data handling practices across a healthcare organization data warehouse and analytics environment.

data lineage identifierdata_lineage_id

A unique identifier linking a data record or dataset to its complete provenance history, including source system, extraction method, transformation logic, and load process, used in data governance and audit frameworks to trace how data moved and was transformed from origin to consumption in a healthcare analytics platform.

data quality scoredata_qual_scr

A composite numeric score reflecting the overall quality of a data asset across dimensions such as completeness, accuracy, consistency, timeliness, and uniqueness, derived from automated data quality rule execution. Data quality scores are used in data catalog platforms, data observability tools, and data governance dashboards to prioritize remediation efforts and track quality improvement over time.

PreviousPage 73 of 325Next