Banner Data Dictionary

How do I know what Banner access to request?

University Technology Services has developed a web application for browsing certain Banner database data dictionary, security, and version tables. We refer to this application as the "Banner Data Dictionary". The Banner Data Dictionary application can assist you in obtaining security information about various Banner forms, classes, tables, views, roles, and users. It can also provide you with data concerning the layout of Banner tables and views. It also can display the currently installed version of various Banner products and a history of their installation dates.

Receiving Access

To receive access to the Banner Data Dictionary application, navigate to the UTS forms page (https://www.oakland.edu/uts/forms/index) and open the Banner - Data Controls Access request form. Request the role BAN_SECURITY_R and submit the form according to the form's routing instructions.

If you are trying to match the access of an employee that performs similar or like duties, start with a comparison from the Data Dictionary. We encourage departments to create the comparison list for employees in their respective departments to prepare for transitions or departures. If you have already experienced this and cannot perform a compare, you can ask others with like roles to run their individual access so you have a starting point.

In order to view the Report Viewer in eVisions, you must have requested the Banner Role USR_Security_R

Step 1- Visit https://www.oakland.edu/uts/services/banner-services-menu/.

Step 2- Scroll down to Evisions eLauncher (You must be connected to VPN first if connecting remotely).

https://lh6.googleusercontent.com/QV_0PFOCqzMdJhWCS346dYr2Y1XA_MFJ9d4h4eCg81prLqIFNvHK_jWXtHVmG_JxcpUeEGEBaDFTVlnxjXaKAPfgkAU-hXqkjhVCdJ5a-PTfmHGhCMqW7bEU9a09d-olGgXHc3FE1XVkzn2lo7PjWA

https://lh3.googleusercontent.com/b63fPC2_2E_4zTq3dAwsw-cccC8L7_eJxmlryQEg_d9n2q3U0qdymePnQ34n1UxwZw-f9plydJHTdTsBoYnrQBrwb67PQLxE0R1BQ_CdX5syzz88QSgGntFH3v0yTw0UrPOv2jO_r-m8atdJ1x11Wg

Step 3-Log in with your NetID

Step 4-Accept DUO Prompt

https://lh3.googleusercontent.com/BWqr2xM41v086Q65gYU0uY2mG_69rRklcv4Pa-eq_MVmJml8dnyT0qtqkua-CSaU4hjHnZQwvQU36AnpifxDux70aLgwlieuPuR7-AF-ir_kyN9DRraUsrmic6YMhMI1Jyumt-HlkREe_KpyOZ0kbQ

Step 5- Select Argos Web Viewer

Step 6- Select OU_Public Reports

https://lh4.googleusercontent.com/HCNk9ErPuxz8SmWSDZY9QGw84XeVeEZ9rMLEejd5NVTCn4f9gOuaG-LBPcSpQYjKL2N9vEa-ENLfW3g_s_kKkYfGYQF_tsmIXxowELjL0OPBT5qchBIJUoaSb10sFkPTiwSDeppCMsdHjZ27MC9U9w

https://lh6.googleusercontent.com/ypsXikGVkeWIL7J_La79I-8n3kwE3k0Gx1xuV7KXPX7nnz2mdYCl5x58jO0fbBGsBdXibSzp1mYf05S9i9frFc2uA_6Abzk1xm2HkKxNJCyvTW1TcO1bRIiG6TF-XOxxsFaKOTPOc5dUISmM4tvJBA

Step 7- Select Data Dictionary by double clicking.

https://lh3.googleusercontent.com/n09-XPEeqHcAFitE9CCvFMlH9uHzDzybws1VSo50t1E5kVxS29WgoxOg9ORTl4skBYigdu8mBYY4rfoTOQohJdGi_LtW-Gu_J19l_aJxjifXONmgJXpjfLVsed8XJSZZsfBbELrSVEhnOkO2dgTGWA

You will be presented with a menu of options

https://lh6.googleusercontent.com/0Lqn1JJuRStm4rBXZu5ZQ3FGHRPMRHpIQhFwdhc767VHc_bY_ieYceCqtsCZFNUFZH2puxrF319DiMVIY5l1nnKmzfxc-PPf42FuODBNEUImZyJoSb4hNleQC5sTXdC7HPyS5vfi-j92-pEDlWu24w

Step 8 - If you want to see your User Classes and Roles select Individual User. If you want to compare two users to identify similarities and differences select Compare.

Step 9 -Type in the NetID without the domain.

https://lh6.googleusercontent.com/4L12i7rIB4lobaFMnYQLL_CgB4MSCcgMxl20oLo_sPvgpRBdPuHBqc98vd0QrfodInHQaAX9B2_ShkiH4bRsOaSTH-AWOEehQ3eq8A4lz2sw4seutYqIsyKp6LmfJfDHW3VPpi2ISzEGOjiVbyHYKg

The compare feature works the same but will list the differences between user A and B.

https://lh3.googleusercontent.com/3G6YYoeo-CMJ1hhyhl-k-8CVTwMmBanHmoofRKRVF8n8Bxe4LZWWKvmcIHFOELX-4D8-6jXUqx6Jz6UVTJgv6whws9CywaQHKYg8Iv94ap7XOT6f1x4GiaJuamIgFeoqT7EKItF76BauaeItZcqJ6w

Last edited 6/30/2023