Each kind of fact in health data has its own code set:
- ICD-10-CM: diagnoses, on every encounter and claim (CDC and CMS, public).
- ICD-10-PCS: procedures on inpatient hospital stays (CMS, public). Seven characters, no dot.
- CPT: services billed by physicians and outpatient departments (owned by the American Medical Association, licensed). HCPCS Level II: supplies, equipment, some drugs and services CPT does not cover (CMS, public).
- NDC: drug products, down to the package (FDA). RxNorm: normalized drug names that link products of the same drug (National Library of Medicine).
- LOINC: lab tests and clinical observations (Regenstrief Institute).
- SNOMED CT: the clinical terms behind problem lists (free in the US under a National Library of Medicine license).
Cedar Ridge stores ICD-10-CM in hd_diagnoses.icd10_code and ICD-10-PCS in hd_procedures.procedure_code. hd_labs.test_code is a local code, not LOINC, and medications carry generic names, not NDC codes. CPT is licensed, so this course shows no CPT codes.
One code set per kind of fact.