HK: Rosen Hernia 510 Evaluate how to grab the correct Qualifying Implant Years from the Case, as it might differ from the original implant year

[jesusitd]

Generated M Code: surgeries.m.txt

Requerimientos: Mejorar Details Filtrar con boton de criterio "Note" label not good. Maybe Sub-criteria MAXIMUM 55 Leads for 08-09, not Minimum En Hernia Mesh Tabs: diagnosed complications puede volar. Hacer Barras de Qualifying Implant Year Criteria: Para Rosen: buscar si tiene alguna cirugia 2012+, para calificar en el bucket que no toca el Cap 20%, PERO TIENE QUE TENER UNA POSTERIOR, RELACIONADA A LA CIRUGIA QUE ESTOY CALIFICANDO (Surgery_related_to O mismo location+hernia type) Criteria (cont,) Si no tiene 2012+, se intenta por 2010 (dentro bucket 2010-2011 20%) y si no, se busca en el 08-09 (Max 55) Agregar Summary estrella, y Timeline estrella, agregar New Implant Sxs??? Retirar Original Implant Yr de Cases Details (criteria tab) y colocar Qualifying Surgery Year Grafico Orig Implant Year, reemplazar por Qualifying Surgery y Reorganizar buckets de Qualifying Implant Year, 08-09, 10-11 y 12+ El Grafico de Revision Surgeries se puede mejorar Criteria Page in Image OR adjust criteria boxes Star Tooltip for Qualifying Surgery

Columns: Surgery YearS (TODO) Summary (ademas Original es 1) Qualifying Surgery Year Qualifying Revision Years

[jesusitd]

TOOLTIP STAR SURGERIES SUMMARY

[jesusitd]

Final solution comments: Added “Hernia 510-One Criteria” tab. Highlights:

• Went through the Document for FIRM’S CRITERIA relating to this case
• Developed Criteria Checks and its background data from scratch, including the logics behind Surgery-Revision qualifications as per HK indications.
• Report Contains Rosen Injury Criteria checks for the 510-One Hernia contract
• Visually indicates: o Cases meeting ALL Criteria o Cases not meeting criteria and not DQd yet o DQ Cases
• Criteria Checks with Colored Indicators (they change colors to tell if a goal has been met or a threshold has been passed) o Cases with Qualifying Implant Year 2008-09, 2010-11 or 2012 to Present o Maximum of 55 Cases 2008-09 o Minimum of 455 Cases 2010-Present o Cap of 102 Cases (20%) for Cases 2010-Present o Must have had Revision or have a Scheduled Revision within 90 days o “Meets ALL Criteria” Indicator
• QUALIFYING Surgery Year is driven off of the most recent Surgery that had a subsequent revision of the SAME TYPE and in the AREA
• BUTTONS for seeing: o ALL Cases o Cases by Bucket (08-09 / 10-11 / 12-present)
• Other Case Details o New Implant Surgeries YEARS o Qualifying Implant Year o 1st Qualifying Revision Year o SURGERIES SUMMARY with TOOLTIP

Updated “Rosen - Hernia Mesh” tab:

• Improved Case Details to show data relevant to the Qualifying Implant and Revision
• Chart: Had Revision vs. Scheduled Revision tab
• Chart: How many years Qualifying Revision came After Implant
• Chart: Cases Meeting ALL Criteria vs. Disqualified