1 / 9

The Block and Field entries represent the table and field where the data is stored.

If you need to use some information that is not contained in one of the pre-selected tables, you can find out where that data is stored through the Banner forms. Simply click where the data is displayed and then choose Dynamic Help Query from the Help menu.

clive
Download Presentation

The Block and Field entries represent the table and field where the data is stored.

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. If you need to use some information that is not contained in one of the pre-selected tables, you can find out where that data is stored through the Banner forms. Simply click where the data is displayed and then choose Dynamic Help Query from the Help menu.

  2. The Block and Field entries represent the table and field where the data is stored.

  3. You can then add the table by clicking on the Tables button, the New button, and then Link Table.

  4. Change the Files of type to ODBC Databases (the very last entry).

  5. Double-click on the HRDG entry. If the HRDG entry is not there, call the Help Desk at extension 4440 and ask them to configure the ODBC software for you.

  6. Enter your username and password.

  7. A list of tables for which you have been given access will appear. An easy way to get to a specific table is to type its name, including the prefix. For some reason many of the tables are prefixed by Saturn. To get to this table I typed saturn.sgrsact

  8. When you’ve selected your table, click the OK button and you will see this screen. It is best to select the fields that in combination make each record unique. When in doubt, however, just select the PIDM (Personal ID Master key) . Finally, click the OK button.

  9. The new table should be included in the displayed list of tables.

More Related