Manitoba Health "Conditioner": Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) |
TOstryzniuk (talk | contribs) mNo edit summary |
||
| Line 4: | Line 4: | ||
*Is an ACCESS program | *Is an ACCESS program | ||
**note: this conditioner has nothing to do with hair products okay. | **note: this conditioner has nothing to do with hair products okay. | ||
==Where do you find it?== | |||
*X:\CCMDB_ADMIN_DATABASE\MB_Health_Records_Cleaning\MB Health Conditioner.mdb | |||
*Backup copy: | |||
**X:\CCMDB_ADMIN_DATABASE\MB_Health_Records_Cleaning\Others_backup_folder\Pagasa_don't_touch_MB Health Conditioner.mdb | |||
***the Pagasa don't touch copy fixes columns that are printing outside page size. | |||
==What Does it do?== | ==What Does it do?== | ||
| Line 25: | Line 31: | ||
*hopefully the next batch we send to MHSC will be returned without this problem. | *hopefully the next batch we send to MHSC will be returned without this problem. | ||
== | |||
==Instruction on how to reformat database DOB column in EXCEL for this problem== | |||
Revision as of 19:35, 19 November 2008
The Manitoba Health (MHSC) "Conditioner"
What is it?
- Is an ACCESS program
- note: this conditioner has nothing to do with hair products okay.
Where do you find it?
- X:\CCMDB_ADMIN_DATABASE\MB_Health_Records_Cleaning\MB Health Conditioner.mdb
- Backup copy:
- X:\CCMDB_ADMIN_DATABASE\MB_Health_Records_Cleaning\Others_backup_folder\Pagasa_don't_touch_MB Health Conditioner.mdb
- the Pagasa don't touch copy fixes columns that are printing outside page size.
- X:\CCMDB_ADMIN_DATABASE\MB_Health_Records_Cleaning\Others_backup_folder\Pagasa_don't_touch_MB Health Conditioner.mdb
What Does it do?
- automates the process of identifying corrections to key patient identifiers (PHIN, LN, FN, DOB & Gender) from an EXCEL file that is sent every few months to MHSC for crosschecking purposes and is returned with matches that require corrections in our Master ICU/Medicine Master Database.
- highlights corrections that are needed in red.
Who dunit?
- developed by Julie. Tina provided a few other enhancements (conditional formatting for color).
November 19.08 PROBLEM
PROBLEM:
- Conditioner Program no longer reading the MHSC output EXCEL file correctly, specifically our DOB data column.
- October 10.08 - The EXCEL Batch sent to MHSC for crosschecking: included a few more columns of data: admit and discharge. Purpose was to hopefully allow us to obtain Hosp mortality data if available.
- The EXCEL files returned from MHSC (MedXout.xls and ICU, AVout.xls) we noted that in our original DOB column, the format was changed from M/D/YYYY to YYYY-M-D. Because of this, the "Conditioner Program" could not read the file properly and was reporting error for all DOB data.
REPAIR SOLUTION:
- Julie will advise the contact person at MHSC about format change on the output file. We want to retain same DOB format for our original DOB column of data.
- In the mean time we reformatted our DOB data column back to the D/M/YYYY format and Conditioner Program worked.
- hopefully the next batch we send to MHSC will be returned without this problem.