PRISM Weekly NETSS Transmission Ending for 2014 Data

[Mary White - Florida]

According to the CDC 2014 Data Summary Timeline, you can no longer submit 2014 data during the weekly NETSS transmission after 4/7/2015.  Therefore, be sure to run the following script to NULL out your prior year parameter.

 

USE STDPrism

GO

 

UPDATE Prism.SystemParameter

SET DS_ParameterValue = NULL

WHERE NM_Parameter = 'NETSSMMWRYearPrior';

GO

 

If you are still correcting data (as most of us are), you can run the following update to prepare the parameters for a resend file to be created for 2014.  After you run this script, run your STDPrismBatchNETSS batch job and the output will contain a 2014 replacement file for submission to CDC.  Do not change the NETSSResend flag to 'Y' using the script below unless you are ready to create a replacement 2014 file for CDC as it will override your weekly transmission.

 

USE STDPrism

GO

 

UPDATE Prism.SystemParameter

SET DS_ParameterValue = '2013-12-29 00:00:00.000'

WHERE NM_Parameter = 'NETSSStartDate';

GO

 

UPDATE Prism.SystemParameter

SET DS_ParameterValue = '2015-01-03 23:59:00.000'

WHERE NM_Parameter = 'NETSSEndDate';

GO

 

UPDATE Prism.SystemParameter

SET DS_ParameterValue = 'Y'

WHERE NM_Parameter = 'NETSSResend';

GO

 

If you have any questions, please post on this message and I will answer as soon as possible.