Populate linking pairs

As part of vetting CFE needs to pair up any records for the consecutive/continuous admission of a patient.

Instructions

be sure you have completed Pre-linking checks
click the "populate linking_pairs" button on the main screen
- this takes ~3 minutes to run (as of 2021-08-04)
After this is done, move on to Correcting suspect links

click expand to see implementation details
Because MS Access SQL doesn't have functionality to compare data in a "current" to a "next" record this is implemented as an iterative process in VBA in Module linking Sub populate_linking_pairs which populates the linking_pairs table. The process considers the output of Query linking_pairs_preList, which contains records that are not in linking_pairs table, and that have more than one instance of a PHIN. After these are linked, if there are any non-sequential entries in linking pairs, these are deleted by Query linking_pairs_out_of_sequence/linking_pairs_out_of_sequence_deleter, and then their entries are recreated. That happens until all are sequential. Scenarios Two things will make a record require a pairs update: a new record is added (the >95% case) an older record(s) is changed, requiring a re-alignment (the <2% case) a collector catches up with backlog, and 2 records that had already been linked 1-3 need to be re-linked to 1-2-3 (the 3% case)