Back to search
condition medical record number
cond_mrngeneral
Updated 3/30/2026
Definition
The patient medical record number for a medical state or disease. Used as a unique reference to identify and track the condition across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for condition management and reporting.
Standard Abbreviation
cond_mrn
Category
general
Database Usage
-- Example column naming
CREATE TABLE claims (
claim_id VARCHAR(50),
cond_mrn VARCHAR(100), -- condition medical record number
...
);
-- Example in SELECT
SELECT
claim_id,
cond_mrn as condition_medical_record_number
FROM claims;Looking for more healthcare terms?
Browse our complete library of 65,000+ standardized healthcare data terms
Browse All Terms