Banner Reporting Access
Some employees also need access to run reports from Banner by linking to Banner tables and/or views. Similar to user classes, Banner reporting roles include the tables needed for reporting from a functional area. The same procedure as above is followed to request reporting access (tables or reporting roles) for an individual.
Banner is a large, integrated database system and reporting can be very complex and confusing. Unless tables are joined correctly and proper parameters are defined, reports may appear accurate but records may be missing or incorrect data may be included. To accommodate common reporting needs for student information, several Microsoft Access databases are available for use by individuals who have been granted the proper Banner reporting access. The Access databases allow individuals to report as needed on the following:
- Academic and address information for a selected population of Graduate students
- Academic and address information for a selected population of Undergraduate students
- Roster and Enrollment information
- Student Schedule information
Desktop Finance Reporting Database is a Microsoft Access database designed to provide user-friendly access to Banner Finance and related reports and financial data. This database is maintained by Bob Siegfried, Director of Finance and Administration Systems, and is available to all Banner Financial Managers and their designees.
See Request for Banner Access for additional information.
After Banner reporting access is approved, an individual may access the J: drive on the Lehigh network. The Access databases and documentation are stored on J:\Banner\StuReports. The database cannot be used directly from the J drive but must be copied to the user's computer.