OSHA Instruction TED 1.13 AUG 8, 1988 Office of Management Data Systems

Subject: Integrated Management Information System (IMIS) Training: Course DEscriptions and Registration Requirements

A. Purposes. This instruction describes the courses conducted by the Office of Management Data Systems to support the effective utilization and operation of the Integrated Management Information System (IMIS) in the Occupational Safety and Health Administration (OSHA).

B. Scope. This instruction applies to all individuals involved in the operation of the IMIS in Federal OSHA, the 18(b) States and the Consultation Projects.

C. Action. Use this instruction to assist in planning and registering for training required to support the IMIS.

D. IMIS Training Registration.

1. Registrar. The responsibilities of a Registrar are with the Field Systems Support Branch of the Office of Management Data Systems (OMDS). Contact this Branch to register for classes and for general information about training related to the IMIS. The address and telephone numbers are:

Office of Management Data Systems Attention: FSSB U.S. Department of Labor - OSHA 200 Constitution Avenue NW - Room N3661 Washington, DC 20210

FTS: 523-6251 Commercial: (202)523-6251

2. Who Shall Register students.

a. Office Field Personnel. Regional Administrators shall nominate personnel directly to FSSB.

b. National Office Personnel. National Office personnel shall contact FSSB directly to register for training.

OSHA Instruction TED 1.13 AUG 8, 1988 Office of Management Data Systems

c. 18(B) State and Consultation Project Personnel. Regional Administrators shall nominate personnel from 18(b) States and Consultation Projects for IMIS training directly to FSSB.

FSSB will accept direct nominations from State and Consultation officials if the Regional Administrator has approved that procedure.

3. Information Required to Register. The following information about each student is required for registration:

a. First and Last Name. b. Office Name, Address and Telephone Number. c. Reporting ID. d. Type of Equipment (CPU and Terminal). e. Program and Job Title.

4. Confirmation of Registration. FSSB will confirm registration with the nominee via letter as soon as the registration is recorded. In addition, FSSB will send written confirmation that the class will be conducted or notification that it has been canceled directly to participants approximately 2 weeks before each class is scheduled to begin. Copies of all correspondence related to training will be sent to the Regional Training Officer and to the Regional Consultation Project Officer where appropriate.

5. Student Cancellations. Regional Administrators shall submit the names of those canceling their registration no later than three weeks prior to course commencement. If last minute circumstances occur which require cancellation after the deadline, Regional Administrators will be asked to fill the vacant position if the cancellation brings the total enrollment in the class below 10.

E. Training Site.

1. Administrative Programs Training Center. All regularly scheduled IMIS training shall be conducted at the OSHA Administrative Programs Training Center located at:

7918 Jones Branch Drive McLean, Virginia 22102

OSHA Instruction TED 1.13 AUG 8, 1988 Office of Management Data Systems

2. Requests for Off-Site Courses. OMDS welcomes opportunities to meet with OSHA field, 18(b) State, and Consultation staff at any location to share information or to provide training which does not require use of computer equipment. Because of logistics and hardware problems, OMDS cannot agree to conduct training which is designed around the use of the computer at any remote site.

3. Equipment. The Training Center has two classrooms. Each room is equipped with one Altos 2086 and either three Altos 586 or two Altos 686 computers. This arrangement should make it possible for each student to be trained on the equipment he/she uses in the office and will give backup equipment if hardware failures occur.

F. Information Related to Training. The Regional Training Officer or a representative of the Chief of FSSB will counsel, as needed, nominees on course requirements and related issues to ensure the maximum benefit to participants and their offices.

G. Course Schedules.

1. Distribution of Class Schedules. The "Quarterly Schedule of IMIS Training" will be distributed to all potential candidates via the directive system midway through the preceding quarter. An advance copy will be sent to Regional Training Officers as soon as it is available.

2. Field Input into Scheduling. OMDS's goal is to schedule the appropriate mix of courses needed to meet the needs of the users in the most timely manner possible. To this end, OMDS will schedule courses on a quarterly basis based on the demand registered by the field. When a Region, 18(b) State or Consultation Project anticipates a training need, the Regional Training Officer should contact FSSB to add the potential student to a specific class roster or to a course roster for future classes. One month into each quarter, FSSB will contact each Regional Training Officer to ensure that all needed training has been reported. The number of people on waiting lists and on rosters for future training will determine which courses and how many of each course will be scheduled.

OSHA Instruction TED 1.13 AUG 8, 1988 Office of Management Data Systems

3. Class Cancellations. The minimum number of students required for a course to be conducted is ten (10). If fewer than 10 people are registered 3 weeks before any class is scheduled to begin, FSSB will solicit the Regions for additional students. If not enough can be found, the class will be canceled and registered students will be notified via letter. A message will also be added to the Start-of-Day messages informing all users of the cancellation.

