Change in patient identifier
2 posters
Page 1 of 1
Change in patient identifier
this is the scenario:
in staging I have a patient table with identifier MRN. Also have an admissions table with account Number and MRN.
in the warehouse, I have a patient dimension with MRN and an admission fact table with account Number.
Issue:
patient comes into staging with incorrect MRN, thus it is loaded, along with demographics to the Patient_D and the fact table is loaded with the correct account number but incorrect patient key.
the error is corrected, and into staging comes the same patient with a new MRN and the admission data with the correct account number, MRN.
now to fix the previously, incorrectly entered fact.
I can add the patient again to the patient_D, but unless I try some algorithm to match the previous record (match on name, DOB, SSN....this is not foolproof at all), I can't 100% identify it to give it a new version number, or to update it. So is it best just to add the new record (patient is entered twice) and just correct the admission fact record with an update to the correct MRN. The problem is that the patient_d has duplicates in it and then reporting on patient volumes would have to go through the account_fact table at all times. Is this the best way to go with this?
thanks
Jeff
in staging I have a patient table with identifier MRN. Also have an admissions table with account Number and MRN.
in the warehouse, I have a patient dimension with MRN and an admission fact table with account Number.
Issue:
patient comes into staging with incorrect MRN, thus it is loaded, along with demographics to the Patient_D and the fact table is loaded with the correct account number but incorrect patient key.
the error is corrected, and into staging comes the same patient with a new MRN and the admission data with the correct account number, MRN.
now to fix the previously, incorrectly entered fact.
I can add the patient again to the patient_D, but unless I try some algorithm to match the previous record (match on name, DOB, SSN....this is not foolproof at all), I can't 100% identify it to give it a new version number, or to update it. So is it best just to add the new record (patient is entered twice) and just correct the admission fact record with an update to the correct MRN. The problem is that the patient_d has duplicates in it and then reporting on patient volumes would have to go through the account_fact table at all times. Is this the best way to go with this?
thanks
Jeff
jmather- Posts : 6
Join date : 2011-04-26
Age : 66
Location : Hartford, CT
Re: Change in patient identifier
Isn't there a claim or admissions document number associated with the fact?
Re: Change in patient identifier
there's an account number in the admission_f
jmather- Posts : 6
Join date : 2011-04-26
Age : 66
Location : Hartford, CT
Similar topics
» Change Data Capture
» Patient Re-admission Measure (count)
» how to get reason for change information
» Best practices for a Fact table that contains a row per date/hour/location/patient stay
» Much ado about overlapping type 2 change
» Patient Re-admission Measure (count)
» how to get reason for change information
» Best practices for a Fact table that contains a row per date/hour/location/patient stay
» Much ado about overlapping type 2 change
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum