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 master identifiernrs_mstr_id

The enterprise-wide unique identifier assigned to a licensed nursing professional across all integrated healthcare systems. Serves as the master linkage key connecting nurse records across credentialing, scheduling, payroll, and clinical assignment systems to ensure consistent identity resolution.

nurse maximumnrs_max

The upper boundary value associated with a nurse-related metric or threshold, such as maximum patient load, maximum shift hours, or maximum allowable overtime. Used in workforce scheduling, staffing ratio compliance, and workload management systems to enforce regulatory and operational limits.

nurse medical record numbernrs_mrn

The facility-assigned medical record number linked to a licensed nursing professional when that nurse is also a patient within the same healthcare system. Enables dual-role identity tracking in EHR systems where staff may receive care at their employing institution.

nurse middle namenrs_mid_nm

The middle name or middle initial of a licensed nursing professional as recorded in workforce, credentialing, or HR systems. Used to disambiguate nurses with identical first and last names and to ensure accurate identity matching across licensing boards, payroll, and clinical staffing records.

nurse minimumnrs_min

The lower boundary value associated with a nurse-related metric or threshold, such as minimum required shift hours, minimum staffing levels per unit, or minimum qualification scores. Used in workforce planning, scheduling systems, and regulatory compliance reporting to enforce staffing standards.

nurse mobilenrs_mob

The personal or work-issued mobile phone number for a licensed nursing professional. Used in workforce management systems to facilitate direct communication for on-call scheduling, shift change notifications, emergency staffing alerts, and secure clinical messaging across healthcare operations.

nurse modified bynrs_mod_by

The system user identifier of the individual who last updated a licensed nursing professional's record in the workforce or credentialing system. Used in audit trail logging to track data stewardship, accountability, and record change history for compliance and quality assurance purposes.

nurse modified datenrs_mod_dt

The timestamp recording the most recent update to a licensed nursing professional's record in EHR, credentialing, or provider master systems. Used for audit trails, incremental data loads, change detection in ETL pipelines, and regulatory compliance reporting.

nurse modified timenrs_mod_tm

The exact timestamp recording when a licensed nursing professional's record was most recently updated in the workforce, credentialing, or HR system. Used in audit logging, data synchronization across integrated systems, and change history tracking for compliance and data governance purposes.

nurse namenrs_nm

The full display name of a licensed nursing professional (RN, LPN, CNA) as recorded in EHR, staffing, or care coordination systems. Used to attribute clinical documentation, patient assignments, and care events to the responsible nurse in downstream data pipelines.

nurse notenrs_nt

Free-text or structured annotation entered by a licensed nursing professional in EHR systems such as Epic or Cerner. Captures clinical observations, patient status updates, and care interventions. Used in NLP pipelines and clinical data warehouses for quality reporting and care gap analysis.

nurse numbernrs_nbr

A unique numeric or alphanumeric identifier assigned to a licensed nursing professional within EHR, staffing, or credentialing systems. Used as a foreign key in data models to link nurse records across scheduling, payroll, clinical documentation, and claims adjudication platforms.

nurse onset datenrs_onset_dt

The date on which a nurse-documented clinical condition, symptom, or health event first began for a patient under their care. Captured during nursing assessments and used in clinical documentation systems to establish disease progression timelines and support care planning decisions.

nurse oxygen saturationnrs_o2sat

The peripheral blood oxygen saturation percentage recorded by a licensed nursing professional during patient assessment, typically measured via pulse oximetry. Captured in clinical documentation systems as a vital sign to monitor respiratory status, detect hypoxia, and guide patient care interventions.

nurse paid amountnrs_pd_amt

The gross or net monetary compensation paid to a licensed nursing professional for services rendered during a given pay period or assignment. Captured in payroll and workforce management systems and used in labor cost reporting, budget reconciliation, and contract compliance tracking.

nurse paid datenrs_pd_dt

The date on which compensation was disbursed to a licensed nursing professional for completed work or services. Recorded in payroll and workforce management systems to support pay period reconciliation, audit trails, and financial reporting across healthcare labor cost accounting systems.

nurse parentnrs_prnt

The hierarchical superior entity associated with a licensed nursing professional in organizational or care team data structures. Used in EHR and workforce management systems to define reporting relationships, unit assignments, and supervisory chains within healthcare data models.

nurse percentagenrs_pct

A ratio or percentage value attributed to a licensed nursing professional, such as productivity metrics, caseload allocation, or care hours distribution. Used in workforce analytics, staffing models, and quality reporting systems to evaluate nurse performance and resource utilization.

nurse periodnrs_prd

The defined time span associated with a licensed nursing professional's activity, shift, assignment, or contract in EHR or workforce systems. Used in staffing analytics and payroll data pipelines to calculate hours worked, shift coverage, and longitudinal care continuity metrics.

nurse phonenrs_ph

The primary telephone contact number for a licensed nursing professional as stored in EHR, credentialing, or care coordination systems. Used for care team communication routing, on-call scheduling applications, and provider directory data validation in member-facing systems.

PreviousPage 434 of 806Next