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
- Log into Banner.
- Click on the Applications icon
on the left navigation bar. - Expand the Banner menu.
- Expand the Jobs and Reports menu.
- Expand the Academic Affairs Reports menu.
- Expand the Academic Departments menu.
- Select Class Roster (SFRSLST).
Accessing the Report Using Search
- Log into Banner.
- Enter Class Roster into the search box on the main Welcome screen.
- This will pull up a list of items that have "Class Roster" in the name. Select Class Roster (SFRSLST) from the results list.
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 Section (Page 1 - Section 1):
The Key section specifies which report you are running. It will be pre-populated with Class Roster (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.
Click on the Go button to move to the next section.
Printer Control Section (Page 1 - Section 2):
The Printer Control section 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. Press F9 or click the button with a caption of "..." on the right side of the text box to get a list of valid values. If you do not see your department print queue listed, call our Faculty & Staff Help Desk for assistance. If you would like to review the report online, enter DATABASE in the printer field. If you would like to have the report sent in pdf format to your BannerFiles folder in your personal Box drive, enter SFTP_PDF in the printer field. If you would like the report emailed to you, enter EMAIL or a valid email address in the printer field.
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).
Use the mouse to click into the Parameter Values section.
Parameter Values Section (Page 1 - Section 3):
The Parameter Values section displays a list of parameters used to create the Class Roster 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 section. 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, click on the Insert button at the top of the Parameter Values section, 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 mouse or down and up arrow keys to cursor through the records. After entering your parameter values, use the mouse to click into the Submission section.
Submission Section (Page 1 - Section 4):
The Submission section 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.
Click on the Save button in the bottom right corner of the page to submit the report. The report should print or be available online within a few minutes. If you have chosen to send to Box, it may take a little longer to show up on Box.
