Provider

A risk-adjusted measure of a healthcare provider resource utilization and total cost of care relative to peer providers treating similar patient populations, used in value-based payment programs and network tiering decisions to identify high and low value providers. Cost efficiency scores account for differences in patient complexity using risk adjustment models to ensure fair comparisons across providers treating different patient mix compositions. Providers with lower risk-adjusted costs while maintaining quality standards are identified as high-efficiency providers eligible for preferred network tier placement and efficiency bonuses. Healthcare data teams build cost efficiency measurement pipelines that calculate provider-attributed total cost of care from claims, apply episode grouper or prospective risk adjustment methodologies, compare provider costs against peer benchmarks, and produce efficiency scores used in value-based contract settlement, network tiering, and provider engagement analytics.

Numeric aggregate of provider records meeting specific criteria within claims, network, or eligibility datasets. Used by data engineers for network adequacy reporting, panel size analysis, and quality metric denominators across EHR, payer, and managed care systems.

The country where a healthcare provider's practice location or mailing address is situated. Used in provider demographic and credentialing systems to support network management, international claims adjudication, and compliance with country-specific licensing and regulatory requirements.

The county or county-equivalent geographic area in which a healthcare provider primary practice location is situated, used in network adequacy analysis and geographic access to care measurement. County is a critical geographic unit for Medicare Advantage network adequacy because CMS evaluates provider access at the county level in service area filings. Rural counties often have fewer providers per capita, creating network adequacy challenges that require health plans to establish exception processes or telehealth alternatives. Healthcare data teams use prvdr_cnty with FIPS county codes as VARCHAR(5) in network adequacy models, joining provider location data to CMS county-level standards tables to identify gaps in specialty access, and in population health analytics to correlate provider supply with member health outcomes across geographic areas.

The system username or user identifier of the individual who originally entered the provider's record into the healthcare data system. Used for data governance, audit trail management, and accountability tracking within provider enrollment, credentialing, and network management platforms.

Timestamp indicating when a provider record was originally created within a provider master, credentialing, or network management system. Critical for data engineers performing audit trails, change data capture, and longitudinal tracking of provider lifecycle events across EHR and payer platforms.

The timestamp recording when a provider's record was first created in the healthcare data system. Used in provider enrollment and credentialing workflows to establish record provenance, support audit logging, and track the lifecycle of provider data from initial entry through updates and termination.

A professional qualification, certification, or designation earned by a healthcare provider through completion of accredited training programs, examination, and continuing education requirements, demonstrating competency in a defined scope of clinical practice. Provider credentials include academic degrees such as MD, DO, NP, PA, and PharmD, professional licenses issued by state boards, board certifications from specialty organizations, and additional certifications for specific clinical competencies. Credentials are the foundation of provider credentialing processes and must be verified through primary sources during initial credentialing and recredentialing. Healthcare data teams maintain provider credential records with credential type, issuing organization, issue date, expiration date, and verification status in credentialing systems, track credential renewals to prevent network participation lapses due to expired credentials, and produce credential inventory reports for NCQA accreditation documentation.

The formal process through which a health plan or healthcare organization verifies and assesses the qualifications, training, licensure, experience, and professional standing of a healthcare provider prior to granting network participation or clinical privileges. Credentialing involves primary source verification of medical school graduation, residency and fellowship training, board certification, state licensure, DEA registration, malpractice history, hospital privileges, and sanctions history. NCQA, URAC, and The Joint Commission establish credentialing standards that health plans must meet for accreditation. The credentialing process typically takes 60 to 90 days and must be completed before providers can treat members as in-network. Healthcare data teams build credentialing workflow systems that track application status, document collection, verification completion, committee approval dates, and expiration dates for credentials requiring periodic renewal.

