Glossary

 

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Action Menu

A drop down menu listing navigation and command functions.

Back to Top

Alias

In an SQL query, an alternative name for a table or column. For example, you can define a table name alias in the FROM clause of a query: FROM THINGS T, PROPERTY_LIST P This defines the THINGS table alias as the letter T and the PROPERTY_LIST tables' alias as the letter P.

Back to Top

Application Form

A form/screen used to query, enter, and/or update information.

Back to Top

Attribute

A characteristic. For example, the datatype and size of a column are two of the column's attributes.

Back to Top

Application form

Type of Banner form used to enter original information and update existing information. Sometimes you can use an application form to view calculations in your system.

Back to Top

Auto Hint

The automatic display of a message when the cursor enters a field on a form.

Back to Top

Block

A section of a form containing related pieces of information -- usually a single database table. Blocks are usually separated by a solid line.

Back to Top

Client-server architecture

A network architecture in which each computer or process on the network is either a client or a server. Servers are powerful computers or processes dedicated to managing disk drives (file servers), printers (print servers), or network traffic (network). Clients are desktop computers (such as Macintoshes, PCs, or workstations) on which people run applications. Clients rely on servers for resources, such as files, devices, and even processing power.

Back to Top

Column

A component of the database that contains the definition of what kinds of data are to be collected and stored in the rows of the table.

Back to Top

Commands

You can retrieve data from your database without using Banner. Some examples of how to do this are the Spreadsheet Budgeting application that works with Microsoft Excel and your database, and SQL commands.

Back to Top

Commit

A command you execute in Banner that saves changes or updates you've made to the information. After you use COMMIT in Banner, you cannot undo your changes, unless you write some SQL code that changes the data back and then commits the new change). Before the commit occurs, you can undo your update or change using the ROLLBACK command. Some commands have an automatic commit built in. Examples of commands that automatically commit your changes are ALTER, CREATE, DROP, and RENAME.

Back to Top

Constraint

A rule applied to a table or column that restricts the data allowed in any row in the table.

Back to Top

Database

A collection of tables used to store data.

Back to Top

Database schematic

A "map" of related tables within your Banner system. Shows the relationships between the tables as well as the data elements within those tables.

Back to Top

DBA

Database administrator, or other high-level technical person at your institution. Some types of problems or issues with your system can only be addressed by this person.

Back to Top

Entity

A table or a group of tables. In Banner documentation, the term "entity" is often used interchangeably with table.

Back to Top

Extracting data for reports

You can retrieve data from your database without using Banner. Some examples of how to do this are the Spreadsheet Budgeting application that works with Microsoft Excel and your database, and SQL commands.

Back to Top

Field

A data element within a block. For example, an address block may contain the street, city, and state fields.

Back to Top

Flat files

A file of organized text data that isn't organized in a formal database format (in other words, without rows and columns)

Back to Top

Form

A screen used to query, enter, and/or update information.

Back to Top

Form header

The header of each Banner form is the title bar of the form. The header contains the descriptive form name, the 7-character form name, the release number, and the database name from the Installation Control Form (GUAINST).

Back to Top

FRM errors

Error that occurs in your system due to the functioning of a form in your Banner system. You'll see the error message either in a pop-up window on your screen, or on the dialog line near the bottom of your Banner window.

Back to Top

Function keys

Function keys are specific keystrokes or keystroke combinations that are equivalent to a selection on a menu. For example, at your institution, pressing F7 might be equivalent to selecting Enter Query. To find the keyboard equivalents at your institution, click the Show Keys button on the toolbar or select Show Keys from the Help pull-down menu.

Back to Top

Functional Form

A form/screen used to query, enter, and/or update information.

Back to Top

GUI

Graphical User Interface -- Windows driven software.

Back to Top

Help

Banner has online help available for selected forms. The online help assists you in completing tasks related to the form that you're using.

Back to Top

Job submission

