Back to search
Pneumonia
PNAclinical
Updated 5/16/2026
Definition
A clinical diagnosis code field (PNA) recorded in EHR, claims, and hospital information systems, typically represented by ICD-10 codes such as J18.9. Used in case management, DRG grouping, readmission tracking, and population health analytics across inpatient and outpatient data pipelines.
Standard Abbreviation
PNA
Category
clinical
Database Usage
-- Example column naming
CREATE TABLE claims (
clm_id VARCHAR(50),
pna VARCHAR(100), -- Pneumonia (max 100 chars)
...
);
-- Example in SELECT
SELECT
clm_id,
pna as pneumonia
FROM claims;Common uses in healthcare data
- Risk stratification and population health analytics
- CMS-HCC risk adjustment and RAF score calculation
- Quality measure attribution and HEDIS reporting
- Clinical data warehouse schema design
- Value-based care contract performance tracking
Example database column name
ISO-11179 snake_case standard
-- Recommended column name
pna
-- Example DDL
CREATE TABLE healthcare_data (
record_id VARCHAR(50) NOT NULL,
pna VARCHAR(100), -- Pneumonia (max 100 chars)
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
Looking for more healthcare terms?
Browse our complete library of 100,000+ standardized healthcare data terms
Browse All Terms