Banner Reports‎ > ‎

List of Students (GWLSTUD)

In Banner INB (accessed from Portal)

Go to GWLSTUD:

Next Block 

Enter "DATABASE" in the Printer field

printer - database.jpg

Next Block

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

Next Block

SAVE

Wait five minutes

Open Excel

File Open

Open the Banjobs folder found in your U drive

Make sure "All Files" is selected to the right of File Name

Select STU_FULL_MATRIC_LIST_mmddyy.txt

The "Text Import Wizard" will appear on the screen.

Click the "Delimited" button

Click Next >

Click "Comma" button

Click Next >

Click Finish

You can then manipulate the data in Excel as you see fit.

Files saved in Banjobs will only remain there for 15 days.



   
Comments