Skip Navigation

Southern Oregon University

Banner Systems

Banner Reports and Jobs Menu

Overview

You can run reports and other batch processes directly from Banner using the Process Submission Controls form (GJAPCTL).  You complete the information on this form, identifying the job you want to submit, where you want the output directed and the parameter values, such as registration term code, you want to program to use.  After you select the SUBMIT radio button and save the information, Banner starts a batch process in the background that executes the job.  This is commonly referred to as "Job Submission."  

A Reports and Jobs menu on the main menu in Banner conveniently organizes reports and other batch processes into folders based on the University organization structure. 

You have many options with Job Submission. You can send the report output to a Banner print queue of your choosing (or a default Banner print queue).  You can email the output to yourself or someone else.  You can view the output online from Banner or even launch it in a web browser from which you can save it to your desktop.  These last two options are especially useful for reports which produce comma-delimited extract files you may wish to convert to a spreadsheet.

There are multiple report format options: portrait and condensed portrait; landscape and condensed landscape.

There is even a Banner form which allows you to monitor the status of your job so you know when it has completed.

The Job Submission Process consists of the following steps:

  1. Select your report from the Reports and Jobs menu (or your personal menu) on the Banner main menu or access the report from the Direct Access (Go To...) box.
  2. Provide the necessary parameters on the Process Submission Controls form (GJAPCTL) and submit the job.
  3. Monitor the job status on the Banner Job Submission Results form (GWIJOBR).
  4. Review the job output:
    1. On the Saved Output Review form (GJIREVO), if you chose to view the output online,
    2. In your email inbox, if you chose to email it, or
    3. On a VMS printer, if you chose to print it.

You can view documentation for Banner reports and jobs from the Job Help (JOBHELP) form.  You can also produce a documentation report for any Banner report or process by running the Job Submission Program Documentation (BAN_REPORTS_DOC) report program.

WARNING: If you have an "!" in your network/banner password, job submission will not work.  Please change your password.

Accessing Reports and Jobs

You may access reports and jobs using Direct Access or the Reports menu. When you select a report from the Reports menu, the Process Submission Controls form (GJAPCTL) will display so that you may enter printer destination and any parameters required to run the report.

Accessing the Report Using the Reports and Jobs Menu
  1. Log into Banner.
  2. From the main Banner menu, expand Reports and Jobs.
  3. The Reports and Jobs menu is based on the organizational structure at SOU. Expand the appropriate menus until you get to your department menu.
Accessing a Report Using Direct Access
  1. Log into Banner.
  2. Enter the report name (ex. REG_SCHED_COMP_PROOFS) in the Go To box and press the Enter key.

NOTE: Unsure of the report name?  You can perform a wild card search (%) in the Go To box.  Just enter part of the report code or name with wild card characters in the Go To box, e.g., %Proof%, and press enter.

Running Reports and Jobs

To run a report, you first need to set up the required parameters. The Process Submissions Control form (GJAPCTL) is used to enter parameters for reports.

Key Block (Page 1 - Block 1):

The Key block specifies which report you are running. Enter the following information:

Process: Process will be pre-populated with the report code if you selected the report from the Reports and Jobs menu. If it is blank or has the wrong report, choose Help/List from the menu for a list of available reports.

Parameter Set: Enter the name for the set of parameters you wish to use if you have saved a set of parameters previously. Otherwise, leave blank.

Choose Block/Next from the menu bar to move to the Printer Control block or use the mouse to click into the block.

Printer Control Block (Page 1 - Block 2):

The Printer Control block allows you to choose where the output will go, the number of lines to print per page, and the time to submit the job.  Enter the following information:

Printer: There are 5 choices:

  1. Print the output. Enter the code of the Banner print queue where you want the report to print. Choose Help/List from the menu bar for valid print queue codes. If you do not see your department print queue listed, call our Faculty & Staff Help Desk for assistance. 
  2. View the output online.  If you would like to review this report online, enter DATABASE in the printer field.
  3. Email the output. If you would like to email this report to yourself or someone else, enter the word EMAIL in the printer field.  To send the email to someone other than yourself, enter the email address instead. NOTE: if you plan to select and copy the contents of a large Gmail email to a Notepad or similar file, use FireFox instead of IE.  IE appears to have issues handling large Gmail emails.  You may find the DATABASE option (2) a better choice for this purpose.
  4. Send output to personal network drive. If you want to send the output to your personal network drive, enter SFTP in the print field. This will do a secure file transfer from the Banner server to your p:\BannerFiles directory.
  5. Suppress the output. If you want to surpress the print, enter NOPRINT in the print field. 