H. Training Costs. There is no charge for attending any IMIS training. Travel costs incurred to attend are the responsibility of participants.

I. Accommodations and Transportation. Information on accommodations and transportation will be provided to each student with their registration confirmation.

David C. Zeigler Director Administrative Programs

Distribution: National, Regional, and Area Offices State Designees State 7(c)(1) Project Managers - 4 -

OSHA Instruction TED 1.13 AUG 8, 1988 Office of Management Data Systems

Course Number Course Title

701E Word Processing (XED) and System Administration

701C Word Processing (XED) and System Administration

702 Basic Enforcement Application Training

703 Advanced Enforcement Application Training

704C Information Retrieval for Consultation

704E Retrieval for Enforcement

705 Designing Applications with Informix

706 Advanced Informix Training

707 Using OSHA'S Management Information for Enforcement

708 Basic Consultation Application Training

710 Using OSHA'S Management Information for Consultation

OSHA Instruction TED 1.13 AUG 8, 1988 Office of Management Data Systems

_________________________________________________________________________

701E WORD PROCESSING (XED) AND SYSTEM ADMINISTRATION _________________________________________________________________________

Course Description: This is the basic course for personnel who use the

Altos 586/2086 microcomputer. Topics covered include the XED word processing package, basic system administration, and the use of the Altos equipment for electronic mail. It is recommended that this course be taken before any application training. (5 days).

Course Highlights: Intensive hands-on training enables the student to

actually perform the functions that are being discussed.

Course Objectives: Students should be able to:

* Send and receive electronic mail using the Altos

Prerequisites: None.

Class Times Generally, class starting time is 1:00 p.m. Monday.

The class ends mid-morning on Friday. For the remainder of the week, class runs from 8:30 a.m. to 5:00 p.m. unless otherwise arranged by the instructors.

NOTE: This course will use the equipment and menus developed for Enforcement. It is recommended that where possible Consultation personnel attend the 701C sessions and Enforcement personnel attend the 701E sessions, however, when required, this class is available to both Enforcement and Consultation staff.

OSHA Instruction TED 1.13 AUG 8, 1988 Office of Management Data Systems

_________________________________________________________________________

701C WORD PROCESSING (XED) AND SYSTEM ADMINISTRATION _________________________________________________________________________

Course Description: This is the basic course for personnel who use the

Altos 686/1086 microcomputer. Topics covered include the XED word processing package, basic system administration, and the use of the Altos equipment for electronic mail. It is recommended that this course be taken before any application training (5 days).

Course Highlights: Intensive hands-on training enables the student to

actually perform the functions that are being discussed.

Course Objectives: Students should be able to:

* Perform basic system administration functions.

* Send and receive electronic mail using the Altos.

Prerequisites: None.

Class Times: Generally, class starting time is 1:00 p.m. on Monday.

The class ends mid-morning on Friday. For the remainder of the week, class runs from 8:30 a.m. to 5:00 p.m. unless otherwise arranged by the instructors.

NOTE: This course will use the equipment and menus developed for Consultation. It is recommended that where possible Consultation personnel attend the 701C sessions and Enforcement personnel attend the 701E sessions however, when required, this class is available to both Enforcement and Consultation staff.

OSHA Instruction TED 1.13 AUG 8, 1988 Office of Management Data Systems

_________________________________________________________________________

_________________________________________________________________________

Course Description: This course covers the basic concepts required to

successfully operate the Enforcement application on the Altos 586/2086 microcomputer. Topics include forms completion and data entry, citation processing, form letter processing, start-of-day procedures, error correction and running reports (5 days).

Course Highlights: Intensive hands-on training enables the student to

actually perform the functions that are being discussed. The course emphasizes the ability to perform the basic operator tasks and only discuss reports and EOD/SOD in general terms.

Course Objectives: Students should be able to:

* Enter the forms in the Enforcement application.

* Create and generate local and standard formletters.

Prerequisites: 701, with exceptions granted by the Field Systems Support Branch.

Class Times: Generally, class starting time is 1:00 p.m. Monday.

The class ends mid-morning on Friday. For the remainder of the week, class runs from 8:30 a.m. to 5:00 p.m., unless otherwise arranged by the instructors.

OSHA Instruction TED 1.13 AUG 8, 1988 Office of Management Data Systems

_________________________________________________________________________

703 ADVANCED ENFORCEMENT APPLICATION TRAINING _________________________________________________________________________

Course Description: The course is designed for experienced operators and

covers such topics as how to increase space on the system, basic operating system commands, simple Informer queries, reject correction, system administration functions, creating local letters and reports, local and micro-to-host standard compliance reports, and the use of the Altos 586/2086 microcomputer to communicate and transfer files between Altos systems and to use the OCIS files at the Salt Lake City Lab.

Course Highlights: Intensive hands-on training enables the student to

