A chart opens on the banner, the lines that identify the patient on every screen:
- MRN, the medical record number. Staff use it to find the chart; it is on wristbands and labels. In the database,
patient_id is a separate key that joins the tables, and nobody on the ward sees it.
- DOB, the date of birth, and the age. Cedar Ridge shows age on 1 July 2026, the day the data was pulled: subtract the birth year, then take one off if the birthday comes later in the year.
- Payer, the main insurance, and Primary care, the patient's own doctor for routine care.
Below the banner are four sections, each from its own table: Encounters (every visit and stay), Diagnoses (the codes on those encounters), Medications and Results (lab tests).
Count what the chart shows row by row: an emergency visit and the admission that followed it are two encounters, even on the same date, and a test repeated on another day is a second result.
Two identifiers with two jobs.