|Data Element (edit)|
|CCMDB tab:||Top Row|
|Table:||L_Log table, L_PHI table|
|Program:||Med and CC|
The number used by medical records to uniquely identify a patient's chart; it is different for the same patients at different hospitals.
The number is assigned to a patient by Admitting. This is done once the patient has been seen by Triage in ER or new to the hospital for clinics, testing and various workups. This number remains the patient's chart number for all hospital visits, admissions, tests, etc.
If your chart number system uses leading zeros, don't enter the leading zeros, start with the first non-zero number.
Dashes near the end of the number
EPR sometimes lists something like MRN 123456-1; in that case, we code 1234561, i.e. leave out the dash, but code the trailing number.
Unclear or changing chart numbers
Minimal Data Set
This entry is part of the Minimal Data Set. Special collection instructions apply, see that page for more info.
The Centralized_data_front_end.accdb has queries that make sure that the chart number for each Hospital site is the same for the same patient and make sure the chart number has valid format.
In addition, the Statistician uses SAS to check key identifiers so they are consistent for same patient including Hosp chart etc.
L_PHI vs L_Log
Data Integrity Checks (SMW)
|Query check minimal data set incomplete||CCMDB.accdb||implemented|
|Function Validate Chart||CCMDB.accdb||implemented|
|Check duplicate patient||CCMDB.accdb||implemented|
|Function PHIN same as Chart||CCMDB.accdb||implemented|
|PL Chart 9 Digit||Centralized data front end.accdb||implemented|
|PL SameCHART Site Diff PHIN||Centralized data front end.accdb||implemented|
|PL SamePHIN Site Diff chart||Centralized data front end.accdb||implemented|