These are a list of terms to assist in familiarity
with the new enterprise resource planning system, Banner.
|
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
Account Code: In HRS, it was represented by Object Code. The account code
is a primary element in the FOAPAL labor distribution.
Action Menu:
A drop down menu listing navigation and command functions.
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.
Application Form:
A form/screen used to query, enter, and/or update information.
Attribute:
A characteristic. For example, the datatype and size of a column are two of the column's attributes.
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.
Auto Hint:
The automatic display of a message when the cursor enters a field on a form.
Block:
A section of a form containing related pieces of information -- usually a single database table. Blocks are usually separated by a solid line.
Benefit Category: A Banner attribute that organizes the types of
benefits that different employee classes are eligible to receive.
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.
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.
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.
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.
Constraint:
A rule applied to a table or column that restricts the data allowed in any row in the table.
Database:
A collection of tables used to store data.
DBA:
Database administrator, or other high-level technical person. Some types of problems or issues with
the Banner system can only be addressed by this person.
Entity:
A table or a group of tables. In Banner documentation, the term "entity" is often used interchangeably with table.
ECLS: ECLS, Employee Classes, are categories of employees based on
their benefits eligibility, type of work, and appointment.
Effective Date: For Banner, this means either the future effective
date a change is to occur or the first day following the last paid date if
a change is retroactive.
Field:
A data element within a block. For example, an address block may contain the street, city, and state fields.
Form:
A screen used to query, enter, and/or update information.
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).
FTE: "Full Time Equivalent," in Banner, we will capture employee's
percent and reflect it as FTE. Function
Keys:
Function keys are specific keystrokes or keystroke combinations that are equivalent to a selection on a menu. For example, 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.
Functional Form:
A form/screen used to query, enter, and/or update information.
GUI:
Graphical User Interface -- Windows driven software.
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.
Home Org: A Banner attribute assigned on the PEAEMPL that associates
an Employee with a department or organization, usually associated with the
employee’s primary job (status position and department).
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.
Job Change Reason: For each change to appointments, a "Job Change
Reason" needs to be entered so we can categorize the activities and use for
reporting.
Job Type: Banner has three job types: primary, secondary, overload.
Most reports are driven to read off the primary job record. Status
positions will all be either primary or secondary. Any supplemental
appointments will be "overload."
JOBS Record: Nickname for NBAJOBS record. It is a date effective
snapshot of an employee’s appointment to a particular position. Key Block:
Appears at the top of each Banner form and used as the query criteria required to access data.
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.
Leave Category: A Banner attribute that organizes the types of leave
(vacation, earned time, sick leave) that employees are eligible to receive.
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.
More...:
Appears at the bottom right of a Banner form and indicates more windows for this form.
Naming Conventions: A set of rules for naming forms, jobs, and tables in Banner.
Null: Unknown or missing.
Oracle:
The database management software used by the Banner system to store, manage, and retrieve information.
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.
PAYID: The actual pay cycles that run to produce paychecks. There
are four PAYID’s – a bi-weekly pay for hourly folks (HB), a bi-weekly pay
for salaried folks (UB), 9 month faculty (F9), and summer faculty (SB).
PCLS: PCLS, Position Classes, categorize the type of work being
performed and are assigned to a pay range and scale. Example include
Administrative Assistant II; Associate Professor; Accountant; Utility
Worker.
Personnel Date: The actual date that changes to records SHOULD have
occurred. Since Banner cannot allow changes before the "last paid date,"
personnel date will indicate when the change SHOULD have occurred, and
effective date will indicate when the change actually managed to be made in
the system.
Pooled Positions: A position established with a budget that can have
one to many employees hired into it.
Position: A position is used to budget for personnel services. It
associates a position classification (like Accountant) with a accounting
line (FOAPAL), a work schedule, and a reporting line.
Single Positions: A position intended for only one incumbent. 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.
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.
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.
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.
Row:
A component of a database table that contains the actual data organized in columns.
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.
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.
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.
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.
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.
Timesheet Org: A Banner attribute assigned on the NBAJOBS record
that associates an Employee with a department or organization for the
purpose of facilitating payroll processes.
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.
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.
Validation Form:
Form that defines values required by Banner.
Web For: Web For Employees, often called just ‘Web For’ will be a
self service web tool for employees to review their paystub information, or
view their name and address information, or even make selections for
benefits during the Open Enrollment period. |
