In Banner INB (accessed from Portal)
Go to GWLSTUD:
Enter "DATABASE" in the Printer field
Enter Values for each parameter listed below.
01 Letter Name STU_FULL_MATRIC_LIST
02 Term Code 201508 (Year followed by "02 - Spring", "08 - Fall")
03 Student ID either the U number or "%" for all students
04 Course either the 3 character subject code followed without space by the course number or "%" for all
05 Section Number either the 2 character section number for the specific class or "%" for all
06 Part of Term either the specific section number or "%" for all
07 Attribute Code either the attribute code or blank if not searching on attribute
08 Attribute Code excluded either the attribute code to be excluded or blank if not searching on attribute
09 Online/Face2Face Only A- All, O- Online, F- F2F Only, B- Online & F2F only
10 Minimum Credits for Semester the minimum # of credits student is taking for the semester
11 Include Non Matrics either Y or N
12 Run with Transcript Program N
13 Major Code Either the Campus Code or "%" for all majors
14 Update Letter Generation Tbl N
15 Campus Code % for All
16 Run all Students Y
17 Phone Type Leave Blank
18 Concentration Codes % for All
Wait five minutes
Open the Banjobs folder found in your U drive
Make sure "All Files" is selected to the right of File Name
The "Text Import Wizard" will appear on the screen.
Click the "Delimited" button
Click Next >
Click "Comma" button
Click Next >
You can then manipulate the data in Excel as you see fit.
Files saved in Banjobs will only remain there for 15 days.
Banner Reports >