The way Banner runs reports or processes. For example, let's say you want to find all students who have outstanding parking fee balances. You would "submit the job" by entering your criteria for the report and then telling Banner to go into the database and find the matching data.

Back to Top

Key

A column or set of columns in a table that identifies a unique row of data.

Back to Top

Key Block

Appears at the top of each Banner form and used as the query criteria required to access data.

Back to Top

LOV

List of Values. A list of possible field values which are displayed by pressing the List of Values (LOV) button next to the field.

Back to Top

Menu Bar

Located at the top of the screen, below the form name and Title Bar, the Menu Bar has a list a series of options (eg. File, Edit, etc) available on a specific form.

Back to Top

More...

Appears at the bottom right of a Banner form and indicates more windows for this form.

Back to Top

Naming conventions

A set of rules for naming forms, jobs, and tables in Banner.

Back to Top

Null

Unknown or missing.

Back to Top

Oracle

The database management software used by the Banner system to store, manage, and retrieve information.

Back to Top

Oracle errors

Error that occurs in your system due to a function of the Oracle database. You'll see the error message either in a pop-up window on your screen, or on the dialog line near the bottom of your Banner window.

Back to Top

Origination tag

A unique value that identifies a fixed asset at your institution (a desk or a set of chairs, for instance). Used to track depreciation and related expenses throughout the useful life of the asset.

Back to Top

Permanent tags

Used to track assets in the Fixed Assets module of the Banner Finance System.

Back to Top

PIDM

The Person Identification Master or PIDM is an internal key field stored in the Person Identification table (SPRIDEN). The PIDM may represent a student, vendor, employee, beneficiary, alumnus, or other entity. All tables that contain person or entity related data must store the PIDM but not necessarily complete records. This relational reference method makes Banner a powerful and efficient tool for data storage and retrieval.

Back to Top

Primary key

A column or set of columns in one table that uniquely identifies each row in the table. Each row in a table has a value in the primary key different from that of every other row in that table.

Back to Top

Query

A question in Banner that looks at the data in the Banner database for an answer. Banner queries use SQL (Structured Query Language), which is an English-like set of commands for defining database objects.

Back to Top

Record

A collection of information stored in a database table as a single unit. One or more records may be included in a single block.

Back to Top

Relational database

A collection of tables connected together in a series of relationships so that they model some small part of the real world.

Back to Top

Rollback

A command that removes all changes since the last Commit or Save. Rollback is the same as Revert to Saved in other applications. On validation, application, and inquiry forms, Rollback returns the cursor to the first enterable field on the form. On query forms, Rollback returns the cursor to the first enterable field on the calling form. Rollback is also referred to as Clear Form.

Back to Top

Row

A component of a database table that contains the actual data organized in columns.

Back to Top

Scroll Bar

A horizontal or vertical bar that appears at the side or bottom of a Banner form window. Clicking the arrows at the ends of the Scroll Bar will move the window and display additional information.

Back to Top

Security

The way in which Banner keeps unauthorized users from making changes to the system. Generally set up by your DBA (or other high-level technical people) via various forms within Banner. You're not allowed to access these forms. Sorry! Also controls the codes that you're able to use when you enter information via a Banner form.

Back to Top

Status Line

The status line is displayed at the bottom of a form and provides information about the number of records displayed and whether all records have been displayed. The * denotes that all records have been displayed.

Back to Top

Table

The Oracle structure that holds information inside a database. A table organizes information in columns and rows, so the information is easy to manipulate; for example, you can sort, filter, find, combine, or add information.

Back to Top

Term

Unique identifier used to represent a specific semester and year. The term is a six digit number with the first four digits representing the year and the next two digits representing the semester. For example, 199920 represents the Spring 1999 semester.

Back to Top

Title Bar

Located at the extreme top of a Banner form, the Title Bar displays the full name of the form and it's seven character identifier.

Back to Top

Tool Bar

Located under the Menu Bar at the top of a form, the Tool Bar contains icons that are used to navigate through the form.

Back to Top

Validation form

Form that defines values required by Banner.

Back to Top