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

serology completed datesero_cmpl_dt

The date on which a serology (serum antibody) study was fully processed and results were finalized by the laboratory. Used to measure turnaround time, track test completion workflows, and establish the temporal reference point for clinical interpretation and reporting of antibody study outcomes.

serology confidential indicatorsero_conf_ind

A flag designating that a serology study record contains sensitive information requiring restricted access beyond standard clinical permissions. Commonly applied to serology results related to HIV, sexually transmitted infections, or other conditions subject to heightened privacy protections under applicable healthcare privacy regulations and institutional policies.

serology countsero_cnt

The numeric count of serology studies, specimens, or result instances associated with a patient encounter or defined time period. Used in laboratory reporting, utilization analysis, and population health tracking to quantify serological testing volume and identify patterns in antibody study ordering across clinical workflows.

serology countrysero_ctry

The country associated with the patient's address or the facility performing a serology study. Supports international epidemiological surveillance, travel history correlation, and reporting of antibody test data in cross-border infectious disease monitoring programs and global immunology research datasets.

serology created bysero_crtd_by

The unique identifier of the user, clinician, or system that originally created the serology study record in the laboratory or clinical information system. Used for audit trail integrity, accountability tracking, and workflow attribution when reviewing the origin of serum antibody test orders and associated documentation.

serology created datesero_crtd_dt

The calendar date on which the serology study record was initially entered into the laboratory or clinical information system. Establishes the audit trail start point, supports workflow chronology, and is used in conjunction with order and collection dates to track serum antibody test lifecycle management.

serology created timesero_crtd_tm

The timestamp indicating the exact time at which a serology study record was initially created in the laboratory or clinical information system. Used alongside the created date to provide precise audit trail documentation, support workflow sequencing, and enable time-sensitive tracking of serum antibody test record origination.

serology creatininesero_cr

The serum creatinine value documented in association with a serology encounter, reflecting kidney filtration function at the time of testing. Relevant in serological workups where renal status may affect antibody interpretation, particularly in autoimmune nephropathy, transplant serology, or medication monitoring contexts requiring concurrent renal function assessment.

serology datesero_dt

The primary calendar date associated with a serology study, representing when the serum antibody test was ordered, collected, or resulted depending on system context. Serves as the core temporal reference for indexing serological records, tracking disease exposure timelines, and correlating antibody findings with clinical events.

serology datetimesero_dttm

The combined date and time value associated with a serology study event, providing a precise timestamp for test ordering, specimen collection, or result finalization. Enables accurate chronological sequencing of serum antibody studies within laboratory workflows, clinical timelines, and longitudinal patient immunology records.

serology dea numbersero_dea_nbr

The Drug Enforcement Administration registration number associated with a serum antibody study record. Used to identify the prescribing or ordering clinician in laboratory workflows where controlled substances may be involved in specimen collection or patient care context.

serology death datesero_death_dt

The recorded date of death for the patient associated with a serum antibody study. Used in longitudinal clinical analysis to correlate serological test results with patient outcomes, supporting mortality tracking and retrospective immunological research across laboratory information systems.

serology deleted datesero_del_dt

The date on which a serum antibody study record was marked as deleted within the laboratory or clinical data system. Supports audit trail maintenance and data governance by preserving the timestamp of record inactivation without permanently removing historical serological data.

serology deleted indicatorsero_del_ind

A flag indicating whether a serum antibody study record has been logically removed from active use in the laboratory information system. Allows downstream reporting and clinical workflows to exclude invalidated serological records while retaining the data for audit and compliance purposes.

serology descriptionsero_desc

A human-readable textual explanation describing the nature, purpose, or findings of a serum antibody study. Used in laboratory and clinical documentation to communicate test methodology, specimen characteristics, or result interpretation to clinicians and downstream healthcare data consumers.

serology detailsero_dtl

Granular information captured at the individual test or specimen level for a serum antibody study. Includes specific procedural, diagnostic, or result data points used to support clinical interpretation, laboratory quality control, and detailed serological reporting in healthcare data systems.

serology discharge datesero_dsch_dt

The date on which the patient associated with a serum antibody study was discharged from an inpatient or outpatient clinical setting. Used to correlate serological testing timelines with episode-of-care boundaries and support post-discharge immunological follow-up tracking.

serology due datesero_due_dt

The expected or required completion date for a serum antibody study, indicating when results or follow-up actions should be finalized. Used in laboratory workflow management to prioritize pending serological tests and ensure timely reporting to ordering clinicians or care teams.

serology durationsero_dur

The measured or calculated length of time associated with a serum antibody study, such as the interval between specimen collection and result reporting, or the duration of a serological testing protocol. Used in laboratory performance monitoring and clinical outcome analysis.

serology emailsero_eml

The electronic mail address associated with the patient, clinician, or contact linked to a serum antibody study record. Used to facilitate result notification, order communication, and laboratory correspondence within clinical and laboratory information system workflows.

PreviousPage 626 of 806Next