Provider

A flag identifying that a provider's record has been logically deactivated or removed from active use within the healthcare data system. Used in provider network and credentialing systems to suppress inactive records from directory searches, claims routing, and eligibility transactions without permanently purging historical data.

Human-readable text field describing a provider's role, specialty, or organizational context within provider master, network, and claims systems. Used by data engineers to populate provider directories, support search and filtering logic, and enrich downstream analytics and reporting datasets.

Granular-level information associated with a provider record within EHR, claims, or credentialing systems, including specialty, licensure, and affiliation data. Used by data engineers to populate provider master tables, support adjudication logic, and enable detailed provider-level analytics across payer platforms.

Date a provider's patient was formally discharged from an inpatient or facility-based episode, captured in EHR, UB-04 claims, and hospital billing systems. Used by data engineers to calculate length of stay, validate claim spans, and support episode-of-care analytics in payer and clinical datasets.

The date by which a payment, document submission, or required action associated with a provider must be completed. Used in claims payment processing, credentialing renewals, and contract management workflows to enforce deadlines, trigger reminders, and track compliance with payer or regulatory obligations.

The measured length of time associated with a provider's service delivery, contract period, credentialing cycle, or network participation. Used in care management, claims analysis, and provider network reporting to quantify engagement periods and support utilization management and performance measurement workflows.

The date on which a provider record, contract, or network participation becomes active in a healthcare payer system. Used in provider network management, claims adjudication, and directory accuracy to determine when a provider is eligible to receive in-network reimbursement.

Date when a provider's participation, contract, or credential becomes active within EHR, claims, and provider master systems. Used by data engineers to filter valid provider records, enforce referential integrity, and support SCD Type 2 tracking in provider dimension tables.

The Employer Identification Number assigned by the Internal Revenue Service to healthcare organizations including hospitals, medical groups, clinics, and health systems for federal tax identification purposes. The EIN is a nine-digit number in the format XX-XXXXXXX and serves as the primary tax identifier for organizational healthcare providers on Medicare and Medicaid claims, W-9 forms, and 1099-MISC tax reporting. CMS requires providers to maintain current EIN registrations to receive Medicare reimbursement. Healthcare data teams use prvdr_ein to link provider billing records to organizational tax entities, validate provider identity during credentialing workflows, detect billing anomalies where multiple organizations share an EIN, and support payment integrity analytics comparing billing patterns across provider tax entities.

Electronic mail address associated with a licensed healthcare provider, stored in provider master, credentialing, and directory systems. Used by data engineers for provider outreach integrations, roster file validation, and matching provider contact records across EHR and payer platforms.

A flag designating that a provider rendered services under emergency conditions, bypassing standard referral or prior authorization requirements. Used in claims adjudication to apply appropriate benefit exceptions, ensure correct reimbursement rates, and comply with state and federal emergency care coverage mandates.

Date marking the conclusion of a provider's active participation period within a network, contract, or credentialing record in EHR, claims, and payer systems. Data engineers use this field to expire provider dimension records, enforce SCD logic, and filter out inactive providers in analytics pipelines.

The specific time at which a provider concluded delivering a healthcare service during an encounter or procedure. Captured in claims, scheduling, and clinical documentation systems to calculate service duration, support accurate billing for time-based procedure codes, and enable operational reporting on provider capacity and workflow efficiency.

The process and status of a healthcare provider being registered and approved to participate in a government or commercial health insurance program to receive reimbursement for covered services. Provider enrollment encompasses Medicare and Medicaid enrollment through CMS PECOS and state Medicaid enrollment systems, commercial health plan credentialing and contracting, and facility enrollment processes. Providers must complete enrollment before claims can be paid and must maintain enrollment by complying with revalidation requirements. CMS mandates Medicare provider revalidation every five years. Healthcare data teams build provider enrollment pipelines that track enrollment application status, approval dates, revalidation due dates, and enrollment gaps that affect claims payment eligibility across Medicare, Medicaid, and commercial payer systems.

The current state of a provider's enrollment with a payer, government program, or health network, such as pending, active, suspended, or terminated. Used in provider management and claims adjudication systems to determine eligibility for reimbursement and validate that providers meet credentialing and participation requirements before processing claims.

The username or identifier of the individual who manually keyed or submitted a provider-related record or transaction into the healthcare data system. Captured for audit and data governance purposes in provider enrollment, claims entry, and credentialing platforms to trace data origin and support error resolution workflows.

The self-reported or recorded ethnic background of a healthcare provider. Collected in provider demographic and workforce data systems to support healthcare equity initiatives, diversity reporting, network composition analysis, and compliance with federal and state workforce monitoring requirements for provider organizations and health plans.

An indicator identifying that a healthcare provider has been excluded from participation in Medicare, Medicaid, and other federal healthcare programs by the Office of Inspector General or CMS due to fraud, abuse, patient harm, felony convictions, or other disqualifying conduct. Excluded providers are listed on the OIG List of Excluded Individuals and Entities. Health plans and healthcare organizations that employ or contract with excluded providers risk substantial civil monetary penalties. Exclusions may be mandatory for certain offenses or permissive at OIG discretion for other violations. Healthcare data teams implement automated exclusion screening workflows that check provider rosters against the OIG LEIE and state exclusion lists monthly, generate real-time alerts when newly excluded providers are identified in the network, and maintain exclusion screening audit logs to demonstrate compliance during CMS program integrity audits.

The date on which a provider record, contract, or network participation expires or becomes inactive in a healthcare payer system. Used in provider network management and claims adjudication to identify terminated providers and prevent in-network payment after contract expiration.

Date on which a provider's credential, license, contract, or network participation record becomes invalid within credentialing, EHR, and payer enrollment systems. Data engineers use this to trigger alerts, suppress expired providers from active rosters, and maintain accurate provider validity windows in downstream reporting.