PRISM Change for Disease Code 070 from Hepatitis A to Hepatitis Unknown

[Mary White - Florida]

This message pertains to all states currently using PRISM or in the process of converting to PRISM.

 

As I was in the process of converting data for a state from STD*MIS, we came across an issue in PRISM where disease code ‘070’ was defined as 'Hepatitis A' and should have been defined as 'Hepatitis Unknown'.  This has been around since the beginning of PRISM, but we would like to rectify this now.  I have placed a script below that should be run by the database analyst for your system.  This will correct all the records where they were defined as 'Hepatitis A' to be 'Hepatitis Unknown'.  This should put us back in sync with CDC.

 

If anyone has any questions or needs more clarification on this issue, please just let me know.  You can reach me at my new e-mail address of Mary....@flhealth.gov.

 

USE STDPrism

GO

 

/* Change Disease and Disease Category from Hepatitis A to Hepatitis Unknown */

 

PRINT CONVERT(VARCHAR,GETDATE(),121) + ' Change DiseaseCategory for Hepatitis A to Hepatitis Unknown - Codes';

UPDATE Prism.Codes SET CD_Value = 'Hepatitis Unknown' WHERE CD_Type = 'DiseaseCategory' AND CD_Value = 'Hepatitis A';

 

PRINT CONVERT(VARCHAR,GETDATE(),121) + ' Change DiseaseCategory for Hepatitis A to Hepatitis Unknown - Disease';

UPDATE Prism.Disease SET DS_DiseaseCategory = 'Hepatitis Unknown', DS_Disease = 'Hepatitis Unknown'

WHERE DS_DiseaseCategory = 'Hepatitis A';

 

PRINT CONVERT(VARCHAR,GETDATE(),121) + ' Change DiseaseReportCategory for Hepatitis A to Hepatitis Unknown';

UPDATE Prism.DiseaseReport SET DS_DiseaseReportCategory = 'Hepatitis Unknown' WHERE DS_DiseaseReportCategory = 'Hepatitis A';

 

PRINT CONVERT(VARCHAR,GETDATE(),121) + ' Change DiseaseCategory for Hepatitis A to Hepatitis Unknownm - Test';

UPDATE Prism.test SET DS_DiseaseCategory = 'Hepatitis Unknown' WHERE DS_DiseaseCategory = 'Hepatitis A';