Information Technology
Overview
The Students with Major report (FAC_MAJORS) creates a file of students for a parameter major for a parameter department for a parameter term in a parameter format (CSV or Report) If you do not have access to the report, please contact our Faculty & Staff Help Desk.
Accessing the Report
You may access the Report using Search or the Reports and Job menu. When you select the Students with Major report, the Process Submissions Control form (GJAPCTL) will display so that you may enter the parameters required to run the report.
Accessing the Report Using the Reports and Jobs Menu
- Log into Banner.
- Click on the Applications icon
on the left navigation bar. - Expand the Banner menu.
- Expand the Reports and Jobs menu.
- Expand the Academic Affairs menu.
- Expand the Academic Departments menu.
- Select Students with Major [FAC_MAJOR].
Accessing the Report Using Search
- Log into Banner.
- Start Typing “Major” into the Search box on the main Welcome screen.
- This will pull up a list of items that have “Major” in the name. Select Students with Major (FAC_MAJORS) from the 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 the Students with Major report (FAC_MAJORS).
Enter the following information:
- Process: Process will be pre-populated with the report. If it is blank or has the wrong report, enter FAC_MAJORS.
- 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.
Click on the Go button to move to the Printer Control 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 the transcript 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 output sent to your personal network drive (p drive), enter SFTP in the printer field.
- Special Print: Enter LANDSCAPE_CONDENSED if field is empty.
- 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, the transcript 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 transcript job 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 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. Click on the Search icon for the Values field to see a list of valid values if one is available.
Enter the following information:
- Major Code: Enter a 4-character major code. Wildcard % OK.
- Department Code: Enter a 4-character department code. Wildcard % OK.
- Term Code: Enter the enrollment term code for the students.
- Output Format: Enter “C” for CSV format and “R” for Report format. Note: If you enter CSV for the report format, a file will be created in a quote/comma delimited format but the extension will not be .csv. For easiest importing into Excel, rename the file with an extension of .csv before opening in Excel.
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 (Pages 1 – 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 your job. The report should print or be available online within a few minutes.