A coded value indicating the current stage or outcome of a healthcare provider credentialing process within a health plan or healthcare organization credentialing workflow. Common credentialing status values include application received for providers who have submitted initial paperwork, pending verification for applications in active primary source verification, pending committee review for completed files awaiting medical staff or credentialing committee approval, approved for providers who have completed credentialing and been granted network participation, denied for applications that did not meet credentialing standards, and expired for providers whose credentialing period has lapsed without recredentialing completion. Healthcare data teams use prvdr_credntl_sts in provider network management systems to track pipeline volume, identify bottlenecks in the credentialing workflow, prevent premature network activation before approval, and generate compliance reports for NCQA credentialing accreditation surveys.

A flag or indicator identifying the most recent or active version of a provider record in a healthcare data system. Used in provider data warehouses implementing slowly changing dimension patterns to distinguish current provider information from historical versions.

Business-context date associated with a provider record within eligibility and enrollment systems, representing effective dates, panel assignment dates, or contract start dates. Used by data engineers to enforce date-range logic, validate member-provider assignments, and support temporal reporting across payer platforms.

Combined date and time timestamp associated with a provider-related event or transaction within EHR, claims, or credentialing systems. Used by data engineers for precise event sequencing, audit logging, change data capture pipelines, and resolving data conflicts in near-real-time healthcare data environments.

The doing business as name under which a healthcare provider or organization operates publicly, which may differ from the legal entity name registered with the IRS or state licensing board. DBA names are common when healthcare organizations operate multiple clinics or practices under a brand name distinct from their legal corporate name. CMS NPPES allows providers to register DBA names alongside their legal name in the NPI registry. Healthcare data teams maintain prvdr_dba_nm in provider master data tables to support member-facing provider directory accuracy, network adequacy reporting, and claims matching workflows where the billing name on a claim may reflect the DBA rather than the legal entity name, enabling correct provider identity resolution across disparate source systems.

The unique registration number issued by the Drug Enforcement Administration authorizing a licensed provider to prescribe, dispense, or administer controlled substances. Captured in provider credentialing and pharmacy systems to validate prescribing authority and ensure regulatory compliance with DEA scheduling requirements.

Date of death for a licensed healthcare professional recorded in provider master, credentialing, and NPPES registry systems. Used by data engineers to inactivate provider records, prevent fraudulent claim submissions, and maintain accurate provider lifecycle histories in payer and EHR platforms.

An indicator identifying that a healthcare provider or organization has been debarred from participation in federal government contracts and programs, including Medicare, Medicaid, and other federally funded healthcare programs. Debarment is listed in the System for Award Management database maintained by the General Services Administration. Healthcare organizations are legally prohibited from contracting with debarred entities for federally funded services. Debarment differs from OIG exclusion in that it applies to federal contracting broadly rather than specifically to healthcare programs, though the practical effect on healthcare providers is similar. Healthcare data teams integrate SAM.gov debarment screening into provider credentialing and ongoing monitoring workflows, running automated checks monthly against the provider roster to detect newly debarred entities and generate compliance alerts for immediate contract review and potential network termination.

The dollar amount applied toward a member's annual deductible from a claim associated with a specific provider. Used in claims adjudication and member cost-sharing calculations to accurately track deductible accumulation and determine the correct provider payment after member liability is applied.

A coded value identifying the highest academic or professional degree earned by a healthcare provider from an accredited educational institution, designating the provider educational level and professional category. Common provider degree codes include MD for Doctor of Medicine, DO for Doctor of Osteopathic Medicine, NP for Nurse Practitioner with masters or doctoral preparation, PA for Physician Assistant, PharmD for Doctor of Pharmacy, DDS or DMD for dental degrees, PhD for doctoral research degrees, and MSW or LCSW for social work credentials. Provider degree drives scope of practice determinations, prescribing authority, and billing eligibility for certain service types. Healthcare data teams use prvdr_deg_cd in provider master data to classify providers by educational level, apply correct credentialing standards by degree category, validate billing code eligibility based on provider degree and scope of practice, and produce provider workforce analytics stratified by degree type across the network.

The calendar date on which a provider's record was logically removed or deactivated within the healthcare data system. Used in provider network management and credentialing platforms to maintain historical accuracy, support audit trails, and prevent deleted records from appearing in active provider directories or claims routing.