Basic CIRS Reporting Modules

The modules below assist you in learning a particular ad hoc reporting technique or function.  They take you through the development process of building ad hoc report requests using FOCUS reporting language to produce various outputs:  online reports, batch reports, printed reports and download files.  The modules build in complexity with later modules reinforcing and complimenting the information learned in earlier modules. For additional information, refer to the material in Advanced CIRS Reporting Modules.   

 

Each of the modules below are Word documents that can be downloaded from a password protected site.  Contact the CIRS Hotline, if you are a CIRS user and need the userid and password to download.  To download the entire workbook, select a link below:

 

Basic CIRS Reporting Workbook (.zip,  470 KB)
Basic CIRS Reporting Workbook
(.exe,  538 KB)

 

Module 1, Introduction  (43 KB)

Welcome

What is CIRS?

How To Use This Workbook

Assumptions

Resources

Module 2, Ad Hoc Reporting Overview  (58 KB)

Ad Hoc Reporting Process

Terminology

Master File Descriptions

Using the Data Element Dictionary

What You Have Learned

Module 3, Basic FOCUS Commands  (117 KB)      

FOCUS Report Requests

Beginning and Ending Report Requests

Displaying Data

Sorting Report Columns

Selecting Records

Summary of Basic Commands

Practice

What You Have Learned

Module 4, Creating and Maintaining Requests  (87 KB)  

Personal Library

Navigation Options

Creating Requests

Line Edit Commands

Command Line Entries

Maintenance Commands

Practice

What You Have Learned

Module 5, Executing Requests Online   (77 KB)

Online Execution

Online File Selection

Online FOCUS Environment

Hot Screen

Printing Report Data

Fixing Errors Online

Exiting The Online FOCUS Environment

Practice

What You Have Learned

Module 6, Using Batch Functions  (265 KB)

Batch Functions

Batch Versus Online

Submitting Batch Jobs

Status and System Messages

Batch Job Reports

Practice

What You Have Learned

Module 7, Using Hold Files  (240 KB)

Hold Files Overview

Creating Hold Files

Browsing Hold Files

Editing Hold Files

Download Hold Files

Practice

What You Have Learned

Module 8, Customizing Printed Reports (98 KB)    

Headings and Footings

Creating New Column Titles

Changing Column Formats and Justification

Column and Row Totals

Subtotals

Practice

What You Have Learned

Module 9, Using Joined Files  (67 KB)

What Are Joined Files

Automatic Joins  

Pre-programmed Joins

Practice

What You Have Learned

Module 10, Creating Temporary Fields  (74 KB)

Temporary Fields Overview

Syntax For Computed Fields

Syntax For Defined Fields

Practice

What You Have Learned  

Module 11, Common Library  (92 KB)

Common Library Procedures

Accessing the Common Library

Finding Report Requests

Executing Report Requests

Copying From the Common Library

Copying To the Common Library

Practice

What You Have Learned

Module 12, Employment History Files (100 KB)

Employment History Files Overview

TR File Practice

Employment History Extract Process

Extract Verification

EH File Practice

What You Have Learned

Module 13, Payment History Files  (86 KB)

Payment Files Overview

PH File Practice

Payment History Extract Process

Extract Verification

PY File Practice

What You Have Learned

Module 14, Employment Verification  (57 KB)

Employment Verification Report Overview

Creating an Employment Verification Report

Printing an Employment Verification Report

Practice

What You Have Learned

Module 15, Closeout  (55 KB)

Ad Hoc Report Procedures

Summary of FOCUS commands

Recommendations for Successful Reporting

Appendix A, Contacts (38 KB)

Appendix B, Campus Codes  (50 KB)

Appendix C, Frequently Used Files  (51 KB)