Back to search
disease preferred name
dis_pref_nmgeneral
Updated 3/30/2026
Definition
The chosen display name for a pathological condition. Used to display and describe the disease in a human-readable format. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for disease management and reporting.
Standard Abbreviation
dis_pref_nm
Category
general
Database Usage
-- Example column naming
CREATE TABLE claims (
clm_id VARCHAR(50),
dis_pref_nm VARCHAR(100), -- disease preferred name
...
);
-- Example in SELECT
SELECT
clm_id,
dis_pref_nm as disease_preferred_name
FROM claims;Common uses in healthcare data
- Healthcare data warehouse schema design and modeling
- Interoperability and cross-system data exchange
- ETL pipeline development and orchestration
- Master data management (MDM) programs
- Analytics and business intelligence reporting
Example database column name
ISO-11179 snake_case standard
-- Recommended column name
dis_pref_nm
-- Example DDL
CREATE TABLE healthcare_data (
record_id VARCHAR(50) NOT NULL,
dis_pref_nm VARCHAR(255), -- disease preferred name
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.
Related Content
Related Definitions
Try the Tool
Browse GlossaryLooking for more healthcare terms?
Browse our complete library of 100,000+ standardized healthcare data terms
Browse All Terms