Manitoba Health "Conditioner"

The Manitoba Health (MHSC) "Conditioner" Program

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_DONT_TOUCH_MB Health Conditioner.mdb
    • in the "Pagasa DONT TOUCH copy" we fixed columns so that they are don't print outside page size.
    • previous backup copy that works is called "JAN 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).

Template:Discussion

November 19.08

PROBLEM:

• Conditioner Program is 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.

Instruction: Changing DOB format of OUR DOB column- for MHSC output.xls

• to change our DOB column format which was returned from MHSC as YYYY-M-D to M/D/YYYY format

• This instruction is only for this batch of MHSC output data (ICU_AVout.xls & MedXout.xls).
• The final solution will be to have MHSC revert to previous output format for this column. Julie to follow up with MHSC contact.

1. Open MHSC_out.xls file
2. Select DOB column (this is our DOB column, not the MH_DOB column)
3. Go to DATA menu tab at top of EXCEL screen
4. Select "test to column" from drop down menu
5. Press NEXT at bottom of this window
6. Press NEXT again
7. Top Right of this window you will see COLUMN DATE FORMAT

-select DATE item on menu -from the drop down list beside DATE, select M/D/Y format

• 9. Don't forget to save changes.
• 10. Exit Excel
• 11. MHSC Conditioner Program will now be able to read this Excel file.

TOstryzniuk 19:17, 19 November 2008 (CST)