actually perform the functions that are being discussed. Students are encouraged to ask questions and raise issues they have encountered in their offices.

Course Objectives: Students should be able to:

* Understand better the basic application functions.

* Perform and understand system administration functions.

* Use the Altos to communicate with other Altos equipment and SLC databases.

* Write simple Informer queries to select information from the OSHA database.

* Understand file permissions and the Xenix directory system.

Prerequisites: Course #702.

Class Times: Generally, class starting time is 1:00 p.m. Monday.

The class ends mid-morning on Friday. For the remainder of the week, class runs from 8:30 a.m. to 5:00 p.m. unless otherwise arranged by the instructors.

OSHA Instruction TED 1.13 AUG 8, 1988 Office of Management Data Systems

_________________________________________________________________________

_________________________________________________________________________

Course Description: This course is designed for personnel who need to use

the Informix database management package to write or better understand reports which use the Consultation database on the Altos 686/1086. (5 days).

When completed, the student should understand the Consultation database, and be able to write a simple Ace report. This will provide the basics for using Informix to meet unique local reporting needs of an office.

Course Highlights: Students are encouraged to bring a special project to

class and use it for their workshops. Many students leave class with a completed report which is useful in meeting work responsibilities in their offices.

Course Objectives: Students should be able to:

* Understand the structure of the Consultation database.

* Write Informer queries using more than one file to answer simple data requests.

* Write basic Ace programs to generate reports in a tailored format.

* Read and understand standard application Ace reports and Clearinghouse reports.

* Perform elementary data verification on their database using Ace reports.

Prerequisites: None, but participants should have general knowledge of XED or XTE.

Class Times: Generally, class starting time is 1:00 p.m. Monday.

The class ends mid-morning on Friday. For the remainder of the week, class runs from 8:30 a.m. to 5:00 p.m. unless otherwise arranged by the instructors.

OSHA Instruction TED 1.13 AUG 8, 1988 Office of Management Data Systems

_________________________________________________________________________

704E INFORMATION RETRIEVAL FOR ENFORCEMENT _________________________________________________________________________

Course Description: This course is designed for personnel who need to use

the Informix database management package to write or better understand reports which use the Enforcement database on the Altos 586/2086.(5 days).

When completed, the student should understand the Enforcement databases, and be able to write a simple Ace report. This will provide the basics for using Informix to meet unique local reporting needs of an office.

Course Highlights: Students are encouraged to bring a special project to

class and use it for their workshops. Many students leave class with a completed report which is useful in meeting work responsibilities.

Course Objectives: Students should be able to:

* Understand the structure of the Enforcement databases.

* Write Informer queries using more than one file to answer simple data requests.

* Write basic Ace programs to generate reports in a tailored format.

* Read and understand standard application Ace reports and Clearinghouse reports.

* Perform elementary data verification on their databases using Ace reports.

Prerequisites: None, but participants should have general knowledge of XED or XTE.

Class Times: Generally, class starting time is 1:00 p.m. Monday.

The class ends mid-morning on Friday. For the remainder of the week, class runs from 8:30 a.m. to 5:00 p.m. unless otherwise arranged by the instructors.

OSHA Instruction TED 1.13 AUG 8, 1988 Office of Management Data Systems

_________________________________________________________________________

_________________________________________________________________________

Course Description: The course is intended for personnel who need to

design their own databases and applications. Topics covered include creating databases and data entry screens. Basic system design issues are also covered. (5 days).

Course Highlights: Students are encouraged to bring a special project to

class and use it in the workshops. Applications developed in class can serve as a foundation for developing additional applications for use in local offices.

Course Objectives: Students should be able to:

* Understand the concepts of a relational database.

* Design and program a simple database to store information.

* Build a customized data entry screen for users which validates data upon entry.

* Write elementary Informer queries and Ace programs to recall information from the database.

Prerequisites: None, but participants should have general knowledge of XED or XTE.

Class Times: Generally, class starting time is 1:00 p.m. on Monday.

The class ends mid-morning on Friday. For the remainder of the week, class runs from 8:30 a.m. to 5:00 p.m. unless otherwise arranged by the instructors.

NOTE: This course is available to both Enforcement and Consultation staff. Classes are not specific to either program and may use either the Altos 586, 686 or 2086.

OSHA Instruction TED 1.13 AUG 8, 1988 Office of Management Data Systems

_________________________________________________________________________

706 ADVANCED INFORMIX TRAINING _________________________________________________________________________

Course Description: The advanced Informix class is designed for personnel

who extensively use the Informix package to write reports. It features a workshop format and presents advanced report writing techniques including shell scripts. The course will focus on discussions related to a class project. (5 days).

Course Highlights: This participatory class provides a forum for sharing

experiences in utilizing Informix to write Ace reports, develop additional applications, and maximising the use of the Altos as a management tool.

Course Objectives: Students should be able to:

