MEDITECH Expanse introduces important new changes in the Data Repository, including all new tables in ABS and BAR, to reflect the changes begun in 6.0 with REG and HIM tables. In this T-SQL report writer/programmer-focused session, we’ll review how using these new tables is different from MAGIC, C/S and 6.0 and demonstrate how to write efficient T-SQL code when looking for patient diagnoses, capturing dates and times from different points during a patient stay, and how to quickly query account financial data from BAR, either at the summary or the transaction-level.
If you’re a DR report writer or data analyst, come see what’s new in this Tuesday Training.
: Ian Proffer, Director of Communication and Training, Acmeware
Before joining Acmeware in 2007, Ian Proffer spent seven years in healthcare IT at Jefferson Healthcare in Port Townsend, WA (a MEDITECH C/S site) and Harborview Medical Center in Seattle. Ian has worked for the last 20 years as a consultant, report writer, database analyst, administrator, and architect, including four years at Microsoft Corp., where he worked extensively with SQL Server starting on version 4.21. His practical work experience in healthcare includes database analysis and administration, report and application authoring and development, and user education and training.