Instructions for exporting data using MCHP Export.accdb: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
|||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 26: | Line 26: | ||
* [[MCHP Export.accdb]] : before 2020-05-05, the exported file contains from the beginning of the database to the current time. Starting 2020-05-05, the data file being sent start always from 2019-01-01 to current. | * [[MCHP Export.accdb]] : before 2020-05-05, the exported file contains from the beginning of the database to the current time. Starting 2020-05-05, the data file being sent start always from 2019-01-01 to current. | ||
* [[PHI.mdb]] contains always from the beginning of the database to current. | * [[PHI.mdb]] contains always from the beginning of the database to current. | ||
==== Temporary instruction ==== | ==== Temporary instruction re:[[LAU Collection Project]] ==== | ||
* 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 [[LAU Collection 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 === | ||
| Line 62: | Line 63: | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category: MCHP]] | [[Category:MCHP]] | ||