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

Operations

Scheduling, facilities, departments, workflows, and staff

6,492 operations terms

precertification glucoseprecert_gluc

The blood sugar level for a pre-service authorization. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for precertification management and reporting.

precertification group numberprecert_grp_nbr

The insurance group identifier associated with the member's health plan coverage at the time a pre-service authorization request is submitted. Used to verify eligibility, apply the correct benefit plan rules, and route the precertification to the appropriate utilization management team.

precertification hemoglobinprecert_hgb

The blood hemoglobin level for a pre-service authorization. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for precertification management and reporting.

precertification identifierprecert_id

The unique alphanumeric key assigned to a pre-service authorization record within payer, utilization management, or EHR systems. PRECERT_ID serves as the primary join key for linking authorization records to claims, member enrollment, and clinical encounter data across source systems in healthcare data pipelines.

precertification indexprecert_idx

An ordinal position value assigned to a pre-service authorization within a sequence of multiple authorizations for a member or service episode in utilization management or payer systems. PRECERT_IDX enables data engineers to order, deduplicate, and correctly map authorization records in multi-authorization processing pipelines.

precertification indicatorprecert_ind

A boolean or coded field in payer, EHR, or claims systems denoting the presence or status of a pre-service certification requirement for a specific procedure or service. PRECERT_IND is used by data engineers to segment authorized versus non-authorized claims and to support utilization management reporting and denial analytics.

precertification instructionprecert_instr

Free-text or coded guidance associated with a pre-service authorization, stored in utilization management or payer platforms, outlining clinical criteria, documentation requirements, or submission steps. PRECERT_INSTR is parsed by data engineers to populate decision support tools, provider-facing portals, and authorization workflow automation systems.

precertification keyprecert_key

The primary surrogate or natural key used to uniquely identify a pre-service authorization record within a health plan or utilization management database. Serves as the core lookup reference for joining precertification data across clinical, claims, and member management systems.

precertification languageprecert_lang

The preferred spoken or written language of the patient or requesting party associated with a pre-service authorization. Used to route communications, approval letters, and clinical correspondence in the appropriate language to ensure member comprehension and regulatory compliance.

precertification last nameprecert_last_nm

The family surname of the individual associated with a pre-service authorization request, typically the patient or requesting clinician. Used in combination with other demographic fields to accurately match the precertification to the correct member or provider record.

precertification legal nameprecert_legal_nm

The official registered name of the patient or clinician as it appears on government-issued identification or licensure records, submitted as part of a pre-service authorization. Used to ensure accurate identity verification and compliance with health plan documentation requirements.

precertification levelprecert_lvl

A hierarchical classification value in payer or utilization management systems indicating the tier or complexity category of a pre-service authorization, such as standard, urgent, or expedited review. PRECERT_LVL is used by data engineers to segment authorization workflows, route records, and apply tier-specific adjudication logic in claims processing.

precertification license numberprecert_lic_nbr

The state-issued professional license identifier of the clinician requesting a pre-service authorization. Used by health plans and utilization management organizations to verify that the requesting provider holds valid credentials to order or perform the requested service.

precertification marital statusprecert_mar_sts

The marital or domestic relationship status of the patient at the time a pre-service authorization request is submitted. May be used in coordination of benefits determinations and to identify applicable dependent coverage rules when reviewing the precertification request.

precertification master identifierprecert_mstr_id

The enterprise master patient or provider identifier linked to a pre-service authorization record, used to resolve and match entities across multiple health plan systems. Supports accurate identity resolution when precertification data is shared across claims, enrollment, and clinical platforms.

precertification maximumprecert_max

The upper limit value approved within a pre-service authorization, such as the maximum number of visits, units, doses, or days authorized for a requested service. Used by health plans to enforce benefit limits and flag claims that exceed the approved authorization threshold.

precertification medical record numberprecert_mrn

The facility-assigned medical record number of the patient associated with a pre-service authorization request. Used to link the precertification to the patient's clinical record at the requesting facility, supporting care coordination and claims adjudication workflows.

precertification middle nameprecert_mid_nm

The middle name or initial of the individual associated with a pre-service authorization request. Used to disambiguate patients or clinicians with similar first and last names when matching precertification records across health plan enrollment and provider credentialing systems.

precertification minimumprecert_min

The lower limit value specified within a pre-service authorization, such as the minimum number of units, doses, or days required before a service can proceed. Used in utilization management to establish baseline thresholds for clinical necessity criteria and authorization compliance.

precertification mobileprecert_mob

The mobile phone number of the patient or requesting clinician associated with a pre-service authorization. Used by health plans and utilization management teams to send real-time authorization status updates, missing documentation alerts, and approval notifications via SMS or voice outreach.

PreviousPage 174 of 325Next