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

nurse totalnrs_tot

The aggregated numeric value representing a sum of nursing-related activities, hours, costs, or patient interactions in EHR, workforce, and claims systems. Used in staffing reports, productivity analytics, cost allocation models, and quality measurement dashboards across healthcare data platforms.

nurse total countnrs_tot_cnt

The aggregate number of nurses, nursing encounters, interventions, or documented events within a defined reporting period or unit. Used in staffing analytics, productivity reporting, quality benchmarking, and operational dashboards to assess nursing resource utilization and workload distribution across care settings.

nurse typenrs_typ

The classification category identifying the specialty or licensure type of a nursing professional in EHR, credentialing, and provider master systems. Values may include RN, LPN, CNA, or NP, used to route clinical tasks, apply billing codes, and enforce scope-of-practice rules.

nurse updated datenrs_upd_dt

The most recent date on which a nurse's record, clinical documentation, credentialing profile, or care plan entry was modified. Used in audit logging, data governance, and clinical systems to track changes over time, support version history, and ensure currency of nursing workforce and patient care records.

nurse urgencynrs_urg

The triage or prioritization level assigned by a nurse to indicate the time-sensitivity of a patient's clinical need or care request, such as emergent, urgent, or routine. Used in triage workflows, care coordination systems, and clinical decision support to guide resource allocation and response sequencing across care settings.

nurse valuenrs_val

A discrete or calculated data point associated with a nursing professional's performance, clinical measurement, or workforce metric in EHR and analytics systems. Used in quality scoring, productivity benchmarking, clinical outcome tracking, and provider profiling across healthcare data pipelines.

nurse versionnrs_ver

Tracks the sequential revision number of a licensed nurse's credentialing or profile record in healthcare workforce systems. Increments when key attributes such as licensure status, specialty, or contact information are updated, enabling audit trail maintenance and data reconciliation across clinical systems.

nurse zipnrs_zip

The postal ZIP code associated with a licensed nurse's primary practice or residence address in workforce credentialing and licensing systems. Used to verify geographic practice jurisdiction, support state board licensure compliance, and analyze nursing workforce distribution across service regions.

observation active indicatorobs_actv_ind

A binary flag in clinical data systems that designates whether a specific patient observation record is currently active and clinically relevant. Inactive observations may have been superseded by updated measurements, entered in error, or voided, and are excluded from active clinical decision support workflows.

observation active statusobs_actv_sts

Captures the lifecycle state of a patient observation record in clinical documentation systems, distinguishing active, inactive, voided, or superseded states. Used to filter current versus historical observation data in reporting, clinical dashboards, and quality measurement workflows to ensure only valid records are analyzed.

observation addressobs_addr

The physical or logical location associated with a clinical observation or measurement event in EHR and care management systems. Used to identify the facility, department, or care setting where the observation was recorded, supporting site-of-service analytics and geographic care pattern reporting.

observation adjustment amountobs_adj_amt

The dollar value applied to modify the original billed amount for an outpatient observation service encounter on a claim. Adjustments reflect contractual write-offs, payer corrections, coordination of benefits changes, or administrative modifications processed during claims adjudication for observation-level facility charges.

observation admission dateobs_admn_dt

The hospital entry date recorded when a patient transitions to observation status rather than inpatient admission. Used in EHR and claims systems to track CMS-defined observation stays, trigger revenue code 0762, and determine Medicare Part B versus Part A billing eligibility.

observation ageobs_age

The patient's calculated age in years at the time an observation service encounter was initiated or documented. Used in clinical analytics, quality measure stratification, and utilization reporting to segment observation stay populations by age cohort for clinical and operational decision-making.

observation allowed amountobs_alwd_amt

The maximum dollar amount a health plan will reimburse for services rendered during an outpatient observation encounter, as defined by the payer's fee schedule or negotiated contract terms. Amounts exceeding this threshold become patient responsibility or provider write-offs in claims adjudication processing.

observation amountobs_amt

The monetary value associated with a clinical observation or measurement in EHR and claims systems, typically reflecting the cost or charge for the observation service. Used in revenue cycle management, cost analysis, and claims adjudication workflows to link clinical findings to financial transactions.

observation approval statusobs_appr_sts

Indicates whether an outpatient observation placement or associated clinical order has received authorization from a payer, utilization management team, or clinical reviewer. Status values typically include pending, approved, denied, or partially approved, and directly affect downstream claims payment eligibility and billing workflows.

observation approved byobs_appr_by

Identifies the user, clinician, or authorization system that formally approved an observation placement order or associated clinical documentation. Captured for compliance, audit trail, and utilization management purposes in hospital information systems where observation status requires clinical or administrative sign-off.

observation arrival timeobs_arrv_tm

The recorded timestamp indicating when a patient physically arrived at a facility and was placed under outpatient observation status. Used in operational reporting to calculate length of stay, measure door-to-provider intervals, and support compliance with CMS observation notification requirements under the MOON mandate.

observation arrived dateobs_arrv_dt

The calendar date on which a patient was registered and placed under outpatient observation status at a facility. Used in utilization management reporting, CMS billing compliance, and length-of-stay analysis to establish the start boundary of the observation encounter for claims and clinical documentation.

PreviousPage 437 of 806Next