Populate linking pairs: Difference between revisions

mNo edit summary
Line 37: Line 37:
Clean our only those pairs that are questionable:
Clean our only those pairs that are questionable:
* find all records whose pairs have non-consecutive (admit dttms)  
* find all records whose pairs have non-consecutive (admit dttms)  
** need to admit this with the old style admit dttm included so the wholsale recreation will still work
** need to admit this with the old style admit dttm included so the wholesale recreation will still work
* remove all pairs related to those patients (ie have same PHIN)(easier than figuring out which to remove)
* remove all pairs related to those patients (ie have same PHIN)(easier than figuring out which to remove)
* remove all pairs where a pair-less profile is present for the same phin
* remove all pairs where a pair-less profile is present for the same phin
** this would include old single encounters (57% of our records are single encounters)


Run the populate linking code, but run it only for profiles that aren't in pairs
Run the populate linking code, but run it only for profiles that aren't in pairs
* run the linking pairs updater only for profiles that don't have  
* run the linking pairs updater only for profiles that don't have


== Related articles ==
== Related articles ==