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.....

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"

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.

Excel data files that have been sent to and returned from MHSC by courier which is on a (encrypted/password protected) CD.

for crosschecking our database patient identifiers against MHSC database
aligning and correcting our patient ID information with MHSC
maintaining consistency of key patient identfiers in our database when patient are readmitted.

sent files are labeled as follows:
- ICU EXAMPLE: AU.xls (AU.zip)
- MED EXAMPLE: MedX.xls
returned files are labeled as follows:
- ICU EXAMPLE: AUout.xls
- MED EXAMPLE: MedXout.xls
paper log file is kept of sent batch numbers for ICU and Medicine

ACCESS Conditioner program developed by Julie. Tina provided a few other enhancements (conditional formatting for color).
Data checking with MHSC started: _______?

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.

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.

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

TOstryzniuk 19:17, 19 November 2008 (CST)