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 surgery datesero_surg_dt

Date of a surgical procedure associated with or preceding a serum antibody study, such as pre-operative screening or post-transplant serological monitoring. Used in clinical data systems to correlate serological test results with surgical interventions for infection risk assessment and immunological monitoring.

serology targetsero_tgt

Specific antigen, pathogen, or antibody type that a serum antibody study is designed to detect or measure, such as HIV antibodies, hepatitis B surface antigen, or ANA. Used in laboratory information systems to define the analyte focus of the serological assay and guide result interpretation.

serology taxonomy codesero_tax_cd

Standardized classification code identifying the category or type of a serum antibody study within a defined coding taxonomy. Used in laboratory and clinical data systems to systematically categorize serological tests for data aggregation, reporting, interoperability, and integration with external health information systems.

serology temperaturesero_temp

Temperature measurement recorded in association with a serum antibody study, including patient body temperature at time of specimen collection or required storage and processing temperatures for serological reagents. Used in laboratory systems to ensure specimen integrity and proper assay conditions for accurate antibody testing.

serology termination datesero_term_dt

Calendar date on which a serum antibody study or associated serological monitoring episode was concluded, discontinued, or formally closed. Used in laboratory and clinical data systems to define the end boundary of antibody testing periods, supporting episode duration calculations and longitudinal outcome analysis.

serology timesero_tm

Time of day recorded in association with a serum antibody study event, such as specimen collection, receipt in laboratory, or result reporting. Used in laboratory information systems to support accurate temporal sequencing of serological workflow events and precise documentation of timed antibody assays.

serology timestampsero_ts

Combined date and time value capturing a specific event within a serum antibody study, such as specimen collection, laboratory receipt, analysis, or result verification. Used in laboratory information systems for precise audit trail documentation, chain of custody tracking, and regulatory compliance reporting.

serology titlesero_ttl

Formal name or label assigned to a serum antibody study or serological test panel, such as Hepatitis B Antibody Panel or Rubella IgG Titer. Used in laboratory information systems and clinical documentation to clearly identify and communicate the specific type of antibody testing ordered and performed.

serology totalsero_tot

Aggregate numeric value representing the combined sum of all components within a serum antibody study, such as total antibody units detected or cumulative charges for a serological test panel. Used in laboratory and billing systems to summarize quantitative results or costs across all test components.

serology total countsero_tot_cnt

Cumulative count of all serum antibody studies or individual serological test occurrences recorded for a patient or within a defined dataset. Used in laboratory information systems and clinical analytics to quantify testing volume, monitor frequency of serological monitoring, and support population-level antibody surveillance reporting.

serology typesero_typ

Classifies the category of serum antibody test performed, such as ABO blood typing, Rh factor, crossmatch, or infectious disease serology. Used in laboratory information systems to route specimens, apply reference ranges, and organize results within patient immunology and transfusion medicine records.

serology updated datesero_upd_dt

Records the most recent date on which a serology test record was modified in the laboratory information system. Used for audit trail tracking, result amendment documentation, and ensuring clinicians are reviewing the most current antibody study findings prior to transfusion or treatment decisions.

serology urgencysero_urg

Indicates the time sensitivity level assigned to a serology order, such as STAT, routine, or urgent. Drives laboratory prioritization and turnaround time expectations for antibody studies including blood type, crossmatch, and infectious serology panels used in transfusion medicine and pre-surgical workflows.

serology versionsero_ver

Tracks the sequential version number of a serology record, incrementing each time the result or associated data is amended in the laboratory information system. Supports audit compliance and enables clinicians to identify whether a serology result has been updated since initial reporting or specimen analysis.

serology zipsero_zip

Captures the postal code associated with the location where a serology specimen was collected or the ordering facility. Used in laboratory data systems to support geographic reporting, specimen logistics, and regional disease surveillance tracking for antibody study results across health networks.

service admission datesvc_admn_dt

Records the date a patient was formally admitted to a facility in connection with a specific clinical service episode, such as inpatient surgery or behavioral health. Used in claims processing and clinical data systems to establish episode timelines, calculate length of stay, and validate billing periods.

service discharge datesvc_dsch_dt

Records the date a patient was formally released from a facility following a specific clinical service episode. Used in claims adjudication, utilization management, and clinical data systems to calculate length of stay, close service episodes, and trigger post-discharge follow-up workflows and billing finalization.

service emergency indicatorsvc_emerg_ind

A flag denoting whether a clinical service was rendered under emergency conditions, typically mapped to place-of-service or type-of-bill codes on claims. Affects reimbursement rates, authorization requirements, and cost-sharing rules for members, and is used in utilization analysis to distinguish emergency from elective care episodes.

service history present illnesssvc_hpi

Contains the clinician-documented narrative describing the onset, duration, and progression of a patient's current condition at the time of a service encounter. Captured in clinical data systems to support diagnosis coding accuracy, medical necessity determination, and continuity of care across treating providers.

service labelsvc_lbl

The human-readable display name assigned to a specific clinical service in scheduling, billing, or clinical data systems. Used to present service types consistently across user interfaces, patient-facing documents, and operational reports, ensuring staff and members can identify the nature of the care activity without interpreting procedural codes.

PreviousPage 631 of 806Next