Populate linking pairs: Difference between revisions

Line 35: Line 35:
* delete any non-consecutive records
* delete any non-consecutive records
* add any new records
* add any new records
{{Todo
| who = Tina
| todo_added = 2021-08-03
| todo_action = 2021-08-03
| question = I still need to document the new process properly, e.g. [[Query linking_pairs_preList]], [[Query linking_pairs_LatestLinkedPHINAdmit]]
[[Query linking_pairs_multis]]
[[Query linking_pairs_out_of_sequence/linking_pairs_out_of_sequence_deleter]]
[[Query linking_pairs_unlinkeds]]
}}


{{Collapsable  
{{Collapsable  
Line 47: Line 58:
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
Second draft.  
Second draft.  
* Find every D_ID not in [[Linking pairs table]], and delete all other/existing records from [[Linking pairs table]] for that PHIN  
* Find every D_ID not in [[Linking pairs table]], and delete all other/existing records from [[Linking pairs table]] for that PHIN