Report Writing with heartbase

1. Report Writing with heartbase SIR users’ conference

2. Report Writing with heartbase • Report types • Query Tool – Allows users to pick fields by record type, specify navigation by Procedure Date or Discharge Date, and specify tool to use for the report. • Ad-Hoc – Allows users to specify any fields and any order of field navigation. Many report options are available for output • Registry Retrievals – Allows entire registry data sets to output with a simple click of the button. Report date range is as the registries run reports, ACC by Discharge Date, STS by Procedure Date. • Category Reporting – Allows detailed report analysis by a category, like, LOS. One query produces standard report outputs and formats for packages like SPSS. Frequencies are produced for many of the data variables in the report. SIR users’ conference

3. Report Writing with heartbase • Master Impacts – To make reports run faster, master is programmatically disconnected while a report runs and is reconnected when the report is finished. SIR users’ conference

4. Report Writing with heartbase • Startin directory. • Many of the report sources are automatically deposited into the startin directory defined on the desktop shortcut. • Citrix users should contact there is department to determine where the STARTIN directory is located or to change the startin directory SIR users’ conference

5. Report Writing with heartbase • Startin directory. SIR users’ conference

6. Report Writing with heartbase Mapping locations of Software Packages used in reporting – SPSS, EXCEL, SAS, require mapping in the current SIR session. Click on Preferences SIR users’ conference

7. Report Writing with heartbase • Pick procedures Put your editor here SIR users’ conference

8. Report Writing with heartbase • Type in the extension you are looking for under New, like the five examples listed below. Press the double arrows to search for the executable. Press the Add button when finished. Type in Extension here Browse to path of software SIR users’ conference

9. Access Main Reports from the Reports Icon Main Reports SIR users’ conference

10. ACC and STS reporting Main Menu SIR users’ conference

11. ACC Cath Lab Reports • The main menu for ACC reports has been broken up into three sections • ACC 2.0C • ACC 3.04 • All Versions. Note that “All Versions” means 2.0C and 3.04 combined. 1.0 was not tested against these reports. SIR users’ conference

12. ACC Cath Lab Reports SIR users’ conference

13. Query Tool Problem/Need • Different logical views of data necessitate different types of Queries • End users have a difficult time doing all the relational joins for queries. • Report needs can occur almost instantaneously with varying report query parameters • One super query instead of many smaller ones to get the job done • Statistics needed from a point and click environment • Sites have different variable reporting needs • Some fields need to be calculated. • Required reporting variables change as systems evolve SIR users’ conference

14. Query Tool Solution • Generic, adoptable query tool. • Interface directly with Datavisor screen painter. • Reporting elements are stored in a text file and are customizable. • Direct interaction with Excel, SPSS, and SAS which gives familiarity to users and the power of those packages, like statistics, summarization, and graphs. • Provides calculated fields for things like Length of Stay and Patient Age. • Queries are automatically created based on the date path the user wishes to utilize, procedure or discharge date. • Can be saved so the query can be run over and over again without having to recreate it. • Eliminates user need for programming in PQL. SIR users’ conference

15. heartbase Query Tool The buttons located on the right of this screen are utilized to set the criteria for the query which will be run. Clicking on one of these buttons will open a screen which allows the user to select the variables for the query. SIR users’ conference

16. heartbase Query Tool Clicking on the different variables will highlight them. Once the desired variables have been selected, click "OK." SIR users’ conference

17. heartbase Query Tool The drop down menu at the bottom of the ACC Cath Lab Reporter screen allows the user to select the type of procedure to collect data from. Once the desired criterion has been selected, click "Run Query." SIR users’ conference

18. heartbase Query Tool Once the date range for the query has been entered, click "OK". If needed by discharge date, check the by discharge box. SIR users’ conference

19. heartbase Query Tool The report will go to SPSS by default, use pulldowns for SAS and Excel formats SIR users’ conference

20. heartbase Query Tool You have an option of saving the source code for this report to a PQL file name. SIR users’ conference

21. Ad-Hoc Reporter • Easy way to generate data • Output can be a report, tabulation, graph, or an export file. Export Options include SPSS, SAS, DIF, MINITAB, EXCEL, CSV • Allows field specific picking of field names based on a member stored in the SYSTEM family names EASYACC (ACC 2.0) or EASYA30 (ACC 3.04). These can be edited to add custom fields. • No implied joins are made so full relational database navigation is available. • Walk Thru method for report generation SIR users’ conference

