2020-03 HSC COVID unit transition: Difference between revisions

Line 34:

=== data processor instructions ===

The change of [[Service/Location]] will cause [[Orphans in [[~~Centralized data~~.accdb]]]]. Query ''COV_Pat_ID_matcher'' should help with cleanup. You may need to change the parameters H4/H5 to make it work for the respective laptop.

The change of [[Service/Location]] will cause [[Orphans in [[Centralized_data.accdb]]]]. Query ''COV_Pat_ID_matcher'' should help with cleanup. You may need to change the parameters H4/H5 to make it work for the respective laptop.

{{Collapsable

Line 49:

** original remains with renamed location [[HSC_D5_Pre_COVID]], '''negative'' of [[Serial number]] as before, [[Dispo]] will be [[HSC_WRS3]]

** other copy will be [[HSC_WRS3]], same [[Serial number]] as before, [[Previous Location]] will be [[HSC_D5_Pre_COVID]]

** This may resulted in [[Orphans in [[~~Centralized data~~.accdb]]]] for these patients, since the the D5 entry was renamed and therefore the dispo_ID remains the same, but the serial was turned negative. Tina cleaned these up and emailed Pagasa with further info.

** This may resulted in [[Orphans in [[Centralized_data.accdb]]]] for these patients, since the the D5 entry was renamed and therefore the dispo_ID remains the same, but the serial was turned negative. Tina cleaned these up and emailed Pagasa with further info.

==== H4 (old D4) ====

@@ Line 34: / Line 34: @@
 === data processor instructions ===
-The change of [[Service/Location]] will cause [[Orphans in [[Centralized data.accdb]]]]. Query ''COV_Pat_ID_matcher'' should help with cleanup. You may need to change the parameters H4/H5 to make it work for the respective laptop.
+The change of [[Service/Location]] will cause [[Orphans in [[Centralized_data.accdb]]]]. Query ''COV_Pat_ID_matcher'' should help with cleanup. You may need to change the parameters H4/H5 to make it work for the respective laptop.
 {{Collapsable
@@ Line 49: / Line 49: @@
 ** original remains with renamed location [[HSC_D5_Pre_COVID]], '''negative'' of [[Serial number]] as before, [[Dispo]] will be [[HSC_WRS3]]
 ** other copy will be [[HSC_WRS3]], same [[Serial number]] as before, [[Previous Location]] will be [[HSC_D5_Pre_COVID]]
-** This may resulted in [[Orphans in [[Centralized data.accdb]]]] for these patients, since the the D5 entry was renamed and therefore the dispo_ID remains the same, but the serial was turned negative. Tina cleaned these up and emailed Pagasa with further info.
+** This may resulted in [[Orphans in [[Centralized_data.accdb]]]] for these patients, since the the D5 entry was renamed and therefore the dispo_ID remains the same, but the serial was turned negative. Tina cleaned these up and emailed Pagasa with further info.
 ==== H4 (old D4) ====