AlgorithmVariableName DataDictionary memo criteria priority Disease age.min.year >=0 Algorithm 1 02A CaMRSA age.max.year <= 89 Algorithm 1 02A CaMRSA labRelatedVisit Not implemented for now, need ETL lab related visit Alg 2a 02A CaMRSA report.ssti.text What lab/report test? NLP part, annotating bacterial culture lab test 02A CaMRSA report.ssti.code from report.ssti.text? 02A CaMRSA reportString.ssti.text SKIN NLP part, annotating bacterial culture lab test Alg 2a 02A CaMRSA reportString.ssti.text WOUND NLP part, annotating bacterial culture lab test Alg 2a 02A CaMRSA reportString.ssti.text BOIL NLP part, annotating bacterial culture lab test Alg 2a 02A CaMRSA reportString.ssti.text ABSCESS NLP part, annotating bacterial culture lab test Alg 2a 02A CaMRSA reportString.ssti.text FOOT NLP part, annotating bacterial culture lab test Alg 2a 02A CaMRSA reportString.ssti.text HAND NLP part, annotating bacterial culture lab test Alg 2a 02A CaMRSA reportString.ssti.text LEG NLP part, annotating bacterial culture lab test Alg 2a 02A CaMRSA reportString.ssti.text BUTTOCK NLP part, annotating bacterial culture lab test Alg 2a 02A CaMRSA reportString.ssti.text BREAST NLP part, annotating bacterial culture lab test Alg 2a 02A CaMRSA reportString.ssti.text CARBUNCLE NLP part, annotating bacterial culture lab test Alg 2a 02A CaMRSA reportString.ssti.text FURUNCLE NLP part, annotating bacterial culture lab test Alg 2a 02A CaMRSA reportString.ssti.text FINGER NLP part, annotating bacterial culture lab test Alg 2a 02A CaMRSA reportString.ssti.text TOE NLP part, annotating bacterial culture lab test Alg 2a 02A CaMRSA reportString.ssti.text CELLULITIS NLP part, annotating bacterial culture lab test Alg 2a 02A CaMRSA reportString.ssti.text IMPETIGO NLP part, annotating bacterial culture lab test Alg 2a 02A CaMRSA reportString.ssti.text SUBCUTANEOUS NLP part, annotating bacterial culture lab test Alg 2a 02A CaMRSA reportString.ssti.text HAIR NLP part, annotating bacterial culture lab test Alg 2a 02A CaMRSA reportString.ssti.text HYDRADENITIS NLP part, annotating bacterial culture lab test Alg 2a 02A CaMRSA dx.ssti.icd9 611 Alg 2b 02A CaMRSA dx.ssti.icd9 680.* Alg 2b 02A CaMRSA dx.ssti.icd9 681.* Alg 2b 02A CaMRSA dx.ssti.icd9 682.* Alg 2b 02A CaMRSA dx.ssti.icd9 684.* Alg 2b 02A CaMRSA dx.ssti.icd9 686.9 Alg 2b 02A CaMRSA dx.ssti.icd9 704.8 Alg 2b 02A CaMRSA dx.ssti.icd9 705.83 Alg 2b 02A CaMRSA dx.mrsa.icd9 038.12 Alg 2b 02A CaMRSA dx.mrsa.icd9 041.12 Alg 2b 02A CaMRSA dx.mrsa.icd9 482.42 Alg 2b 02A CaMRSA valRange.sstiMrsa.min.day >= -7 SSTI diagnosis within +/- 7 days of MRSA diagnosis Alg 2b 02A CaMRSA valRange.sstiMrsa.max.day <= 7 SSTI diagnosis within +/- 7 days of MRSA diagnosis Alg 2b 02A CaMRSA caseExclusion.hospitalization 9201 place_of_service_concept_id field Alg 3 02A CaMRSA valRange.hospitalizationBeforeMRSA.max.year <= 1 Alg 3 02A CaMRSA continuousEnrollment.min.year >=3 Control definition 02A CaMRSA visitFreq.primaryCare.min >=2 at least 2 visits with a primary care provider. Need to ETL of provider Control definition 02A CaMRSA ctrl.MRSAexcl.icd9 041.12 Control definition 02A CaMRSA ctrl.MRSAexcl.icd9 482.42 Control definition 02A CaMRSA ctrl.MRSAexcl.icd9 482.41 Control definition 02A CaMRSA ctrl.MRSAexcl.icd9 038.12 Control definition 02A CaMRSA ctrl.MRSAexcl.icd9 V02.54 Control definition 02A CaMRSA ctrl.MRSAexcl.icd9 V12.04 Control definition 02A CaMRSA ctrl.MRSAexcl.icd9 V09.0 Control definition 02A CaMRSA lab.MRSAbacterialCulture.med.caseName 2249 CPMC Organism Result: Staphylococcus Aureus, Methicillin Resistant|Mapped from: lab.MRSAbacterialCulture.text 02A CaMRSA CPMC Organism Result: Staphylococcus Aureus, Methicillin Resistant YES_1179 nlpYES YES_CaseName lab.MRSAbacterialCulture.med.caseName 119158 ME Term: Methicillin-Resistant Staphylococcus aureus|Mapped from: lab.MRSAbacterialCulture.text 02A CaMRSA ME Term: Methicillin-Resistant Staphylococcus aureus YES_1179 nlpYES YES_CaseName lab.MRSAbacterialCulture.med.ctrlName 101104 MESSAGE: STAPHYLOCOCCUS AUREUS, METHICILLIN SUSCEPTIBLE|Mapped from: lab.MRSAbacterialCulture.text 02A CaMRSA MESSAGE: STAPHYLOCOCCUS AUREUS, METHICILLIN SUSCEPTIBLE YES_1179 nlpYES YES_CtrlName lab.MRSAbacterialCulture.med.ctrlName 39322 No Growth of Methicillin Resistant Staph Aureus (Mrsa)|Mapped from: lab.MRSAbacterialCulture.text 02A CaMRSA No Growth of Methicillin Resistant Staph Aureus (Mrsa) YES_1179 nlpYES YES_CtrlName lab.MRSAbacterialCulture.med.ctrlName 120369 ME Term: Methicillin-Susceptible Staph aureus|Mapped from: lab.MRSAbacterialCulture.text 02A CaMRSA ME Term: Methicillin-Susceptible Staph aureus YES_1179 nlpYES YES_CtrlName lab.MRSAbacterialCulture.med.ctrlName 101061 MESSAGE: NO MRSA DNA DETECTED|Mapped from: lab.MRSAbacterialCulture.text 02A CaMRSA MESSAGE: NO MRSA DNA DETECTED YES_1179 nlpYES YES_CtrlName lab.MRSAbacterialCulture.med.valueCase 161103 Cerner ME DTA: MRSA PCR|Mapped from: lab.MRSAbacterialCulture.text 02A CaMRSA Cerner ME DTA: MRSA PCR 35492-8 35492-8_Methicillin resistant Staphylococcus aureus (MRSA) DNA [Presence] by Probe and target amplification method| YES_1179 nlpYES YES_Value Positive for Case; Negative for Control lab.MRSAbacterialCulture.med.valueCtrl 161094 Cerner ME DTA: MSSA PCR|Mapped from: lab.MRSAbacterialCulture.text 02A CaMRSA Cerner ME DTA: MSSA PCR 35492-8 35492-8_Methicillin resistant Staphylococcus aureus (MRSA) DNA [Presence] by Probe and target amplification method| YES_1179 nlpYES YES_Value Positive for Control; Negative for Case labString.MRSAbacterialCulture.positive.text present Appendix 2 02A CaMRSA labString.MRSAbacterialCulture.positive.text positive Appendix 2 02A CaMRSA labString.MRSAbacterialCulture.negative.text absent Appendix 2 02A CaMRSA labString.MRSAbacterialCulture.negative.text negative Appendix 2 02A CaMRSA