Projecto C: Surgical Cost-Effectiveness Analysis Database
In times of crisis like these, a cost-effectiveness analysis database for surgical procedures is the best tool to have. A number of clinical variables were defined to complement the cost-effectiveness analysis with one of first operation room expenditure’s database implemented in a public hospital. This study is based on the same cornerstone of the ACS-NSQIP program. Some variables were collected automatically from the information systems available in the hospital, and the remaining are entered in a custom developed application be the surgeons. The indicators to provide are being defined with the surgeons and implemented in the form of dashboards. The result of this project will provide a tool for the hospital surgeons, manager and administrators to make better decisions.
Keywordsbusiness intelligence surgery data mining database data-entry
Unable to display preview. Download preview PDF.
- 2.Welke, K.F., Karamlou, T., Diggs, B.S.: Databases for assessing the outcomes of the treatment of patients with congenital and paediatric cardiac disease -a comparison of administrative and clinical data. Cardiol. Young. (18 suppl. 2), 137–144 (2008)Google Scholar
- 3.ACS NSQIP website, https://acsnsqip.org/main/resources_information_packet.pdf (accessed November 18, 2009)
- 5.Hall, B.L., Hamilton, B.H., Richards, K., et al.: Does surgical quality improve in the American College of Surgeons National Surgical Quality Improvement Program: an evaluation of all participating hospitals. Ann. Surg. 250(3), 363–376 (2009)Google Scholar
- 6.Rogers, S.O.: The Holy Grail of surgical quality Improvement: process measures or risk-adjusted outcomes? Am. Surg. 72(11), 1046–1050 (2006); discussion 1061–1069, 1133–1148Google Scholar
- 11.Huang, Z., Xu, L., Yang, T., et al.: Hepatic resection: ananalysis of the impact of operative and perioperative factors on morbidity and mortality rates in 2008 consecutive hepatectomy cases. Chin. Med. J. 122(19), 2268–2277 (2009)Google Scholar
- 15.Davenport, D.L., Henderson, W.G., Khuri, S.F., Mentzer, R.M.: Preoperative risk factors and surgical complexity are more predictive of costs than postoperative complications: a case study using the National Surgical Quality Improvement Program (NSQIP) database. Ann. Surg. 242(4), 463–468 (2005); discussion 468–471Google Scholar
- 17.Chetta, A., Tzani, P., Marangio, E., et al.: Respiratory effects of surgery and pulmonary function testing in the preoperative evaluation. Acta Biomed. 77(2), 69–74 (2006)Google Scholar
- 21.Wong, D.H., Weber, E.C., Schell, M.J., et al.: Factors associated with postoperative pulmonary complications in patients with severe chronic obstructive pulmonary disease. Anesth. Analg. 80(2), 276–284 (1995)Google Scholar
- 27.Microsoft© Silverlight, http://www.silverlight.com
- 28.Microsoft© SQL Server, www.microsoft.com/sqlserver/
- 30.Gray, R.T., Sut, M.K., Badger, S.A., Harvey, C.: Post-operative telephone review is cost-effective and acceptable to patients. Ulster. Med. J. 79(2), 76–79 (2010)Google Scholar
- 31.QlikTech© Qlikview, www.qlikview.com/