We're compiling a group of "aids" and useful links to help as we all learn our way around Banner.
| Cross-functional Aids | Format | Author |
| UI Integrate Training Materials | various | UI2 |
| Banner "Job Aids" and Web-based Training | Adobe Acrobat | UI2 |
| Banner Organization Code to College-Department Code mapping Original
As of 8/07 | Excel | DMI - Livingstone |
| Conversion of UIUC Departments to Mailcodes, addresses, and buildings | Excel | Mailing center web site |
| Address types and contents in Banner(02/07) | Excel | C. Livingstone |
| Creating a pass-through query to EDW in Access | HTML | Kim Nystrom |
| Race/Ethnicity Changes - 2009-10 | Format | Author |
| VPAA web site on r/e | HTML | R/E team |
| New race codes with subcategories | Excel | R/E team |
| Definitions of old and new categories | Word | R/E team |
| Crosswalk - old codes to new | Word | R/E team |
| Overview presentation to Datamasters - Sept 2009 | PPT | Jo Menacher & Susan Flanagin |
| Handout for presentation to Datamasters - Sept 2009 | DOC | Jo Menacher & Susan Flanagin |
| Reporting options for new Categories, presentation to Datamasters - Sept 2009 | PPT | C. Livingstone |
| Examples of reports, presentation to Datamasters - Sept 2009 | XLS | C. Livingstone |
| Key Points of R/E changes - presentation to Academic Caucus Oct. 2009 | DOC | C. Livingstone |
| Human Resources Aids | Format | Author |
| Guidelines for HR reporting selection criteria | Word | HR |
| E-class codes (7/25/07) | Excel | DMI, from EDW |
| Pclass codes for academics (12/13/05) | Excel | HR, was on DART - updated by DMI |
| Academic Profnl P-class codes lookup tables (11/24/04) | Excel | DMI, from DART |
| How to distinguish 9/12 jobs | Email | HR |
| How retroactive changes to pay are made | Email | HR |
| How to identify a person's major appt | Email | Tyler Fitch |
| HR Front end reports in DART (4/09) | Cheryl Hahn |
| HR Front End, includes training & Knowledge base | Web page | |
|
Finance Aids | Format | Author |
| UFAS report to Eddie report mapping | Adobe Acrobat | UI2 |
| Explanation of FOAPAL components | Excel | DMI - Livingstone |
| Merged Financial Reports | pdf | Jack Su |
| EDW Finance tables -- metadata(Easy to use) | Access | ECE - Ron Tarvin |
| Fund codes in Banner | (Excel, 5 Mbytes) | DMI - Livingstone |
| Job Aids & Training Materials - Business & Finance | HTML / Word | OBFS |
| Creating new C-FOAPAL elements | HTML / Word | OBFS |
|
Student -- Programs, Majors, Concentrations | Format | Author |
| Concentrations: Major-Based vs. Rule-Based (5/1/07) | Word | Rod Hoewing - AITS |
| Student: Program code to Curriculum code crosswalk (3/26/04) | Excel | Mike Kamowski |
| Program code Primer | Word | Keith Marshall |
| Program code: proposal for second character (3/16/ 09) | Word | DMI - Livingstone |
| Program codes (mappings to degree, major, conc names) (4/1/04) | Excel | DMI - Livingstone |
| Urbana Undergraduate Minors (comparison to Provost web site)(2/5/07) | Excel | DMI - Livingstone |
| Urbana proposal for converting degrees in Academic History | Excel | DMI - Livingstone |
| Majors, minors, concentrations Updated 9/1/04 | Excel | DMI - Livingstone |
| Active Urbana Academic Programs with ConcentrationsCreated 1/18/06 | Excel | DMI - Livingstone |
| Handling students with two programs in the Budget calc | Word (draft) | DMI - Livingstone |
| NCES definitions of degree levels | Word | DMI - Livingstone |
|
Student -- Other | Format | Author |
| Snapshot dates for courses(2/27/09) | Excel | DMI - Livingstone |
| Catalog/Schedule: Crosswalk of courses | Web page | UIUC Provost Office |
| Student: Course rubric to Banner Subject crosswalk | Excel | DMI - Livingstone |
| Cross-listed course problems, Spring 10 | Excel | DMI - Elizabeth Stern |
| Cross-listed course problems, Fall 09 | Excel | DMI - Elizabeth Stern |
| Cross-listed course problems, Summer 09 | Excel | DMI - Elizabeth Stern |
| Conversion of UI Direct fields to Banner | Excel | UI2: Pat Tuchman |
| Unusual ways to organize courses (draft 4/29/04) | HTML | DMI - Livingstone |
| Section instructor list/Course tape programs (5/10/05) | HTML | DMI - Livingstone |
