Manitoba Health "Conditioner": Difference between revisions

Line 78:

*hopefully the next batch we send to MHSC will be returned without this problem.

==Instruction: How to Change the ~~DOB format of OUR~~ DOB & PHIN column~~- for MHSC output.xls~~==

==Instruction: (for MHSC output.xls). How to Change the "Our" DOB & PHIN column format from text to numeric formatt==

*This instruction starts for batch MHSC output data (ICU_'''AV'''out.xls & Med'''X'''out.xls)& onward.

*Problem: When we ~~send a batch~~ of M

*Problem: When MHSC returns crosschecked data back to us, "our" DOB and PHIN column has been altered.

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

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

*how to change "our" sent DOB column format from YYYY-M-D back to M/D/YYYY

Line 99:

Line 103:

*11. MHSC Conditioner Program will now be able to read this Excel file.

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

[[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!!

==Discussion==

@@ Line 78: / Line 78: @@
 *hopefully the next batch we send to MHSC will be returned without this problem.
-==Instruction: How to Change the DOB format of OUR DOB & PHIN column- for MHSC output.xls==
+==Instruction: (for MHSC output.xls). How to Change the "Our" DOB & PHIN column format from text to numeric formatt==
 *This instruction starts for batch MHSC output data (ICU_'''AV'''out.xls & Med'''X'''out.xls)& onward.
-*Problem: When we send a batch of M
+*Problem: When MHSC returns crosschecked data back to us, "our" DOB and PHIN column has been altered.
+*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.
+*the ACCESS "Conditioner Program" will not run if correction we don't restore the correct format of these columns.
 *how to change "our" sent DOB column format from YYYY-M-D back to M/D/YYYY
@@ Line 99: / Line 103: @@
 *11. MHSC Conditioner Program will now be able to read this Excel file.
 [[User:TOstryzniuk|TOstryzniuk]] 20:06, 19 November 2008 (CST)
+[[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!!
 ==Discussion==