physician effective date

phys_eff_dt

provider

Updated 5/16/2026

Definition

The date on which a physician's record, contract, network participation, or credential becomes active within a healthcare system. Used in payer enrollment, provider directory management, and EHR systems to control claims eligibility, fee schedule application, and in-network status determination.

Standard Abbreviation

phys_eff_dt

Database Usage

-- Example column naming
CREATE TABLE claims (
  clm_id VARCHAR(50),
  phys_eff_dt DATE,  -- physician effective date (date only, no time)
  ...
);

-- Example in SELECT
SELECT
  clm_id,
  phys_eff_dt as physician_effective_date
FROM claims;

Common uses in healthcare data

Provider data management and credentialing workflows
Network adequacy analysis and directory accuracy
NPI validation and NPPES registry reconciliation
Provider master data management (MDM)
Payer-provider contract and fee schedule management

Example database column name

ISO-11179 snake_case standard

-- Recommended column name
phys_eff_dt

-- Example DDL
CREATE TABLE healthcare_data (
  record_id   VARCHAR(50)   NOT NULL,
  phys_eff_dt  DATE,  -- physician effective date (date only, no time)
  created_dt  TIMESTAMP     NOT NULL DEFAULT NOW()
);

Column names follow the ISO-11179 naming convention: lowercase, underscore-separated, using the standard abbreviation as a prefix where applicable.

Looking for more healthcare terms?

Browse our complete library of 100,000+ standardized healthcare data terms

Browse All Terms