* Write Informix programs that take advantage of Version 3.3 enhancements.

* Change printer pitch on a report program using software.

* Execute Ace programs and Informer queries from shell prompts.

* Use Xenix shell commands to shortcut using the Altos menu system.

* Use the cron file to run Informix reports at a specific time.

* Create temporary database files to use with reports.

Prerequisites: Course # 704C or # 704E and approval from the Field Systems Support Branch.

Class Times: Generally, this course starts at 8:30 a.m. Tuesday and

finishes at 5:00 p.m. on Thursday. On Wednesday, class runs from 8:30 a.m. to 5:00 p.m. unless otherwise arranged by the instructors.

OSHA Instruction TED 1.13 AUG 8, 1988 Office of Management Data Systems

NOTE: To register for Advanced Informix Training participants must first contact the Field Systems Support Branch of OMDS ((202)/FTS: 523-6251) for acceptance. They will be required to demonstrate that they are using Informix at a level commensurate with this advanced training.

OSHA Instruction TED 1.13 AUG 8, 1988 Office of Management Data Systems

_________________________________________________________________________

707 USING OSHA'S MANAGEMENT INFORMATION FOR ENFORCEMENT _________________________________________________________________________

Course Description: The course is designed for Area Directors, Supervisors

and State management officials involved with the Enforcement program. It introduces them to the specific tools provided by the Altos to help them manage the activity of the office. The Monday afternoon session is optional and will be an overview of computers for the participant who feels the need for a very basic introduction to the hardware and software components of the Altos equipment and the Enforcement application. Tuesday morning begins the hands-on training which focuses on "Desired State" reports, tracking options, micro-to-host reports, asynchronous communications, OCIS and managing the IMIS in the office. (4 days).

Course Highlights: Hands-on training enables the manager to actually run

the reports being discussed and become more comfortable with the system itself. Participants are encouraged to ask questions and raise issues they have encountered in their offices.

Course Objectives: Students should be able to:

* Understand the reports referenced in the ADP "desired state" memorandum.

* Understand the report generation capabilities of the microcomputer.

* Use the manuals to determine whether a report exists and how to interpret the data.

* Request a micro-to-host report for historical data.

Prerequisites: No prior computer training is required.

Class Times: Generally class starting time is 1:00 p.m. Monday for

the optional overview. The class ends mid-morning on Friday. For the remainder of the week, class begins at 8:30 a.m. and ends at 5:00 p.m.

OSHA Instruction TED 1.13 AUG 8, 1988 Office of Management Data Systems

_________________________________________________________________________

708 BASIC CONSULTATION APPLICATION TRAINING _________________________________________________________________________

Course Description: The course covers the basic functions required to

successfully operate the Consultation application on the Altos 686/1086. Topics covered include forms completion and data entry, report and form letter processing, start-of-day/end-of-day procedures, asynchronous communications and running reports (5 days).

Course Highlights: Intensive hands-on training enables the student to

actually perform the functions that are being discussed. The course emphasizes the ability to perform the basic operator tasks and only discusses reports in general terms.

Course Objectives: Students should be able to:

* Enter the forms in the Consultation application.

* Create, modify, and print Reports to the Employer.

* Create, and generate local and standard formletters

Prerequisites: Course # 701 with exceptions granted by the Field Systems Support Branch.

Class Times: Generally, class starting time is 1:00 p.m. Monday.

The class ends mid-morning on Friday. For the remainder of the week, class runs from 8:30 a.m. to 5:00 p.m. unless otherwise arranged by the instructor.

OSHA Instruction TED 1.13 AUG 8, 1988 Office of Management Data Systems

_________________________________________________________________________

710 USING OSHA'S MANAGEMENT INFORMATION FOR CONSULTATION _________________________________________________________________________

Course Description The course is designed for managers and supervisors

involved in the Consultation program. It introduces them to the specific tools provided by the Altos to help them manage the activity of the project. The Monday afternoon session is optional and will be an overview of computers for the participant who feels the need for a very basic introduction to the hardware and software components of the Altos equipment and the Consultation application. Tuesday morning begins the hands-on training which focuses on reports, tracking options, asynchronous communications for OCIS and E-mail, and managing the IMIS in the office. (4 days).

Course Highlights: Hands-on training enables the manager to actually run

the reports being discussed and become more comfortable with the system itself. Participants are encouraged to ask questions and raise issues they have encountered in their offices.

Course Objectives: Students should be able to:

* Understand the report generation capabilities of the microcomputer.

* Use the manuals to determine whether a report exists and how to interpret the data.

* Request a micro-to-host report for historical data.

Prerequisites: None.

Class Time: Generally, class starting time is 1:00 p.m. Monday for

the optional overview. The class ends mid-morning on Friday. For the remainder of the week, class begins at 8:30 a.m. and ends at 5:00 p.m.