Overview

The Class Roster report (SFRSLST) prints class rosters for a term. You may create class rosters for an entire campus, school, department, subject, or for one or more individual classes. The report may be run directly from Banner and is available for use by all faculty and staff who access Banner.


Accessing the Class Roster Report

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

Accessing the Class Roster Report Using the Reports Menu
  1. Log into Banner.
  2. From the main Banner menu, expand Reports.
  3. Expand Academic Affairs Reports.
  4. Expand Faculty Reports.
  5. Select Class Roster (SFRSLST).
Accessing the Report Using Direct Access
  1. Log into Banner.
  2. Enter SFRSTCR in the Go To box and press the Enter key.

Running the Report

To run the 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. It will be pre-populated with the Class Roster report (SFRSLST).

Enter the following information:

Process: Process will be pre-populated with the Class Roster report (SFRSLST). If it is blank or has the wrong report, enter SFRSLST.

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. Note: We recommend that you do not use a saved parameter set for the Class Roster report.

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 the printer code for where you want report to print. Choose Help/List from the menu bar for valid printer codes. If you do not see your department print queue listed, call our Faculty & Staff Help Desk for assistance.

Special Print: Leave the value blank.

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.

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 Class Roster report. Below the list of parameters is information about the parameter the cursor is on. A description of the parameter, valid value options, whether it's required, and whether it's single or multiple is listed here. If the parameter is Multiple instead of Single, it means you may enter multiple values for the parameter. To do this, after entering the first value, choose Record/Insert from the menu bar, enter the number of the parameter (i.e., 06 for CRN), and then enter the parameter value. Repeat until you have entered all of the values for that parameter.

Enter the following information:

Report Title Override: If you want to use a report title other than "Class Roster", enter it here. Otherwise, leave the value blank.

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

Part of Term: Enter the part of term for the roster. Choose Help/List from the menu bar for valid codes. Enter % for All. Part of term is only used in summer to differentiate between the sessions.

Start Range From Date: Leave the value blank.

Start Range To Date: Leave the value blank.

CRN: Enter the CRN for the roster. If you want all rosters for a term, campus, school, or department, enter a %.

Sort Option: Enter sort order for rosters.

Campus: Enter campus code for rosters. Choose Help/List from the menu bar for valid codes. Enter % for All.

Schedule Type: Enter schedule type for rosters. Choose Help/List from the menu bar for valid codes. Enter % for All.

Instructional Method: Enter instructional method for rosters. Choose Help/List from the menu bar for valid codes. Enter % for All.

Registration Codes:: Enter registration code for rosters. Choose Help/List from the menu bar for valid codes. Enter % for All.

Degree Status: Enter degree status code for rosters. Choose Help/List from the menu bar for valid codes. Enter % for All.

Combine Crosslisted Sections: Enter a value of Y to create a combined roster of cross listed sections. Enter a value of N to not combine cross listed sections.

Print Student Addresses: Enter a value of A to print addresses. Enter a value of P to print phone number. Enter a value of N to print neither address nor phone.

Address Selection Date: The current date will default automatically. If it does not, enter the current date using the format of DD-MON-YYYY (i.e., 15-SEP-2006).

Address Priority and Type(s): Enter a value of 1MA.

Primary Instructors Only: Enter a value of Y to print rosters for primary instructors only. Enter a value of N to print rosters for all instructors.

Print Long Section Title: Enter a value of Y to print the long section title if it exists. Enter a value of N to print regular section title.

Run Mode: Enter a value of R to print the report only. Enter a value of U to Update.

College Code: Enter the college code for the rosters. Choose Help/List from the menu bar for valid codes. Enter % if you have entered one or more CRN's.

Department Code: Enter the department code for the rosters. Choose Help/List from the menu bar for valid codes. Enter % if you have entered one or more CRN's.

Subject Code: Enter the department code for the rosters. Choose Help/List from the menu bar for valid codes. Enter % if you have entered one or more CRN's.

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.