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 cancelled datenrs_cncl_dt

The date a scheduled nursing visit, service, or clinical encounter was cancelled. Recorded in scheduling and home health systems to track missed care events, support rescheduling workflows, and identify patterns affecting care continuity and utilization reporting.

nurse categorynrs_cat

Classifies a licensed nursing professional into a functional or organizational grouping in HR, credentialing, or workforce management systems. Examples include Acute Care, Long-Term Care, Ambulatory, or Specialty nursing categories, supporting staffing analytics, role-based access controls, and workforce planning models.

nurse charge amountnrs_chrg_amt

The gross charge amount associated with nursing services rendered during a patient encounter, prior to contractual adjustments or payments. Used in revenue cycle management and claims data to reflect the list price of nursing care billed to insurers or patients.

nurse chief complaintnrs_cc

The primary symptom, concern, or reason for a clinical encounter as reported by the patient and documented by the nurse during intake. Recorded in EHR triage and assessment workflows to guide clinical evaluation and ensure accurate encounter coding.

nurse childnrs_chld

Defines a subordinate hierarchical relationship for a licensed nursing professional within organizational or credentialing data models in healthcare workforce systems. Used to represent reporting structures, delegation hierarchies, or role-based dependencies in staffing platforms and provider directory datasets.

nurse citynrs_city

The city associated with a nurse's practice address, employer location, or home health service area. Used in provider directories, credentialing systems, and workforce data to support geographic reporting, licensure verification, and care access analysis.

nurse classnrs_cls

Specifies the classification tier assigned to a licensed nursing professional in HR, payroll, or credentialing systems. Common values may include RN, LPN, CNA, or APRN tiers, used for role-based access control, staffing ratio compliance reporting, scope-of-practice validation, and compensation band assignments.

nurse codenrs_cd

A standardized alphanumeric identifier assigned to a licensed nursing professional in credentialing, HR, or provider master systems. May correspond to internal workforce identifiers, state nursing board license codes, or NPI cross-references, supporting provider attribution, staffing records, and clinical audit trail linkage.

nurse commentnrs_cmt

The free-text notation entered by a licensed nursing professional in EHR or clinical documentation systems, capturing observations, care instructions, or patient status updates. Used by data engineers to extract and process unstructured nursing narrative data for NLP pipelines, auditing, and care quality reporting.

nurse completed datenrs_cmpl_dt

The date a nursing visit, treatment, assessment, or assigned care task was fully completed. Documented in clinical and home health systems to confirm service delivery, trigger billing workflows, and support quality monitoring of care plan adherence.

nurse confidential indicatornrs_conf_ind

A flag denoting that a nurse's record, encounter note, or associated patient information is subject to heightened privacy protections. Used in EHR and clinical data systems to restrict access to sensitive documentation in compliance with HIPAA and organizational privacy policies.

nurse contactnrs_cntct

The communication point, such as phone number, pager, or messaging endpoint, associated with a licensed nursing professional in EHR, care coordination, or workforce management systems. Used by data engineers to link nursing staff records with communication logs and care team assignment tables for operational analytics.

nurse countnrs_cnt

The numeric count of licensed nursing professionals associated with a unit, shift, encounter, or reporting period within EHR or workforce management systems. Used by data engineers to calculate staffing ratios, nurse-to-patient metrics, and resource utilization statistics for operational and regulatory reporting.

nurse countrynrs_ctry

The country associated with a nurse's practice location, credentialing record, or mailing address. Used in provider directories and workforce systems to support international licensure tracking, foreign-trained nurse credentialing, and geographic reporting in multi-national health organizations.

nurse created bynrs_crtd_by

The unique identifier of the user or system that originally created a nurse's record in a clinical or administrative system. Used for audit trail purposes to establish accountability, support data governance, and trace record provenance in EHR and workforce management platforms.

nurse created datenrs_crtd_dt

The timestamp indicating when a licensed nursing professional's record was initially created in EHR, credentialing, or workforce management systems. Used by data engineers to track record provenance, audit data entry timelines, and support slowly changing dimension logic in clinical data warehouse pipelines.

nurse created timenrs_crtd_tm

The exact timestamp at which a nurse's record, clinical note, or administrative entry was first created in the system. Used in audit logging and data governance to establish a chronological record of documentation, supporting compliance reviews and data lineage tracking.

nurse creatininenrs_cr

The serum or urine creatinine level measured and recorded by a nurse as part of a patient's laboratory assessment. Used in clinical records to evaluate kidney function, monitor patients on nephrotoxic medications, and support clinical decision-making for care planning.

nurse datenrs_dt

A general calendar date value associated with a licensed nursing professional's activity, assignment, or record event within EHR or workforce management systems. Used by data engineers as a flexible date dimension attribute to support time-based filtering, trending, and cohort analysis across nursing staff datasets.

nurse datetimenrs_dttm

The combined date and time value capturing a precise moment associated with a licensed nursing professional's activity or system event in EHR or clinical documentation platforms. Used by data engineers for high-resolution temporal analysis, event sequencing, and audit trail reconstruction in clinical data pipelines.

PreviousPage 431 of 806Next