MS4 & Vision – Vision User Group Conference 2010 – In Full Swing

Improve the way you turn data into information using tools to analyze, communicate, and share results. Learn the basics of this report-writing software including sorts, selection criteria, group creation, summary fields, drill-downs, section formatting, and creating formulas. Instruction also covers the basics of database linking as it relates to PC and ODBC databases.

Audience: Anyone needing to access and report on MS4 application data.

MedSeries4 applications contain more than 40,000 fields, each one a little packet of potential information. Understanding and utilizing this huge database of information can be a daunting task without an understanding of the design logic behind 25 years of MedSeries4 application development. Like a genome, MS4 application data is built from a simple-to-complex arrangement of data, each with its own distinguishing characteristics and attributes. Our workshop starts at the highest level and dissects database structures down to their most atomic characteristics and concludes with a hands-on introduction to the Query/400 Reporting tool.

Audience: Anyone with a desire to understand MedSeries4 database structures and reporting tools. This workshop is a pre-requisite for upper division Query classes.

Query/400 is an excellent tool that lets you quickly design ad-hoc reports for organizing and reporting information, testing data, or creating a database for external use. The Query – Beginning workshop offers a basic, hands-on overview of IBM’s Query/400 utility. This tool is not specific to any application and emphasizes designing, formatting, and running a basic Query definition. There will also be class time for individual exercises.

Audience: Anyone needing to access and report on MS4 application data.

Use more sophisticated techniques to turn up the heat a notch in Query definitions. Building on skills learned in Beginning – Query, the Intermediate – Query workshop continues work with joined files, result fields, and other complex Query functions. There will also be class time for individual exercises.

Audience: Users with a basic knowledge of Query/400 who need to access and report on MS4 application data.

Despite rumors of its demise, Query/400 continues to remain one of the most popular applications for informal, ad-hoc reporting needs. This advanced workshop explores new ways of squeezing more functionality from this venerable tool. The three hour, hands-on session adds new techniques for advanced screen formatting, file recursion, output to IFS, matched and unmatched record functions, views (your own logical file), parameters, and more.

Audience: Users with a good knowledge of Query/400, and a working knowledge of SQL and MS4 database structures.

Taught by a Clinical Informaticist, this workshop teaches you to use Query/400 to create a myriad of reports, from daily worklists to aggregate studies, all from existing MS4 clinical applications. You will work with files from Order Communications and MS4 Repository in complex Query functions and see how the files can integrate with AR/ADT. Participants must already have advanced query skills, and be able to independently write a query that joins files. No instruction time will be spent on Query basics.

Audience: Advanced Clinical Informaticists

SELECT * FROM BrainOfInstructor WHERE CATEGORY=‘TECH’ & CLASS = ‘SQL ADVANCED’

SQL Advanced is where you will learn more complex SQL tricks including table joins, creating and dropping tables and indexes, and query optimization. Explore the case statements and functions that can make your SQL statements more powerful than most people realize and make the data manipulation/management much easier.

Audience: Advanced SQL users