Populate linking pairs: Difference between revisions
Jump to navigation
Jump to search
| Line 4: | Line 4: | ||
* be sure you have completed [[Pre-linking checks]] | * be sure you have completed [[Pre-linking checks]] | ||
* click the "populate linking_pairs" button on the main screen | * click the "populate linking_pairs" button on the main screen | ||
** | **2019-Feb-07: NOTE: takes ~08 minutes to run | ||
* After this is done, move on to [[Correcting suspect links]] | * After this is done, move on to [[Correcting suspect links]] | ||
Revision as of 11:09, 7 February 2019
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
- 2019-Feb-07: NOTE: takes ~08 minutes to run
- After this is done, move on to Correcting suspect links
Implementation
Because MS Access doesn't have functionality to compare data in a "current" to a "next" record this is implemented as an iterative process in Module linking Sub populate_linking_pairs which populates the linking_pairs table.