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 dea numbernrs_dea_nbr

The Drug Enforcement Administration registration number assigned to a nurse with prescriptive authority, such as a nurse practitioner. Used in pharmacy and EHR systems to validate controlled substance prescribing privileges and ensure regulatory compliance with federal DEA requirements.

nurse death datenrs_death_dt

The recorded date of death for a licensed nursing professional as maintained in HR, credentialing, or workforce management systems. Used by data engineers to terminate active records, update slowly changing dimensions, and ensure accurate staffing and licensure reporting within healthcare workforce analytics platforms.

nurse deleted datenrs_del_dt

The date a nurse's record was logically deleted or deactivated in a clinical or administrative system. Retained in data systems to support audit trails, historical reporting, and data integrity checks without permanently removing the record from the database.

nurse deleted indicatornrs_del_ind

A flag indicating that a nurse's record has been logically removed or inactivated in a healthcare system without physical deletion. Used in EHR and workforce databases to filter active records while preserving historical data for audit, compliance, and reporting purposes.

nurse descriptionnrs_desc

The textual explanation or narrative associated with a licensed nursing professional's role, specialization, or record attribute in EHR or workforce management systems. Used by data engineers to populate reference tables, support search functionality, and enrich nursing staff dimension records in clinical data warehouse environments.

nurse detailnrs_dtl

The granular, record-level information associated with a licensed nursing professional's profile, assignment, or clinical activity in EHR or workforce management systems. Used by data engineers to populate detail tables, support drill-down reporting, and enable comprehensive nurse-level analytics in healthcare data warehouses.

nurse discharge datenrs_dsch_dt

The date on which a licensed nursing professional's assignment, episode of employment, or patient care responsibility ended, as recorded in EHR or workforce management systems. Used by data engineers to calculate assignment durations, close active records, and support staffing turnover and continuity analytics.

nurse due datenrs_due_dt

The date by which a nursing service, care task, competency requirement, or invoice payment is expected to be completed or fulfilled. Used in care management, revenue cycle, and workforce systems to drive scheduling, compliance tracking, and accounts receivable workflows.

nurse durationnrs_dur

The total length of time a nurse spent delivering care during a patient visit, procedure, or clinical encounter. Captured in home health, staffing, and claims systems to support productivity reporting, service billing under time-based codes, and care utilization analysis.

nurse emailnrs_eml

The electronic mail address associated with a licensed nursing professional as stored in EHR, credentialing, or workforce management systems. Used by data engineers to link nursing staff identity records across systems, support care team communication datasets, and enable provider directory matching in healthcare data integration workflows.

nurse emergency indicatornrs_emerg_ind

A flag identifying that a nursing visit or service was rendered in response to an urgent or emergent patient condition. Used in clinical and claims systems to distinguish emergency nursing encounters from routine care, supporting appropriate billing, triage reporting, and care acuity analysis.

nurse end datenrs_end_dt

The completion or termination date associated with a licensed nursing professional's assignment, contract, or enrollment record in EHR or workforce management systems. Used by data engineers to implement slowly changing dimension logic, close active records, and calculate tenure or assignment duration metrics in healthcare workforce analytics.

nurse end timenrs_end_tm

The timestamp marking the conclusion of a nursing shift, patient care episode, or clinical task performed by a licensed nurse. Used in workforce scheduling systems and clinical documentation to calculate hours worked, care duration, and staffing utilization across inpatient and outpatient settings.

nurse entered bynrs_ent_by

The system user ID or username of the individual who created or submitted a nursing record in the clinical documentation system. Used in audit trails to track data entry accountability, identify documentation errors, and support compliance reviews within EHR and nursing workflow platforms.

nurse ethnicitynrs_ethn

The self-reported ethnic background of a licensed nursing professional, captured for workforce diversity reporting and compliance with Equal Employment Opportunity requirements. Used in HR systems and staffing databases to support demographic analysis, equity initiatives, and regulatory workforce reporting.

nurse expiration datenrs_exp_dt

The credential validity end date for a licensed nursing professional, stored in EHR, credentialing, and provider master systems. Used to enforce license compliance checks, trigger renewal workflows, and validate nurse eligibility for care delivery assignments.

nurse external identifiernrs_ext_id

A unique identifier assigned to a nurse by an external system, such as a state nursing board registry, staffing agency, or health system network. Used to cross-reference nurse records across disparate clinical, credentialing, and workforce management platforms for accurate identity resolution.

nurse faxnrs_fax

The facsimile telephone number associated with a licensed nurse or their primary work location. Used in clinical communication workflows to transmit orders, referrals, and patient documentation securely between care settings, particularly where electronic messaging systems are unavailable or not yet integrated.

nurse feenrs_fee

The billable rate or service charge associated with nursing care rendered to a patient, used in cost accounting, workforce billing, and contract staffing invoicing. Relevant in home health, staffing agency, and per diem nursing contexts where nursing labor is tracked as a discrete billable service.

nurse first namenrs_first_nm

The given or personal first name of a licensed nursing professional as recorded in the workforce or clinical information system. Used in staff directories, care team displays, patient documentation attribution, and scheduling interfaces to identify individual nurses in a human-readable format.

PreviousPage 432 of 806Next