2011-01-05 - PRISM End of Year Issue with MMWR

Post date: Jan 5, 2011 7:23:25 PM

Thanks to questions from Indiana, we have found an issue with the MMWR calculation for 1/1/2011. It was returning week 53 instead of week 52. I think I have fixed this error in the function and you can find it on the FTP site at "PRISM Changes-Releases\PRISM Fix - 2011-01-05".

Also, you will find a new version of usp_BatchNETSS and usp_BatchNETSSCleanup. These two stored procedures have changed to look if we need to modify the MMWR prior to the job running. This is necessary to make sure the @cMMWRYear and @cMMWRPrior variables are set correctly.

Please note that there are two versions of the usp_BatchNETSS out there. One for the users who are running the 20090307 release (last comment on 2009-04-17) and the other for anyone running after that release. Please make sure you use the correct version for the database you have. If the version of NETSS that you are CURRENTLY running has the following comment in the change log at the top:

2009-08-28 WhiteMZ Change to work with new congenital format.

You are running the new format and should use the one named usp_BatchNETSS.sql, otherwise, use the usp_BatchNETSS_20090417 version. Also, make sure you compare my version with your version so that any changes you have made on your own are not lost.

There is a document out there called "usp_BatchNETSS_ChangesFrom20090417VersionTo20110105Version.sql" that shows every change that has been made to the stored procedure between these two versions. Please note that if you are running the 20090307 version of the application, you will not be able to implement some of these changes. The following changes have been made to the usp_BatchNETSS_20090417.sql version.

All on 1/5/11

All on 11/19/2010

Ignore all changes on 6/08/2010

Only the following changes from 11/03/09

- Lines 534, 536, 537, 538 (look at the values in Prism.Codes for CD_Type = 'Imported' and make sure the have a CD_NETSS value. The values should be

CD_Value CD_NETSS

1 N

2 C

3 S

9 U

- Line 1737 (add the word DISTINCT)

As always, please let me know if you have any questions.