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

assessment addressasmt_addr

The physical location where a clinical assessment was conducted, including facility or home address details. Used in care management and clinical documentation systems to record where patient evaluations occurred, supporting care coordination and population health reporting.

assessment approval statusasmt_appr_sts

The current authorization or review state of a clinical assessment, such as pending, approved, or denied. Used in care management workflows to track whether an assessment has received required clinical or administrative sign-off before results are acted upon.

assessment charge amountasmt_chrg_amt

The billed charge associated with administering a clinical assessment, representing the provider's stated fee before payer adjustments. Used in claims and care management financial reporting to track assessment-related costs and support revenue cycle analysis.

assessment effective dateasmt_eff_dt

The date on which a clinical assessment becomes active or valid for use in care planning and clinical decision-making. Used in care management systems to establish the timeframe during which assessment results are considered current and actionable for treatment decisions.

assessment group numberasmt_grp_nbr

The insurance group identifier linked to a member at the time a clinical assessment was conducted. Used in care management and claims systems to associate assessment records with the correct employer group or health plan contract for billing and reporting purposes.

assessment medical record numberasmt_mrn

The unique patient medical record number assigned by a healthcare facility, linked to a clinical assessment record. Used to associate assessment data with the correct patient across EHR and care management systems, ensuring accurate longitudinal health record tracking.

assessment scheduled dateasmt_sched_dt

The calendar date on which a clinical assessment is planned to be administered to a patient. Used in care management and scheduling systems to coordinate patient outreach, clinician availability, and follow-up workflows for structured health evaluations.

assessment scheduled timeasmt_sched_tm

The specific time of day at which a clinical assessment appointment is planned. Used alongside the scheduled date in care management and scheduling systems to manage clinician calendars, patient notifications, and assessment completion tracking workflows.

assessment street addressasmt_st_addr

The street-level address component of the location where a clinical assessment was performed or is scheduled to occur. Used in care management systems to document and verify the specific site of patient evaluation for care coordination and reporting purposes.

assessment unitasmt_unt

The unit of measure associated with a clinical assessment, such as a single encounter, a scored scale value, or a timed interval. Used in care management and claims systems to quantify assessment activity and support utilization tracking and outcome measurement.

assistant addressasst_addr

The physical or mailing address on record for a healthcare support worker, such as a medical assistant or clinical aide. Used in workforce management and credentialing systems to maintain accurate contact and location data for staffing, compliance, and communication purposes.

assistant ageasst_age

The current age in years of a healthcare support worker, derived from date of birth. Used in workforce management and HR systems for demographic reporting, labor analytics, and compliance with age-related employment regulations in healthcare settings.

assistant allowed amountasst_alwd_amt

The maximum dollar amount a payer will reimburse for services rendered by a healthcare support worker, such as a surgical assistant or clinical aide. Used in claims adjudication to calculate payment after applying contractual adjustments and coordination of benefits rules.

assistant amountasst_amt

The monetary value associated with a surgical or procedural assistant's contribution to a healthcare encounter. Used in claims processing and reimbursement workflows to capture the billed or allowed dollar amount tied to assistant surgeon or clinical assistant services rendered.

assistant approval statusasst_appr_sts

The current authorization state indicating whether a surgical or clinical assistant's involvement in a procedure has been approved, pending, or denied. Used in prior authorization workflows and claims adjudication to validate assistant service eligibility before or after care delivery.

assistant approved byasst_appr_by

The identifier or name of the individual, system, or review body that granted authorization for a surgical or clinical assistant's participation in a procedure. Used in claims and utilization management workflows to maintain an audit trail of approval decisions for assistant services.

assistant arrival timeasst_arrv_tm

The recorded time at which a surgical or clinical assistant arrived at the care setting for a scheduled procedure or encounter. Used in operative scheduling, staffing coordination, and clinical workflow systems to track punctuality and resource readiness for assistant personnel.

assistant arrived dateasst_arrv_dt

The calendar date on which a surgical or clinical assistant arrived at the care facility for a scheduled encounter or procedure. Used in operative scheduling and staffing records to document assistant attendance and support compliance with procedural staffing requirements.

assistant assessmentasst_asmt

The clinical evaluation or narrative documentation completed by a healthcare assistant during a patient encounter. Used in clinical documentation systems to capture structured or free-text findings, observations, or assessments contributed by assistant-level clinical staff supporting patient care delivery.

assistant birth dateasst_birth_dt

The date of birth of a surgical or clinical assistant, used to verify identity, licensure eligibility, and credentialing requirements within provider enrollment and workforce management systems. Supports age-based compliance checks and demographic record accuracy for assistant personnel.

PreviousPage 30 of 325Next