SIR

1

• Report Writing with heartbase

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.

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.

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

5
Report Writing with heartbase

• Startin directory.

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
7
Report Writing with heartbase

• Pick procedures

Put your editor here
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
9
Access Main Reports from the Reports Icon
Main Reports
10
ACC and STS reporting Main Menu
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.

12
ACC Cath Lab Reports
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

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.

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.
16
heartbase Query Tool
Clicking on the different variables will
highlight them. Once the desired variables have
been selected, click "OK."
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."
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.
19
heartbase Query Tool
The report will go to SPSS by default, use
pulldowns for SAS and Excel formats
20
heartbase Query Tool
You have an option of saving the source code for
this report to a PQL file name.
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

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
23
Ad-Hoc Reporter Customize your Data Points

• Default Logic
• global easyprofNONE
• Lets all the SIR record types be displayed when
  using the PROCEDURE command.
• STS2.52
• global easyprofSYSTEM.easyS252
• Sets the PROCEDURE to allow only the record
  types/fields found in member SYSTEM.EASYS252

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

25
Ad-Hoc Reporter

• 1. Output File Type and name

26
Ad-Hoc Reporter

• 2. Select Variables

27
Ad-Hoc Reporter

• 2. Select Variables

28
Ad-Hoc Reporter

• 3. Local Variables

29
Ad-Hoc Reporter

• 4. Sort Output

30
Ad-Hoc Reporter

• 5. Extra Options

31
Ad-Hoc Reporter

• 6. Filter Records

32
Ad-Hoc Reporter

• 7. Finished

33
Registry Retrievals
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.

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.

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.

37
Registry Retrievals
Registry Retrieval-Visit Level
Edit list of variables
Run the Registry Retrieval
Location of Word
Location of editable file
38
Registry Retrievals
Registry Retrieval-Visit Level Edit the
variables
39
Registry Retrievals

• Visit Level

Pull down for facility Or all
Pick your format SAS SPSS DIF
Pick the procedure type.
40
Category Report Complication
41
Category Report Complication

• New features include MD and network/hospital
  reporting.

42
Category Report Complication
A new feature allows standard reports to be
qualified for an entire group of reports.
43
Category Report Complication
Enter the date range in for the report
44
Category Report Complication
Note that the reports are enabled to be selected.
45
Category Report Complication
46
Category Report Complication
47
Category Report Complication
48
Category Report Complication
49
Category Report Complication
50
Category Report Complication
51
ACC Cath Lab Report

• The End

52
(No Transcript)
53
STS Reports
54
STS Reports

• The main menu for STS reports has been broken up
  into three sections
• STS 2.41
• STS 2.52
• All Versions
• Note that All Versions means 2.41 and 2.52
  combined. 2.35 was not tested against these
  reports.

55
STS 2.52 Query Tool/Registry Retrieval

• Registry retrieval and the query tool have been
  combined into one easy to use tool.

STS 2.52 Registry Retrieval
Select Fields here
Calculated Fields
Click for by discharge
Report Constants
56
STS 2.52 Query Tool/Registry Retrieval

• Select Fields

Notice change in record type
57
STS 2.52 Query Tool/Registry Retrieval

• Calculated Fields

58
STS 2.52 Query Tool/Registry Retrieval

• Run the Query

59
STS 2.52 Query Tool/Registry Retrieval

• See the Output

60
STS 2.52 Query Tool/Registry Retrieval

• Save a Source Copy

61
STS 2.41 and 2.52 Ad-Hoc Reporter

• The Ad-Hoc Reporter provides an easy way to
  generate output from the data in a database.
• Output can be a report, tabulation, graph, or an
  export file.
• Field specific picking of field names based on a
  member stored in the SYSTEM family names EASYSTS
  (STS 2.41) or EASYS25(STS 2.52).
• No implied joins are made so full relational
  database navigation is available.
• A variety of additional report formats are
  available.

62
STS Reports

• Complication Reporting
• reports have been greatly expanded to include
  more features and functions.
• New features include MD summarization.
• network/hospital comparisons.
• Analysis by complication category.

63
STS Reports

• Risk Analysis
• greatly expanded to include analysis by MD as
  well as many new report categories that relate to
  the CAB ONLY risk prediction models.
• Risk reports include CABG Only, All Risk, Deep
  Chest Infection, Renal Failure, Stroke, Vent,
  Reop, LOS 6 days, LOS 14 days and Any CABG.

64
STS Reports

• Mortality
• Enhanced mortality reporting has been developed
  based on the STS definition of Death.
• Operative Death, discharge status of 20, and a 30
  day mortality status of Dead result in a
  mortality count on this report.

65
STS Reports

• LOS
• Extensive LOS analysis is available by LOS
  categories of Admit to Discharge, Admit to
  Procedure, and Procedure to Discharge.
• Sub categories include MD, Sex, Procedure Status
  and race.

66
STS Reports

• Patient
• Many patient level reports are available.
• SPSS is used to access these reports.

67
STS Reports Complications
Report covers both versions of STS
68
STS Reports Complications
69
STS Reports Complications
70
STS Reports Complications
71
STS Reports Complications
72
STS Reports Complications
73
STS Reports Complications
74
STS Reports Complications
75
STS Reports Complications
76
STS Reports Complications
77
STS 2.52 Risk Analysis
78
STS 2.52 Risk Analysis

• Rules for Risk Reporting
• Must have previously run the risk scoring program
  for the date range in question.
• Scores are only produced for
• CABG only
• CABG AVR
• CABG MVR
• MVR Only
• AVR Only