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

consent sequencecsnt_seq

The ordinal position number assigned to a consent document within a series of authorizations obtained from a patient during a treatment episode or research protocol. Used in consent management systems to maintain ordered processing of multiple permissions and ensure correct application to related procedures.

consent severitycsnt_sev

The classification of the seriousness of the treatment or procedure for which consent is being obtained, ranging from routine to high-risk interventions. Determines the level of disclosure detail, witness requirements, and administrative review processes applied to the consent documentation workflow.

consent sexcsnt_sex

The biological sex of the patient associated with a consent document, used to ensure accurate patient matching and identity verification. Captures male, female, or other designations as recorded at the time consent was obtained in clinical or administrative workflows.

consent sourcecsnt_src

Identifies the origin system, facility, or channel through which a patient consent document was collected, such as a hospital admission portal, EHR, or telehealth platform. Used to trace consent provenance and support audit and compliance requirements across healthcare settings.

consent start datecsnt_start_dt

The calendar date on which a patient consent document becomes effective and legally valid. Marks the beginning of the authorized period during which the consented activity, such as treatment, data sharing, or research participation, may be carried out in accordance with the patient's wishes.

consent start timecsnt_start_tm

The specific time of day at which a patient consent document becomes effective, recorded alongside the start date to create a precise activation timestamp. Critical for time-sensitive consents such as surgical procedures, anesthesia authorization, or emergency treatment approvals.

consent statecsnt_st

The U.S. state or territory jurisdiction in which a patient consent document was executed or is legally applicable. Used to apply state-specific consent laws and regulations, including those governing minors, mental health disclosures, and reproductive health privacy requirements.

consent statuscsnt_sts

Indicates the current lifecycle state of a patient consent document, such as active, expired, revoked, pending, or superseded. Drives downstream clinical and administrative workflows by determining whether a consent is currently valid and enforceable for its intended purpose.

consent strengthcsnt_str

Describes the scope or level of authorization granted within a patient consent document, such as full consent, limited consent, or conditional consent. Differentiates broad authorizations from narrowly scoped permissions granted for specific procedures, data uses, or treatment categories.

consent subtotalcsnt_subtot

A partial aggregated count or value within a consent management reporting context, representing a subset of consent records grouped by a specific criterion such as consent type, status, or department. Used in operational dashboards and compliance reporting to analyze consent volumes.

consent surgery datecsnt_surg_dt

The scheduled or actual date of the surgical procedure for which a patient consent document was obtained. Links the consent record directly to the operative event, supporting perioperative documentation requirements and confirming that informed consent preceded the procedure.

consent targetcsnt_tgt

Identifies the specific entity, system, department, or recipient that is the subject of the patient's consent authorization, such as a receiving facility, research program, or data sharing partner. Used to define the scope and boundaries of the authorized activity within consent management systems.

consent taxonomy codecsnt_tax_cd

A structured classification code that categorizes a patient consent document by its subject matter or purpose, such as treatment consent, research authorization, or data release. Enables standardized grouping, querying, and reporting of consent records across clinical and administrative systems.

consent temperaturecsnt_temp

Represents the urgency or sensitivity level assigned to a patient consent document, indicating how quickly consent must be obtained or how critical the authorization is to proceeding with care. Used in clinical workflows to prioritize consent collection for emergent or high-risk procedures.

consent termination datecsnt_term_dt

The calendar date on which a patient consent document expires, is revoked, or otherwise ceases to be valid. Defines the end boundary of the consent authorization period and triggers workflow alerts to obtain renewed consent before continuing consented activities or data sharing.

consent timecsnt_tm

The specific time of day at which a patient consent document was signed, witnessed, or formally recorded. Used alongside the consent date to establish a precise moment of authorization, supporting legal documentation requirements and sequencing within clinical event timelines.

consent timestampcsnt_ts

A combined date and time value recording the exact moment a patient consent document was created, signed, or last modified within the healthcare system. Provides a precise audit trail entry essential for legal compliance, medical record integrity, and regulatory review of consent activities.

consent titlecsnt_ttl

The formal name or label assigned to a patient consent document, such as Informed Consent for Surgery, Authorization to Release Medical Records, or Research Participation Agreement. Used to identify and distinguish consent forms within clinical documentation systems and patient records.

consent totalcsnt_tot

The aggregate count or cumulative value of patient consent records within a defined reporting scope, such as all active consents for a facility or program during a given period. Used in compliance tracking, operational reporting, and consent management audits across healthcare systems.

consent total countcsnt_tot_cnt

The complete number of patient consent documents recorded within a specified dataset, time period, or organizational unit. Used in consent management reporting to measure consent collection rates, identify gaps in authorization coverage, and support regulatory compliance audits.

PreviousPage 125 of 806Next