Altera & Veradigm Bulletin
Streamlined Healthcare
Reporting Solutions
What’s the Buzz this month?
Reporting
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)
Past Issues
ALTERA BULLETIN: ISSUE #5
ALTERA BULLETIN: ISSUE #4
ALTERA BULLETIN: ISSUE #3
ALTERA BULLETIN: ISSUE #2
Automating Document Management,
Printout Tips & Advisory Services
ALTERA BULLETIN: ISSUE #1
Interface Engine Migration,
v20 Upgrades and Crystal Report Tip
Networking
Opportunities
Keena TechTalk TWEHR V20+
Fourth Tuesday of each month at 2pm CST
- Open TouchWorks Clients with at minimum v20 installed in Production. Technical discussions re: servers, database, printing, integrations, etc.
Reach out to Christine to get the call invite
Keena Everything Interfaces
Quarterly, Second Tuesday of the Second month (8/8 is next call) at 1 pm CST
- Open to all TouchWorks Clients regardless of version or interface engine.
Reach out to Christine to get the call invite
CRUG Monthly Membership Call
Third Tuesday of each month at 2pm CST
- Open to CRUG members to discuss all items TouchWorks primarily Analyst driven
Altera TWEHR Basecamp
June 20th – 21st – Chicago
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.