Back to search

effective last name

eff_last_nm
general
Updated 3/30/2026

Definition

The family surname for a coverage start validity. Used to display and describe the effective in a human-readable format. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for effective management and reporting.

Standard Abbreviation

eff_last_nm

Category

general

Database Usage

-- Example column naming
CREATE TABLE claims (
  claim_id VARCHAR(50),
  eff_last_nm VARCHAR(100),  -- effective last name
  ...
);

-- Example in SELECT
SELECT 
  claim_id,
  eff_last_nm as effective_last_name
FROM claims;

Looking for more healthcare terms?

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

Browse All Terms