Instructions for exporting data using MCHP Export.accdb: Difference between revisions
| Line 28: | Line 28: | ||
==== Temporary instruction ==== | ==== Temporary instruction ==== | ||
* starting 2025-03-01, Non-medicine wards or Lower Acute units [[LAU]] have been collected as a temporary project and incorporated into [[CCMDB.accdb]]. These records need to be excluded manually from the export files before sending. | * starting 2025-03-01, Non-medicine wards or Lower Acute units [[LAU]] have been collected as a temporary project and incorporated into [[CCMDB.accdb]]. These records need to be excluded manually from the export files before sending. | ||
** How? create a sub-folder under the S:\MED\MED_CCMED\CCMDB_Special_Projects\MCHP and label it by yyyy-mm-dd (the date when the export files were done. Copy the [[MCHP Export.accdb]] and the [[PHI.mdb]] from the desktop | ** How? create a sub-folder under the S:\MED\MED_CCMED\CCMDB_Special_Projects\MCHP and label it by yyyy-mm-dd (the date when the export files were done). Copy the [[MCHP Export.accdb]] and the [[PHI.mdb]] from the desktop into the sub-folder. | ||
Similarly open [[PHI.mdb]] | *** Open the [[MCHP Export.accdb]] and click L_LOG_MCHP table. Filter those records having service location with loc_type LAU or right click any record under [[D ID field]] and choose '''text filters contains LAU''' ). Then delete them all and consequently the related tables should clear out as well. | ||
* End date: | *** Similarly open [[PHI.mdb]] and click L_PHI table. Filter those records by right clicking any record under [[D ID field]] and choose '''text filters contains LAU'''. Then delete them all. | ||
* End date: none yet | |||
=== sending === | === sending === | ||