Populate linking pairs: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
|||
| Line 5: | Line 5: | ||
* click the "populate linking_pairs" button on the main screen | * click the "populate linking_pairs" button on the main screen | ||
**2018-Apr-27: NOTE: takes 16 minutes to run | **2018-Apr-27: NOTE: takes 16 minutes to run | ||
{{Discuss | who = All | question = * Pagasa, how long does this take at this point?}} | |||
* After this is done, move on to [[Quality Assurance queries in CFE]] | |||
== Implementation == | == 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''. | 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''. | ||
{{Discuss | who = Tina | question = * what table is this actually stored in?}} | |||
== Related articles == | |||
{{Related Articles}} | |||
[[Category: Data Processing]] | [[Category: Data Processing]] | ||
[[Category: Multiple encounter longitudinal consistency check|*]] | |||
Revision as of 02:15, 27 October 2018
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
- 2018-Apr-27: NOTE: takes 16 minutes to run
- After this is done, move on to Quality Assurance queries in CFE
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.
