PRISM NETSS Change

[Mary White - Florida]

Here in Florida, we recently received our STD NETSS Edit Checks for 2012 and 2013.  In this data, we noticed that CDC was stating we had an error when we sent a date of death for a stillborn Congenital Syphilis case.

 

CDC considers a date of death invalid for a Stillborn on Congenital Syphilis.  This was not listed in the NETSS layout dated January 2011.  It only states to leave DEATHDAT blank if child was born alive.  

 

CDC informs us that on the Congenital Syphilis Case Investigation and Reporting Form Instructions for Question #27 it states the following "27. Date of death:  Complete this question only if the infant or child died after birth.  If the date of death is not known, mark the unknown box.  Do not complete the question if the infant was stillborn".  

 

Since this was not in the NETSS instructions, this did not happen.  Therefore, a modification to the NETSS stored procedure is needed.

 

Please modify the Prism.usp_BatchNETSS stored procedure as follows:

 

- Add new comment to top of changes list as follows:

2013-02-22 WhiteMZ    Change to leave date of death blank for Stillborn on CS

 

- Do a find on “[DEATHDAT] =”.  You only need to modify the first instance found to read as follows:

 

,               [DEATHDAT] =

                              CASE

                                       WHEN p.DT_Death IS NULL OR Prism.fn_GetNETSSForCode('DS_BabyStatus',c.DS_BabyStatus) = '3'

                                                 THEN '        '

                                        ELSE CAST(REPLACE(CONVERT(char(10), p.DT_Death, 121),'-','') AS CHAR(8))

                               END

 

- Execute the ALTER on this stored procedure

 

If you have any questions, please feel free to contact me at (850) 245-4603.