Workshops

Print Page

TECH

 

♦ = Lecture

Δ = CEU

TECH CLINICAL SECURITY
W15

Learn the steps to securing patient data, while still providing users with the functionality they need to do their job. We’ll cover security for individual users and equivalents for Advanced Clinicals (GUI) and Clinical Suite (Web) functions and data. There will be practical examples and practice time. This class will focus on learning to use the Security File Maintenance process in Advanced Clinicals File Maintenance. We will also discuss the file maintenance and user functions associated with setting preferences.

Audience: Beginners class focused on new clinical users responsible for the decisions and processes required to maintain security in MS4’s GUI and Web applications.

TECH DBU/DFU UTILITIES
W59

Not a programmer, but you need to change the data in a protected field? Just found out that you used the wrong state abbreviation for Maine, and you just created 150 records? Take advantage of this workshop to learn how to access a data file and change or delete the data within the file without a specific access program of two very powerful tools.

The data file utility (DFU), which is part of the iSeries™ Applications Development Tools package available from IBM®, is a program builder that helps you create programs to enter data, update tables, and make inquiries. It can be one of the best friends you’ll make in the iSeries world.

One of the other best friends you can make is DBU, a third party product. It is a utility that also lets you add, change, delete, and display records in a file without creating a program. With DBU you can:

  • Add, change, delete and display records in any file
  • Search and replace/delete using multiple search arguments
  • Have instant access to data base relations allowing selection
  • Access on-line file layouts for field selection and documentation
  • Complete user profile based security and audit logs

Audience: IT staff responsible for file and database management. Use of these powerful tools is not for the faint of heart.

TECH FAST START – PART 1
W32

Your brand new IBM i5/iSeries has been installed and your MS4 software was just loaded. Now what? Join the Fast Start workshop to get acquainted with the i5, as well as how MS4 utilizes this versatile system. In Part 1 you will learn about MS4 object nomenclature, i5 commands, i5 menus, i5 security, and work management.

Audience: Anyone who wants to know more about navigating the i5 and MS4’s relationship to it.

TECH FAST START – PART 2
W46

In Part 2 of the Fast Start workshop we continue learning about work management and then move into the MS4 menu driver, problem determination, journaling, and much more.

Audience: Anyone who wants to know more about navigating the i5 and MS4’s relationship to it.

TECH GP TRIGGERS
W60

Triggers are great little time savers that ensure updated or new data gets put in all the right places. They are programs attached to a database event that run automatically when the event occurs.

The GP Triggers workshop gives you an understanding of how MS4’s GP triggers operate and what they can do. This session offers hands-on work with the Trigger Master file, associated job descriptions, attaching and removing triggers, and managing trigger errors.

Audience: IT staff responsible for maintaining triggers.

TECH MS4 WEB SETUP
W55

Moving from green screen to browser interface need not be painful. This presentation covers the planning and requirements needed to install MedSeries4’s Web user interface over existing Patient Accounting and General Financial legacy applications and reviews MS4 Web applications, navigating in the browser, application-specific concepts, and troubleshooting.

Audience: IT technical staff

TECH OPTIMIZING DAYEND
W45

Master the art of using the Automated Dayend Monitor and the IBM Job Scheduler. Work with the Save While Active function, learn how to maintain a multientity environment for training and testing, and experience how to run Automated Dayend with or without prompts.

Audience: IT staff who execute or support Dayend processes.

TECH SQL PERFORMANCE AND DATABASE ADMINISTRATION
W62

Set sail on an amazing journey into the uncharted waters of SQL and Database performance monitoring. SQL is used more and more by applications to retrieve and process data. Learn how this happens and why it is important for you to know how to monitor SQL behavior. This information can help you keep your IT ship moving full steam ahead rather than just treading water.

Among other things, this workshop covers:

  • Understanding SQL
    • What is it?
    • How does it affect me?
  • SQL Performance Monitoring
    • Learn how SQL is affecting the iSeries performance.
    • What is balancing workloads?
    • What is the value of an index?
    • How to detect and avoiding full table scans.
  • Database Monitoring
  • iSeries Navigator
    • What is it?
    • How can this tool help me with SQL?
  • Visual Analyzer
    • How to use this tool.
    • What can it tell me?
  • DBMON – Database Monitoring tool
  • What to do when you encounter problems

We’ll also discuss how MedSeries4 is utilizing SQL in its applications.

Audience: Intermediate. It is best if students have some experience working in an iSeries environment, and exposure to SQL.