Special Print: This field allows you to specify the report format.  If nothing is entered in this field, it will default to landscape. Each report should have another default report format if landscape is not appropriate.  You may enter a report format manually.  The options are:

  1. LANDPRINT (landscape – default)
  2. LAND_CONDENSED (landscape condensed font)
  3. PORTRAIT (portrait)
  4. CONDENSED (Portrait condensed font)

Number of Lines: Enter the number of lines per page you wish to print or use the default already entered. Note: If you choose a larger number of lines than will fit on the page, your report will not print properly. We recommend this value is left blank.

Submit Time: Leave the value blank if you wish report to run immediately. If you wish the report to run at a later time, enter the time in military format (i.e., 23:00 for 11:00 PM).

Choose Block/Next from the menu bar to move to the Parameter Values block or use the mouse to click into the block.

Parameter Values Block (Page 1 - Block 3):

The Parameter Values block displays a list of parameters used to create the report. As you cursor through each parameter, help text about the parameter is displayed underneath the list of parameters at the bottom of the Parameter Values block. Click on the Search icon for the Values field to see a list of valid values if one is available.

Use the vertical scrollbar or down and up arrow keys to cursor through the records. After entering your parameter values, choose Block/Next from the menu bar to move to the Submission block or use the mouse to click into the block.

Submission Block (Page 1 - Block 4):

The Submission block allows you to save your parameters for future use and to submit the report.

Enter the following information:

Save Parameter Set as: If you wish to save the parameters to use again, check this box.

Name: If you have checked the Save Parameter Set as box, enter a name for the parameter set. If you did not check the Save Parameter Set as box, leave Name blank.

Description: If you have checked the Save Parameter Set as box, enter a description for the parameter set. If you did not check the Save Parameter Set as box, leave Description blank.

Hold/Submit: Select the Submit radio button.

Choose File/Save from the menu bar to submit your job. The report should print or be available online within a few minutes.

Viewing Job Submission Status Online

After submitting a job via Job Submission, you may check the job status online from the Process Submission Controls form (GJAPCTL).  Select Review Job Status (GWIJOBR) from the Options Menu. This form will display the status of your Job Submissions for the last 3 days. If your job is still executing, you may refresh the form by select BLOCK NEXT from the menu bar.

If you do not see your job, be sure your selected the SUBMIT radio button and not the HOLD radio button on the Process Submission Controls form (GJAPCTL). HOLD is the default.

Viewing Banner Report Online

If you entered DATABASE as the printer, you may view your report online via MySOU or Banner.

From MySOU

  1. Log into MySOU.
  2. Click on the Faculty SISWeb or Faculty/Staff tab.
  3. Click on the link to your report in the My Reports channel. This will open up your report in the Saved Output Review form in Banner.
  4. If you wish to save or print the report, select Show Document (Save and Print File) from the Options Menu.

From Banner

  1. If you are still in the Process Submission Controls form (GJAPCTL) in Banner, you may select Review Output from the Options Menu. Otherwise, log into Banner and go to the Saved Output Review form (GJIREVO).
  2. Select the Process from the drop down menu.
  3. If you wish to save or print the report, select Show Document (Save and Print File) from the Options Menu.

Saving and Printing Reports and Data Extracts Online

After reviewing the report in the Saved Output Review form (GJIREVO) in Banner, you may print the report to your local printer or save the report or data extract to your workstation.

  1. Select Show Document (Save and Print) from the Options Menu on the Saved Output Review form (GJIREVO).
  2. Respond "Yes" to the message: "You have selected to show file (file name) in a browser. Do you wish to continue?"
  3. Select Print or Save As from the browser's File menu to print or save the file.

Help

For additional help, please call the Faculty & Staff Help Desk at 552-6900 or email banner@support.sou.edu.