Manitoba Health "Conditioner": Difference between revisions

(35 intermediate revisions by 3 users not shown)

Line 1:

~~The Manitoba~~ Health (MB Health~~) "Conditioner" ACCESS Program~~

{{LegacyContent

|explanation=MB Health data stopped

|successor=[[MB Health Tool.mdb]]

|content=

~~See [[Crosschecking data with Manitoba Health]] for more information in regards to the process of sending and receiving data to MB Health.~~

~~==What~~ is ~~it?==~~

The Manitoba Health (MB Health) "Conditioner" is an MS Access Program that facilitates [[Crosschecking data with Manitoba Health]] using the [[Manitoba Health Match Indicator Guideline]].

*ACCESS program

~~==Who Developed it?==~~

*ACCESS Conditioner Program ~~developed by Tina as requested by Julie~~.

*DATE: January, 2005

==What does it do?==

Line 16:

Line 13:

==Where do you find it?==

*X:~~\CCMDB_ADMIN_DATABASE\~~MB_Health_Records_Cleaning\'''~~MB Health Conditioner~~.mdb~~'''~~

*{{M:|MB_Health_Records_Cleaning}}'''

* a backup copy of conditioner.mdb is also in this directory - [[User:PTorres|PTorres]] 15:20, 2014 May 29 (CDT)

~~==Where do you find~~ a ~~working BACKUP~~ copy~~?==~~

Pagasa also keeps a backup copy of the above folder and all its contents her C drive

**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 the last 3 columns are't as wide~~ and ~~therefore page won't print outside margin limits.~~

***previous backup copy that worked is called '''"JAN DON'T TOUCH_MB Health Conditioner.mdb'''"

~~{{Discussion}}~~

**as of January 22.09 it has been discovered that this program is not working correctly. Needs investigation.[[User:TOstryzniuk|TOstryzniuk]] 20:35, 22 January 2009 (CST)

==What files does it read?==

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

*Excel data files that have been sent to and returned from MB Health by [[Courier]] which is on a (encrypted/password protected) CD.

*and ifolder was set up for the purpose of exchanging information, however MB Health would not exchange files in this manner.

==What is in the Excel files that is sent and then returned?==

*Study, Chart, PHIN, LN, FN, DOB & Sex - '''MH_PHIN2, MH_LName, MH_FName, MH_DOB, MH_Sex, matched kind (0 to 2)

'''

===What do the "~~matchind~~" ~~values~~ mean when data is returned from MB Health? ===

===What do the [[Manitoba Health Match Indicator Guideline |"matchkind" indicators]] mean when data is returned from MB Health? ===

Matched Indicators:

*0 = no match made with MHSC data

Line 41:

Line 33:

==Where are the Excel Data Files located==

*X:\CCMDB_ADMIN_DATABASE\MB_Health_Records_Cleaning\'''MBHealth'''

*{{S:\MED\MED_CCMED}}CCMDB_ADMIN_DATABASE\MB_Health_Records_Cleaning\'''MBHealth'''

==How are EXCEL files labeled?==

Line 63:

Line 55:

*now you can use MHSC CONDITIONER Program which will import and read the output MHSC file correctly.

*file DISK in MHSC crosschecking binder

~~{{Discussion}}~~

==November,19.08 "Conditioner" ACCESS Program Problems==

Line 84:

Line 72:

=INSTRUCTION for changing the format of a COLUMN of data in EXCEL from TEXT to NUMERIC=

=INSTRUCTION for changing the format of a COLUMN of data in EXCEL from NUMERIC to TEXT=

* MHSC- "OUT" -is the name of the file which is '''returned''' from MB Health.

**when we '''send''' data to MB Health, the HSC columns of data for '''PHIN''' and DOB are '''NUMERIC''' (justified to the RIGHT).

**When data file is '''returned''' from MB Health, the HSC column of data for '''PHIN''' is '''retained as NUMERIC''' and the '''DOB''' is '''changed to TEXT''' (justified to LEFT).

**MB Health columns of data for MB_PHIN and MB_DOB columns of data are both TEXT (justified to LEFT)

* '''For MB Conditioner Program to work the following columns of data must be checked''':

#the HSC column for PHIN must be changed to TEXT (justified to left).[[User:TOstryzniuk|TOstryzniuk]] 14:22, 23 June 2009 (CDT)

If conditioner doesn't run with the above fix then check the following:

#the "HSC" column for '''PHIN''' & '''DOB''' should both be TEXT (justified to the LEFT).

#"MHSC" column for MB_PHIN & MB_DOB should both be TEXT (justified LEFT).

#Header Row must be the same. (Pagasa copies header row from previous MBH OUT to current MBH OUT. Save. Exit. Now run MB Conditioner).

*NOTE: Julie's comment:

Line 92:

Line 94:

*NOTE: that if number field has a small '''green tag''' in it, click on that. It is a comment for that field. It will tell you that the number is stored as a TEXT. [[User:TOstryzniuk|TOstryzniuk]] 18:41, 23 January 2009 (CST)

~~{{Discussion}}~~

**Julie, I had a looked at the AVoutput.xls and noticed that the MH_PHIN and MH_DOB columns are also stored as TEXT? Why would they store a number as a text? How does does the MHSC Conditioner Program compare a numeric field (our DOB & PHIN) against a Text field (MH_DOB & PHIN)? [[User:TOstryzniuk|TOstryzniuk]] 20:55, 22 January 2009

*for MHSC output.xls

Line 101:

*2 problems:

# DOB is changed to YYYY-M-D back from the original M/D/YYYY that we sent them.

# DOB and PHIN columns are ~~formatted as~~ text ~~instead of numeric~~.

# DOB and PHIN columns of data are not sent back in consistent format. e.g. HSC PHIN is numeric and MB_PHIN is text format.

*the ACCESS "Conditioner Program" will not run if we don't restore the correct format of these columns.

Line 117:

#Press FINISH

B. how to change "our" PHIN column format from text ~~to numeric.~~

B. how to change "our" PHIN column format from '''numeric''' to text:

#Open MHSC_out.xls file

#Select the whole ~~DOB~~ column (this is "our" ~~DOB~~ column, not the ~~MH_DOB~~ column)

#Select the whole PHIN column (this is "our" PHIN column, not the MH_PHIN column)

#Go to DATA menu tab at top of EXCEL screen

#Select "text to column" from drop down menu

Line 131:

[[User:TOstryzniuk|TOstryzniuk]] 20:06, 19 November 2008 (CST)

[[User:TOstryzniuk|TOstryzniuk]] 20:49, 22 January 2009 (CST)UPDATED

[[User:TOstryzniuk|TOstryzniuk]] 20:49, 22 January 2009 (CST)UPDATED.

*Pagasa need to include steps to change PHIN column from TXT to numeric. I really need some input from Julie or Pagasa here if they feel there are changes that can be made here to help others who might have to run this program. Thanks!![[User:TOstryzniuk|TOstryzniuk]] 18:13, 23 January 2009 (CST)

==Discussion==

***I see that there is a another page started with [[Crosschecking data with Manitoba Health]]. I didn't realize it was there. Some of this information list here under MB Health CONDITIONER program will need to be moved over there. [[User:TOstryzniuk|TOstryzniuk]] 17:56, 20 November 2008 (CST)

*tina.....feel free to move things.

** Trish, the whole of [[:Category:Manitoba Health]] of could benefit from re-factoring; this will take some time, if you want me to do it please put into [[Change Priorities]]

Legacy info only below here.

==iFolder==

ifolder was set up for the purpose of exchanging information, however MB Health would not exchange files in this manner.

==Who Developed it?==

*ACCESS Conditioner Program developed by Tina as requested by Julie.

*DATE: January, 2005

== Related articles ==

}}

