Manitoba Health "Conditioner"

From CCMDB Wiki
Jump to navigation Jump to search

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.


Template:Discussion

November 19.08 PROBLEM

Problem: Conditioner Program not 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:

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Manitoba_Health_%22Conditioner%22&oldid=4435"