If you are admitted to any of the 180 hospitals in our state you are given
what should be a MRN (Medical Record Number). You would retain this number
at this hospital for life. If you go to another hospital you would recieve a
different MRN for that hospital ID. IF you are readmitted to any of these
hospitals you would have the same MRN that hospital originally gave you Some
one at hospital 98768 could have the same MRN that you have at hospid 96300
Field Mkey unique identifier
Field Hospid 5 digit code
Field MRN 7 digit not unique to hospid (multiple admitance and discharge)
I would like to examine the MRN's with multiple admittances to each hospid
how would I group by hospid and MRN to find dups at that hospid?
Hope this doesn't confuse you as much as it does me!