Overview

The Banner to EMS Extract (SA_BANNER_TO_EMS_EXTRACT) produces an extract file of all classroom reservations in a select set of buildings for a designated term.  The designated buildings are: the Athletic Field, Britt Hall, Hannon Library, Higher Education Center, McNeal Pavillion (Physical Education), and Stevenson Union. 


Accessing the Banner to EMS Extract

You may access the Banner to EMS Extract using Direct Access or the Reports menu. When you select the Banner to EMS Extract, the Process Submissions Control form (GJAPCTL) will display so that you may enter the parameters required to run the report.

Accessing the Banner to EMS Extract Using the Reports Menu
  1. Log into Banner.
  2. From the main Banner menu, expand Reports.
  3. Expand Student Affairs.
  4. Expand Student Activities and Leadership.
  5. Select Banner to EMS Extract (SA_BANNER_TO_EMS_EXTRACT).
Accessing the Banner to EMS Extract Using Direct Access
  1. Log into Banner.
  2. Enter SA_BANNER_TO_EMS_EXTRACT in the Go To box and press the Enter key.

Running the Banner to EMS Extract Report

To run the Banner to EMS Extract (SA_BANNER_TO_EMS_EXTRACT), 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 Banner to EMS Extract (SA_BANNER_TO_EMS_EXTRACT). If it is blank, enter SA_BANNER_TO_EMS_EXTRACT.

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 which printer to use, the number of lines to print per page, and the time to submit the job. Enter the following information:

Printer: Enter DATABASE so that the extracted data may be viewed online and saved to your workstation.

Special Print: Leave the value blank.

Number of Lines: Leave the value blank.

Submit Time: Leave the value blank.

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 Banner to EMS Extract report.

Enter the following information:

Term: Enter the term code of the courses. Choose Help/List from the menu bar for valid codes.

Building Code: Enter one of the designated building codes (FIELD, BRITT, HEC, LIB, PE, SU) or use % for all of the building codes in the list.  The parameter defaults to %.

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.