University of Illinois at Urbana-Champaign Division of Management Information

 Some Banner Aids

Life was simple before World War II. After that, we had systems.
— Rear Admiral Grace Murray Hopper

We're compiling a group of "aids" and useful links to help as we all learn our way around Banner.
If you have any job aids that might help, let us know!

Links to Web Applications

   Enterprise Applications (Banner, Self-Service, etc.)
   Document Direct (standard frozen reports)
   Class schedule search
   Decision Support Project home page
   Eddie (standard reports)
   University Codebook (all organization and program codes)
   DART: Banner Resources for appointments
   Class rosters for instructors (updated daily).
   Class rosters for dept staff (updated daily)
Cross-functional AidsFormatAuthor
UI Integrate Training MaterialsvariousUI2
Banner "Job Aids" and Web-based TrainingAdobe AcrobatUI2
Banner Organization Code to College-Department Code mapping Original  As of 8/07ExcelDMI - Livingstone
Conversion of UIUC Departments to Mailcodes, addresses, and buildings ExcelMailing center web site
Address types and contents in Banner(02/07)ExcelC. Livingstone
Creating a pass-through query to EDW in Access HTMLKim Nystrom
Human Resources AidsFormatAuthor
Guidelines for HR reporting selection criteriaWordHR
E-class codes (7/25/07)ExcelDMI, from EDW
Pclass codes for academics (12/13/05)ExcelHR, was on DART - updated by DMI
Academic Profnl P-class codes lookup tables (11/24/04)ExcelDMI, from DART
How to distinguish 9/12 jobsEmailHR
How retroactive changes to pay are madeEmailHR
How to identify a person's major apptEmailTyler Fitch
Finance AidsFormatAuthor
UFAS report to Eddie report mappingAdobe AcrobatUI2
Explanation of FOAPAL componentsExcelDMI - Livingstone
Merged Financial ReportspdfJack Su
EDW Finance tables -- metadata(Easy to use)AccessECE - Ron Tarvin
Fund codes in Banner(Excel, 5 Mbytes)DMI - Livingstone
Student -- Programs, Majors, ConcentrationsFormatAuthor
Concentrations: Major-Based vs. Rule-Based (5/1/07)WordRod Hoewing - AITS
Student: Program code to Curriculum code crosswalk (3/26/04)ExcelMike Kamowski
Program code PrimerWordKeith Marshall
Program codes (mappings to degree, major, conc names) (4/1/04)ExcelDMI - Livingstone
Urbana Undergraduate Minors (comparison to Provost web site)(2/5/07)ExcelDMI - Livingstone
Urbana proposal for converting degrees in Academic HistoryExcelDMI - Livingstone
Majors, minors, concentrations Updated 9/1/04ExcelDMI - Livingstone
Active Urbana Academic Programs with ConcentrationsCreated 1/18/06ExcelDMI - Livingstone
Handling students with two programs in the Budget calc Word (draft)DMI - Livingstone
Student -- OtherFormatAuthor
Catalog/Schedule: Crosswalk of coursesWeb pageUIUC Provost Office
Student: Course rubric to Banner Subject crosswalkExcelDMI - Livingstone
Cross-listed course problems, Spring 08Excel DMI - Elizabeth Stern
Cross-listed course problems, Fall 08Excel DMI - Elizabeth Stern
Cross-listed course problems, Summer 08Excel DMI - Elizabeth Stern
Conversion of UI Direct fields to BannerExcelUI2: Pat Tuchman
Unusual ways to organize courses (draft 4/29/04)HTMLDMI - Livingstone
Section instructor list/Course tape programs (5/10/05)HTMLDMI - Livingstone
The Division of Management Information
909 S. Sixth Street
Champaign, IL 61820
phone: (217) 333-3551
fax: (217) 333-2863
e-mail: dmi@uiuc.edu

Here's a great quote that may help:

"Courage doesn't always roar.
Sometimes courage is the little voice
at the end of the day that says...
I'll try again tomorrow."

Mary Anne Radmacher-Hershey


10/25