22. Ad-Hoc Reporter: Customize your Data Points Global Easyprof allows you to specific which record types and fields are displayed when using the PROCEDURE section of the SIR Main Menu SIR users’ conference

23. Ad-Hoc Reporter: Customize your Data Points Default Logic • global easyprof=NONE • Let’s all the SIR record types be displayed when using the PROCEDURE command. STS2.52 • global easyprof=SYSTEM.easyS252 • Sets the PROCEDURE to allow only the record types/fields found in member SYSTEM.EASYS252 SIR users’ conference

24. Ad-Hoc Reporter: Customize your Data Points • CASE LIST = '000-00-0001' THRU '~~~~~~~~~~~' • INCLUDE • DEMO.SSNUM • DEMO.LNAME • DEMO.FNAME • DEMO.MINT • HOSP.SSNUM • HOSP.ADMDATE • HOSP.DISDATE • HOSP.SMOKCOUN • CLINPRES.SSNUM • CLINPRES.ADMDATE • CLINPRES.WGTKILO • CLINPRES.HTCM • CLINPRES.SMOKE • SURG.SSNUM • SURG.ADMDATE • SURG.SURGDATE • SURG.SURGSTIM • SURG.PSRGMDID • SURG.SURGSTAT • POSTOR.SSNUM • POSTOR.ADMDATE • POSTOR.SURGDATE • POSTOR.SURGSTIM • POSTOR.POCOMP • STSCATH.SSNUM • STSCATH.ADMDATE • STSCATH.CATHDATE • STSCATH.CATHSTIM • STSCATH.AOVSTEN SIR users’ conference

25. Ad-Hoc Reporter • 1. Output File Type and name SIR users’ conference

26. Ad-Hoc Reporter • 2. Select Variables SIR users’ conference

27. Ad-Hoc Reporter • 2. Select Variables SIR users’ conference

28. Ad-Hoc Reporter • 3. Local Variables SIR users’ conference

29. Ad-Hoc Reporter • 4. Sort Output SIR users’ conference

30. Ad-Hoc Reporter • 5. Extra Options SIR users’ conference

31. Ad-Hoc Reporter • 6. Filter Records SIR users’ conference

32. Ad-Hoc Reporter • 7. Finished SIR users’ conference

33. Registry Retrievals SIR users’ conference

34. Registry Retrievals • Registry Retrieval-Visit Level • Allows full access to all components of the Cath Lab Visit. • Fully editable variable list. • Hospamid fields may be specified for particular locations. • The default is by procedure date but discharge date may be specified. SIR users’ conference

35. Registry Retrievals • Registry Retrieval-Segment Level • Allows full access to all components of the Cath Lab Visit including Segment. • Fully editable variable list. • Hospamid fields may be specified for particular locations. • The default is by procedure date but discharge date may be specified. • One record appears on the report for each segment entered into the database. • Equipment information is summarized. SIR users’ conference

36. Registry Retrievals • Registry Retrieval-Equip Level • Allows full access to all components of the Cath Lab Visit including Segment and Equipa. • Fully editable variable list. • Hospamid fields may be specified for particular locations. • The default is by procedure date but discharge date may be specified. • One record appears on the report for each Equipa entered into the database. • Equipment information is summarized. SIR users’ conference

37. Registry Retrievals Registry Retrieval-Visit Level Edit list of variables Run the Registry Retrieval Location of Word Location of editable file SIR users’ conference

38. Registry Retrievals Registry Retrieval-Visit Level Edit the variables: SIR users’ conference

39. Registry Retrievals Pull down for facility Or all Pick your format SAS SPSS DIF Pick the procedure type. Visit Level SIR users’ conference

40. Category Report: Complication SIR users’ conference

41. Category Report: Complication New features include MD and network/hospital reporting. SIR users’ conference

42. Category Report: Complication A new feature allows standard reports to be qualified for an entire group of reports. SIR users’ conference

43. Category Report: Complication Enter the date range in for the report SIR users’ conference

44. Category Report: Complication Note that the reports are enabled to be selected. SIR users’ conference

45. Category Report: Complication SIR users’ conference

46. Category Report: Complication SIR users’ conference

47. Category Report: Complication SIR users’ conference

48. Category Report: Complication SIR users’ conference

49. Category Report: Complication SIR users’ conference

50. Category Report: Complication SIR users’ conference