mdatool
LibraryBlogPricing
mdatool
mdatool

Healthcare data architecture platform for data engineers, architects, and analysts building modern health systems.

HIPAA-AlignedEnterprise Ready

Tools

  • SQL Linter
  • DDL Converter
  • Bulk Sanitizer
  • Naming Auditor
  • Name Generator
  • AI Data Modeling
  • HCC Calculator

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 engineers & architects.

Back to Glossary

Domain

Operations

Scheduling, facilities, departments, workflows, and staff

6,387 operations terms

ct scheduled timect_sched_tm

The planned time for a computed tomography scan. Used to track temporal information related to ct scheduled time. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for ct management and reporting.

ct street addressct_st_addr

The street location for a computed tomography scan. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for ct management and reporting.

ct unitct_unt

The single item or measure for a computed tomography scan. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for ct management and reporting.

culture scheduled datecult_sched_dt

The planned appointment date for a microorganism growth test. Used to track temporal information related to culture scheduled date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for culture management and reporting.

culture scheduled timecult_sched_tm

The planned time for a microorganism growth test. Used to track temporal information related to culture scheduled time. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for culture management and reporting.

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.

debit addressdb_addr

The physical location text for a charge or amount owed. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for debit management and reporting.

debit approval statusdb_appr_sts

The authorization state for a charge or amount owed. Used to track the current state or condition of the debit. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for debit management and reporting.

debit charge amountdb_chrg_amt

The service charge value for a charge or amount owed. Used to capture financial data associated with debit transactions. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for debit management and reporting.

debit effective datedb_eff_dt

The active beginning date for a charge or amount owed. Used to track temporal information related to debit effective date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for debit management and reporting.

debit group numberdb_grp_nbr

The insurance group identifier for a charge or amount owed. Used as a unique reference to identify and track the debit across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for debit management and reporting.

debit medical record numberdb_mrn

The patient medical record number for a charge or amount owed. Used as a unique reference to identify and track the debit across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for debit management and reporting.

debit scheduled datedb_sched_dt

The planned appointment date for a charge or amount owed. Used to track temporal information related to debit scheduled date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for debit management and reporting.

debit scheduled timedb_sched_tm

The planned time for a charge or amount owed. Used to track temporal information related to debit scheduled time. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for debit management and reporting.

debit street addressdb_st_addr

The street location for a charge or amount owed. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for debit management and reporting.

debit unitdb_unt

The single item or measure for a charge or amount owed. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for debit management and reporting.

deductible scheduled dateded_sched_dt

The planned appointment date for a insurance threshold amount. Used to track temporal information related to deductible scheduled date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for deductible management and reporting.

deductible scheduled timeded_sched_tm

The planned time for a insurance threshold amount. Used to track temporal information related to deductible scheduled time. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for deductible management and reporting.

PreviousPage 72 of 320Next