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

note typent_typ

Classifies a clinical documentation entry by its functional category in EHR systems such as Epic, Cerner, or Allscripts. Common values include Progress Note, Discharge Summary, Operative Report, Consult Note, and Nursing Assessment, enabling structured retrieval and NLP preprocessing in clinical analytics.

note updated datent_upd_dt

The most recent date and time a clinical note was modified, amended, or addended within the EHR system. Supports audit trail integrity, version control tracking, and regulatory compliance by establishing when documentation changes occurred relative to the original authorship date and patient care timeline.

note urgencynt_urg

The priority or time-sensitivity classification assigned to a clinical note, indicating how quickly the note requires review, response, or action by clinical staff. Values typically range from routine to urgent or stat, guiding triage workflows, care escalation protocols, and clinician task queue prioritization in inpatient and outpatient settings.

note versionnt_ver

The sequential version number assigned to a clinical note each time it is modified, addended, or corrected within the EHR system. Enables document version control by preserving the history of changes over time, supporting audit compliance, medico-legal review, and accurate reconstruction of the clinical documentation record.

note zipnt_zip

The five or nine-digit US postal code associated with the location referenced in a clinical note, such as the patient's residence or the facility where care was rendered. Used to support geographic analysis, population health reporting, care access assessments, and regional disease surveillance within clinical data systems.

nurse active indicatornrs_actv_ind

A binary flag indicating whether a licensed nursing professional currently holds an active employment, credentialing, or system access status within the healthcare organization. Used in workforce management systems to control EHR access rights, care assignment eligibility, staffing rosters, and regulatory compliance reporting for nursing personnel.

nurse active statusnrs_actv_sts

The current operational or employment status of a licensed nursing professional, indicating whether the nurse is actively practicing, on leave, suspended, or terminated. Used in workforce management and credentialing systems to govern care assignments, shift scheduling, scope-of-practice enforcement, and nursing license verification workflows.

nurse admission datenrs_admn_dt

The date on which a licensed nursing professional was admitted to a facility, enrolled in a staffing system, or assigned to a patient care unit, as recorded in EHR or workforce management systems. Used by data engineers to track nurse assignment timelines, staffing coverage, and care continuity metrics.

nurse agenrs_age

The calculated age in years of a licensed nursing professional based on their date of birth. Used in healthcare workforce analytics to support demographic reporting, retirement planning, workforce succession modeling, and compliance with age-related employment regulations applicable to clinical nursing staff across care settings.

nurse allowed amountnrs_alwd_amt

The maximum reimbursable dollar amount approved for nursing services rendered under a specific payer contract, fee schedule, or care agreement. Used in healthcare billing and workforce cost accounting to establish payment limits for nursing labor charges, agency staffing contracts, and value-based care reimbursement arrangements.

nurse amountnrs_amt

Represents a monetary value associated with a licensed nursing professional in healthcare financial systems, such as contracted rate, reimbursement amount, or compensation figure. Used in workforce cost analytics, staffing budget models, and payroll reconciliation across HR and revenue cycle management platforms.

nurse approval statusnrs_appr_sts

The current credentialing or authorization state of a licensed nursing professional, indicating whether the nurse has been formally approved to practice within the healthcare organization or a specific clinical unit. Used in privileging workflows, onboarding processes, and compliance systems to validate scope-of-practice authorization before care assignments.

nurse approved bynrs_appr_by

The identifier or name of the administrator, supervisor, or credentialing authority who formally approved a licensed nursing professional for clinical practice, system access, or a specific care assignment. Used in audit logs, credentialing records, and workforce governance systems to establish accountability for nurse authorization decisions.

nurse arrival timenrs_arrv_tm

The recorded timestamp indicating when a licensed nursing professional arrived at the care setting, patient location, or scheduled shift assignment. Used in staffing management, home health visit tracking, and care coordination systems to verify punctuality, calculate on-site duration, support payroll processing, and ensure patient care coverage compliance.

nurse arrived datenrs_arrv_dt

The date a licensed nurse arrived at a care setting, patient location, or clinical encounter. Used in visit scheduling and home health records to document when nursing services physically commenced, supporting care coordination and billing validation.

nurse assessmentnrs_asmt

The structured clinical evaluation documented by a licensed nurse, capturing patient condition, symptoms, vital observations, and care needs. Forms the foundation of the nursing process in EHR records and drives care planning, intervention decisions, and clinical documentation compliance.

nurse balancenrs_bal

Tracks the outstanding financial amount attributable to a licensed nursing professional in healthcare accounting or payroll systems, such as unpaid wages, overpayment balances, or unsettled reimbursements. Used in workforce financial reconciliation, accounts payable workflows, and HR audit reporting.

nurse billed amountnrs_bill_amt

The total dollar amount billed by or for a licensed nurse on a healthcare claim or invoice. Captured in claims processing and revenue cycle systems to reflect nursing service charges submitted to payers for reimbursement under applicable billing codes.

nurse birth datenrs_birth_dt

Records the date of birth of a licensed nursing professional as stored in credentialing databases, HR systems, or provider master files. Used for identity verification during license validation, DEA registration, background screening, and age-based workforce demographic analysis in healthcare data platforms.

nurse blood pressurenrs_bp

The systolic and diastolic arterial pressure measurement recorded by a licensed nurse during a patient encounter or assessment. A critical vital sign documented in clinical records to monitor cardiovascular status, track trends, and inform treatment decisions.

PreviousPage 430 of 806Next