Report Writing with heartbase
This presentation is the property of its rightful owner.
Sponsored Links
1 / 78

Report Writing with heartbase PowerPoint PPT Presentation


  • 73 Views
  • Uploaded on
  • Presentation posted in: General

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

Download Presentation

Report Writing with heartbase

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Report writing with heartbase

Report Writing with heartbase

SIR

users’ conference


Report writing with heartbase

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


Report writing with heartbase1

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


Report writing with heartbase2

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


Report writing with heartbase3

Report Writing with heartbase

  • Startin directory.

SIR

users’ conference


Report writing with heartbase4

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


Report writing with heartbase5

Report Writing with heartbase

  • Pick procedures

Put your editor here

SIR

users’ conference


Report writing with heartbase6

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


Access main reports from the reports icon

Access Main Reports from the Reports Icon

Main Reports

SIR

users’ conference


Acc and sts reporting main menu

ACC and STS reporting Main Menu

SIR

users’ conference


Acc cath lab reports

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


Acc cath lab reports1

ACC Cath Lab Reports

SIR

users’ conference


Query tool

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


Query tool1

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


Heartbase query tool

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


Heartbase query tool1

heartbase Query Tool

Clicking on the different variables will highlight them. Once the desired variables have been selected, click "OK."

SIR

users’ conference


Heartbase query tool2

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


Heartbase query tool3

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


Heartbase query tool4

heartbase Query Tool

The report will go to SPSS by default, use pulldowns for SAS and Excel formats

SIR

users’ conference


Heartbase query tool5

heartbase Query Tool

You have an option of saving the source code for this report to a PQL file name.

SIR

users’ conference


Ad hoc reporter

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


Ad hoc reporter customize your data points

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


Ad hoc reporter customize your data points1

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


Ad hoc reporter customize your data points2

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


Ad hoc reporter1

Ad-Hoc Reporter

  • 1. Output File Type and name

SIR

users’ conference


Ad hoc reporter2

Ad-Hoc Reporter

  • 2. Select Variables

SIR

users’ conference


Ad hoc reporter3

Ad-Hoc Reporter

  • 2. Select Variables

SIR

users’ conference


Ad hoc reporter4

Ad-Hoc Reporter

  • 3. Local Variables

SIR

users’ conference


Ad hoc reporter5

Ad-Hoc Reporter

  • 4. Sort Output

SIR

users’ conference


Ad hoc reporter6

Ad-Hoc Reporter

  • 5. Extra Options

SIR

users’ conference


Ad hoc reporter7

Ad-Hoc Reporter

  • 6. Filter Records

SIR

users’ conference


Ad hoc reporter8

Ad-Hoc Reporter

  • 7. Finished

SIR

users’ conference


Registry retrievals

Registry Retrievals

SIR

users’ conference


Registry retrievals1

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


Registry retrievals2

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


Registry retrievals3

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


Registry retrievals4

Registry Retrievals

Registry Retrieval-Visit Level

Edit list of variables

Run the Registry Retrieval

Location of Word

Location of editable file

SIR

users’ conference


Registry retrievals5

Registry Retrievals

Registry Retrieval-Visit Level

Edit the variables:

SIR

users’ conference


Registry retrievals6

Registry Retrievals

Pull down for facility

Or all

Pick your format

SAS

SPSS

DIF

Pick the procedure

type.

Visit Level

SIR

users’ conference


Category report complication

Category Report: Complication

SIR

users’ conference


Category report complication1

Category Report: Complication

New features include MD and network/hospital reporting.

SIR

users’ conference


Category report complication2

Category Report: Complication

A new feature allows standard

reports to be qualified for an

entire group of reports.

SIR

users’ conference


Category report complication3

Category Report: Complication

Enter the date range in for the report

SIR

users’ conference


Category report complication4

Category Report: Complication

Note that the reports are enabled to be selected.

SIR

users’ conference


Category report complication5

Category Report: Complication

SIR

users’ conference


Category report complication6

Category Report: Complication

SIR

users’ conference


Category report complication7

Category Report: Complication

SIR

users’ conference


Category report complication8

Category Report: Complication

SIR

users’ conference


Category report complication9

Category Report: Complication

SIR

users’ conference


Category report complication10

Category Report: Complication

SIR

users’ conference


Acc cath lab report

ACC Cath Lab Report

The End

SIR

users’ conference


Report writing with heartbase

SIR

users’ conference


Sts reports

STS Reports

SIR

users’ conference


Sts reports1

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.

SIR

users’ conference


Sts 2 52 query tool registry retrieval

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

SIR

users’ conference


Sts 2 52 query tool registry retrieval1

STS 2.52 Query Tool/Registry Retrieval

Notice change in record type

Select Fields

SIR

users’ conference


Sts 2 52 query tool registry retrieval2

STS 2.52 Query Tool/Registry Retrieval

Calculated Fields

SIR

users’ conference


Sts 2 52 query tool registry retrieval3

STS 2.52 Query Tool/Registry Retrieval

Run the Query

SIR

users’ conference


Sts 2 52 query tool registry retrieval4

STS 2.52 Query Tool/Registry Retrieval

See the Output

SIR

users’ conference


Sts 2 52 query tool registry retrieval5

STS 2.52 Query Tool/Registry Retrieval

Save a Source Copy

SIR

users’ conference


Sts 2 41 and 2 52 ad hoc reporter

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.

SIR

users’ conference


Sts reports2

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.

SIR

users’ conference


Sts reports3

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.

SIR

users’ conference


Sts reports4

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.

SIR

users’ conference


Sts reports5

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.

SIR

users’ conference


Sts reports6

STS Reports

  • Patient

    • Many patient level reports are available.

    • SPSS is used to access these reports.

SIR

users’ conference


Sts reports complications

STS Reports: Complications

Report covers both versions of STS

SIR

users’ conference


Sts reports complications1

STS Reports: Complications

SIR

users’ conference


Sts reports complications2

STS Reports: Complications

SIR

users’ conference


Sts reports complications3

STS Reports: Complications

SIR

users’ conference


Sts reports complications4

STS Reports: Complications

SIR

users’ conference


Sts reports complications5

STS Reports: Complications

SIR

users’ conference


Sts reports complications6

STS Reports: Complications

SIR

users’ conference


Sts reports complications7

STS Reports: Complications

SIR

users’ conference


Sts reports complications8

STS Reports: Complications

SIR

users’ conference


Sts reports complications9

STS Reports: Complications

SIR

users’ conference


Sts 2 52 risk analysis

STS 2.52 Risk Analysis

SIR

users’ conference


Sts 2 52 risk analysis1

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

SIR

users’ conference


  • Login