Transcript Using Data Dump to Export Data from StarPanel Purpose: Means of exporting data as Excel spreadsheet for manipulation outside StarPanel.

Using Data Dump to Export
Data from StarPanel
Purpose: Means of exporting data as Excel
spreadsheet for manipulation outside
StarPanel. Generally start process from Pt.
View w/ after setting date range to include
patients previously admitted to unit w/
current inpts. (or to look at prior date range
entirely such as 1st 6 months of 2007).
Important: Data Dump can only be done from
an Administrative Workstation (AWS).
2
1
From a patient list (in this case created from Inpatient Census by selecting
a unit), pull up a list of patients in Patient View format. Notice options
circled in orange in bottom example.
Result 
1
2
Use pop up calendar to enter start and end
date for data search and click on OK button
3
Depending on size of new panel being
created, it may take a few minutes.
Watch green bars at bottom of screen
to monitor progress.
Demographic data that can be
pulled into spreadsheet by
checking box beside item.
StarPanel mapping names OR name
of StarForm against which you wish
to search go here
If you click here, you get a list of
StarForms from which to select
the one(s) you want to query.
Check desired form(s) and
click on Add Forms box
CATHETER_TYPE
Correct “syntax” is critical to getting the desired result.
You need to enter the triple G lab code (usually a 3 digit
code) in the Lab test names space or enter the HED
code in the Form field names space.
To find these correct names:
•find a patient who has the desired data charted
•go to that patient’s flowsheet
•find the value
•hover over it to see the name
•Enter exactly the same way for your search (eg.
UPPER and lower case, special characters, etc. must
match exactly)
• you may also find these correct item names from Fast
Labs view of HED data
Sample completed Data Dump
instructions. Note I checked boxes to
open new window & Start up MS
Excel. (More details on this in next
slide.)
Job processes in
new window. May
take some time.
Watch green bars
at bottom of screen
for status.
The settings checked above were used to get the report below. The columns with
headers (like the example below) make the report more user friendly. The example
on next page was produced WITHOUT checking “Dump as table rows”.
When processing complete,
you must click on Open
button to view results.
Caution!
This is the step that will NOT
work on a CWS so you
cannot even create a query
on a CWS.
Sample spreadsheet
produced with different
settings than the one on
the previous page. Note
that there are multiple
rows for each account
number in this example.
This was created without
using “Dump data as table
rows” making it somewhat
harder to understand.
1
Queries are initially named for date/time produced. To re-use or send to someone
else, you’ll want to rename to something logical. To do this: 1) right click diamond
to left of query you want to re-name. You’ll get the pop-up box shown. 2) Enter the
new name of the Query and click OK. 3) The name will then display in your
“Previous choices” section.
2
3
Once you have run the Query and have an Excel spreadsheet, you will want to
save it so you can review later. You will not be able to do this step on a CWS so
Data Dump queries should always be done from an AWS. 1) You will get a pop-up
telling you that the spread sheet produced if “read only” and instructions to click on
OK button to save. 2) You will need to enter both a file name AND select the
desired file type ( Excel 97-2003 Template selected in this example).
1
2
1
Once you’ve created a Query, you can send to another user (or users). 1) Click
Send query to user hyperlink. 2) You can enter last name of user and Star will
search for RacF ID. 3) Enter the name of the Query and click Send hyperlink.
2
3
Hints for Reusing Queries
When you create a query for use by others, you need to provide
guidance on how to use.
– Make sure you save query with an understandable name before you
send to someone else. This will make it clear to them which one to use
should they have more than one query available.
– The date range will need to be re-entered for each use. For example, if
they want to look at compliance with Braden screen once a week, each
time they run the query, they’ll need to enter the new date range.
– Make sure the resultant reports meet their needs and is understandable.
You may need to tweak the Excel output parameters to get it “just right”.
– The query you forward will contain the syntax needed but not all of the
Excel set up instructions so make sure you also tell them exactly which
boxes to check to obtain the desired report configured in the most
usable manner. A screen shot showing the correct boxed checked might
be helpful to novice users.
To Delete a Query: 1) right click on diamond beside Query to be deleted and in the
pop-up, click on Delete query hyperlink. 2) You will get pop-up asking you to confirm.
Click OK button. 3) The Query is deleted.
1
2
3
Sample Problems:
1) Bed, Date of Adm., Case #, and Unit are not retained in Pt. View for Discharged Pts. so these fields blank.
2) Patient was on S44 5/14-15 & discharged. Was readmitted to SICU on 5/21 so SICU Bed, Adm. Date, Case # & Unit
display. In such cases, you’d pay attention only to the dates the patient was on the unit of interest.
Key Points to Remember
•
•
•
•
•
•
•
•
To create or run a Data Dump query, you must work from an AWS.
You must use correct syntax for your search terms. Find HED terms from Nursing
Flowsheet or Fast Labs view of HED data.
Experiment with various Excel output format options to produce a usable report.
Once you have the query perfected, rename it to something that will make sense next
time you need to use it.
You may create a query and then sent to someone else so they can run the query as
often as they need to review the data.
When you send a query, make sure you send instructions on how to set up Excel set
up check boxes to obtain the optimally formatted report.
Make sure anyone who will use a query is familiar with possible problems they might
see. Review the first report with them to ensure understanding. Offer to explain
questions going forward.
A query created for one unit can be used on another unit but you might want to
rename to avoid confusion. (Eg. Braden Compliance Report 9S renamed Braden
Compliance Report 10N).