~~{{stub}}~~

[[Category:Manitoba Health Legacy Information]]

[[Category: ~~Questions]]~~

~~[[Category: Data Processing~~]]

@@ Line 1: / Line 1: @@
-The Manitoba Health (MB Health) "Conditioner" ACCESS Program
+{{LegacyContent
+|explanation=MB Health data stopped
+|successor=[[MB Health Tool.mdb]]
+|content=
-See [[Crosschecking data with Manitoba Health]] for more information in regards to the process of sending and receiving data to MB Health.
-==What is it?==
+The Manitoba Health (MB Health) "Conditioner" is an MS Access Program that facilitates [[Crosschecking data with Manitoba Health]] using the  [[Manitoba Health Match Indicator Guideline]].
-*ACCESS program
-==Who Developed it?==
-*ACCESS Conditioner Program developed by Tina as requested by Julie.
-*DATE: January, 2005
 ==What does it do?==
@@ Line 16: / Line 13: @@
 ==Where do you find it?==
-*X:\CCMDB_ADMIN_DATABASE\MB_Health_Records_Cleaning\'''MB Health Conditioner.mdb'''
+*{{M:|MB_Health_Records_Cleaning}}'''
+* a backup copy of conditioner.mdb is also in this directory - [[User:PTorres|PTorres]] 15:20, 2014 May 29 (CDT)
-==Where do you find a working BACKUP copy?==
+Pagasa also keeps a backup copy of the above folder and all its contents her C drive
-**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 the last 3 columns are't as wide and therefore page won't print outside margin limits.
-***previous backup copy that worked is called '''"JAN DON'T TOUCH_MB Health Conditioner.mdb'''"
-{{Discussion}}
-**as of January 22.09 it has been discovered that this program is not working correctly. Needs investigation.[[User:TOstryzniuk|TOstryzniuk]] 20:35, 22 January 2009 (CST)
 ==What files does it read?==
-*Excel data files that have been sent to and returned from MB Health by courier which is on a (encrypted/password protected) CD.
+*Excel data files that have been sent to and returned from MB Health by [[Courier]] which is on a (encrypted/password protected) CD.
-*and ifolder was set up for the purpose of exchanging information, however MB Health would not exchange files in this manner.
 ==What is in the Excel files that is sent and then returned?==
 *Study, Chart, PHIN, LN, FN, DOB & Sex - '''MH_PHIN2, MH_LName, MH_FName, MH_DOB, MH_Sex, matched kind (0 to 2)
 '''
-===What do the "matchind" values mean when data is returned from MB Health? ===
+===What do the [[Manitoba Health Match Indicator Guideline |"matchkind" indicators]] mean when data is returned from MB Health? ===
 Matched Indicators:
 *0 = no match made with MHSC data
@@ Line 41: / Line 33: @@
 ==Where are the Excel Data Files located==
-*X:\CCMDB_ADMIN_DATABASE\MB_Health_Records_Cleaning\'''MBHealth'''
+*{{S:\MED\MED_CCMED}}CCMDB_ADMIN_DATABASE\MB_Health_Records_Cleaning\'''MBHealth'''
 ==How are EXCEL files labeled?==
@@ Line 63: / Line 55: @@
 *now you can use MHSC CONDITIONER Program which will import and read the output MHSC file correctly.
 *file DISK in MHSC crosschecking binder
-{{Discussion}}
 ==November,19.08 "Conditioner" ACCESS Program Problems==
@@ Line 84: / Line 72: @@
-=INSTRUCTION for changing the format of a COLUMN of data in EXCEL from TEXT to NUMERIC=
+=INSTRUCTION for changing the format of a COLUMN of data in EXCEL from NUMERIC to TEXT=
+* MHSC- "OUT" -is the name of the file which is '''returned''' from MB Health.
+**when we '''send''' data to MB Health, the HSC columns of data for '''PHIN''' and DOB are '''NUMERIC''' (justified to the RIGHT).
+**When data file is '''returned''' from MB Health, the HSC column of data for '''PHIN''' is '''retained as NUMERIC''' and the '''DOB''' is '''changed to TEXT''' (justified to LEFT).
+**MB Health columns of data for MB_PHIN and MB_DOB columns of data are both TEXT (justified to LEFT)
+* '''For MB Conditioner Program to work the following columns of data must be checked''':
+#the HSC column for PHIN must be changed to TEXT (justified to left).[[User:TOstryzniuk|TOstryzniuk]] 14:22, 23 June 2009 (CDT)
+If conditioner doesn't run with the above fix then check the following:
+#the "HSC" column for '''PHIN''' & '''DOB''' should both be TEXT (justified to the LEFT).
+#"MHSC" column for MB_PHIN & MB_DOB  should both be TEXT (justified LEFT).
+#Header Row must be the same.  (Pagasa copies header row from previous MBH OUT to current MBH OUT.   Save. Exit.  Now run MB Conditioner).
 *NOTE:  Julie's comment:
@@ Line 92: / Line 94: @@
 *NOTE:  that if number field has a small '''green tag''' in it, click on that.  It is a comment for that field.  It will tell you that the number is stored as a TEXT. [[User:TOstryzniuk|TOstryzniuk]] 18:41, 23 January 2009 (CST)
-{{Discussion}}
-**Julie, I had a looked at the AVoutput.xls and noticed that the MH_PHIN and MH_DOB columns are also stored as TEXT? Why would they store a number as a text? How does does the MHSC Conditioner Program compare a numeric field (our DOB & PHIN) against a Text field (MH_DOB & PHIN)? [[User:TOstryzniuk|TOstryzniuk]] 20:55, 22 January 2009
 *for MHSC output.xls
@@ Line 101: / Line 101: @@
 *2 problems:
 # DOB is changed to YYYY-M-D back from the original M/D/YYYY that we sent them.
-# DOB and PHIN columns are formatted as text instead of numeric.
+# DOB and PHIN columns of data are not sent back in consistent format. e.g. HSC PHIN is numeric and MB_PHIN is text format.
 *the ACCESS "Conditioner Program" will not run if we don't restore the correct format of these columns.
@@ Line 117: / Line 117: @@
 #Press FINISH
-B. how to change "our" PHIN column format from text to numeric.
+B. how to change "our" PHIN column format from '''numeric''' to text:
 #Open MHSC_out.xls file
-#Select the whole DOB column (this is "our" DOB column, not the MH_DOB column)
+#Select the whole PHIN column (this is "our" PHIN column, not the MH_PHIN column)
 #Go to DATA menu tab at top of EXCEL screen
 #Select "text to column" from drop down menu
@@ Line 131: / Line 131: @@
 [[User:TOstryzniuk|TOstryzniuk]] 20:06, 19 November 2008 (CST)
-[[User:TOstryzniuk|TOstryzniuk]] 20:49, 22 January 2009 (CST)UPDATED
+[[User:TOstryzniuk|TOstryzniuk]] 20:49, 22 January 2009 (CST)UPDATED.
-*Pagasa need to include steps to change PHIN column from TXT to numeric. I really need some input from Julie or Pagasa here if they feel there are changes that can be made here to help others who might have to run this program. Thanks!![[User:TOstryzniuk|TOstryzniuk]] 18:13, 23 January 2009 (CST)
 ==Discussion==
 ***I see that there is a another page started with [[Crosschecking data with Manitoba Health]].  I didn't realize it was there.  Some of this information list here under MB Health CONDITIONER program will need to be moved over there. [[User:TOstryzniuk|TOstryzniuk]] 17:56, 20 November 2008 (CST)
 *tina.....feel free to move things.
+** Trish, the whole of [[:Category:Manitoba Health]] of could benefit from re-factoring; this will take some time, if you want me to do it please put into [[Change Priorities]]
+ Legacy info only below here.
+==iFolder==
+ifolder was set up for the purpose of exchanging information, however MB Health would not exchange files in this manner.
+==Who Developed it?==
+*ACCESS Conditioner Program developed by Tina as requested by Julie.
+*DATE: January, 2005
+== Related articles ==
+{{Related Articles}}
+}}
-{{stub}}
+[[Category:Manitoba Health Legacy Information]]
-[[Category: Questions]]
-[[Category: Data Processing]]