Streamlined Healthcare
Reporting Solutions
When it comes to creating and maintaining productivity reports, several clients find themselves faced with high staff turnover and/or challenges dealing with the costs of buying analytical software and the steep learning curve that comes with it. If you find this situation familiar, there are other options!

Several of our clients have taken advantage of Keena’s expert SQL programmers and their ability to provide a wide spectrum of automated reports. Whether you need a one-off report or ongoing performance tracking intelligence, our skilled TouchWorks subject matter and coding experts will quickly transform your requests into actionable reports to meet your data needs as follows:
- Customized requests designed to meet the needs of each client
- Scheduled at given intervals and delivered via email or saved to a network file location
Sample of Custom Reports Available
All Active Tasks
ApptCharge_DocStatus_DTTM.
Clinical Trial Analysis
EHR Controlled Meds
EHR Incomplete Notes
EHR PA Med Audit Report
EHR Wellness Report
EHR Worklist Report
FA Worklist – Order (Daily)
HCC Patient Report
Interface_Audit_EMR_Charge_Report (Daily)
Monthly Reception Report w/ Summary
No Login within 1 Month – Active Users
Provider Overdue Pap Reports
Tasking Productivity Report
Tasks Assigned to Inactive Users Report
TOC Report (Monthly)
Unprocessed Orders Report
Weekly Worklist Stats
YTD Encounters per PCP (Monthly)
Tips and Tricks
Did you know SSMT can help provide insight into the TouchWorks database?
Do you have an extract that is far too large for SSMT to handle?
- Analysts can use SSMT to determine the database call used to extract the Content Category by checking the “Show Database Calls?” checkbox prior to clicking the Extract Data button. When this checkbox is selected the database call will show at the top of the screen.
- For example, if the above workflow is done for the Content Category of “Chart View – Sections”, the database call of “Exec IMPGetChartViewSections” will appear at the top of the screen.
- This call can then be run directly in SQL OR a review of the stored procedure for insight into the stored procedure on tables accessed via SSMT.
Past Bulletins

Issue #5
V22 Preparations and Vaccine Workflows

Issue #4
Staffing Issues, Latest Altera/Veradigm News
Get Involved
Tech Talk
Monthly client discussion, facilitated by Keena consultants
Please join our next call on the 4th Tuesday of each month. Contact Christine Piper for an invite. You must be live on v20+ to participate.
Attention Altera TouchWorks v20+ clients! Keena has started a client driven technical user group that is brought together to discuss common technical challenges around your v20+ upgrade. Recent topics include Application Pool Recycling and Monitoring; and addressing troubled servers.
Everything Interfaces
Quarterly client discussion, facilitated by Keena consultants
Please join our next call on the 2nd Tuesday of each Month.
Open to all Altera TouchWorks regardless of version or interface engine application. Everything Interfaces provides a discussion about challenges, and tips & tricks to improve the function and efficiency of complex interface operations facing Altera clients.