Manitoba Health "Conditioner": Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) |
TOstryzniuk (talk | contribs) |
||
| Line 15: | Line 15: | ||
{{Discussion}} | {{Discussion}} | ||
==November 19.08 PROBLEM== | ==November 19.08 PROBLEM== | ||
Problem: Conditioner Program | 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 in hopes to obtain Hosp mortality data. | *October 10.08 - The EXCEL Batch sent to MHSC for crosschecking: included a few more columns of data: admit and discharge. Purpose was in hopes to obtain Hosp mortality data. | ||
*The EXCEL files returned from MHSC (Med'''X'''out.xls and ICU, '''AV'''out.xls) we noted that our original DOB column 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. | *The EXCEL files returned from MHSC (Med'''X'''out.xls and ICU, '''AV'''out.xls) we noted that our original DOB column 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. | ||
Revision as of 19:01, 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.
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 required corrections in our Master ICU/Medicine Master Database.
- highlights changes needed in red.
Who dunit?
- developed by Julie. Tina provided a few other enhancements.
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 in hopes to obtain Hosp mortality data.
- The EXCEL files returned from MHSC (MedXout.xls and ICU, AVout.xls) we noted that our original DOB column 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: