2020-03 HSC COVID unit transition: Difference between revisions

** [[HSC_D5_Pre_COVID]] to [[HSC_D5_P]]

** [[HSC_D4_COVID]] to [[HSC_D4_C]]

* Once the last of these is sent we can name them back to their longer, more expressive versions. }}

* deactivate HSC_D4_P / HSC_D5_P in [[s_tmp table]] once last pt has moved. }}

** original will remain with renamed location [[HSC_D4_pre_COVID]], '''negative'' of [[Serial number]] as before, [[Dispo]] will be [[HSC_D5]]

** other copy will be [[HSC_D5]], same [[Serial number]] as before, [[Previous Location]] will be [[HSC_D4_pre_COVID]], [[Accept_DtTm]] blank and [[Arrive_DtTm]] blank

** This may result in [[Orphans in Centralized data.mdb]] 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 will discuss with Pagasa }}